CS_DOC_OWNER_VW

(SQL View)
 Index Back

SELECT B.OPRID , A.OPRID FROM PS_OPR_DEF_TBL_CS A , PSOPRDEFN B WHERE A.CS_FULL_ACCESS = 'Y' UNION SELECT OPRID , CS_DOC_OWNER FROM PS_CS_SEC_USER WHERE CS_DOC_OWNER <> ' ' AND CS_ADMIN_ACCESS = 'Y' UNION SELECT OPRID , OPRID FROM PS_OPR_DEF_TBL_CS WHERE CS_ADMIN_ACCESS = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator