ENRL_REQ_DT_VW2

(SQL View)
 Index Back

Enrollment Request Detail Line

The Enrollment Request Detail View2

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.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 ,B.ENRL_REQ_SOURCE ,A.ACAD_PROG FROM PS_ENRL_REQ_DETAIL A , PS_ENRL_REQ_HEADER B WHERE A.ENRL_REQUEST_ID = B.ENRL_REQUEST_ID

# 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_BE Character(2) VARCHAR2(2) NOT NULL Enrollment Request Action
A=Add Grade
C=Change Grade
D=Drop
E=Enroll
F=Enroll from Wait List
M=Normal Maintenance
P=Change Wait List Position
Q=PERC - no drop action
QC=PERC - Drop if Conditional
QD=PERC - Drop Action
QN=PERC - Drop if Not Satisfied
R=Remove Grade
S=Swap Courses
W=Drop to Wait List
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 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
13 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment

Prompt Table: REPEAT_CODE_TBL

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

Prompt Table: GRADE_TBL2_VW

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 CHG_TO_WL_NUM Number(4,0) SMALLINT NOT NULL Change To Wait List Nbr
20 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1

Prompt Table: CLASS_TBL_RE_VW

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

Prompt Table: CLASS_TBL_RE_VW

22 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

25 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

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

Y/N Table Edit

Default Value: N

27 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

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

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.OVRD_REQUISITES

29 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

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

Y/N Table Edit

Default Value: N

31 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: %EDITTABLE3

37 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

38 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

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

Prompt Table: TSCRPT_NOTE_TBL

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

Y/N Table Edit

Default Value: N

43 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
44 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.
45 ENRL_REQ_SOURCE Character(2) VARCHAR2(2) NOT NULL Enrollment Request Source
CR=Class Roll
E=Enrollment Request
EN=Enrollment
FE=Fluid Cls Srch Enrl non-SFF
FF=Fluid Cls Srch Enrl SFF
FS=Fluid Self Service SFF
FX=Fluid Self Service non-SFF
IL=Grade Lapse
ME=Mass Enrollment
PB=Post Enrl Req Chk Batch
PD=Req Chk Drop Online
PO=Post Enrl Req Chk Online
PX=Req Chk Drop Batch
QE=Quick Enroll
SE=Self-Service Enrollment
SF=Student Financials Batch
SG=Self Service Grade Posting
TA=Test Administration (NLD)
WD=Term Withdrawal Engine
WL=Wait List Engine
46 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program