HRS_BIP_EQST_VW(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OXMLP report Print Job Opening Screening Questions |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.JOBCODE , A.HRS_JO_PRM_JCD_FLG , B.HRS_QSTN_ID , D.DESCR , B.HRS_QSTN_ORDER_NBR FROM PS_HRS_JO_RQMT A , PS_HRS_JO_EMP_QSTN B , PS_HRS_QSTN_TBL_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_QSTN_ID = B.HRS_QSTN_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_QSTN_ID | Number(15,0) | DECIMAL(15) NOT NULL | Question ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | HRS_QSTN_ORDER_NBR | Number(3,0) | SMALLINT NOT NULL | Question ID |