HR_REQUEST_HIST(SQL Table) |
Index Back |
|---|---|
Hire RequestHire Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | HIRE_REQUEST_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Hire Request ID |
| 4 | SRC_SYSTEM | Character(254) | VARCHAR2(254) NOT NULL | Source System |
| 5 | SRC_KEY | Character(254) | VARCHAR2(254) NOT NULL | Hire Request Source Key |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | DSRD_ST_DT | Date(10) | DATE | Desired Start Date |
| 11 | APPLICANT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Applicant Type
E=External - New F=External - Previous Employee I=Internal - Employee N=Internal - Non-Employee |
| 12 | SM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Run
N=No Y=Yes Default Value: N |
| 13 | ORG_INSTANCE_ERN | Number(3,0) | SMALLINT NOT NULL | Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level. |
| 14 | HIRE_COMMENTS | Character(254) | VARCHAR2(254) NOT NULL | Hire Comments |
| 15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 16 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 17 | HIRE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Hire
H=Hire J=Add Concurrent Job R=Rehire T=Transfer W=Add Contingent Worker |
| 18 | HIRED_MSG_SENT | Character(1) | VARCHAR2(1) NOT NULL |
Hired Message Sent (Y/N)
N=No Y=Yes Default Value: N |
| 19 | PERSON_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
Person Created
N=No Y=Yes Default Value: N |
| 20 | JOB_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
Job Created
N=No Y=Yes Default Value: N |
| 21 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 22 | APPNAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 23 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 24 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 25 | HR_REQUEST_STTS | Character(1) | VARCHAR2(1) NOT NULL |
Hire Request Status
A=Action Required C=Completed D=Draft E=Error H=Hired O=Cancel R=Requested X=All |
| 26 | TBH_SEQ | Number(12,0) | DECIMAL(12) NOT NULL | Template Sequence |