OPRIDROLENAMEPrompt Table: %EDITTABLE
CLASSIDINSTITUTIONENRL_ACCESS_IDSSR_OPR_ENOV2VW(SQL View) |
Index Back |
|---|---|
Enrollment Override AccessView used by SR to determine access Enrollment Access Override using Roles |
| SELECT A.OPRID , A.ROLENAME , B.CLASSID , C.INSTITUTION , C.ENRL_ACCESS_ID , D.WAIT_LIST_OKAY FROM PSROLEUSER_VW A , PSROLECLASS B , PS_OPRCLASS_DEF_SA C , PS_ENRMT_OVRD_TBL D WHERE B.ROLENAME = A.ROLENAME AND C.OPRCLASS = B.CLASSID AND D.ENRL_ACCESS_ID = C.ENRL_ACCESS_ID |
| # | 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 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: %EDITTABLE |
| 3 | CLASSID |
Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 4 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | ENRL_ACCESS_ID |
Character(4) | VARCHAR2(4) NOT NULL | Enrollment Access ID |
| 6 | WAIT_LIST_OKAY | Character(1) | VARCHAR2(1) NOT NULL | Wait List Okay |