SCP_CONTUSER_VW (SQL View)	Index Back
Content Unique Users Unique Users with access to Content

SCP_CONTUSER_VW

(SQL View)

Content Unique Users

Unique Users with access to Content

SELECT DISTINCT(C.ROLEUSER) FROM PS_SCP_SEC_GRP_VW A , PS_SCP_CONTGRP_ROL B , PSROLEUSER C WHERE B.SCP_SECURITY_GROUP = A.SCP_SECURITY_GROUP AND C.ROLENAME = B.ROLENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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