HRS_JO_TMPLS_V3 (SQL View)	Index Back
Job Opening Sections per Rqmt Job opening template sections for each JO Rqmt Sequence in JO. This view contains the Content Sections for each instance of HRS_JO_RQMT_SEQ in a Job Opening, especially important for Multiple Job scenarios. All content types that have been configured for use in RS will exist in this view. If the JO Template also contains the content types, then the page numbers from the template section will be populated. If the JO template doesn't contain one or more of the content types, the page number will be 0.

HRS_JO_TMPLS_V3

(SQL View)

Job Opening Sections per Rqmt

Job opening template sections for each JO Rqmt Sequence in JO. This view contains the Content Sections for each instance of HRS_JO_RQMT_SEQ in a Job Opening, especially important for Multiple Job scenarios. All content types that have been configured for use in RS will exist in this view. If the JO Template also contains the content types, then the page numbers from the template section will be populated. If the JO template doesn't contain one or more of the content types, the page number will be 0.

SELECT JO.HRS_JOB_OPENING_ID , JORQMT.HRS_JO_RQMT_SEQ , TMPLSCT.HRS_JO_TMPL_ID , TMPLSCT.HRS_PAGE_NBR , JOTMPL.HRS_JO_TMPL_SCTN12 , JOTMPL.HRS_REQ_SRC , JOTMPL.JPM_ADHOC_FLG , JOTMPL.DESCR FROM PS_HRS_JOB_OPENING JO , PS_HRS_JO_RQMT JORQMT , PS_HRS_RCRT_TMPL RCTMPL , PS_HRS_JO_TMPL_SCT TMPLSCT , PS_HRS_JO_TMPLS_VW JOTMPL WHERE JO.HRS_JOB_OPENING_ID = JORQMT.HRS_JOB_OPENING_ID AND JO.HRS_RCRT_TMPL_ID = RCTMPL.HRS_RCRT_TMPL_ID AND RCTMPL.HRS_JO_TMPL_ID = TMPLSCT.HRS_JO_TMPL_ID AND TMPLSCT.HRS_JO_TMPL_SCTN12 = JOTMPL.HRS_JO_TMPL_SCTN12 AND JOTMPL.HRS_REQ_SRC = 'J' AND %EffdtCheck(HRS_RCRT_TMPL RCTMPL1, RCTMPL, %CurrentDateIn) UNION SELECT JO2.HRS_JOB_OPENING_ID , JORQMT2.HRS_JO_RQMT_SEQ , RCTMPL2.HRS_JO_TMPL_ID , 0 , JOTMPL2.HRS_JO_TMPL_SCTN12 , JOTMPL2.HRS_REQ_SRC , JOTMPL2.JPM_ADHOC_FLG , JOTMPL2.DESCR FROM PS_HRS_JOB_OPENING JO2 , PS_HRS_JO_RQMT JORQMT2 , PS_HRS_RCRT_TMPL RCTMPL2 , PS_HRS_JO_TMPLS_VW JOTMPL2 WHERE JO2.HRS_JOB_OPENING_ID = JORQMT2.HRS_JOB_OPENING_ID AND JO2.HRS_RCRT_TMPL_ID = RCTMPL2.HRS_RCRT_TMPL_ID AND JOTMPL2.HRS_REQ_SRC = 'J' AND %EffdtCheck(HRS_RCRT_TMPL RCTMPL2A, RCTMPL2, %CurrentDateIn) AND NOT EXISTS ( SELECT TMPLSCT2.HRS_JO_TMPL_SCTN12 FROM PS_HRS_JO_TMPL_SCT TMPLSCT2 WHERE RCTMPL2.HRS_JO_TMPL_ID = TMPLSCT2.HRS_JO_TMPL_ID AND TMPLSCT2.HRS_JO_TMPL_SCTN12 = JOTMPL2.HRS_JO_TMPL_SCTN12)

Parent record: HRS_JO_TMPL_PG

# 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 HRS_JO_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Template ID
Prompt Table: HRS_JO_TMPL

4 HRS_PAGE_NBR Number(3,0) SMALLINT NOT NULL Page Number
Default Value: 0
Prompt Table: HRS_JO_TMPL_PG

5 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
Prompt Table: JPM_CAT_TYPE_VW

6 HRS_REQ_SRC Character(1) VARCHAR2(1) NOT NULL Resume or Job Opening Template sections including recruiting-specific sections from PSXLATITEM - identified by HRS_REQ_SRC = 'X' - and JPM Content Sections - identified by HRS_REQ_SRC = 'J'. Only those JPM Content sections that have been configured for Recruiting Solutions will be available for selection.
J=JPM Content Type
X=Translate Value

7 JPM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Indicates that the Catalog Type is Adhoc or FreeForm.

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	HRS_JO_TMPL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Template ID Prompt Table: HRS_JO_TMPL
4	HRS_PAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Page Number Default Value: 0 Prompt Table: HRS_JO_TMPL_PG
5	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile. Prompt Table: JPM_CAT_TYPE_VW
6	HRS_REQ_SRC	Character(1)	VARCHAR2(1) NOT NULL	Resume or Job Opening Template sections including recruiting-specific sections from PSXLATITEM - identified by HRS_REQ_SRC = 'X' - and JPM Content Sections - identified by HRS_REQ_SRC = 'J'. Only those JPM Content sections that have been configured for Recruiting Solutions will be available for selection. J=JPM Content Type X=Translate Value
7	JPM_ADHOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the Catalog Type is Adhoc or FreeForm.
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description