JPM_IDX_PROF_V2

(SQL View)
 Index Back

Searchable Profiles

Profile instances that have at least one searchable profile item.

SELECT A.JPM_PROFILE_ID , A.EMPLID , A.DESCR , A.JPM_JP_TYPE FROM PS_JPM_PROFILE A WHERE A.JPM_PROFILE_USAGE IN ('J','P') AND EXISTS ( SELECT 'X' FROM PS_JPM_JP_ITEMS B , PS_JPM_JP_SECTION C , PS_JPM_JP_PROPS D WHERE B.JPM_PROFILE_ID = A.JPM_PROFILE_ID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JPM_JP_ITEMS B1 WHERE B1.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B1.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND B1.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.JPM_JP_TYPE = C.JPM_JP_TYPE AND B.JPM_CAT_TYPE = C.JPM_CAT_TYPE AND %EffdtCheck(JPM_JP_SECTION C1, C, %CurrentDateIn) AND C.JPM_JP_TYPE = D.JPM_JP_TYPE AND C.JPM_JP_SECTION_ID = D.JPM_JP_SECTION_ID AND %EffdtCheck(JPM_JP_PROPS D1, D, %CurrentDateIn) AND D.JPM_SRCH_FLG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

Prompt Table: %EDITTABLE