HRS_BIP_JSCR_VW(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OXMLP report Print Job Opening Screening Options |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.JOBCODE , A.HRS_JO_PRM_JCD_FLG , B.HRS_JO_SCR_SEQ , B.HRS_SCREENING_ID , D.DESCR FROM PS_HRS_JO_RQMT A , PS_HRS_JO_SCR_S_VW B , PS_HRS_SCREEN_VW D WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND A.HRS_JO_RQMT_SEQ = B.HRS_JO_RQMT_SEQ AND A.HRS_JO_PRM_JCD_FLG = 'Y' AND D.HRS_SCREENING_ID = B.HRS_SCREENING_ID |
| # | 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 | HRS_JO_RQMT_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening requirement sequence |
| 3 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 4 | HRS_JO_PRM_JCD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Primary job code for job opening
N=No Y=Yes |
| 5 | HRS_JO_SCR_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening screening sequence |
| 6 | HRS_SCREENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Screening ID |
| 7 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |