« Effective Dates for Tables Changing in DWSR | Main | Link to Access Updated Tables »

Effective Dates for Phase I / Phase II Tables

Effective Dates for Phase I / Phase II Tables

Below are the earliest dates the following tables will be available to University users following conversion happening the weekends of June 14/15, June 28/29, and later. While we don't anticipate any problems and have attempted to identify all issues related to conversion and production deployment, there is some risk that not all tables will be immediately available. Please plan accordingly and check the main page of this blog for updates. Thank you.

These dates are preliminary and subject to change.

 

 

Phase I

Data Groups That Will Become Static After Conversion

  DWFSWill become static sometime after July 1st, 2008.
  DWINWill become static sometime after July 1st, 2008.
  DWRAWill become static after June 27th, 2008.
  DWUSWill become static sometime after July 1st, 2008.
 

Tables That Will Change After Conversion

For tables that are being replaced or are based on fiscal year, the "Last Day to View Pre-EFS Conversion Format" will actually be the last day that table is refreshed. These tables will be available for historical data indefinitely after conversion.
 
DWFA
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  PS_DWFA_FDN_FUNDS*6/27/2008N/A
    *(Will be replaced by PS_DWFA_FDN_CHARTFIELD1)
  PS_DWFA_FDN_CHARTFIELD1N/A 7/1/2008
  PS_DWFA_FDN_SUMMARY7/1/2008 N/A
  PS_DWFA_ST_ASSISTANCE7/1/2008 7/7/2008
  PS_DWFA_GL_INTERFACE6/27/2008 7/1/2008
  PS_DWFA_COMMUN6/27/20087/7/2008
  PS_DWFA_SRVC_IND6/27/2008 7/7/2008
   
DWHN
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  PS_DWHR_COMP_PROP6/15/20086/17/2008
  PS_DWHR_DEMO_ADDR6/15/20086/17/2008
  PS_DWHR_JOB6/15/20086/17/2008
  PS_DWHR_JOB_HIST6/15/2008 6/17/2008
  PS_DWHR_POSITION_DATA6/15/20086/17/2008
   
DWHR
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  DWPA_POSTING6/15/20086/17/2008
  PS_DWHR_EMP_REVIEW6/15/20086/17/2008
  PS_DWHR_TRAINEE6/15/20086/17/2008
   
DWPY
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  PS_DWPY_DIST 6/15/2008 6/17/2008
  PS_DWPY_FRNG_DETAIL_086/15/2008 N/A
  PS_DWPY_FRNG_DETAIL_09N/A 6/29/2008
  PS_DWPY_HSA_FD_08 6/28/2008N/A
  PS_DWPY_HSA_FD_09 N/A 7/15/2008
  PS_DWPY_HSA_08 6/27/2008 N/A
  PS_DWPY_HSA_09 N/A 7/5/2008
  PS_DWPY_MONTHLY_SUM_086/27/08 N/A
  PS_DWPY_MONTHLY_SUM_09N/A 8/2/2008
  PS_DWPY_PAY_FRNG_08 6/28/2008N/A
  PS_DWPY_PAY_FRNG_09 N/A7/1//2008
  PS_DWPY_VAC_SICK 6/14/2008 6/17/2008
   
DWSA
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  PS_DWSA_SRVC_IND 6/30/2008 7/2/2008
  PS_DWSA_SRVC_IND_HS ?? ??
  PS_DWSA_SRVC_IND_RT?? ??
  PS_DWSA_SRVC_IND_XXXX(_08) ?? N/A
  PS_DWSA_SRVC_IND_XXXX(_09)N/A ??
  PS_DWSA_STIX_XXXX(_08)?? N/A
  PS_DWSA_STIX_1089_PR*N/A 9/12/2008
  *This will be the first run (occurring in Fall 2008) of STIX after the conversion.
   
DWSF
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  PS_DWSF_SF_ACCTG_LN_086/30/2008 N/A
  PS_DWSF_SF_ACCTG_LN_09N/A 7/7-7/30/2008

Other Changes

The following tables will not change in structure, but some fields may have new values.

DWAD
For DWAD, new values will start appearing in deptid.
Table Last Day to View Pre-EFS Conversion Changes First Day to View Post-EFS Conversion Changes
  PS_DWAD_COMMUN 7/1/2008 7/3/2008
  PS_DWAD_COMMUN_HS12/30/2008 1/15/2009
  PS_DWAD_SRVC_IND7/1/20087/3/2008
  PS_DWAD_SRVC_IND_HS12/30/2008 1/15/2009
   
DWHR
Table Last Day to View Pre-EFS Conversion Changes First Day to View Post-EFS Conversion Changes
For DWHR tables below, there are column names which include DEPTID that were never used pre-conversion, and will still not be used post-conversion.
  PS_DWHR_CRS_SESSIONN/A N/A
  PS_DWHR_CRSE_SESS_DATES N/A N/A
  PS_DWHR_SESSN_EQUIP N/A N/A
  PS_DWHR_SESSN_EXPENSEN/A N/A
  PS_DWHR_SESSN_INSTR_COSTN/A N/A
   
DWPC
For DWPC, new values will start appearing in acad_org.
Table Last Day to View Pre-EFS Conversion Changes First Day to View Post-EFS Conversion Changes
 DWPC_PROGRAM_DEPARTMENT ?? ??
   
DWSR
For DWSR, new values will start appearing in acad_org.
Table Last Day to View Pre-EFS Conversion Changes First Day to View Post-EFS Conversion Changes
  PS_DWSR_CLASSN/A 7/18/2008
  PS_DWSR_CLASS2N/A 7/18/2008
  PS_DWSR_COURSEN/A 7/18/2008
  PS_DWSR_FACILITYN/A 7/18/2008

Phase II

NSFNIH
Table Last Refresh in Pre-EFS Conversion Format First Run in Post-EFS Conversion Format
DW_GS_SALARY_XXXX 12/200712/2008
DW_NSFNIH_SURVEY_XXXX 12/200712/2008
DW_PD_SALARY_XXXX 12/200712/2008
 
DWEO
Table Last Refresh in Pre-EFS Conversion Format First Run in Post-EFS Conversion Format
PS_DWEO_PERSON_PRIM_JOB 6/10/200808/2008
PS_DWEO_PERSON_PRIM_JOB_HS 6/10/200810/2008
PS_DWEO_PERSON_SEC_JOB 6/10/200808/2008
PS_DWEO_PERSON_SEC_JOB_HS 6/10/200810/2008
 
DWTA
Table Last Refresh in Pre-EFS Conversion Format First Run in Post-EFS Conversion Format
PS_DWTA_CRSE_TUITION 7/14/20088/25/2008
PS_DWTA_CRSE_TUITION_MT 7/14/20088/25/2008
PS_DWTA_CRSE_TUITION_PR 7/14/20088/25/2008
PS_DWTA_STDNT_CRSE 7/14/20088/25/2008
PS_DWTA_STDNT_CRSE_MT 7/14/20088/25/2008
PS_DWTA_STDNT_CRSE_PR 7/14/20088/25/2008
 
DWSP
Table Last Refresh in Pre-EFS Conversion Format First Run in Post-EFS Conversion Format
PS_DWSP_CUFS No change on schedule, TBDTBD
PS_DWSP_FUNCTION No change on schedule, TBDTBD
PS_DWSP_ROOM No change on schedule, TBDTBD
 
DWNC
Table Last Refresh in Pre-EFS Conversion Format First Run in Post-EFS Conversion Format
DWNC_CRSE_SECT TBDTBD
DWNC_INCOME_XX TBDTBD