HRS_SRCH_MGR_VW (SQL View)	Index Back
Cont Sect Srch View w JPM Int If JPM integration is on, Populates search criteria with the intersection of primary person profile type category types and TAM content sections for JPM section properties that are searchable

HRS_SRCH_MGR_VW

(SQL View)

Cont Sect Srch View w JPM Int

If JPM integration is on, Populates search criteria with the intersection of primary person profile type category types and TAM content sections for JPM section properties that are searchable

SELECT DISTINCT HRSCTCFG.JPM_JP_TYPE ,HRSCTCFG.JPM_CAT_TYPE FROM PS_HRS_SCT_MGR_VW HRSCTCFG , PS_JPM_PRI_P_PRP_I JPMPRIPI WHERE HRSCTCFG.JPM_JP_TYPE = JPMPRIPI.JPM_JP_TYPE AND HRSCTCFG.JPM_CAT_TYPE = JPMPRIPI.JPM_CAT_TYPE AND JPMPRIPI.JPM_JP_SRCH_FLG = 'Y'

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