UPG_PERS_APPL_I(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 4 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 5 | 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 |
| 6 | REF_SRC_SUB_CAT |
Character(2) | VARCHAR2(2) NOT NULL | Referral Source Detail |
| 7 | SPECIFIC_REFER_SRC | Character(50) | VARCHAR2(50) NOT NULL | Specific Referral Source |
| 8 | EMPL_REFERRAL_ID | Character(11) | VARCHAR2(11) NOT NULL | Employee Referral ID |
| 9 | PREV_EMPL_BY_COMPY | Character(1) | VARCHAR2(1) NOT NULL | Previously Employed by Company |
| 10 | APP_IS_FAMILY | Character(1) | VARCHAR2(1) NOT NULL | Applicant is a family member |
| 11 | RESUME_TEXT_FILE | Character(64) | VARCHAR2(64) NOT NULL | Resume text file |
| 12 | HRS_SOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 13 | HRS_SUBSOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL | SubSource ID |