JPM_PID_ACK_VW

(SQL View)
 Index Back

Acknowledgment PIDs

Profile Identifiers participating in the Acknowledgment process

SELECT P.JPM_PROFILE_ID ,A.ESIGN_ID FROM PS_JPM_PROFILE P , PS_JPM_JP_TYPES A , PS_JPM_JP_X_RLAT X WHERE P.JPM_JP_TYPE = A.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES A1, A, %CurrentdateIn) AND X.JPM_PROFILE_ID = P.JPM_PROFILE_ID AND EXISTS ( SELECT JPM_RLAT_NAME FROM PS_JPM_JP_TYP_PIDS B WHERE B.JPM_JP_TYPE=A.JPM_JP_TYPE AND B.EFFDT = A.EFFDT AND B.JPM_RLAT_NAME = X.JPM_RLAT_NAME AND B.JPM_REQ_ACK = '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 ESIGN_ID Character(5) VARCHAR2(5) NOT NULL Acknowledgement ID