Main

May 20, 2008

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.

Continue reading "Effective Dates for Tables Changing in DWHN" »

February 27, 2008

Tables in DWHN

The following changes will be made to tables in DWHN in Phase I:
( for Phase II changes, click here)

  • PS_DWHR_COMP_PROP:
    • DEPTID may include 5-character values now.
    • Added column UM_ENTITY, which represents the HR DEPTID.
    • Added column UM_ENTITY_DESCR.

  • PS_DWHR_JOB:
    • DEPTID values may be 4-5 characters.
    • CUFS_AREA will be populated on for 4-character DEPTID rows; otherwise NULL.
    • AREA_CLASS will be replaced with RRC.
    • AREA_CLS_AME30 will replaced with RRC_DESCR.
    • AREA_CAT will be replaced with VP.
    • AREA_CAT_NAME30 will be replaced with VP_DESCR.
    • Added column UM_ENTITY, whcih represents the HR DEPTID.
    • Added column UM_ENTITY_DESCR.
    • Added column UM_ENTITY_ENTRY_DT.
    • Dropped column UM_MAIL_DROP.
    • Dropped column UM_MAIL_DROP_DESCR.

  • PS_DWHR_JOB_HIST:
    • DEPTID values may be 4-5 characters.
    • CUFS_AREA will be populated on for 4-character DEPTID rows; otherwise NULL.
    • AREA_CLASS will be replaced with RRC.
    • AREA_CLS_AME30 will replaced with RRC_DESCR.
    • AREA_CAT will be replaced with VP.
    • AREA_CAT_NAME30 will be replaced with VP_DESCR.
    • Added column UM_ENTITY, which represents the HR DEPTID.
    • Added column UM_ENTITY_DESCR.
    • Added column UM_ENTITY_ENTRY_DT.

  • PS_DWHR_POSITION_DATA:
    • DEPTID values may be 4-5 characters.
    • Added column UM_ENTITY. Represents the HR DEPTID.
    • Added column UM_ENTITY_DESCR.




Below are links to table specs for the DWHN tables requiring updates. Please be aware that this is not a comprehensive list of all DWHN tables:

Continue reading "Tables in DWHN" »