« June 2008 | Main

July 31, 2008

DWSF & DWFA Table Updates

Below is a schedule of tentative dates for the release of remaining DWSF and DWFA tables. Please note that the dates are subject to change and depend entirely on the availability of PeopleSoft data. These tables will be released as soon as data is available in PeopleSoft, and the updated tables have been tested.




Table NameTentative Release DateNotes
  PS_DWFA_FDN_SUMMARY*   8/11/08   PS_DWFA_FDN_SUMMARY_HIST
  PS_DWFA_ST_ASSISTANCE*   8/11/08  PS_DWFA_ST_ASSISTANCE_HIST
  PS_DWFA_FDN_CHARTFIELD1   8/11/08  Replaces PS_DWFA_FDN_FUNDS
  PS_DWSF_SF_ACCTG_LN_09   8/11/08 

*Historical (pre-EFS) versions of PS_DWFA_FDN_SUMMARY and PS_DWFA_ST_ASSISTANCE are viewable in the historical tables PS_DWFA_FDN_SUMMARY_HIST and PS_DWFA_ST_ASSISTANCE_HIST. The 8/11/08 start date is tentative.

July 11, 2008

Remaining Table Changes

The remaining table changes related to the EFS Conversion are underway. Below is a schedule of what's to come in the next six weeks.

July/August 2008

TABLES BEING UPDATED

Table NameOutage PeriodHistorical Table Name
  PS_DWFA_FDN_SUMMARY*   7/1/08-7/23/2008 7/28/08 8/11/08   PS_DWFA_FDN_SUMMARY_HIST
  PS_DWFA_ST_ASSISTANCE*   7/1/08-7/23/2008 7/28/08 8/11/08  PS_DWFA_ST_ASSISTANCE_HIST

*Historical (pre-EFS) versions of PS_DWFA_FDN_SUMMARY and PS_DWFA_ST_ASSISTANCE are viewable in the historical tables PS_DWFA_FDN_SUMMARY_HIST and PS_DWFA_ST_ASSISTANCE_HIST. The 7/23/20087/28/08 8/11/08 start date is tentative.  

 

Table NameFirst Run DateHistorical Table Name
  PS_DWTA_CRSE_TUITION_PR*  7/14/2008 
  PS_DWTA_STDNT_CRSE_PR*  7/14/2008 
  PS_DWTA_CRSE_TUITION**  8/27/2008  PS_DWTA_CRSE_TUITION_HIST
  PS_DWTA_STDNT_CRSE**   8/27/2008  PS_DWTA_STDNT_CRSE_HIST

*The _PR (preliminary) tuition tables will be available in the old (pre-EFS) format on 7/14/08.
**PS_DWTA_CRSE_TUITION and PS_DWTA_STDNT_CRSE will be available in the new (post-EFS) format on 8/27/08. The historical (pre-EFS) versions of these tables are viewable in the historical tables PS_DWTA_CRSE_TUITION_HIST and PS_DWTA_STDNT_CRSE_HIST.  

 

NEW TABLES

Table NameFirst Run DateNotes
  PS_DWFA_FDN_CHARTFIELD1*   7/23/2008 7/28/08 8/11/08  Replaces PS_DWFA_FDN_FUNDS
  PS_DWSF_SF_ACCTG_LN_09*   7/23/2008 7/28/08 8/11/08 
  PS_DW_ACAD_ORG_DEPTID_TBL*   7/23/2008 
  PS_DWPY_MONTHLY_SUM_09   8/6/2008 
*The 7/23/2008 & 8/11/2008 start dates are tentative.  

 

TABLES WITH CHANGING VALUES

Table NameLast RefreshFirst Day New Data Will ShowNotes
  PS_DWCS_CLASS_TBL  7/19/2008  7/22/2008
  PS_DWSR_CLASS  7/18/2008   7/21/2008 
  PS_DWSR_CLASS2  7/18/2008   7/21/2008 
  PS_DWSR_COURSE  7/18/2008   7/21/2008  
  PS_DWSR_FACILITY  7/18/2008   7/21/2008 
 

 

TABLES BECOMING STATIC

Table NameLast Run DateNotes
  DWIN_EQUIP_TRAN_HIST  Approx. 8/10/2008  

July 10, 2008

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


July 8, 2008

Payroll Table Views

The following will be views of payroll tables prior to fiscal year 2009:
ps_dwpy_hsa_hist_vw and ps_dwpy_pay_frng_hist_vw.

For fiscal years 2009 and beyond, the views are named ps_dwpy_hsa_hist_efs_vw and ps_dwpy_pay_frng_hist_efs_vw.