HRS_RCRT_TMPL_IDHRS_JO_TMPL_IDHRS_QSTN_SET_IDHRS_JO_QSTN_VW(SQL View) |
Index Back |
|---|---|
Job Opening Tmpl Sctn VwJob opening template section view excluding job information section |
| SELECT RCRT_TMPL.HRS_RCRT_TMPL_ID , JO_TMPL.HRS_JO_TMPL_ID , JO_TMPL.HRS_QSTN_SET_ID , QSET_QSTN.HRS_QSTN_ID FROM PS_HRS_RCRT_TMPL RCRT_TMPL , PS_HRS_JO_TMPL JO_TMPL , PS_HRS_QSET_QSTN QSET_QSTN WHERE RCRT_TMPL.HRS_JO_TMPL_ID = JO_TMPL.HRS_JO_TMPL_ID AND JO_TMPL.HRS_QSTN_SET_ID = QSET_QSTN.HRS_QSTN_SET_ID AND %EffdtCheck(HRS_RCRT_TMPL, RCRT_TMPL, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_RCRT_TMPL_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Recruitment Template ID |
| 2 | HRS_JO_TMPL_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Template ID |
| 3 | HRS_QSTN_SET_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Question set identifier |
| 4 | HRS_QSTN_ID | Number(15,0) | DECIMAL(15) NOT NULL | Question ID |