PTRS_SEC_QRYVW

index back

SELECT A.CONTENTID , A.FILENAME , A.PTRS_RPT_SECTYPE FROM PS_PTRS_SEC_BASEVW A , PS_CDM_FILE_LIST B WHERE A.CONTENTID = B.CONTENTID AND A.FILENAME = B.FILENAME UNION SELECT C.CONTENTID , C.FILENAME , 'A:All' FROM PS_CDM_FILE_LIST C UNION SELECT D.CONTENTID , D.FILENAME , D.PTRS_RPT_SECTYPE FROM PS_PTRS_SEC_BASEVW D , PS_CDM_AUTH E , PS_CDM_FILE_LIST F WHERE E.DISTIDTYPE = '2' AND D.CONTENTID = E.CONTENTID AND D.CONTENTID = F.CONTENTID AND D.FILENAME = F.FILENAME

PeopleSoft Field Name Field Type Column Type Description
CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
PTRS_RPT_SECTYPE Character(40) VARCHAR2(40) NOT NULL Reporting SearchIndex Security
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19