Main

May 20, 2008

Effective Dates for Tables Changing in DWFA

Below are tentative dates to view DWFA tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

Continue reading "Effective Dates for Tables Changing in DWFA" »

April 15, 2008

Tables in DWFA

Changes will be made to six DWFA tables. In general, we are incorporating the EFS chartfields to these tables.

Changes will be made to:

  • PS_DWFA_COMMUN: New DEPTID values will be incorporated into the table.
  • PS_DWFA_SRVC_IND: New DEPTID values will be incorporated into the table.
  • PS_DWFA_FDN_FUNDS_TBL: Will be replaced by PS_DWFA_FDN_CHARTFIELD1, which will contain short and long descriptions (DESCR_SHORT, DESCR) for the University of Minnesota Foundation Fund number, which is contained in Chartfield1.
  • PS_DWFA_FDN_SUMMARY: A new table (which has yet to be named) will be created that will contain EFS chartfields (fund_code, deptid, account, program_code, project_id, chartfield1, chartfield2, chartfield3, budget_ref, RRC (replaces AREA_CLASS)) for Fiscal Years 2009 and later. Legacy data (Fiscal years prior to 2009) will continue to be available in a frozen table.
  • PS_DWFA_GL_INTERFACE: The new EFS chartfields will be incorporated into the table (fund_code, deptid, account, program_code, project_id, chartfield1, chartfield2, chartfield3, budget_ref).
  • PS_DWFA_ST_ASSISTANCE: A new table will be created for Fiscal Years 2009 and later that will incorporate the EFS chartfields (fund_code, deptid, account, program_code, project_id, chartfield1, chartfield2, chartfield3 and RRC).

Below are links to table specs for the DWFA tables requiring updates. Please be aware that this is not a comprehensive list of all DWFA tables:

Continue reading "Tables in DWFA" »