PSPTADSRTRWP_VW (SQL View)	Index Back
Permission of copy/comp access Permission lists that have copy/compare permissions for ADS datasets

PSPTADSRTRWP_VW

(SQL View)

Permission of copy/comp access

Permission lists that have copy/compare permissions for ADS datasets

SELECT ASEC.CLASSID , RU.ROLEUSER , ASEC.PTADSACCESS FROM PSPTSCRTY_ADS_P ASEC , PSROLEUSER RU , PSROLECLASS RC WHERE ASEC.CLASSID= RC.CLASSID AND RU.ROLENAME= RC.ROLENAME AND ASEC.PTADSACCESS <> 'NO' ORDER BY ASEC.CLASSID, RU.ROLEUSER, ASEC.PTADSACCESS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

2 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

3 PTADSACCESS Character(4) VARCHAR2(4) NOT NULL Access Code
FULL=Full Access
NO=No Access
READ=Read Only

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
2	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User
3	PTADSACCESS	Character(4)	VARCHAR2(4) NOT NULL	Access Code FULL=Full Access NO=No Access READ=Read Only