« Data Groups Not Being Updated | Main | Payroll Table Views »

Data Warehouse Table Updates Related to June 28th-July 1st PeopleSoft Financials Implementation

Beginning the afternoon of Monday, June 30th, several tables will be unavailable while they undergo updates related to the EFS implementation. Backup versions of some of these tables will be available either in a permanent historical format or a temporary conversion backup table. New versions of tables will be released after they have been tested.

In addition to the tables being updated, some tables will become static between June 27th and July 1st. Many of these tables are fiscal year based, and their new counterparts will be created over the same time period. Others will be updated in Phase II, and a few do not have updated versions.

DWFS, DWIN, DWRA and DWUS will not be updated with new EFS data, and will become static on a staggered schedule over the next four months as CUFS updates come to an end.

Finally, some tables won’t change structurally, but will have new EFS data appear over the coming week.

 

Tables Being Updated

  Table Name  Outage Period  Backup Table Names
  PS_DWFA_GL_INTERFACE  7/1-7/3/2008  PS_DWFA_GL_INTERFACE_CONV_BU
  PS_DWFA_FDN_SUMMARY*  7/1-7/9/2008  PS_DWFA_FDN_SUMMARY_HIST
  PS_DWFA_ST_ASSISTANCE*  6/30-7/9/2008  PS_DWFA_ST_ASSISTANCE_HIST

*Data in the updated PS_DWFA_ST_ASSISTANCE and PS_DWFA_FDN_SUMMARY may not be available until the end of July. The backups of these tables will be available after 7/3, and will contain previous fiscal year data through 2008.

 

Tables Becoming Static

  Table Name  Last Run Date  Notes
  PS_DWFA_FDN_FUNDS   7/1/2008  Will be replaced by PS_DWFA_FDN_CHARTFIELD1.
  PS_DWPY_FRNG_DETAIL_08   6/15/2008   Will contain fiscal year 2008 data.
  PS_DWPY_HSA_08  6/27/2008  Will contain fiscal year 2008 data.
  PS_DWPY_HSA_FD_08   6/27/2008   Will contain fiscal year 2008 data.
  PS_DWPY_MONTHLY_SUM_08   6/30/2008   Will contain fiscal year 2008 data.
  PS_DWPY_PAY_FRNG_08   6/15/2008  Will contain fiscal year 2008 data.
  PS_DWSF_AREA_DTL_TBL   7/1/2008   Last refresh, not being replaced.
  PS_DWSF_SF_ACCTG_LN_08   7/1/2008   Will contain fiscal year 2008 data.
  DWSL_ITEM_TYPE_CROSSWALK  6/30/2008   Next refresh with updates will occur again in Fall
  2008. Static table until then.
  DWSL_JV_TRAN   6/30/2008   Next refresh with updates will occur again in Fall
  2008. Static table until then.
  DWSL_LOAN_ATTRIBUTE   6/30/2008   Next refresh with updates will occur again in Fall
  2008. Static table until then.
  DWSL_LOAN_TRANSACTION   6/30/2008   Next refresh with updates will occur again in Fall
  2008. Static table until then.

 

New Tables

  Table Name   First Run Date  Notes
 PS_DWFA_FDN_CHARTFIELD1   7/9/2008  Will replace PS_DWFA_FDN_FUNDS. Data in
  PS_DWFA_FDN_CHARTFIELD1 may not be available
  until the end of July.
  PS_DWPY_FRNG_DETAIL_09   7/2/2008   Will contain fiscal year 2009 data. Table
  will have new PeopleSoft chartfields.
  PS_DWPY_HSA_09   7/3/2008  Will contain fiscal year 2009 data. Table
  will have new PeopleSoft chartfields.
  PS_DWPY_HSA_FD_09   7/15/2008   Will contain fiscal year 2009 data. Table
  will have new PeopleSoft chartfields.
  PS_DWPY_MONTHLY_SUM_09   8/6/2008   Will contain fiscal year 2009 data. Table
  will have new PeopleSoft chartfields.
  PS_DWPY_PAY_FRNG_09   7/3/2008   Will contain fiscal year 2009 data. Table
  will have new PeopleSoft chartfields.
  PS_DWSF_SF_ACCTG_LN_09   7/9/2008   Will contain fiscal year 2009 data. Table
  will have new PeopleSoft chartfields. Data in
  PS_DWSF_SF_ACCTG_LN_09 may not be available
  until the end of July.

 

Tables with Changing Values

  Table Name   Last Refresh  First Day New Data will Show   Notes
  PS_DWAD_COMMUN   7/1/2008   7/2/2008   New values in deptid.
  PS_DWAD_SRVC_IND  7/1/2008   7/2/2008   New values in deptid.
  PS_DWFA_COMMUN   6/28/2008   7/7/2008   New values in deptid.
  PS_DWFA_SRVC_IND   7/5/2008   7/9/2008   New values in deptid.
  DWPC_PROGRAM_DEPARTMENT   7/1/2008   7/2/2008   New values in deptid.
  PS_DWSA_SRVC_IND  7/1/2008   7/2/2008   New values in deptid.
  PS_DWSA_SRVC_IND_STATIC  7/1/2008   7/2/2008   New values in deptid.

 

The following data groups will contain data through fiscal year 2008. Included below are expected last updates.

Data Groups that will Not be Updated with New PeopleSoft Data

  Data Group   Last Refresh Date
  DWFS   October 2008
  DWIN   August 2008
  DWRA   6/27/2008
  DWUS   6/27/2008