PERS_WLF_CHN_CV

(SQL View)
 Index Back

PersonWorkLifeInf China Clairv

Clone of PERS_WRKLIF_CHN record for Clairvia Fullsync message

SELECT CHN.EMPLID , CHN.START_DT_CHN FROM PS_PERS_WRKLIF_CHN CHN , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = CHN.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 START_DT_CHN Date(10) DATE Work Life Start date