« Data Warehouse Table Updates - July 3, 2008 | Main | DWSF & DWFA Table Updates »

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