CDM_AUTH_R_VW2 - Content Dist Mgr - Role Access

CDM_AUTH_R_VW2	index back
Content Dist Mgr - Role Access

Table View to get list of OPRID in the ROLE.

SELECT DISTINCT A.CONTENTID , A.PRCSINSTANCE FROM PS_CDM_AUTH A WHERE A.DISTIDTYPE = '3'

PeopleSoft Field Name Field Type Column Type Description

CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID

PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
CONTENTID	Number(15,0)	DECIMAL(15) NOT NULL	Report ID
PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance