JPM_SRCH_CTYPV2

(SQL View)
 Index Back

JPM Search Criteria Cat Types

Finds all search configuration content types with at least one property defined as searchable. Identifies role access for each content type returned. Used to populate the JPM_SRCH_CTYPE scroll on the Search Criteria page.

SELECT DISTINCT C.OBJECTOWNERID ,C.JPM_SRCH_SUB_ID ,C.JPM_SRCH_ID ,P.JPM_CAT_TYPE ,TGTROLE.JPM_ROLE ,C.JPM_SOURCE_JP ,C.JPM_TARGET_JP FROM PS_JPM_SRCH_CFG C , PS_JPM_SRCH_PROPS P , PS_JPM_JP_TYPES TGT , PS_JPM_JP_SECTION TGTSEC , PS_JPM_JP_ROLES TGTROLE WHERE P.OBJECTOWNERID = C.OBJECTOWNERID AND P.JPM_SRCH_SUB_ID = C.JPM_SRCH_SUB_ID AND P.JPM_SRCH_ID = C.JPM_SRCH_ID AND P.JPM_SRCH_FLG='Y' AND C.JPM_TARGET_JP = TGT.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES TGT1, TGT, %CurrentDateIn) AND TGTSEC.JPM_JP_TYPE = TGT.JPM_JP_TYPE AND TGTSEC.EFFDT = TGT.EFFDT AND TGTSEC.JPM_CAT_RLAT_CD <> 'C' AND TGTROLE.JPM_JP_TYPE = TGTSEC.JPM_JP_TYPE AND TGTROLE.JPM_JP_SECTION_ID = TGTSEC.JPM_JP_SECTION_ID AND TGTROLE.EFFDT = TGTSEC.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
2 JPM_SRCH_SUB_ID Character(4) VARCHAR2(4) NOT NULL Sub Application Id
SP=Succession Planning
3 JPM_SRCH_ID Character(18) VARCHAR2(18) NOT NULL Search Id
4 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.
5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
6 JPM_SOURCE_JP Character(12) VARCHAR2(12) NOT NULL Source Profile
7 JPM_TARGET_JP Character(12) VARCHAR2(12) NOT NULL Target Profile