Summer Session Reporting

Summer Session Reporting

Summer session reporting is somewhat different than reporting for a major term. The term table which is used to determine headcount and hours is a term based table and not designed for summer session reporting. To remedy this reporting issue for summer sessions derived fields have been created and added to both the term and enrollment tables.

In order for a student to have a summer session enrollment status other then blank(null) the student has to have at least one class on the enrollment table with an a derived enrollment status not equal to blank (null) for that session. Each summer session class is either defined as being a summer one (SS1) class or a summer two (SS2) class based on the first class meeting date which must be less than the beginning date of the SS2 (Peoplesoft session code) date. There are exceptions to this and they are listed below:

Institution / Peoplesoft Session Code / Derived Session Code
All / NS1 / SS1
All / NS2 / SS2
Columbus / SS1 / SS1
SS2 / SS2
IUPUI / SS1 / SS1
8W1 / SS1
BU3 / SS1
IS1 / SS1
TB3 / SS1
SS2 / SS2
IS2 / SS2
BU4 / SS2
B4N / SS2
East / SS1 / SS1
6W1 / SS1
12W / SS1
SS2 / SS2
6W2 / SS2
10W2 / SS2
Institution / Peoplesoft Session Code / Derived Session Code
Fort Wayne / SS1 / SS1
1 / SS1
SS2 / SS2
2 / SS2
South Bend / SS1 / SS1
SS2 / SS2

The following fields have been added to the enrollment tables (SR_ENRL_*_GT).

CLS_DRVD_SESN_CD / CLS_DRVD_SESN_DESC
SS1 / First Summer Session
SS2 / Second Summer Session

The field (CLS_DRVD_SESN_CD) is used to determine if a student is enrolled for a particular session on the term table and to calculate summer credit hours, audit hours and load indicator. In addition to the STU_DRV_ENRL_STAT_IND there are other derived fields specifically developed for summer session reporting. These are:

Summer One Fields / Summer Two Fields
ACAD_DRVD_TERM_SMMR_1_IND / ACAD_DRVD_TERM_SMMR_2_IND
ACAD_DRVD_TERM_SMMR_1_UNTS / ACAD_DRVD_TERM_SMMR_2_UNTS
ACAD_DRVD_TERM_SMMR_1_AUD_UNTS / ACAD_DRVD_TERM_SMMR_2_AUD_UNTS
ACAD_DRVD_TERM_SMMR_1_DESC / ACAD_DRVD_TERM_SMMR_2_DESC
ACAD_DRVD_TERM_SMMR_1_LOAD_IND / ACAD_DRVD_TERM_SMMR_2_LOAD_IND

The ACAD_DRVD_TERM_SMMR_1_IND and ACAD_TERM_SMMR_2_IND use the same values as the STU_DRV_ENRL_STAT_IND which are:

Field Value / Value Description
X / The student is deceased.
E / The student is enrolled in at least one credit-bearing course.
EZ / The student is enrolled in at least one credit-bearing course, and the student’s primary program is SWT or CLN.
A / The student is enrolled in at least one course, but only as an auditor.
AZ / The student is enrolled in at least one course, but only as an auditor, and the student’s primary program is SWT or CLN.
W / The student has attempted to register, but is currently only on the course waitlist(s).
WZ / The student has attempted to register, but is currently only on the course waitlist(s), and the student’s primary program is SWT or CLN.
D / The student was registered at some point, but subsequently dropped all courses.
DZ / The student was registered at some point, but subsequently dropped all courses, and the student’s primary program is SWT or CLN.

ACAD_DRVD_TERM_SMMR_1_UNTS and ACAD_DRVD_TERM_SMMR_2_UNTS are similar to STU_DRVD_TOT_TERM_UNT_NBR but are based on the session, not the term

ACAD_DRVD_TERM_SMMR_1_AUD_UNTSand ACAD_DRVD_TERM_SMMR_2_AUD_UNTS are audit hours based on the session

ACAD_DRVD_TERM_SMMR_1_DESC and ACAD_DRVD_TERM_SMMR_2_DESC contain the description of the session if the student is or has been enrolled/waitlisted for the session. The values are: First Summer Session or Second Summer Session.

ACAD_DRVD_TERM_SMMR_1_LOAD_IND and ACAD_DRVD_TERM_SMMR_2_LOAD_IND are summer session versions of ACAD_LOAD_IND which is term base.