JPM_RATING_PROP

(SQL View)
Index Back

SELECT DISTINCT S.JPM_JP_TYPE , S.JPM_CAT_TYPE FROM PS_JPM_JP_SECTION S , PS_JPM_JP_PROPS P WHERE P.JPM_JP_TYPE = S.JPM_JP_TYPE AND P.JPM_JP_SECTION_ID = S.JPM_JP_SECTION_ID AND P.EFFDT = S.EFFDT AND S.JPM_JP_PSECTION_ID = 0 AND FIELDNAME IN ('JPM_RATING1','JPM_RATING2','JPM_RATING3') AND %EffdtCheck(JPM_JP_TYPES T1, S, %CurrentDateIn)

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