PERSON_FRA_CV

(SQL View)
 Index Back

Person Subrecord - FRA Clairvi

Clone of PERSON_FRA record for Clairvia Fullsync message

SELECT FRA.EMPLID , FRA.WRK_EXP_FRA_CD FROM PS_PERSON_FRA FRA , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = FRA.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

    Default Value: NEW

    2 WRK_EXP_FRA_CD Character(1) VARCHAR2(1) NOT NULL Working Experience Code. This code is used by the Single Hiring Statement.

    Prompt Table: WRK_EXP_FRA_TBL