SETIDPROJ_ROLEN=No Access
R=Read only Access to Proj
W=Read/Write Access to Proj
N=No Access
R=Read only access to Activity
W=Read/Write Access to Activity
PC_ROLE_SEC2VW(SQL View) |
Index Back |
|---|---|
Proj Role ViewProj Role view |
| SELECT PROLE.SETID , PROLE.PROJ_ROLE , PROLE.DESCR , SECPRO.PROJ_ACCESS_CD , SECPRO.ACTIVITY_ACCESS_CD FROM PS_PROJ_ROLE PROLE , PS_PC_SEC_PROFILE SECPRO WHERE PROLE.SECURITY_PROFILE = SECPRO.SECURITY_PROFILE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PROJ_ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access to Project
N=No Access R=Read only Access to Proj W=Read/Write Access to Proj |
| 5 | ACTIVITY_ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access to Activity
N=No Access R=Read only access to Activity W=Read/Write Access to Activity |