JPM_SRCH_SEC_VW

(SQL View)
 Index Back

SES Search Security View

Returns Emplids and Class Ids that will be used as a security attribute in the SES security callback processing. A connected query will be run when the process Schedule Search Index is run for the Profile Management search definitions. This connected query includes JPM_SRCH_SEC_VW as a child query

SELECT JPM_PROFILE_ID , 'E' %Concat EMPLID FROM PS_JPM_PROFILE WHERE JPM_PROFILE_USAGE='P' AND JPM_JP_PRFL_STATUS = 'A' UNION SELECT A.JPM_PROFILE_ID , 'C' %Concat B.CLASSID FROM PS_JPM_PROFILE A , PS_JPM_ROWSEC_VW B WHERE B.EMPLID=A.EMPLID AND A.JPM_PROFILE_USAGE='P' AND A.JPM_JP_PRFL_STATUS = 'A' UNION SELECT DISTINCT A.JPM_PROFILE_ID , 'M' %Concat B.SUPERVISOR_ID FROM PS_JPM_PROFILE A , PS_HR_DIRECT_REP_2 B , PS_JPMINSTALLATION C WHERE B.EMPLID=A.EMPLID AND A.JPM_PROFILE_USAGE='P' AND A.JPM_JP_PRFL_STATUS = 'A' AND C.JPM_DR_NAV_MTHD = '2' UNION SELECT DISTINCT A.JPM_PROFILE_ID , 'M' %Concat B.SUPERVISOR_ID FROM PS_JPM_PROFILE A , PS_HR_DIRECT_REP_3 B , PS_JPMINSTALLATION C WHERE B.EMPLID=A.EMPLID AND A.JPM_PROFILE_USAGE='P' AND A.JPM_JP_PRFL_STATUS = 'A' AND C.JPM_DR_NAV_MTHD = '3' UNION SELECT DISTINCT A.JPM_PROFILE_ID , 'M' %Concat B.SUPERVISOR_ID FROM PS_JPM_PROFILE A , PS_HR_DIRECT_REP_4 B , PS_JPMINSTALLATION C WHERE B.EMPLID=A.EMPLID AND A.JPM_PROFILE_USAGE='P' AND A.JPM_JP_PRFL_STATUS = 'A' AND C.JPM_DR_NAV_MTHD = '4' UNION SELECT DISTINCT A.JPM_PROFILE_ID , 'M' %Concat B.SUPERVISOR_ID FROM PS_JPM_PROFILE A , PS_HR_DIRECT_REP_5 B , PS_JPMINSTALLATION C WHERE B.EMPLID=A.EMPLID AND A.JPM_PROFILE_USAGE='P' AND A.JPM_JP_PRFL_STATUS = 'A' AND C.JPM_DR_NAV_MTHD = '5' UNION SELECT DISTINCT A.JPM_PROFILE_ID , 'M' %Concat B.SUPERVISOR_ID FROM PS_JPM_PROFILE A , PS_HR_DIRECT_REP_6 B , PS_JPMINSTALLATION C WHERE B.EMPLID=A.EMPLID AND A.JPM_PROFILE_USAGE='P' AND A.JPM_JP_PRFL_STATUS = 'A' AND C.JPM_DR_NAV_MTHD = '6'

# 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 JPM_SRCH_SECID Character(30) VARCHAR2(30) NOT NULL Search Security Id