FO_APP_DATA(SQL Table) |
Index Back |
|---|---|
Applicant DataFront Office specific applicant fields. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  APPLID |
Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 2 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table: FO_RSRC_PRIORTY |
| 3 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: %EDITTABLE3 |
| 4 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: FO_VNDR_LOC_VW |
| 5 | PROSPECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Customer/Prospect Flag
Y/N Table Edit |
| 6 | I9_COMPL_DT | Date(10) | DATE | I9 Date Completed |
| 7 | ALT_DOC_DT | Date(10) | DATE | Alt Doc Expiration |
| 8 | PER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Person Type
A=Applicant C=Cobra Participant D=GP Dependent/Beneficiary E=Leased Worker I=Independent Contractor L=Time & Labor Contractor M=Temporary Worker N=Non HR Administered Employee O=Other Non-Employee P=Pension Payee S=Stock Non-Employee T=Training Non-Employee U=Succession Candidate Non-Emplo |