UPG_HRS_LSR_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 |
| 7 | HRS_SUBCATG | Character(2) | VARCHAR2(2) NOT NULL |
Hire Data Type Subcatagory
1=Person 11=Eligibility/Identity 12=Honors and Awards 13=Identification Data 14=Languages 15=Licenses & Certificates 16=Memberships 17=Prior Work Experience 18=Test Results 19=National ID 2=Addresses 20=Accomodation 21=Diversity 22=School Education 23=Training 24=Contract Data 25=Professional Education 26=Person Names 3=Email Addresses 4=Phones 5=Competencies 6=Appl/Person Assignment Chklist 7=Applicant/Employment Contracts 8=Bank Accounts 9=Disabilities |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |