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
PROJ_ROLE_SECVW(SQL View) |
Index Back |
|---|---|
Proj Role ViewProj Role view |
| SELECT PR.SETID , PR.PROJ_ROLE , PR.DESCR , SP.PROJ_ACCESS_CD , SP.ACTIVITY_ACCESS_CD FROM PS_PROJ_ROLE PR , PS_PC_SEC_PROFILE SP WHERE PR.SECURITY_PROFILE = SP.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 |