JPM_SRCH_TYPEVW

(SQL View)
 Index Back

Profile Type Prompt Vw

Prompt view for profile type on the Build Profile Search Indexes run control page.

SELECT JPM_JP_TYPE , DESCR FROM PS_JPM_JP_TYPES A WHERE A.JPM_PROFILE_USAGE IN ('J','P') AND A.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') UNION SELECT FIELDVALUE , XLATLONGNAME FROM PSXLATITEM X WHERE FIELDNAME = 'JPM_SRCH_ALL' AND FIELDVALUE = '0000' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)

  • Related Language Record: JPM_SRCH_TYPVWL

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