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" »