TL_PORTL_SEC_VW(SQL View) |
Index Back |
|---|
| SELECT D.OPRID , A.PORTAL_NAME , A.PORTAL_PERMNAME , A.PORTAL_OBJNAME , A.PORTAL_PERMTYPE , A.PORTAL_REFTYPE , B.ROLENAME FROM PSPRSMPERM A , PSROLEUSER B , PSROLECLASS C , PSOPRDEFN D WHERE B.ROLENAME = C.ROLENAME AND B.ROLEUSER = D.OPRID AND A.PORTAL_NAME = 'EMPLOYEE' AND A.PORTAL_REFTYPE IN ('F', 'C') AND (A.PORTAL_PERMNAME = C.CLASSID OR A.PORTAL_PERMNAME = 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). |
| 2 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 3 | PORTAL_PERMNAME | Character(30) | VARCHAR2(30) NOT NULL | Permission Name |
| 4 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 5 | PORTAL_PERMTYPE | Character(30) | VARCHAR2(30) NOT NULL | Permission Type |
| 6 | PORTAL_REFTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Portal Reference Type
C=Content F=Folder |
| 7 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |