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_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 , 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_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
8 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
9 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
10 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_OFF_I

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

Prompt Table: HRS_RSN_OFF_I

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