JPM_JP_PID_VW2

(SQL View)
 Index Back

Profile Type Usage


SELECT JPM_JP_TYPE ,'Y' FROM PS_JPM_JP_TYPES T WHERE EXISTS ( SELECT 'Y' FROM PS_JPM_JP_TYP_PIDS A WHERE A.JPM_JP_TYPE = T.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYP_PIDS A1, A, %CurrentDateIn) AND A.JPM_JP_END_PROFILE = 'Y') UNION SELECT JPM_JP_TYPE ,'N' FROM PS_JPM_JP_TYPES T WHERE NOT EXISTS ( SELECT 'N' FROM PS_JPM_JP_TYP_PIDS A WHERE A.JPM_JP_TYPE = T.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYP_PIDS A1, A, %CurrentDateIn) AND A.JPM_JP_END_PROFILE = 'Y')

# 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_JP_END_PROFILE Character(1) VARCHAR2(1) NOT NULL Job Profile End Profile flag
N=No
Y=Yes