| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RESPONSE_DUE_DT |
Date(10) |
DATE |
Response Due Date
|
| 3 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 4 |
HRS_CHKLST_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Checklist ID
|
| 5 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 6 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 7 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 8 |
HRS_ANSWER_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies an answer definition that can be associated to a question. An applicant can respond to a questionnaire made up of particular questions and answers associated to the job requisition(s) being applied for.
|
| 9 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 10 |
APP_DT |
Date(10) |
DATE |
Date an application was submitted
|
| 11 |
HRS_OTH_DATPSD |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Data Pushed
N=No
Y=Yes
|
| 12 |
CHECKLIST_DT |
Date(10) |
DATE |
Checklist Date
|
| 13 |
CHECKLIST_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Checklist Sequence
|
| 14 |
HRS_RTE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Route ID
|
| 15 |
WC_DECISION_DTTM |
DateTime(26) |
TIMESTAMP |
Works Council decision date/time
|
| 16 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 17 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 18 |
WC_DECISION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Works Council Decision
|
| 19 |
HRS_APP_WC_DEC_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Works Council Decision ID
|
| 20 |
HRS_CHKLST_ITM_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Checklist Item Sequence
|
| 21 |
HRS_QSTN_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Question ID
|
| 22 |
HRS_QSTN_SET_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Question set identifier
|
| 23 |
HRS_QSTN_SET_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Question Set Code
|
| 24 |
HRS_RCMNT_LTR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruitment Letter ID
|
| 25 |
HRS_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 26 |
HRS_QSTN_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Question Code
|
| 27 |
ROUTE_DT |
Date(10) |
DATE |
Route Date
|
| 28 |
ROUTE_TO_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Route To ID
|
| 29 |
HRS_LAST_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Recruitment ID
|
| 30 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 31 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 32 |
HRS_LAST_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Last Sequence Number
|
| 33 |
HRS_RTE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Route Sequence
|
| 34 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 35 |
OFFER_DT |
Date(10) |
DATE |
Offer Date
|
| 36 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 37 |
HRS_OFF_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Offer ID
|
| 38 |
COMMENT_DT |
Date(10) |
DATE |
Comment Date
|
| 39 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 40 |
LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter code
|
| 41 |
LETTER_PRINTED_DT |
Date(10) |
DATE |
Date letter was printed
|
| 42 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 43 |
APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status
A=All Approved
D=Denied
P=In Approval Process
U=Needs Approval
|
| 44 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
|
| 45 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
|
| 46 |
PROCESS_PREHIRE |
Character(1) |
VARCHAR2(1) NOT NULL |
Prehire Processing Requested
|
| 47 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 48 |
RESPONSE_DT |
Date(10) |
DATE |
Response Date
|
| 49 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
|
| 50 |
OFFER_REJECT_RSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reject Reason
B=Benefits
J=Another Job
N=Not Specified
P=Personal
S=Salary
|
| 51 |
RESPONSE_OFFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Response to Offer
A=Accepted
N=No Response
R=Rejected
U=Under Negotiation
W=Withdrawn
|
| 52 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 53 |
SRC_KEY |
Character(254) |
VARCHAR2(254) NOT NULL |
Hire Request Source Key
|
| 54 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 55 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 56 |
NAME_DISPLAY |
Character(50) |
VARCHAR2(50) NOT NULL |
Display Name - name formatted for Display based on the Country
|
| 57 |
HRS_STATUS_DT |
Date(10) |
DATE |
Recruiting Solutions Status Date field
|
| 58 |
ENTRY_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Source
A=Application
O=Organization
|
| 59 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
|
| 60 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 61 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 62 |
OFF_REFSRC_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Official 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
|
| 63 |
OFF_REFSRC_SUB |
Character(2) |
VARCHAR2(2) NOT NULL |
Official Referral Subcategory
|
| 64 |
REQST_ADDTNL_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Additional Info
|
| 65 |
KEYWORD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Keywords Matched
|
| 66 |
CHKLST_ITEM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Item Code
|
| 67 |
BRIEFING_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Briefing Status
C=Completed
I=Initiated
N=Notified
R=Received
|
| 68 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 69 |
CONTRACT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Contract Seq#
|
| 70 |
CONTRACT_CLAUSE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Clause
|
| 71 |
CLAUSE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Clause Status
1=Optional
2=Required
|
| 72 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|