(DN) Organization General Information Record

Contents

Introduction

The (DN) Organization General Information Record report is used to capture date driven planned and unplanned events such as, professional development days, parent-teacher conferences, calamity days, days shortened and other building/district level information. An (DN) Organization General Information Record will be required in specific reporting periods for specific district types. The DN instructions are organized by groupings of related elements. Note that some Attribute Names/Groups are only reported at the district level while the majority is reported at a building level.

Selection Criteria

Selection criteria determine which database records are used in the report. For the (DN) - Organization General Information Recordreport school and district records are selected.

School Selection

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

All schools located in the Schools Table are extracted unless the school is excluded from state reporting, or is excluded from the DN report on the Edit School page.

Source Information

There are numerous tables where information is contained. For the (DN) - Organization General Information Record report the data are contained in these tables.

[PREFS]
[S_OH_SCH_DN_X] and [S_OH_SCH_DN_SNAP_C]
[S_OH_SCH_DN_MGMTCOMP_C]
[S_OH_SUBDISTRICTS.S_OH_ORGGENERALINFO_SNAP_S]
[S_OH_SCH_PHYSED_C] and [S_OH_SCH_PHYSED_SNAP_C]
[S_OH_SCH_X] and [S_OH_SCH_X_SNAP_C]
[S_OH_SCH_SNAP_C]

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
Schools for which to run?	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. Select schools to include in the report 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.
Reporting Period	Select the reporting period for which you are creating the extract – (C) Calendar or (S) Student
Fiscal Year	Enter the fiscal year for the report.
School Type:	Select the school type for the report.
Reporting Window	Select the reporting window for the report.
Scheduling
Run Now	Select this option to execute the report in the order it is received in the report queue.
Schedule (available Version 7.1.1.)	Enter the start date and start time for the report. Select Run Once and Submit to run the report at the specified date and time. Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

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.

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
DN010	Sort Type	The sort type equals DN for the Organization General Information extract.	N/A	Alpha-numeric	2	9–10
N/A	Filler	Filler	N/A	Alpha-numeric	1	11
DN020	Fiscal Year	The fiscal year defaults to the current school year.	N/A	Alpha-numeric	4	12–15
DN030	Reporting Period	This is the reporting period selected on the Organization General Information Record page, Start Page > Reports > Run Reports > Organization General Information (DN).	N/A	Alpha-numeric	1	16
DN040	District IRN	This field contains the district number. This field value is extracted from the Edit District page, Start Page > District Setup > District Information.	[Prefs]DistrictNumber CST_SUBDISTRICTS.Subdistrict_number	Alpha-numeric	6	17–22
DN050	Organization IRN	This field contains the state assigned six-digit IRN of the district or building.	[Schools]SchoolNumber [Prefs]DistrictNumber	Alpha-numeric	6	23-28
DN060	Attribute Name	This field contains the code that defines the data for which a date, number, and/or text description must be reported.	Refer to Source Information and the Data Dictionary.	Alpha-numeric	10	29-38
DN070	Attribute Date	This field contains the date that is appropriate for the Attribute Name being reported.	Refer to Source Information and the Data Dictionary.	Numeric	8	39-46
DN080	Attribute Text	This field contains the number that provides a value for an Attribute Name being reported.	Refer to Source Information and the Data Dictionary.	Alpha-numeric	6	47-52
DN090	Attribute Number	This field contains the code that further describes the Attribute Name being reported.	Refer to Source Information and the Data Dictionary.	Numeric	10	53-62

Back to Top