SSR_OPR_ENOVRVW (SQL View)	Index Back
Enrollment Override Access View used by SR to determine access Enrollment Access Override using Permission Lists

SSR_OPR_ENOVRVW

(SQL View)

Enrollment Override Access

View used by SR to determine access Enrollment Access Override using Permission Lists

SELECT A.OPRID , A.OPRCLASS , B.INSTITUTION , B.ENRL_ACCESS_ID , C.WAIT_LIST_OKAY FROM PSOPRDEFN A , PS_OPRCLASS_DEF_SA B , PS_ENRMT_OVRD_TBL C WHERE B.OPRCLASS = A.OPRCLASS AND C.ENRL_ACCESS_ID = B.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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

4 ENRL_ACCESS_ID Character(4) VARCHAR2(4) NOT NULL Enrollment Access ID

5 WAIT_LIST_OKAY Character(1) VARCHAR2(1) NOT NULL Wait List Okay

#	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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
4	ENRL_ACCESS_ID	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Access ID
5	WAIT_LIST_OKAY	Character(1)	VARCHAR2(1) NOT NULL	Wait List Okay