PTRS_SEC_QRYVW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTENTID | Number(15,0) | DECIMAL(15) NOT NULL | Report ID |
| 2 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 3 | PTRS_RPT_SECTYPE | Character(40) | VARCHAR2(40) NOT NULL | Reporting SearchIndex Security |