SC10 District Summary Report
Contents
Introduction
This report allows creation of a district summary report for either the Cumulative Class Report or the Membership and Attendance Report based on prior data extracts for the currently selected school year.
This report combines all of the data from the individual school extracts and summarizes it at the district level in a one-page report. A second page lists the schools summarized in the report and the dates and times when the extracts were created that are summarized in the report.
The report options allow for either the Membership and Attendance (All Students), Membership and Attendance (Self-Contained only), or Cumulative Class to be summarized.
Selection Criteria
Refer to selection criteria for analysis when the report does not return the correct records.
This report retrieves extract data from the [SC_EFA_EIA_HEADER] and [SC_EFA_EIA_EXTRACT] database tables based on the following criteria:
- Schools must have created extracts using the SC02 Cumulative Class Report and/or the SC06 Membership and Attendance Report.
- The records must have the same Day Number that the SC10 is being run; or
- The records must be within the same date range that the SC10 is being run.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
---|---|
Processing Options | Use the pull-down menu to select a processing option. Use the options to indicate when you want the report to generate.
|
Specific Date/Time | If "On Specific Time" is chosen for the Processing Options, enter the date and time you want the system to generate the report. |
Select Report | Select Report has these options listed in the following order in the pop-up menu:
|
Date Range | You may optionally enter a range of dates within the selected school year for the report to use to retrieve extracts based on the date the extract was created. The report retrieves the latest extract, created in this date range, that also meets the other user-defined parameters including the specified report type, the specified day number, and the use of extracts for funding.
|
Day Number | This is the school day number for which the extract was generated (e.g. 45 or 135). This dropdown list is prepopulated with only the day numbers for which extracts exist in the selected school year. This list is NOT restricted to 45-day or 135-day. |
Use Extracts Selected for State Funding | This option is only available for extracts with the day number 045 or 135. The options in this dropdown box are 'Yes' and 'No'. The default value for this dropdown is No. If you select 'Yes', then the report will use any extracts for the day number entered that have a 'Y' in SC_SubmitForStateFunding_Flag in the extract header. If the value in the dropdown is 'No', the report will use the latest extracts available for each school without regard to the value in SC_SubmitForStateFunding_Flag. If the user does not select 045 or 135 as the day number and has selected 'Yes' in the Use Extracts Selected for State Funding dropdown, this message will display "Use Extracts Selected for State Funding is only valid for a day number of 045 or 135." with an OK button. |
Report Output – Membership and Attendance (All Students) and Membership and Attendance (Self Contained Only)
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Position | Field | Description | [Table]Field Name |
---|---|---|---|
1 | Date | Date – Text "Date: " followed by the date the report was run in the format dd/mm/yyyy. | [SC_EFA_EIA_Header]SC_CreateDateTime |
2 | BEDS Code | BEDS Code is the combination of the District Code and School Code. | [SC_EFA_EIA_Header] SC_DistrictCode |
3 | School Name | This field contains the name of your school. | [SC_EFA_EIA_Header]SC_SchoolName |
4 | Report Name | The report name will be Membership and Attendance (All Students) if that is the parameter selected from the report options. The report name will be Membership and Attendance (Self Contained Only) if that is the parameter selected from the report options. | Pulled from report parameter |
5 | Day and date number | Day number is the day number in the school year that the report was run (i.e. Day 45). Date Number is the date that the report was run. | [SC_EFA_EIA_Header]SC_DayNumber and [SC_EFA_EIA_Header]SC_DateForDayNumber |
6 | District Name | This field contains the name of your school district. | [SC_EFA_EIA_Header]SC_DistrictName |
7 | EFA Code | This field lists the EFA codes in which the student may be enrolled. | N/A |
8 | PK3 – 12 | This field contains the total student enrollments in each EFA code, calculated by grade level. | N/A |
9 | Row Total | This calculated value is the total of all student enrollments in each EFA code. | N/A |
10 | Column Total | This calculated value is the total STUDENT MEMBERSHIP in the EFA codes for each grade level. | N/A |
11 | Column ADM Total | This calculated value is the average daily membership (ADM) for each EFA code for each grade level. | N/A |
12 | Column Absence Total | This calculated value is the total days absent for all students in each grade level. | [SC_EFA_EIA_EXTRACT]SC_CountGradePK-12 where SC_Funding_Code = 'ABS' |
13 | Count of Schools | Count of number of schools included in the report shows the total amount of schools the report was processed for. | N/A |
14 | List of extract included in this report-Schools | The list of schools and school numbers processed in the report. | ([SC_EFA_EIA_HEADER]SC_SchoolCode) ([SC_EFA_EIA_HEADER]SC_SchoolName) |
15 | List of extract included in this report-Extract Date/Time | The date and time the school extract was created in the format mm/dd/yyyy hh:mm:ss. | [SC_EFA_EIA_HEADER]SC_CreateDateTime. |
Report Output – Cumulative Class Option
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Position | Field | Description | [Table]Field Name |
---|---|---|---|
1 | Date | Date – Text "Date: " followed by the date the report was run in the format dd/mm/yyyy. | [SC_EFA_EIA_Header]SC_CreateDateTime |
2 | BEDS Code | BEDS Code is the combination of the District Code and School Code. | [SC_EFA_EIA_Header] SC_DistrictCode |
3 | School Name | This field contains the name of your school. | [SC_EFA_EIA_Header]SC_SchoolName |
4 | Report Name | Cumulative Class Report | Pulled from report parameter |
5 | Day and date number | Day number is the day number in the school year that the report was run (i.e. Day 45). Date Number is the date that the report was run. | [SC_EFA_EIA_Header]SC_DayNumber and [SC_EFA_EIA_Header]SC_DateForDayNumber |
6 | District Name | This field contains the name of your school district. | [SC_EFA_EIA_Header]SC_DistrictName |
7 | EIA Code | This field lists the EIA codes in which the student may be enrolled. | [SC_EFA_EIA_Header]SC_FundingCode1, SC_FundingCode2, SC_FundingCode3, …… SC_FundingCode29. |
8 | PK – 12 | This field contains the total student enrollments in each EIA code, calculated by grade level. | [SC_EFA_EIA_Extract]SC_CountPreKindergarten when [SC_EFA_EIA_Extract]SC_Funding_Code equals the funding code for the line being printed. |
9 | Row Total | This calculated field is the total of all student enrollments in each EIA code. | N/A |
10 | Column Total | This calculated field is the total of all student enrollments in the EIA codes for each grade level. | N/A |
11 | This report summarizes Extracts Selected for State Funding | If 'Yes', then "Extract Selected for State Funding" is printed on the report and left aligned. | N/A |
12 | Count of Schools | Count of number of schools included in the report shows the total amount of schools the report was processed for. | N/A |
13 | List of extract included in this report-Schools | The list of schools and school numbers processed in the report. | ([SC_EFA_EIA_HEADER]SC_SchoolCode) ([SC_EFA_EIA_HEADER]SC_SchoolName) |
14 | List of extract included in this report-Extract Date/Time | The date and time the school extract was created in the format mm/dd/yyyy hh:mm:ss. | [SC_EFA_EIA_HEADER]SC_CreateDateTime. |