Summer School Student Data (SSD)

Introduction

This report includes summer school enrollment and grade information, including summer correspondence courses, on-line courses, virtual school courses, and dual credit courses. The file must be sent prior to the 1^st month submission for the new school year. MSIS does not accept SSD files after September 30^th.

This report should be run from the student’s original school, rather than their summer school or next year school. For example, if the student was enrolled in School #1, transferred to the summer school, and then promoted to their next school, the report should be run from School #1.

Students earning credits for courses (grade levels 8-12) should be included in the Summer School file regardless of whether they are replacing a failed grade or completing a new course.

If there are students who did not meet all of their objectives during the regular school year and the school extends the year to work with the students (mostly for elementary students), then include the students in the Monthly Student Historical file as Not Promoted and with either a failing grade or an I for incomplete. Once they finish the extended year, use the Update Student Grades Screen in MSIS to change their grade and to promote them if they passed.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

The student's school prior to their summer school must equal the school running the report.
The student’s summer school exit date must occur after the report start date.
The student’s summer school entry date must occur on or before the report end date.

Historical Grade Selection

The report selects records from the [StoredGrades] table based on the following criteria:

The student must have a stored grade record matching the store code entered at runtime.
The student must have a stored grade record for the current term year.

Back to Top

Report Input

For help with navigation and running the report, seeHow to Find and Generate a Report.

Field	Description
Reporting Period Start Date	Enter the start date for the summer term.
Reporting Period	Choose the appropriate reporting period from the pop-up menu.
Reporting Period End Date	Enter the end date for the summer term.
Increments by 1.0 for each modified transaction	Enter 1, 2, or 3 to indicate by what value the transactions should be incremented.
Store Code	Enter the Store Code used to store the summer grades (ex: Z1, S9).

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

The records in this report are sorted by the student’s last name.

Item #	Data Element	Description	[Table]FieldName
1	VERSION	This value starts with 1.0 and increments by 1.0 for each modified daily discipline student data transaction set representing the same set of data.	N/A
2	DTG	The date and time that the report completed, in the format MM-DD-YYYY and hh;mm;ss.	N/A
3	DISTRICT	The district number.	[Prefs]Value [Prefs]Name=districtnumber
4	SCHOOL	The school number, based on the selection at report runtime.	[Schools]School_Number
5	PERIOD	The reporting period selected at report runtime.	N/A
6	T_VERSION	The value 1, 2, or 3 to indicate by what value the transactions should be incremented.	N/A
7	TRACK_ID	This value is a combination of the district number, school number, current date, and the File ID entered at report runtime.	[Prefs]Value [Prefs]Name=districtnumber [Schools]School_Number
STUDENT
8	MSISID	The state assigned student identifier.	[Students]State_Student_Number
9	FNAME	The student’s first name.	[Students]First_Name
10	MNAME	The student’s middle name. The report extracts a question mark if the student does not have a middle name.	[Students]Middle_Name
11	LNAME	The student’s last name.	[Students]Last_Name
12	SSN	The student’s social security number, extracted without dashes. A question mark may be reported if the student’s SSN is not provided.	[Students]SSN
13	DOB	The student’s date of birth.	[Students]DOB
PROMOTE Note: Promotion information needs to be updated for any student whose promotion status change since month 9 as a result of their summer activity.
14	PROMOTION	The student’s special education status. Value values: Y N	[S_MS_STU_X]SpecialEdInd
15	P_DATE	The date the student is to be promoted. This field is only reported if the student’s promotion status is Y.	[S_MS_STU_X]PromotionDate
16	GRADCODE	Not reported.	Not reported.
17	GRADENDR1	Displays the category of student's diploma endorsement. Valid values: Blank CE - Career and Technical Endorsement AE - Academic Endorsement DE - Distinguished Academic Endorsement If GRADENDR1 (Diploma Endorsement 1) = CE, then GRADENDR2 (Diploma Endorsement 2) can have values Blank, AE, or DE If GRADENDR1 (Diploma Endorsement 1) = Blank, AE, or DE, then GRADENDR2 (Diploma Endorsement 2) must be Blank	[S_MS_STU_X]DiplomaEndorsement1 [S_MS_REN_X]DiplomaEndorsement1
18	GRADENDR2	Displays the category of student's diploma endorsement. Valid values: Blank CE - Career and Technical Endorsement AE - Academic Endorsement DE - Distinguished Academic Endorsement If GRADENDR1 (Diploma Endorsement 1) = CE, then GRADENDR2 (Diploma Endorsement 2) can have values Blank, AE, or DE If GRADENDR1 (Diploma Endorsement 1) = Blank, AE, or DE, then GRADENDR2 (Diploma Endorsement 2) must be Blank	[S_MS_STU_X]DiplomaEndorsement2 [S_MS_REN_X]DiplomaEndorsement2
SCHEDULE
COURSE
17	COURSENUM	The course number for each of the student’s section enrollments that fall within the report date range. The alternate course number associated with the course is extracted. If no course exists, the StoredGrades Course Number is extracted. Note: Duplicate COURSENUM records for the same student are not allowed for the same TERMSEMCODE.	[Courses]Alt_Course_Number [StoredGrades]Course_Number
18	LOCALNUM	The course number for each of the student’s section enrollments that fall within the report date range. The alternate course number associated with the course is extracted. If no course exists, the StoredGrades Course Number is extracted. Note: Duplicate LOCALNUM records for the same student are not allowed.	[Courses]Alt_Course_Number [StoredGrades]Course_Number
19	LOCALNAME	The course name for each of the student’s section enrollments that fall within the report date range.	[StoredGrades]Course_Name
20	FINALGRADE	The alpha grade awarded for each section enrollment that falls within the report date range.	[StoredGrades]Grade
CLASS
21	TERMSECODE	Always reported as “SU.”	N/A
22	C_GRADE	The alpha grade awarded for each section enrollment that falls within the report date range. Note: This field must be reported at the end of the course enrollment.	[StoredGrades]Grade
23	CREDITS	The number of credits awarded for each section enrollment that falls within the report date range, reported in the format 9.9. Note: This field must be reported at the end of the course enrollment. If the C_GRADE field contains a passing grade, then the CREDITS value must match the last two digits of the CARNEGIE value. If the C_GRADE field contains a failing grade, then the CREDITS value must be 0.0.	[StoredGrades]EarnedCrHrs
24	CARNEGIE	A value of 0 (zero) is inserted in front of the CREDITS value, with the decimal places removed. For example, if CREDITS is 0.5, then CARNEGIE is 005. Note: This field must be reported at the end of the course enrollment.	[StoredGrades]EarnedCrHrs