(DL) Grade Schedule - Record

Contents

Introduction

The (DL) Grade Schedule Record report includes a record for each grade/attendance pattern combination at the district/ building level for any EMIS reporting entity.

Selection Criteria

Selection criteria determine which database records are used in the report.

School Selection

The report selects which district/school records to use based on the following criteria:

All records located in the Ohio General Grade Schedule table will be extracted.

Report Input

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

The report input is done in Incident Management with the codes and subcodes used in IM.

Field	Description
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy, or use the date picker, icon in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10:05 AM.
Fiscal Year	Enter the fiscal year for the report.
Reporting Period	Select the reporting period for which you are creating the extract – (C) Calendar

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.

Note: For documentation of XML report output from the state department of education, refer to http://www.ode.state.oh.us.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin/ End Position
N/A	Filler	Filler	N/A	Numeric	8	1–8
DL010	Sort Type	The sort type equals DL.	N/A	Alpha-numeric	2	9–10
N/A	Filler	Filler	N/A	Alpha-numeric	1	11
DL020	Fiscal Year	The fiscal year defaults to the current school year.	N/A	Alpha-numeric	4	12–15
DL030	Reporting Period	This is the reporting period selected on the Grade Schedule Record page: Start Page > Reports > Run Reports > Grade Schedule (DL)	N/A	Alpha-numeric	1	16
DL040	District IRN	This field contains the district number.	[S_OH_Grade_Sch_S]district_irn	Alpha-numeric	6	17–22
DL050	Building IRN	The state assigned six-digit information retrieval number (IRN) of the building.	[S_OH_Grade_Sch_S]building_irn	Alpha-numeric	6	23-28
DL060	Grade Code	This field contains the grade for which this schedule record is being reported.	[S_OH_Grade_Sch_S]grade_code	Alpha-numeric	2	29-30
DL070	Attendance Pattern	This field contains the arrangement of days in which a student is in this building on a weekly basis.	[S_OH_Grade_Sch_S]attendance_pattern_code	Alpha-numeric	2	31-32
DL080	First Day of School	This field indicates the first day of instruction for students in this grade/ attendance pattern combination. The format is YYYYMMDD	[S_OH_Grade_Sch_S]first_day_school	Numeric	8	33-40
DL090	Last Day of School	This field indicates the last day of instruction for students in this grade/ attendance pattern combination. The format is YYYYMMDD	[S_OH_Grade_Sch_S]attendance_pattern_code	Numeric	8	41-48
DL100	Hours Per Day	This field contains the actual number of hours per day in which scheduled classes, supervised activities, or approved educational options were provided to students in this grade.	[S_OH_Grade_Sch_S]first_day_school	Numeric	1 and 2 decimal places	49-51
N/A	Filler	Filler	N/A	Alpha-numeric	4	52-55
N/A	Filler	Filler	N/A	Alpha-numeric	4	56-60
N/A	Filler	Filler	N/A	Numeric	8	61-68

Back to Top