HR_REQUEST

(SQL Table)
Index Back

Hire Request

Hire Request

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HIRE_REQUEST_ID Number(10,0) DECIMAL(10) NOT NULL Hire Request ID
2 SRC_SYSTEM Character(254) VARCHAR2(254) NOT NULL Source System
3 SRC_KEY Character(254) VARCHAR2(254) NOT NULL Hire Request Source Key
4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 DSRD_ST_DT Date(10) DATE Desired Start Date
9 APPLICANT_TYPE Character(1) VARCHAR2(1) NOT NULL Applicant Type
E=External - New
F=External - Previous Employee
I=Internal - Employee
N=Internal - Non-Employee
10 SM_RUN Character(1) VARCHAR2(1) NOT NULL Search Match Run
N=No
Y=Yes

Default Value: N

11 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.
12 HIRE_COMMENTS Character(254) VARCHAR2(254) NOT NULL Hire Comments
13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
14 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
15 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
16 HIRED_MSG_SENT Character(1) VARCHAR2(1) NOT NULL Hired Message Sent (Y/N)
N=No
Y=Yes

Default Value: N

17 PERSON_CREATED Character(1) VARCHAR2(1) NOT NULL Person Created
N=No
Y=Yes

Default Value: N

18 JOB_CREATED Character(1) VARCHAR2(1) NOT NULL Job Created
N=No
Y=Yes

Default Value: N

19 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
20 APPNAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
21 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
22 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
23 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
24 TBH_SEQ Number(12,0) DECIMAL(12) NOT NULL Template Sequence