PTRS_SEC_BASEVW

(SQL View)
 Index Back

Report search base security vw

This record facilitates reporting search security.

SELECT A.CONTENTID , B.FILENAME , (CASE A.DISTIDTYPE WHEN '2' THEN 'U:' || A.DISTID WHEN '3' THEN 'R:' || A.DISTID ELSE 'NA' END) PTRS_RPT_SECTYPE FROM PS_CDM_AUTH A , PS_CDM_FILE_LIST B

# 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