EMPLID1=Email
2=Direct Hire
3=Web
4=Online Applicant Entry
U=Unknown
Prompt Table: FO_RCRT_SRC_VW
Prompt Table: FO_RCT_CTSRC_VW
Prompt Table: FO_EMPL_NAME_VW
FOEMPSRCDAT_UPG(SQL Table) |
Index Back |
|---|---|
Source Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMP_DATA_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source
1=Email 2=Direct Hire 3=Web 4=Online Applicant Entry U=Unknown |
| 3 | RECRUIT_CAT | Character(6) | VARCHAR2(6) NOT NULL |
Recruit Source Category
Prompt Table: FO_RCRT_SRC_VW |
| 4 | RECRUIT_SRC | Character(6) | VARCHAR2(6) NOT NULL |
Recruiting Source
Prompt Table: FO_RCT_CTSRC_VW |
| 5 | REC_SRC_ID | Character(20) | VARCHAR2(20) NOT NULL | Recruiting Source ID |
| 6 | AD_ID | Character(20) | VARCHAR2(20) NOT NULL | Ad ID |
| 7 | EMP_SRC_DT | Date(10) | DATE | Date Received |
| 8 | SPECIFIC_EMP_SRC | Character(30) | VARCHAR2(30) NOT NULL | Specific Source |
| 9 | REFERRING_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Referring Name
Prompt Table: FO_EMPL_NAME_VW |
| 10 | REFERRING_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Referring Emplid |
| 11 | COMMENTS | Long Character | CLOB | Comment |