| # |
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 |
HRS_VIEW_JO_LTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to allow viewing of Job Offer Letter
|
| 16 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 17 |
HRS_OFF_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Offer ID
|
| 18 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 19 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 20 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 21 |
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
|
| 22 |
HIRED_MSG_SENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Hired Message Sent (Y/N)
N=No
Y=Yes
Default Value: N
|
| 23 |
PERSON_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Person Created
N=No
Y=Yes
Default Value: N
|
| 24 |
JOB_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Created
N=No
Y=Yes
Default Value: N
|
| 25 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 26 |
APPNAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 27 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 28 |
RECRUITER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Recruiter ID
|
| 29 |
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
|
| 30 |
TBH_SEQ |
Number(12,0) |
DECIMAL(12) NOT NULL |
Template Sequence
|
| 31 |
TBH_PERSON_JOB_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Person/Job Indicator
B=Update Person and Job
H=Hire/Rehire
J=Update Job
N=Neither
P=Update Person
Default Value: H
|
| 32 |
TBH_TMPL_TXN_TYP |
Character(10) |
VARCHAR2(10) NOT NULL |
Template Transaction Type
Default Value: HIRE
Prompt Table:
HR_TBH_TXN_TBL
|
| 33 |
TBH_SOURCE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Source indicator
H=Manage Hires
T=Manage Transactions
|
| 34 |
TBH_TXN_COMP_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Template Transaction Component Count.
Default Value: 1
|
| 35 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1
|
| 36 |
TBH_CREATED1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 37 |
TBH_CREATED2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 38 |
TBH_CREATED3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 39 |
TBH_CREATED4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 40 |
TBH_CREATED5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 41 |
TBH_CREATED6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 42 |
TBH_CREATED7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 43 |
TBH_CREATED8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 44 |
TBH_CREATED9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|
| 45 |
TBH_CREATED10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created flag.
Y/N Table Edit
Default Value: N
|