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

Indianapolis	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_UNTS and 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.