CS_EXT_ACCES_VW (SQL View)	Index Back
CS_EXT_ACCES_VW View to pick up the documents based on OPRID

CS_EXT_ACCES_VW

(SQL View)

CS_EXT_ACCES_VW

View to pick up the documents based on OPRID

SELECT C.CS_DOC_ID ,C.OPRID_EXT FROM PS_CS_CONTACT C WHERE C.EXT_VIEW_ACCESS ='Y' UNION SELECT B.CS_DOC_ID , A.OPRID FROM PSROLEUSER_VW A , PS_CS_DOC_ROLE_ACC B WHERE A.ROLENAME = B.ROLENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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