JPM_IDX_TYPE_VW

(SQL View)
 Index Back

Searchable Profile Types

Selects all active end profile types that have at least one searchable property. Used by the Verity Index Builder to determine which collections to build.

SELECT JPM_JP_TYPE , DESCR FROM PS_JPM_JP_TYPES A WHERE JPM_PROFILE_USAGE IN ('J','P') AND JPM_JP_TYPE_STATUS = 'A' AND %EffdtCheck(JPM_JP_TYPES A1, A, %CurrentDateIn) AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_PROPS B WHERE B.JPM_JP_TYPE = A.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_PROPS B1, B, %CurrentDateIn) AND B.JPM_SRCH_FLG = 'Y') AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_TYP_PIDS C WHERE C.JPM_JP_TYPE = A.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYP_PIDS C1, C, %CurrentDateIn) AND C.JPM_JP_END_PROFILE = 'Y')

  • Related Language Record: JPM_IDX_TYP_LVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description