HRS_SCT_CFG_VW (SQL View)	Index Back
Content Section Config View View to content types from JPM that exist in the Primary Profile Type that has been designated for use in Recruting Solutions. Used as a search view on the Content Section Configuration component

HRS_SCT_CFG_VW

(SQL View)

Content Section Config View

View to content types from JPM that exist in the Primary Profile Type that has been designated for use in Recruting Solutions. Used as a search view on the Content Section Configuration component

SELECT DISTINCT JPMCFG.JPM_JP_TYPE , JPMCFG.JPM_CAT_TYPE , JPMCFG.DESCR , JPMCFG.JPM_ADHOC_FLG FROM PS_JPM_PRI_P_CAT_I JPMCFG , PS_JPM_JP_ROLES JPMROL WHERE JPMCFG.JPM_JP_TYPE = JPMROL.JPM_JP_TYPE AND JPMCFG.JPM_JP_SECTION_ID = JPMROL.JPM_JP_SECTION_ID AND %EffdtCheck(JPM_JP_ROLES JPMROL2, JPMROL, %CurrentDateIn) AND JPMROL.JPM_ROLE = 'EMP' AND JPMROL.JPM_SCRTY_MODIFY = 'Y'

Related Language Record: HRS_SCT_CFG_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

2 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.

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

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	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
2	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.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	JPM_ADHOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the Catalog Type is Adhoc or FreeForm.