PERSDATA_FRA_CV

(SQL View)
 Index Back

PERSON for FRA Clairvia

Clone of PERS_DATA_FRA record for Clairvia Fullsync message

SELECT FRA.EMPLID , FRA.EFFDT , FRA.ENTRY_DT_FRA , FRA.MILIT_SITUATN_FRA , FRA.CPAMID FROM PS_PERS_DATA_FRA FRA , PS_PER_ORG_ASG_INT ASG WHERE %EffdtCheck(PERS_DATA_FRA,FRA,%CurrentDateIn) AND 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: PERSON.EMPLID

    Prompt Table: PERSON

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 ENTRY_DT_FRA Date(10) DATE Date of First Entry in France
    4 MILIT_SITUATN_FRA Character(3) VARCHAR2(3) NOT NULL Military Status
    APA=No Country Person
    BEN=Asile Right
    DEG=Military Service Done
    ETR=Alien
    REF=Reformed (don't do milit serv)
    SER=Military Service to Come
    SUR=Military Service Delayed
    5 CPAMID Character(6) VARCHAR2(6) NOT NULL CPAM ID

    Prompt Table: CPAM_TBL