HRS_RCRT_TMPL_IDHRS_JO_TMPL_IDHRS_PAGE_NBRHRS_JO_TMPL_SCTN12LANGUAGE_CDHRS_JO_TMSEC_LN(SQL View) |
Index Back |
|---|---|
Template SectionsTemplate Sections |
| SELECT RCR.HRS_RCRT_TMPL_ID , JOP.HRS_JO_TMPL_ID , JOP.HRS_PAGE_NBR , JOT.HRS_JO_TMPL_SCTN12 , JOTVW.LANGUAGE_CD , JOP.DESCR , JOTVW.DESCR FROM PS_HRS_RCRT_TMPL RCR , PS_HRS_JOTMPLP_LNG JOP , PS_HRS_JO_TMPL_SCT JOT , PS_HRS_JO_TMPLS_LN JOTVW WHERE RCR.HRS_JO_TMPL_ID = JOP.HRS_JO_TMPL_ID AND RCR.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_HRS_RCRT_TMPL A WHERE A.EFFDT <= %CurrentDateIn AND RCR.HRS_RCRT_TMPL_ID = A.HRS_RCRT_TMPL_ID AND A.EFF_STATUS = 'A') AND JOP.HRS_JO_TMPL_ID = JOT.HRS_JO_TMPL_ID AND JOP.HRS_PAGE_NBR = JOT.HRS_PAGE_NBR AND JOTVW.HRS_JO_TMPL_SCTN12 = JOT.HRS_JO_TMPL_SCTN12 AND JOTVW.LANGUAGE_CD = JOP.LANGUAGE_CD |
| # | 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_PAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Page Number |
| 4 | HRS_JO_TMPL_SCTN12 |
Character(12) | VARCHAR2(12) NOT NULL | Job Opening Template Sections |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |