PERSON_FRA

(SQL Table)
Index Back

Person Subrecord - FRA

Associate Record to PERSON for France

  • 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

    3 TGT_EDUC_LVL_FRA Character(2) VARCHAR2(2) NOT NULL Target Education Level. DSN Data Type 30.025. DSN node attribute S21.G00.30.025
    A=A-Not Indicated
    A=Not Indicated
    B=B-Less Than HS Graduate
    B=Less Than HS Graduate
    C=C-HS Graduate or Equivalent
    C=HS Graduate or Equivalent
    D=D-Some College
    D=Some College
    E=E-Technical School
    E=Technical School
    F=F-2-Year College Degree
    F=Associate Degree
    G=G-Bachelor's Level Degree
    G=Bachelors Level Degree
    H=H-Some Graduate School
    H=Some Graduate School
    I=I-Master's Level Degree
    I=Masters Level Degree
    J=J-Doctorate (Academic)
    J=Doctorate (Academic)
    K=K-Doctorate (Professional)
    K=Doctorate (Professional)
    L=L-Post-Doctorate
    L=Post-Doctorate