PERSON_FRA(SQL Table) |
Index Back |
---|---|
Person Subrecord - FRAAssociate Record to PERSON for France |
# | 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 |