PSPTADSRTRWP_VW |
index back |
|---|---|
Permission of copy/comp access |
| 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 | Field Type | Column Type | Description |
|---|---|---|---|
| CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| PTADSACCESS | Character(4) | VARCHAR2(4) NOT NULL |
Access Code
FULL=Full Access NO=No Access READ=Read Only |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |