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 NameField TypeColumn TypeDescription
CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
PTRS_RPT_SECTYPECharacter(40)VARCHAR2(40) NOT NULLReporting SearchIndex Security
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19