« Payroll Table Views | Main | Remaining Table Changes »

Data Warehouse Table Updates - July 3, 2008

Updates to the tables scheduled to convert during the week of June 28th - July 3rd within the Data Warehouse are complete.

Data Groups that have become static

DWRA – Last refresh as of 6/27/2008
DWUS – Last refresh as of 6/27/2008

Updates to the following tables have been completed

PS_DWFA_GL_INTERFACE

Tables refreshed either for the last time or until Phase II

DWSL_ITEM_TYPE_CROSSWALK - Next refresh with updates scheduled for Fall 2008
DWSL_JV_TRAN - Next refresh with updates scheduled for Fall 2008
DWSL_LOAN_ATTRIBUTE - Next refresh with updates scheduled for Fall 2008
DWSL_LOAN_TRANSACTION - Next refresh with updates scheduled for Fall 2008
PS_DWFA_FDN_FUNDS - Will be replaced by PS_DWFA_FDN_CHARTFIELD1
PS_DWPY_FRNG_DETAIL_08
PS_DWPY_HSA_08
PS_DWPY_HSA_FD_08
PS_DWPY_MONTHLY_SUM_08
PS_DWPY_PAY_FRNG_08
PS_DWPY_PAY_FRNG_HIST_VW - View containing all FY through 2008, source tables no longer updated please see PS_DWPY_PAY_FRNG_HIST_EFS_VW for fiscal years greater than 2008
PS_DWSF_SF_ACCTG_LN_08
PS_DWSF_AREA_DTL_TBL

New tables and views

PS_DWPY_FRNG_DETAIL_09
PS_DWPY_PAY_FRNG_09
PS_DWFA_GL_INTERFACE_CONV_BU
PS_DWFA_FDN_SUMMARY_HIST
PS_DWFA_ST_ASSISTANCE_HIST
PS_DWPY_PAY_FRNG_HIST_EFS_VW – View containing fiscal year 09 data forward
PS_DWPY_HSA_09
PS_DWPY_HSA_FD_09

Tables with some updated values in deptid and date to be expected

PS_DWAD_COMMUN – 7/7/2008
PS_DWAD_SRVC_IND – 7/7/2008
PS_DWFA_COMMUN – 7/7/2008
PS_DWFA_SRVC_IND – 7/9/2008
PS_DWSA_SRVC_IND – 7/4/2008

Tables scheduled for next week and beyond

PS_DWFA_FDN_SUMMARY - 7/9/2008 at the earliest
PS_DWFA_ST_ASSISTANCE - 7/9/2008 at the earliest
PS_DWFA_FDN_CHARTFIELD1 - 7/9/2008 at the earliest

PS_DWPY_MONTHLY_SUM_09 - 8/6/2008

PS_DWSF_SF_ACCTG_LN_09 - 7/9/2008 at the earliest