PORTAL_NAMEPrompt Table: PT_IQ_PRT_VW
PORTAL_OBJNAMEPT_IQREGPERM |
index back |
|---|---|
Permission Lists per CREF |
| SELECT DISTINCT D.PORTAL_NAME , D.PORTAL_OBJNAME , C.PORTAL_PERMNAME , E.CLASSDEFNDESC FROM PSPRSMPERM C , PSPRSMDEFN D , PSCLASSDEFN E WHERE D.PORTAL_OBJNAME = C.PORTAL_OBJNAME AND D.PORTAL_NAME = C.PORTAL_NAME AND C.PORTAL_PERMNAME = E.CLASSID |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table: PT_IQ_PRT_VW |
| PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| PORTAL_PERMNAME | Character(30) | VARCHAR2(30) NOT NULL | Permission Name |
| CLASSDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Permission List Description |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |