ENRL_EXTRT_VW

(SQL View)
 Index Back

Enrollment Extract View2

This view is used to extract enrollment data to be used by the COBOL transcript and academic advisement processes.

SELECT A.EMPLID ,A.ACAD_CAREER ,B.INSTITUTION ,B.STRM ,B.CLASS_NBR ,A.STDNT_ENRL_STATUS ,B.ACAD_CAREER ,A.UNT_TAKEN ,A.UNT_PRGRSS ,A.GRADING_BASIS_ENRL ,A.CRSE_GRADE_OFF ,A.REPEAT_CODE ,B.ASSOCIATED_CLASS ,A.AUDIT_GRADE_BASIS ,A.EARN_CREDIT ,A.INCLUDE_IN_GPA ,A.UNITS_ATTEMPTED ,A.GRADE_POINTS ,A.GRD_PTS_PER_UNIT ,B.CRSE_ID ,B.CRSE_OFFER_NBR ,B.SESSION_CODE ,B.CLASS_SECTION ,B.ACAD_GROUP ,B.SUBJECT ,B.CATALOG_NBR ,B.DESCR ,B.SSR_COMPONENT ,B.CRS_TOPIC_ID ,B.EQUIV_CRSE_ID ,B.OVRD_CRSE_EQUIV_ID ,A.INSTRUCTOR_ID ,A.TSCRPT_NOTE_ID ,A.TSCRPT_NOTE_EXISTS ,A.CRSE_COUNT ,A.RQMNT_DESIGNTN ,A.RQMNT_DESIGNTN_OPT ,A.RQMNT_DESIGNTN_GRD ,A.VALID_ATTEMPT ,A.GRADE_CATEGORY ,A.SEL_GROUP ,A.REPEAT_DT ,B.START_DT ,B.END_DT ,C.TERM_BEGIN_DT ,A.UNT_EARNED ,A.GRADING_SCHEME_ENR FROM PS_STDNT_ENRL A , PS_CLASS_TBL B , PS_TERM_TBL C WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.STDNT_ENRL_STATUS = 'E' AND A.GRADING_BASIS_ENRL <> 'NON' AND A.INSTITUTION=C.INSTITUTION AND A.ACAD_CAREER=C.ACAD_CAREER AND A.STRM=C.STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 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
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

4 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
6 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting
7 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
8 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
9 UNT_PRGRSS Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Academic Progress
10 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
11 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
12 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment
13 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
14 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis
15 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
16 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
17 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
I=In Progress
N=No
Y=Yes
18 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
19 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
20 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
21 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
22 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
23 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
24 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
25 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
26 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
27 DESCR Character(30) VARCHAR2(30) NOT NULL Description
28 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
CLN=Clinical
CON=Continuance
DIS=Discussion
FLD=Field Studies
IND=Independent Study
LAB=Laboratory
LEC=Lecture
PRA=Practicum
RSC=Research
SEM=Seminar
SUP=Supervision
THE=Thesis Research
TUT=Tutorial
29 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
30 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
31 OVRD_CRSE_EQUIV_ID Character(1) VARCHAR2(1) NOT NULL Override Equivalent Course
32 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
33 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID
34 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag
35 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
36 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.
37 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes
38 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
N=Not Satisfied
S=Satisfied
39 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
40 GRADE_CATEGORY Character(4) VARCHAR2(4) NOT NULL The default value of NONE is delivered with the system and should not be deleted.
TXFR=Transfer Pass (Sample)
41 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
42 REPEAT_DT Date(10) DATE Repeat Date
43 START_DT Date(10) DATE Start Date
44 END_DT Date(10) DATE end date
45 TERM_BEGIN_DT Date(10) DATE Term Begin Date
46 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
47 GRADING_SCHEME_ENR Character(3) VARCHAR2(3) NOT NULL Grading Scheme