HRS_AL_SRC_TAO(SQL Table) |
Index Back |
|---|---|
Temp Table for Applicant LogTemp Table for Applicant Log Source upgrade |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_AL_LOG_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Unique Identifier - For Log Source |
| 2 | HRS_AL_LOG_ID | Number(15,0) | DECIMAL(15) NOT NULL | Resume Extraction Queue ID |
| 3 | HRS_SOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 4 | HRS_SUBSOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Subsource Id |
| 5 | HRS_SUBSOURCE_DESC | Character(50) | VARCHAR2(50) NOT NULL | Subsource Description |
| 6 | REFERRAL_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Referral Source
AD=Advertisement AG=Agency CL=Client Referral CO=College Recruiting CR=College Recommendation EE=Employee ES=Employment Securitry Bureau FE=Former Employee JF=Job Fair JP=Job Posting OH=Open House OT=Other Source PI=Phone Inquiry UK=Unknown US=Unsolicited WI=Walk-In XR=Executive Referral XS=Executive Search |