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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |