HRS_INT_SRCH(SQL View) |
Index Back |
|---|---|
SS Requisition Search -RoutingHR_SS_REQ_SRCH2 is used for the Self Service transaction to retrieve those requisitions, where applicants past the screening and are ready for routing. |
| SELECT A.HRS_JOB_OPENING_ID , ' ' , A.BUSINESS_UNIT , ' ' , C.DESCR , A.DEPTID ,' ' ,' ' , A.COMPANY , A.STATUS_CODE , B.OPEN_STS_IND , A.ORIGINATOR_ID , ' ' , ' ' FROM PS_HRS_JO_I A ,PS_HRS_STS_REC_I B ,PS_JOBCODE_TBL C WHERE B.STATUS_CODE = A.STATUS_CODE AND EXISTS( SELECT 'X' FROM PS_HRS_PSN_APP_SCH C WHERE A.HRS_JOB_OPENING_ID = C.HRS_JOB_OPENING_ID) AND A.JOBCODE = C.JOBCODE AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(CC1.EFFDT) FROM PS_JOBCODE_TBL CC1 WHERE CC1.JOBCODE = C.JOBCODE AND CC1.EFFDT <= %CurrentDateIn AND C.SETID = CC1.SETID) AND C.SETID = ( SELECT C1.SETID FROM PS_SET_CNTRL_REC C1 WHERE C1.SETCNTRLVALUE = A.BUSINESS_UNIT AND C1.RECNAME = 'JOBCODE_TBL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSN_NOEFFDT_VW |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR |
| 4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 5 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 7 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 10 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table: HRS_STS_JO_VW |
| 11 | OPEN_STS_IND | Character(1) | VARCHAR2(1) NOT NULL | Indicates an open state. |
| 12 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Originator's ID
Prompt Table: PERSON_NAME |
| 13 | AUTHORIZATION_ID | Character(11) | VARCHAR2(11) NOT NULL |
Authorization ID
Prompt Table: PERS_DTA_EMP_VW |
| 14 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |