HRS_SRCH_STY2VW (SQL View)	Index Back
Cont Sect Srch View no JPM Int If JPM integration is off, Populates search criteria with the intersection of primary person profile type category types and TAM content sections for JPM section properties that have fieldname = 'JPM_CAT_TYPE_ID'

HRS_SRCH_STY2VW

(SQL View)

Cont Sect Srch View no JPM Int

If JPM integration is off, Populates search criteria with the intersection of primary person profile type category types and TAM content sections for JPM section properties that have fieldname = 'JPM_CAT_TYPE_ID'

SELECT DISTINCT HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE FROM PS_HRS_SCT_CFG_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI , PS_JPM_PRI_P_CAT_I JPMCFG WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND JPMCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND (JPMPRIPI.FIELDNAME = 'JPM_CAT_ITEM_ID' OR(JPMCFG.JPM_ADHOC_FLG = 'Y' AND JPMPRIPI.FIELDNAME = 'JPM_ADHOC_DESCR'))

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

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