EMPLIDDefault Value: NEW
EFFDTDefault Value: %date
HRS_SOURCE_IDPrompt Table: HRS_SOURCE_I
HRS_SUBSOURCE_IDPrompt Table: HRS_SUBSOURCE_I
SPECIFIC_REFER_SRCEMPL_REFERRAL_IDPrompt Table: PERS_APPL_NAME
Y/N Table Edit
Y/N Table Edit
PERS_APPL_REF(SQL Table) |
Index Back |
|---|---|
Applicant - Person ReferralApplicant - Person Referral Information. This table captures the various referral source info for an Applicant. This record is updated when the applicant is hired. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | HRS_SOURCE_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Source ID
Prompt Table: HRS_SOURCE_I |
| 4 | HRS_SUBSOURCE_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
SubSource ID
Prompt Table: HRS_SUBSOURCE_I |
| 5 | SPECIFIC_REFER_SRC |
Character(50) | VARCHAR2(50) NOT NULL | Specific Referral Source |
| 6 | EMPL_REFERRAL_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee Referral ID
Prompt Table: PERS_APPL_NAME |
| 7 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 8 | HRS_PROFILE_SEQ | Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 9 | PREV_EMPL_BY_COMPY | Character(1) | VARCHAR2(1) NOT NULL |
Previously Employed by Company
Y/N Table Edit |
| 10 | APP_IS_FAMILY | Character(1) | VARCHAR2(1) NOT NULL |
Applicant is a family member
Y/N Table Edit |
| 11 | RESUME_TEXT_FILE | Character(64) | VARCHAR2(64) NOT NULL | Resume text file |