SC05 Daily Activities Summary Log

Contents

Introduction

The Daily Activities Summary Log shows the total number of students added and deleted from each EFA classification on a user-specified day due to school withdrawals and enrollments. This report also shows cumulative values from the start of school to the user-specified date. It is used by school and district administrators to review changes in the numbers of students within each EFA classification.

Student data for the school selected is included in the record selection process; every student who was enrolled in that school at any time during the report period is evaluated.

Selection Criteria

Selection criteria determine which database records are used in the report. For the SC05 Daily Activities Summary Log, student records are selected. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

A student record is selected if it meets the following criteria:

The student was enrolled at any time during the report period with any enrollment code and had a primary EFA classification in effect for the report period.
The student was in a user-selected grade level during the report period.
The student has the Include this student in State Reporting field set to Yes.

A student record is excluded if it meets the following criteria:

The student has an enrollment record with the same enter date and exit date (no show) in the currently selected school year.
The student has a grade level that is not equal to 99.
The student has a school ID that is not the Graduated Students School.

Note: If at least one student included on this report has a mismatch between their initial school enrollment date for the selected year and their initial EFA start date for the selected year, the following warning message will print at the bottom of the report: "Warning: Errors were found in EFA history information. Please run the data verification report and correct reported issues."

Back to Top

Report Input

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

Field	Description
Processing Options	Use the pop-up menu to select a processing option. Use the options to indicate when you want the report to generate. In Background Now ASAP At Night On Weekend On Specific Time The option to override may not be available on some reports.
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.
Date	Optionally, enter the date used to determine the report period. If a date is entered and the Cumulative check box is: Selected, this date is used as the end date of the report period. The first in-session day of school is the start date of the report period. Not selected, the report period is only for the date entered. Leave this field blank if you plan to enter a value in the Day Number field.
Day Number	Optionally, enter a day number to calculate the report period. For example, if you enter the number 5 and the fifth in-session day of school is August 25^th, the report end date will be August 25^th of the current school year. If a day number is entered and the Cumulative check box is: Selected, this calculated date is used as the end date of the report period. The first in-session day of school is the start date of the report period. Not selected, the report period is only for the calculated date. Leave this field blank if you entered a value in the Date field.
Grade	Enter two grade levels to identify the grade level range for the report. You can select any two grade levels that are valid for the selected school. Leave one Grade field blank to include only students in a specific grade level on the report. Leave both Grade fields blank to include all students in your school on the report.

Back to Top

Report Output

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	999 Day Data as of 99/99/9999	This field contains the end date or day number entered on the report interface page.	N/A
2	BEDS Code	This field is calculated by combining the district number and school code. The district number is extracted from the Edit District page, Start Page > District Setup > District Information. The school code is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[Prefs]Name=districtnumber [Schools]School_Number
3	Name	This field contains the name of your school. This value is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[Schools]School_Name
4	Grades	This field contains the grade level range selected on the report interface page. If no grade levels were selected for the report, the grade levels do not print.	N/A
5	District Name	This field contains the name of your school district. This value is extracted from the Edit District page, Start Page > District Setup > District Information.	[Prefs]Name=districtname [Prefs]Value
6	EFA Classification	This column contains the description of each EFA code. These values are extracted from the EFA Code Entry page, Start Page > Student Selection > South Carolina State Information > EFA/EIA Classification. If a student’s initial school enrollment date does not match the student’s initial EFA classification record start date for the selected school year, the message “Error: Mismatch on initial EFA date and school enrollment.” will print in this column. These error records will print on the first page of the report. An EFA classification is included on this report only if a student who enrolled or withdrew in the reporting period was assigned that EFA classification.	[S_SC_STU_EFA_History_C]efa_primary [S_SC_STU_EFA_History_C]efa_2 [S_SC_STU_EFA_History_C]efa_3 [S_SC_STU_EFA_History_C]efa_4 [S_SC_STU_EFA_History_C]efa_5 [S_SC_STU_EFA_History_C]efa_6 [S_SC_STU_EFA_History_C]efa_7 [S_SC_STU_EFA_History_C]efa_8 [S_SC_STU_EFA_History_C]efa_9 [S_SC_STU_EFA_History_C]efa_10
Today
7	Adds	This column contains the calculated count of students enrolled in school on the date specified. A count displays for each EFA classification.	N/A
8	Deletes	This column contains the calculated count of students withdrawn from school on the date specified. A count displays for each EFA classification.	N/A
9	Nets	This column contains the calculated difference between the Today Adds and Today Deletes column. The calculation is Today Adds – Today Deletes.	N/A
Cumulative
10	Adds	This column contains the calculated total number of students enrolled in school from the first in-session date to the report date specified by the user on the report interface page. A total displays for each EFA classification.	N/A
11	Deletes	This column contains the calculated total number of students withdrawn from school from the first in-session date to the report date specified by the user on the report interface page. A total displays for each EFA classification.	N/A
12	Nets	This column contains the calculated difference between the Cumulative Adds and Cumulative Deletes column. The calculation is Cumulative Adds – Cumulative Deletes. A net total displays for each EFA classification.	N/A
13	Totals	A total for each column is calculated and displayed.	N/A

Back to Top