« Tables in DWSP | Main | Tables in DWTA »

Tables in DWHN

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

  • PS_DWEO_PERSON_PRIM_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, which represents the HR DEPTID.
    • Added column UM_ENTITY_DESCR.
  • PS_DWEO_PERSON_SEC_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, which represents the HR DEPTID.
    • Added column UM_ENTITY_DESCR.

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


Phase II
PS_DWEO_PERSON_PRIM_JOB: Excel File   Web Page
PS_DWEO_PERSON_PRIM_JOB_HS: Excel File   Web Page
PS_DWEO_PERSON_SEC_JOB: Excel File   Web Page
PS_DWEO_PERSON_SEC_JOB_HS: Excel File   Web Page