HRS_PERSON_IDHRS_RCMNT_IDHRS_OFF_IDHRS_OFFER_VW(SQL View) |
Index Back |
|---|---|
Employmt Offer to ApplicantsUse OFFER to record details about job offers made to applicants for employment. This data is used in the Recruitment module. |
| SELECT OFR.HRS_PERSON_ID , OFR.HRS_RCMNT_ID , OFR.HRS_OFF_ID , OFR.JOBCODE , OFR.POSITION_NBR , OFR.OFFER_DT , OFR.RECRUITER_ID , OFR.HRS_HIRING_MGR_ID , OFR.BUSINESS_UNIT , SCR.SETID , OFR.HRS_OFR_DT_EXP , OFR.HRS_PROP_ST_DT FROM PS_HRS_OFFER OFR , PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OFR.BUSINESS_UNIT AND SCR.RECNAME = 'JOBCODE_TBL' |
| # | 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 |
| 7 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 8 | HRS_HIRING_MGR_ID | Character(11) | VARCHAR2(11) NOT NULL | Hiring Manager |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 11 | HRS_OFR_DT_EXP | Date(10) | DATE | Offer Expiration Date |
| 12 | HRS_PROP_ST_DT | Date(10) | DATE | Start Date |