WCS_SO_ECORE_VW

(SQL View)
 Index Back

Core Employee Data Tables

This view presents the core employee tables. It is used as a prompt on the Employee Data source definition page.

SELECT HCMD_CLASSID , DESCR FROM PS_HCMD_META_TBL WHERE HCMD_CLASSID IN ('EMPLOYMENT', 'JOB_HISTORY', 'JOB_JR', 'NAMES', 'PERSON', 'PERSON_ORG', 'TL_EMPL_DATA', 'PERDATAEFFDT')

  • Related Language Record: WCS_SO_ECORE_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCMD_CLASSID Character(12) VARCHAR2(12) NOT NULL EI_CLASSID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description