« Q & A from Thursday's Meeting | Main | HRMS Job and Position Tables »

Extended System Maintenance

The normal maintenance window from 6:00 AM to 12:00 PM on Sundays will be extended this weekend because of the initial updates happening with the EFS conversion. The window for maintenance this Sunday, June 15th, will be from 6:00 AM - 3:00 PM. Please plan accordingly.

After 10pm on Sunday, several tables will be unavailable for up to 48 hours, while they undergo conversion to EFS format. During the outage, backup version of these tables will be available. We anticipate that the maximum amount of time a table may be down is 48 hours. The tables will be released after they have been tested.

Another set of tables will become static over the weekend, and will continue to be available in the Data Warehouse. Some of these will be updated during Phase II.

Finally, two new tables will be available starting on Monday following the conversion.

Tables Being Converted

 Table Name Outage Period Backup Table Names
 PS_DWHR_COMP_PROP  6/15/2008-6/17/2008  PS_DWHR_COMP_PROP_CONV_BU
 PS_DWHR_DEMO_ADDR   6/15/2008-6/17/2008 PS_DHWR_DEMO_ADDR_CONV_BU
 PS_DWHR_JOB  6/15/2008-6/17/2008 PS_DWHR_JOB_CONV_BU
 PS_DWHR_JOB_HIST  6/15/2008-6/17/2008 PS_DWHR_JOB_HIST_CONV_BU
 PS_DWHR_POSITION_DATA  6/15/2008-6/17/2008 PS_DHWR_POSITION_DATA_CONV_BU
 DWPA_POSTING  6/15/2008-6/17/2008 DWPA_POSTING_CONV_BU
 PS_DWHR_EMP_REVIEW  6/15/2008-6/17/2008 PS_DWHR_EMP_REVIEW_CONV_BU
 PS_DWHR_TRAINEE  6/15/2008-6/17/2008 PS_DWHR_TRAINEE_CONV_BU
 PS_DWPY_DIST  6/15/2008-6/17/2008  PS_DWPY_DIST_HS
 PS_DWPY_VAC_SICK  6/15/2008-6/17/2008  PS_DWPY_VAC_SICK_CONV_BU

Tables Becoming Static

 Table Name  Last Refresh Date  Notes
  PS_DWPY_FRNG_DETAIL_08  6/15/2008  New table will be for the new fiscal year,
  created on 6/29/2008.
  PS_DWPY_DIST_HS  6/15/2008  Will contain historical data for fiscal years through
  2008. New format will contain fiscal year 2009 and
  updated structure.
  PS_DWEO_PERSON_PRIM_JOB  6/14/2008  Next refresh with updates will occur again in August
  2008. Static table until then.
  PS_DWEO_PERSON_PRIM_JOB_HS  6/14/2008  Next refresh with updates will occur again in October
  2008. Static table until then.
  PS_DWEO_PERSON_SEC_JOB  6/14/2008  Next refresh with updates will occur again in August
  2008. Static table until then.
  PS_DWEO_PERSON_SEC_JOB_HS  6/14/2008  Next refresh with updates will occur again in October
  2008. Static table until then.

New Tables

 Table Name  Available Date  Notes
  PS_DW_DEPTID_FISCAL_TREE  6/16/2008 
  PS_DW_DEPTID_REPORT_TREE  6/16/2008