PTRS_SEC_BASEVW

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 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