Student Membership and Attendance (Monthly)

Contents

Report Description

The Student Membership and Attendance (Monthly) was announced by the Connecticut State Department of Education (CSDE) in September 2020, to capture student membership and attendance separately for a student’s in-person and remote days during the month.

This report can be run at the school or district level.

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] or [ReEnrollments] table based on the following criteria:

The student must not be excluded from state reporting.
The student must have a school enrollment record that starts before the report ADA/ADM End Date and ends after the report ADA/ADM Start Date.

The end date of the school enrollment must be greater than the start date.
The start date of the enrollment must be less than or equal to the Enrollment Snapshot Date and the end date of the enrollment must be equal to or greater than the Enrollment Snapshot Date

Report Input

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

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Select Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Enrollment Snapshot Date	Enter the data you want the report to use for enrollment level data. This value determines which enrollment record to use for point in time data from either Students or Reenrollments.
ADA/ADM Start Date	Enter the date you want the report to use as the start date for calculating attendance and membership data for each student.
ADA/ADM End Date	Enter the date you want the report to use as the end date for calculating attendance and membership data for each student.
Display Headers?	Choose Yes or No from the drop-down menu to determine whether to display header fields in the extract. Headers display the name of each data element for each record extracted. Use headers for troubleshooting purposes.
Extract Format	Choose whether to extract the records in comma-delimited format for troubleshooting purposes or in positional format for submission to the state.

Report Output

Each of the fields displayed in the output of the report is described below. For more information about the report output from the state Department of Education, see http://www.csde.state.ct.us/public/psis/downloads.asp

See Understanding the Report Output Table for a definition of each column in the table.

Note: For fields that are historically tracked, there may be multiple stored values. If so, the output reports the value from the most recent Effective Date that occurs on or before the Enrollment Snapshot Date.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin / End Position
1	Reporting District	The three-digit code for the reporting school district.	[Prefs]Value where [Prefs]Name = districtnumber	Alpha-numeric	3	1–3
2	State Assigned Student ID (SASID)	The student’s state-assigned student ID number.	[Students] State_StudentNumber [S_CT_STU_X]State_Student_ID	Numeric	10	4–13
3	Date of Birth	The student’s date of birth.	[Students]DOB	Alpha-numeric	8	14–21
4	Month of Membership	Month for which student membership is considered	Calculated based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	2	22-23
5	Year of Membership	Year for which student membership is considered	Calculated based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	4	24-27
6	Number of Days of In-Person Membership	Total Number of Days for which the student had In-Person Membership Calculated based on Total Membership minus the Remote Membership	Calculated based on [PS_ADAADM_Defaults_All] Potential_AttendanceValue Value from the 'Number of Days of Remote Membership' column of this report [PS_ADAADM_Defaults_All]CalendarDate based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	2	28-29
7	Number of Days of In-Person Attendance	Total Number of Days for which the student had In-Person Attendance Calculated based on Total Attendance minus the Remote Attendance	Calculated based on [PS_ADAADM_Defaults_All] Potential_AttendanceValue Value from the 'Number of Days of Remote Attendance' column of this report [PS_ADAADM_Defaults_All]CalendarDate based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	2	30-31
8	Number of Days of Remote Membership	Total Number of Days for which the student had Remote Membership	Calculated based on [PS_ADAADM_Defaults_All] Potential_AttendanceValue [CODE_Entity]CE_Code = ‘Remote’ [PS_ADAADM_Defaults_All]CalendarDate based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	2	32-33
9	Number of Days of Remote Attendance	Total Number of Days for which the student had Remote Attendance	Calculated based on [PS_ADAADM_Defaults_All] Potential_AttendanceValue [CODE_Entity]CE_Code = ‘Remote’ [PS_ADAADM_Defaults_All]AttendanceValue [PS_ADAADM_Defaults_All]CalendarDate based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	2	34-35
10	End of Record Marker	Denotes the end of a record.	Always “X”	Alpha-numeric	1	36