HRS_OFFER_MAX_I

(SQL View)
 Index Back

Latest Offer Made to Applicant

Retrieves the latest offers made to applicants.

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_OFF_ID , A.OFFER_DT , A.HRS_REPORT_DEFN_ID , A.HRS_REPORT_TMPL_ID , A.LETTER_PRINTED_DT , A.HRS_STATUS_DT , A.STATUS_CODE , A.STATUS_REASON , A.JOBCODE , A.LOCATION , A.POSITION_NBR , A.STEP , A.HRS_HIRING_MGR_ID , A.RECRUITER_ID FROM PS_HRS_OFFER A WHERE A.HRS_OFF_ID = ( SELECT MAX(B.HRS_OFF_ID) FROM PS_HRS_OFFER B WHERE %Join(COMMON_KEYS, HRS_OFFER A, HRS_OFFER B,HRS_OFF_ID))

# 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 OFFER_DT Date(10) DATE Offer Date

Default Value: %date

5 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
6 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
7 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
8 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
9 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_OFF_I

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

Prompt Table: HRS_RSN_OFF_I

11 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
13 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
14 STEP Number(2,0) SMALLINT NOT NULL Step
15 HRS_HIRING_MGR_ID Character(11) VARCHAR2(11) NOT NULL Hiring Manager
16 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID