SSR_SS_ERD_R1 (SQL View)	Index Back
Enrollment Request Detail Line The Enrollment Request Detail table is used by the Enrollment Engine to determine what enrollment requests to process. Each request is independent of each other. The Enrollment Engine can accomodate more than one student within an Enrollment Request ID.

SSR_SS_ERD_R1

(SQL View)

Enrollment Request Detail Line

The Enrollment Request Detail table is used by the Enrollment Engine to determine what enrollment requests to process. Each request is independent of each other. The Enrollment Engine can accomodate more than one student within an Enrollment Request ID.

SELECT a.ENRL_REQUEST_ID , a.ENRL_REQ_DETL_SEQ , a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.STRM , a.CLASS_NBR , a.RELATE_CLASS_NBR_1 , b.CLASS_TYPE , b.SUBJECT , b.CATALOG_NBR , b.CLASS_SECTION , a.ENRL_REQ_ACTION , a.UNT_TAKEN , a.GRADING_BASIS_ENRL , a.CLASS_PRMSN_NBR , a.CLASS_NBR_CHG_TO , a.DROP_CLASS_IF_ENRL , a.RELATE_CLASS_NBR_1 , a.RELATE_CLASS_NBR_2 , a.WAIT_LIST_OKAY , a.INSTRUCTOR_ID , a.RQMNT_DESIGNTN , a.RQMNT_DESIGNTN_OPT , a.START_DT , a.ACAD_PROG , a.ENRL_REQ_DETL_STAT , a.OPRID , a.DTTM_STAMP_SEC FROM PS_ENRL_REQ_DETAIL a , PS_CLASS_TBL_VW b WHERE a.INSTITUTION = b.INSTITUTION AND a.STRM = b.STRM AND a.RELATE_CLASS_NBR_1 = b.CLASS_NBR AND a.RELATE_CLASS_NBR_1 <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID

2 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table: STDNT_CAREER

5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

6 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: STDNT_CARTRM_VW

7 CLASS_NBR_REQ Number(5,0) INTEGER NOT NULL Class Nbr

8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
Prompt Table: %EDITTABLE

9 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
E=Enrollment Section
N=Non-Enrollment Section

10 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

11 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

12 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section

13 ENRL_REQ_ACTION Character(2) VARCHAR2(2) NOT NULL Enrollment Request Action
A=Add Grade
C=Change Grade
D=Drop
E=Enroll
M=Normal Maintenance
P=Change Wait List Position
R=Remove Grade
S=Swap Courses
W=Drop to Wait List

14 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken

15 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
Prompt Table: %EDITTABLE2

16 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr

17 CLASS_NBR_CHG_TO Number(5,0) INTEGER NOT NULL Change to Class Nbr
Prompt Table: %EDITTABLE4

18 DROP_CLASS_IF_ENRL Number(5,0) INTEGER NOT NULL Drop This Class if Enrolled
Prompt Table: CLASS_TBL_S2_VW

19 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1
Prompt Table: CLASS_TBL_RE_V2

20 RELATE_CLASS_NBR_2 Number(5,0) INTEGER NOT NULL Related Class Number 2
Prompt Table: CLASS_TBL_RE_V2

21 WAIT_LIST_OKAY Character(1) VARCHAR2(1) NOT NULL Wait List Okay
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.WAIT_LIST_OKAY

22 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
Prompt Table: %EDITTABLE3

23 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
Prompt Table: RQMNT_DESIG_TBL

24 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
Default Value: N

25 START_DT Date(10) DATE Start Date

26 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Default Value: STDNT_CAR_TERM.ACAD_PROG_PRIMARY
Prompt Table: SSR_ACPRG_AC_VW

27 ENRL_REQ_DETL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Req Detail Status
E=Errors found
M=Success/Messages
P=Pending
S=Success
X=Pending
Default Value: P

28 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

29 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENRL_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Enrollment Request ID
2	ENRL_REQ_DETL_SEQ	Number(6,0)	INTEGER NOT NULL	Enrollment Req Detail Sequence
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
4	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: STDNT_CAREER
5	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
6	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: STDNT_CARTRM_VW
7	CLASS_NBR_REQ	Number(5,0)	INTEGER NOT NULL	Class Nbr
8	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr Prompt Table: %EDITTABLE
9	CLASS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Class Type E=Enrollment Section N=Non-Enrollment Section
10	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
11	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
12	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section
13	ENRL_REQ_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Enrollment Request Action A=Add Grade C=Change Grade D=Drop E=Enroll M=Normal Maintenance P=Change Wait List Position R=Remove Grade S=Swap Courses W=Drop to Wait List
14	UNT_TAKEN	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken
15	GRADING_BASIS_ENRL	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis Prompt Table: %EDITTABLE2
16	CLASS_PRMSN_NBR	Number(6,0)	INTEGER NOT NULL	Class Permission Nbr
17	CLASS_NBR_CHG_TO	Number(5,0)	INTEGER NOT NULL	Change to Class Nbr Prompt Table: %EDITTABLE4
18	DROP_CLASS_IF_ENRL	Number(5,0)	INTEGER NOT NULL	Drop This Class if Enrolled Prompt Table: CLASS_TBL_S2_VW
19	RELATE_CLASS_NBR_1	Number(5,0)	INTEGER NOT NULL	Related Class Number 1 Prompt Table: CLASS_TBL_RE_V2
20	RELATE_CLASS_NBR_2	Number(5,0)	INTEGER NOT NULL	Related Class Number 2 Prompt Table: CLASS_TBL_RE_V2
21	WAIT_LIST_OKAY	Character(1)	VARCHAR2(1) NOT NULL	Wait List Okay Y/N Table Edit Default Value: OPR_DEF_TBL_CS.WAIT_LIST_OKAY
22	INSTRUCTOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Instructor ID Prompt Table: %EDITTABLE3
23	RQMNT_DESIGNTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement. Prompt Table: RQMNT_DESIG_TBL
24	RQMNT_DESIGNTN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Requirement Designation Option N=No Y=Yes Default Value: N
25	START_DT	Date(10)	DATE	Start Date
26	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Default Value: STDNT_CAR_TERM.ACAD_PROG_PRIMARY Prompt Table: SSR_ACPRG_AC_VW
27	ENRL_REQ_DETL_STAT	Character(1)	VARCHAR2(1) NOT NULL	Enrollment Req Detail Status E=Errors found M=Success/Messages P=Pending S=Success X=Pending Default Value: P
28	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
29	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.