HRS_JO_TMPLS_VW (SQL View)	Index Back
Job Opening Tmpl Sctn Vw 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.

HRS_JO_TMPLS_VW

(SQL View)

Job Opening Tmpl Sctn Vw

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.

SELECT X.FIELDVALUE , X.XLATLONGNAME , 'X' , 'N' FROM PSXLATITEM X WHERE X.FIELDNAME = 'HRS_JO_TMPL_SCTN' AND X.EFF_STATUS <> 'I' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn ) UNION ALL SELECT CAT.JPM_CAT_TYPE , CAT.DESCR , 'J' , CAT.JPM_ADHOC_FLG FROM PS_JPM_PRI_P_CAT_I CAT , PS_HRS_SCT_CFG SCTCFG WHERE CAT.JPM_CAT_TYPE = SCTCFG.JPM_CAT_TYPE

Related Language Record: HRS_JO_TMPLS_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_JO_TMPL_SCTN12 Character(12) VARCHAR2(12) NOT NULL Job Opening Template Sections

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

3 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_JO_TMPL_SCTN12	Character(12)	VARCHAR2(12) NOT NULL	Job Opening Template Sections
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	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
4	JPM_ADHOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the Catalog Type is Adhoc or FreeForm.