Main | March 2008 »

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:

DWHN


Phase I
PS_DWHR_COMP_PROP:   Excel File   Web Page
PS_DWHR_JOB:   Excel File   Web Page
PS_DWHR_JOB_HIST:   Excel File   Web Page
PS_DWHR_POSITION_DATA:   Excel File   Web Page
PS_DWHR_DEMO_ADDR:   Excel File   Web Page

February 6, 2008

DW Presentation to Analysts/Database Group

These are the links to the table specs that were used for todays presentation. This blog will contain links to future specs and also alert you to when new tables are available for testing in DWTEST.
Test.

ps_dwhr_job

ps_dwsf_sf_acctg_ln_xx

ps_dwpy_pay_frng_xx

ps_dw_deptid_fiscal_tree

link: https://dw-test.ims.umn.edu/efsupdates/