« April 2008 | Main | June 2008 »

May 20, 2008

Effective Dates for Tables Changing in DWSR

Below are tentative dates to view DWSR tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

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

   
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

Effective Dates for Tables Changing in DWSF

Below are tentative dates to view DWSF tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

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

Effective Dates for Tables Changing in DWSA

Below are tentative dates to view DWSA tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

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 of STIX after the conversion.

Effective Dates for Tables Changing in DWPY

Below are tentative dates to view DWPY tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

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/18/2008
   

Effective Dates for Tables Changing in DWPC

Below are tentative dates to view DWPC tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

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

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    
   

Effective Dates for Tables Changing in DWHR

Below are tentative dates to view DWHR tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

The following tables will change in structure:

DWHR
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  DWPA_POSTING6/15/20086/18/2008
  PS_DWHR_EMP_REVIEW6/15/20086/18/2008
  PS_DWHR_TRAINEE6/15/20086/18/2008
   

The following tables will not change in structure:

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
   

Effective Dates for Tables Changing in DWHN

Below are tentative dates to view DWHN tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

DWHN
Table Last Day to View Pre-EFS Conversion Format First Day to View Post-EFS Conversion Format
  PS_DWHR_COMP_PROP6/15/20086/18/2008
  PS_DWHR_DEMO_ADDR6/15/20086/18/2008
  PS_DWHR_JOB6/15/20086/18/2008
  PS_DWHR_JOB_HIST6/15/2008 6/18/2008
  PS_DWHR_POSITION_DATA6/15/20086/18/2008
   

Effective Dates for Tables Changing in DWFA

Below are tentative dates to view DWFA tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

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
   

Effective Dates for DWAD Tables

Below are tentative dates to view DWAD tables in Pre-EFS and Post-EFS form. Note that these dates are subject to change. If there will be changes, or if unexpected issues arise, please look to the main page of this blog to see more recent posts.

The following tables will not change in structure, but some fields will 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