HRS_OFFER_I

(SQL View)
 Index Back

Employmt Offers to Applicants

Use HRS_OFFER to record details about job offers made to applicants for employment. This data is used in the Recruitment module.

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_OFF_ID , A.JOBCODE , A.POSITION_NBR , A.OFFER_DT , A.HRS_PROP_ST_DT , A.HRS_OFR_DT_EXP , A.HRS_ONLN_OFR_POSTD , A.HRS_REPORT_DEFN_ID , A.HRS_REPORT_TMPL_ID , A.LETTER_PRINTED_DT , A.STATUS_CODE , A.STATUS_REASON , A.HRS_HIRING_MGR_ID , A.RECRUITER_ID , A.HRS_STATUS_DT , A.WC_COUNCIL_ID , %subrec(HRS_AUDIT_SBR, A) , A.BUSINESS_UNIT FROM PS_HRS_OFFER A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
6 OFFER_DT Date(10) DATE Offer Date

Default Value: %date

7 HRS_PROP_ST_DT Date(10) DATE Start Date
8 HRS_OFR_DT_EXP Date(10) DATE Offer Expiration Date
9 HRS_ONLN_OFR_POSTD Character(1) VARCHAR2(1) NOT NULL Online Job Posted
10 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
11 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
12 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
13 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_OFF_I

14 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

Prompt Table: HRS_RSN_OFF_I

15 HRS_HIRING_MGR_ID Character(11) VARCHAR2(11) NOT NULL Hiring Manager
16 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
17 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
18 WC_COUNCIL_ID Character(9) VARCHAR2(9) NOT NULL Works Council ID
19 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
20 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
21 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
22 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit