HRS_PERSD_FRA_I

(SQL View)
 Index Back

Interface View for France

Interface View for French Person Data

SELECT A.EMPLID , A.EFFDT , A.ENTRY_DT_FRA , A.MILIT_SITUATN_FRA , A.CPAMID FROM PS_PERS_DATA_FRA A

  • 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