HRS_ONLOFR_CE_I(SQL View) |
Index Back |
|---|---|
Employmt Offers to ApplicantsUse HRS_OFFER to record details about job offers made to applicants for employment. This data is used in the Recruitment module. |
| SELECT OFRA.HRS_PERSON_ID , OFRA.HRS_RCMNT_ID , OFRA.HRS_OFF_ID , OFRA.JOBCODE , OFRA.POSITION_NBR , OFRA.HRS_REPORT_DEFN_ID , OFRA.HRS_REPORT_TMPL_ID , OFRA.LETTER_PRINTED_DT , OFRA.OFFER_DT , OFRA.LOCATION , OFRA.HRS_STATUS_DT , OFRA.STATUS_CODE , OFRA.STATUS_REASON , OFRA.STEP , OFRA.RESPONSE_DT , OFRA.PAY_FREQ_ABBRV , OFRA.OFFER_REJECT_RSN , OFRA.RESPONSE_OFFER , OFRA.ORIGINATOR_ID , OFRA.AUTHORIZATION_ID , OFRA.AUTHORIZATION_DT , OFRA.RECRUITER_ID , OFRA.HRS_HIRING_MGR_ID , OFRA.BUSINESS_UNIT , OFRA.WC_COUNCIL_ID , OFRA.HRS_OFR_DT_EXP , OFRA.HRS_PROP_ST_DT , OFRA.HRS_ONLN_OFR_POSTD , OJO.HRS_JOB_OPENING_ID , OJO.HRS_PRM_PST_TITLE , OJO.HRS_RESP_STATUS , OJO.HRS_JO_NTF_DELETED , RCM.HRS_LOGICAL_DELETE , %subrec(HRS_AUDIT_SBR, OFRA) FROM PS_HRS_OFFER OFRA , PS_HRS_RCMNT RCM , PS_HRS_OJOR OJO WHERE OFRA.HRS_PERSON_ID = RCM.HRS_PERSON_ID AND OFRA.HRS_RCMNT_ID = RCM.HRS_RCMNT_ID AND RCM.HRS_LOGICAL_DELETE = 'N' AND RCM.STATUS_CODE <> '130' AND OFRA.HRS_PERSON_ID = OJO.HRS_PERSON_ID AND OFRA.HRS_RCMNT_ID = OJO.HRS_RCMNT_ID AND OFRA.HRS_OFF_ID = OJO.HRS_OFF_ID AND OFRA.HRS_OFF_ID = ( SELECT MAX(OFRB.HRS_OFF_ID) FROM PS_HRS_OFFER OFRB WHERE OFRA.HRS_PERSON_ID = OFRB.HRS_PERSON_ID AND OFRA.HRS_RCMNT_ID = OFRB.HRS_RCMNT_ID) AND OFRA.HRS_ONLN_OFR_POSTD = 'Y' |
| # | 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 | HRS_REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | The Fusion Publisher Report Definition ID used by Recruiting |
| 7 | HRS_REPORT_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | The Fusion publisher Report template ID used by RS. |
| 8 | LETTER_PRINTED_DT | Date(10) | DATE | Date letter was printed |
| 9 | OFFER_DT | Date(10) | DATE |
Offer Date
Default Value: %date |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 11 | HRS_STATUS_DT | Date(10) | DATE | Recruiting Solutions Status Date field |
| 12 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table: HRS_STS_OFF_I |
| 13 | STATUS_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
Prompt Table: HRS_RSN_OFF_I |
| 14 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 15 | RESPONSE_DT | Date(10) | DATE | Response Date |
| 16 | PAY_FREQ_ABBRV | Character(1) | VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual B=Bi-weeky H=Hour M=Month Y=Year Default Value: M |
| 17 | OFFER_REJECT_RSN | Character(1) | VARCHAR2(1) NOT NULL |
Reject Reason
B=Benefits J=Another Job N=Not Specified P=Personal S=Salary |
| 18 | RESPONSE_OFFER | Character(1) | VARCHAR2(1) NOT NULL |
Response to Offer
A=Accepted N=No Response R=Rejected U=Under Negotiation W=Withdrawn Default Value: N |
| 19 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Originator's ID |
| 20 | AUTHORIZATION_ID | Character(11) | VARCHAR2(11) NOT NULL |
Authorization ID
Prompt Table: HRS_PERSON_NM_I |
| 21 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
| 22 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 23 | HRS_HIRING_MGR_ID | Character(11) | VARCHAR2(11) NOT NULL | Hiring Manager |
| 24 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 25 | WC_COUNCIL_ID | Character(9) | VARCHAR2(9) NOT NULL | Works Council ID |
| 26 | HRS_OFR_DT_EXP | Date(10) | DATE | Offer Expiration Date |
| 27 | HRS_PROP_ST_DT | Date(10) | DATE | Start Date |
| 28 | HRS_ONLN_OFR_POSTD | Character(1) | VARCHAR2(1) NOT NULL | Online Job Posted |
| 29 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 30 | HRS_PRM_PST_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 31 | HRS_RESP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Offer Response Status
A=Accepted C=Created O=Original R=Rejected S=Saved V=Viewed |
| 32 | HRS_JO_NTF_DELETED | Character(1) | VARCHAR2(1) NOT NULL | Job Offer Notification Deletion Indicator |
| 33 | HRS_LOGICAL_DELETE | Character(1) | VARCHAR2(1) NOT NULL | Indicates row has been logically deleted. |
| 34 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 35 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 36 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 37 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |