SSR_ENRL_REQ_VW

(SQL View)
 Index Back

Enrollment Request Detail View

This Enrollment Request Detail View joins ENRL_REQ_DETAIL and SSR_ENRQDTL_OPT

SELECT A.ENRL_REQUEST_ID ,A.ENRL_REQ_DETL_SEQ ,A.EMPLID ,A.ACAD_CAREER ,A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.ENRL_REQ_ACTION ,A.ENRL_ACTION_REASON ,A.ENRL_ACTION_DT ,A.UNT_TAKEN ,A.UNT_EARNED ,A.CRSE_COUNT ,A.REPEAT_CODE ,A.CRSE_GRADE_INPUT ,A.GRADING_BASIS_ENRL ,A.CLASS_PRMSN_NBR ,A.CLASS_NBR_CHG_TO ,A.DROP_CLASS_IF_ENRL ,A.CHG_TO_WL_NUM ,A.RELATE_CLASS_NBR_1 ,A.RELATE_CLASS_NBR_2 ,A.OVRD_CLASS_LIMIT ,A.OVRD_GRADING_BASIS ,A.OVRD_CLASS_UNITS ,A.OVRD_UNIT_LOAD ,A.OVRD_CLASS_LINKS ,A.OVRD_CLASS_PRMSN ,A.OVRD_REQUISITES ,A.OVRD_TIME_CNFLCT ,A.OVRD_CAREER ,A.WAIT_LIST_OKAY ,A.OVRD_ENRL_ACTN_DT ,A.OVRD_RQMNT_DESIG ,A.OVRD_SRVC_INDIC ,A.OVRD_APPT ,A.INSTRUCTOR_ID ,A.ENRL_REQ_DETL_STAT ,A.RQMNT_DESIGNTN ,A.RQMNT_DESIGNTN_OPT ,A.RQMNT_DESIGNTN_GRD ,A.TSCRPT_NOTE_ID ,A.TSCRPT_NOTE_EXISTS ,A.OPRID ,A.DTTM_STAMP_SEC ,A.START_DT ,A.ACAD_PROG ,'Y' FROM PS_ENRL_REQ_DETAIL A WHERE 'Y' = ( SELECT B1.SSR_DYND_LDRP_OVRD FROM PS_SSR_ENRQDTL_OPT B1 WHERE B1.ENRL_REQUEST_ID = A.ENRL_REQUEST_ID AND B1.ENRL_REQ_DETL_SEQ = A.ENRL_REQ_DETL_SEQ AND B1.SSR_DYND_LDRP_OVRD = 'Y') UNION SELECT A.ENRL_REQUEST_ID ,A.ENRL_REQ_DETL_SEQ ,A.EMPLID ,A.ACAD_CAREER ,A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.ENRL_REQ_ACTION ,A.ENRL_ACTION_REASON ,A.ENRL_ACTION_DT ,A.UNT_TAKEN ,A.UNT_EARNED ,A.CRSE_COUNT ,A.REPEAT_CODE ,A.CRSE_GRADE_INPUT ,A.GRADING_BASIS_ENRL ,A.CLASS_PRMSN_NBR ,A.CLASS_NBR_CHG_TO ,A.DROP_CLASS_IF_ENRL ,A.CHG_TO_WL_NUM ,A.RELATE_CLASS_NBR_1 ,A.RELATE_CLASS_NBR_2 ,A.OVRD_CLASS_LIMIT ,A.OVRD_GRADING_BASIS ,A.OVRD_CLASS_UNITS ,A.OVRD_UNIT_LOAD ,A.OVRD_CLASS_LINKS ,A.OVRD_CLASS_PRMSN ,A.OVRD_REQUISITES ,A.OVRD_TIME_CNFLCT ,A.OVRD_CAREER ,A.WAIT_LIST_OKAY ,A.OVRD_ENRL_ACTN_DT ,A.OVRD_RQMNT_DESIG ,A.OVRD_SRVC_INDIC ,A.OVRD_APPT ,A.INSTRUCTOR_ID ,A.ENRL_REQ_DETL_STAT ,A.RQMNT_DESIGNTN ,A.RQMNT_DESIGNTN_OPT ,A.RQMNT_DESIGNTN_GRD ,A.TSCRPT_NOTE_ID ,A.TSCRPT_NOTE_EXISTS ,A.OPRID ,A.DTTM_STAMP_SEC ,A.START_DT ,A.ACAD_PROG ,'N' FROM PS_ENRL_REQ_DETAIL A WHERE 'N' NOT IN ( SELECT 'N' FROM PS_SSR_ENRQDTL_OPT B2 WHERE B2.ENRL_REQUEST_ID = A.ENRL_REQUEST_ID AND B2.ENRL_REQ_DETL_SEQ = A.ENRL_REQ_DETL_SEQ AND B2.SSR_DYND_LDRP_OVRD = 'Y')

# 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 Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: %EDITTABLE

8 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

Default Value: E

9 ENRL_ACTION_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Action Reason

Prompt Table: ENRL_RSN_TBL

10 ENRL_ACTION_DT Date(10) DATE Enrollment Action Date
11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
12 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
13 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
14 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment

Prompt Table: REPEAT_CODE_TBL

15 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A

Prompt Table: GRADE_TBL2_VW

16 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

Prompt Table: %EDITTABLE2

17 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr
18 CLASS_NBR_CHG_TO Number(5,0) INTEGER NOT NULL Change to Class Nbr

Prompt Table: %EDITTABLE4

19 DROP_CLASS_IF_ENRL Number(5,0) INTEGER NOT NULL Drop This Class if Enrolled

Prompt Table: CLASS_TBL_S2_VW

20 CHG_TO_WL_NUM Number(4,0) SMALLINT NOT NULL Change To Wait List Nbr
21 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1

Prompt Table: CLASS_TBL_RE_VW

22 RELATE_CLASS_NBR_2 Number(5,0) INTEGER NOT NULL Related Class Number 2

Prompt Table: CLASS_TBL_RE_VW

23 OVRD_CLASS_LIMIT Character(1) VARCHAR2(1) NOT NULL Used by SR Enrollments and Class Permissions.

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.OVRD_CLASS_LIMIT

24 OVRD_GRADING_BASIS Character(1) VARCHAR2(1) NOT NULL Override Grading Basis

Y/N Table Edit

Default Value: N

25 OVRD_CLASS_UNITS Character(1) VARCHAR2(1) NOT NULL Override Class Units

Y/N Table Edit

Default Value: N

26 OVRD_UNIT_LOAD Character(1) VARCHAR2(1) NOT NULL Override Unit Load

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.OVRD_UNIT_LOAD

27 OVRD_CLASS_LINKS Character(1) VARCHAR2(1) NOT NULL Override Class Links

Y/N Table Edit

Default Value: N

28 OVRD_CLASS_PRMSN Character(1) VARCHAR2(1) NOT NULL Override Class Permission

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.OVRD_CLASS_PRMSN

29 OVRD_REQUISITES Character(1) VARCHAR2(1) NOT NULL Override Requisites

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.OVRD_REQUISITES

30 OVRD_TIME_CNFLCT Character(1) VARCHAR2(1) NOT NULL Override Time Conflict

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.OVRD_TIME_CNFLCT

31 OVRD_CAREER Character(1) VARCHAR2(1) NOT NULL Override Career

Y/N Table Edit

Default Value: N

32 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

33 OVRD_ENRL_ACTN_DT Character(1) VARCHAR2(1) NOT NULL Override Action Date

Y/N Table Edit

Default Value: N

34 OVRD_RQMNT_DESIG Character(1) VARCHAR2(1) NOT NULL Ovrd Requirement Designation

Y/N Table Edit

Default Value: N

35 OVRD_SRVC_INDIC Character(1) VARCHAR2(1) NOT NULL Override Service Indicator

Y/N Table Edit

Default Value: N

36 OVRD_APPT Character(1) VARCHAR2(1) NOT NULL Override Appointment

Y/N Table Edit

Default Value: N

37 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

Prompt Table: %EDITTABLE3

38 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

39 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

40 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
41 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
N=Not Satisfied
S=Satisfied
42 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID

Prompt Table: TSCRPT_NOTE_TBL

43 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag

Y/N Table Edit

Default Value: N

44 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
45 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.
46 START_DT Date(10) DATE Start Date
47 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
48 SSR_DYND_LDRP_OVRD Character(1) VARCHAR2(1) NOT NULL Dynamic Dates