JPM_SRCH_CTYPVW

(SQL View)
 Index Back

JPM Search Criteria Cat Types

Returns "parent" content types that are in both source and target profile types and accessible by the same role. In addition, the target content type must have at least one searchable property.

SELECT DISTINCT A.JPM_JP_TYPE ,B.JPM_JP_TYPE ,A.JPM_CAT_TYPE ,C.JPM_ROLE ,CAT.DESCR FROM PS_JPM_JP_TYPES SRC , PS_JPM_JP_TYPES TGT , PS_JPM_JP_SECTION A , PS_JPM_JP_SECTION B , PS_JPM_JP_ROLES C , PS_JPM_JP_ROLES D , PS_JPM_CAT_TYPES CAT WHERE %EffdtCheck(JPM_JP_TYPES SRC1, SRC, %CurrentDateIn) AND %EffdtCheck(JPM_JP_TYPES TGT1, TGT, %CurrentDateIn) AND A.JPM_JP_TYPE = SRC.JPM_JP_TYPE AND A.EFFDT = SRC.EFFDT AND A.JPM_CAT_RLAT_CD <> 'C' AND B.JPM_JP_TYPE = TGT.JPM_JP_TYPE AND B.EFFDT = TGT.EFFDT AND B.JPM_CAT_RLAT_CD <> 'C' AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_JP_TYPE = C.JPM_JP_TYPE AND A.JPM_JP_SECTION_ID = C.JPM_JP_SECTION_ID AND A.EFFDT = C.EFFDT AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_PROPS F WHERE F.JPM_JP_TYPE = B.JPM_JP_TYPE AND F.EFFDT= B.EFFDT AND F.JPM_JP_SECTION_ID = B.JPM_JP_SECTION_ID AND F.JPM_SRCH_FLG = 'Y') AND B.JPM_JP_TYPE = D.JPM_JP_TYPE AND B.JPM_JP_SECTION_ID = D.JPM_JP_SECTION_ID AND B.EFFDT = D.EFFDT AND C.JPM_ROLE = D.JPM_ROLE AND CAT.JPM_CAT_TYPE = A.JPM_CAT_TYPE

  • Related Language Record: JPM_SRCH_CTYPVL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_SOURCE_JP Character(12) VARCHAR2(12) NOT NULL Source Profile
    2 JPM_TARGET_JP Character(12) VARCHAR2(12) NOT NULL Target Profile
    3 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.
    4 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
    ADM=Administrator
    EMP=Employee
    MGR=Manager
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description