Tool Search: OH Extracts
The Ohio Organization General Information (DN) extract is used to report groups of information regarding building and district information.
Ohio State Extract Editor: Organization General Information (DN)
Report Logic
Each attribute within each group reports a record. Records should be sorted by group and by calendar. Calendar and state exclude will report.
A record reports for each day with a Date Event, for each State Grade. Duplicate records are not reported for days with multiple events.
Assessment Group Attribute Codes
| Code | Description |
|---|---|
| ASMTFG3ELA | Fall 3rd Grade ELA assessment |
| ASMTSPRELA | Spring English Language Arts (all grades, including EOC) |
| ASMTSPRMSS | Spring Math, Science, Social Studies (all grades, including EOC) |
Calendar Group Attribute Codes
For Day Events of DBLZZARD, a record reports for each Day with that Event. A separate record reports for each Grade Level that is not marked as State Exclude. If an Attendance Pattern is entered, a record reports for each Attendance Pattern entered for a Grade Level.
For all other attributes, for each Day Event of the reported attribute, each grade level not marked state exclude reports a record, and within that a record reports for each unique Attendance Pattern.
Code | Description |
|---|---|
C_DCMTYTKN | Full day taken for calamity situations. |
C_DNOTPLAN | Full unplanned day not in session, excluding calamity days. |
C_DPLANNED | Full planned day not in session, such as holidays and breaks. |
| C_HRSLNGTH | Can be used for a calamity makeup day added to a scheduled day, or for other reasons. |
| C_HSHRTNOP | Hours in session when the day was shortened for an unplanned reason other than weather, such as early dismissals, late starts, or mid-day interruptions. |
| C_HSHRTPLN | Hours in session when the day was shortened for a planned reason other than weather, such as teacher professional days and parent-teacher conference days. Reports days where both students and staff are expected to attend. If a day only includes staff, hours report in Teacher Days code. |
| C_HSHRTWEA | Hours in session when the day was interrupted by weather. |
| C_PRFLMEET | Staff professional meeting day, full or partial. |
| C_PTCONFRC | Parent-teacher conference day, full or partial. |
| C_YWKDAYMN | For students who are not expected to be in attendance every Monday during the school year. |
| C_YWKDAYTU | For students who are not expected to be in attendance every Tuesday during the school year. |
| C_YWKDAYWD | For students who are not expected to be in attendance every Wednesday during the school year. |
| C_YWKDAYTH | For students who are not expected to be in attendance every Thursday during the school year. |
| C_YWKDAYFR | For students who are not expected to be in attendance every Friday during the school year. |
| C_YWKDAYSA | For students who are expected to be in attendance every Saturday during the school year. |
| C_YWKDAYSU | For students who are expected to be in attendance every Sunday during the school year. |
| C_HRSWKEND | For students who attend on a Saturday or Sunday that is not in the regular schedule, such as make up days. |
College Credit Plus Group Attribute Codes
| Code | Description |
|---|---|
| CCPDENIALS | Count of CCP students denied participation because they did not give notice of CCP participation by the deadline |
| CCPREIMBCT | Count of students who failed or dropped a course and districts sought reimbursement from the student for the cost of the course |
| CCPRESTITU | Total dollar amount a district is seeking for CCP reimbursement due to a dropped or failed course for all students (rounded to the nearest dollar) |
District Group Attribute Codes
| Code | Description |
|---|---|
| LEAPRVHARD | The district provides computer hardware (desktops, lap-tops, tablets etc) to all students in one or more grade levels for use in completing schoolwork at their primary residence. |
| TFRPSESCYS | District is providing preschool special education services for resident children and the district has authorized the Department to transfer funds for preschool special education students |
| TFRPSESCNO | An Educational Service Center (ESC) is providing preschool special education services for resident children and the district has not authorized the Department to transfer funds for preschool special education students to the ESC providing those services |
| LCLWELLPOL | Local Wellness Policy. |
| LEAPRVWIFI | Indication of Wi-Fi accessibility to students outside of the building. |
| PBISIMPSTG | Number of months at Positive Behavior Intervention Support (PBIS) Implementation Stage |
| EDUMODELDB | The initial delivery model used in the district at the start of the school year, and each date when the delivery model changes. |
| DSTRCTSFTW | DSTRCTSFTW is used to report the primary software used by the district for organizing and maintaining EMIS submission data. |
Financial Group Attribute Codes
| Code | Description |
|---|---|
| CENOFFSQFT | Square footage of the central office |
| BLDGSQFEET | Square footage of a building |
| LUNCHRMPCT | Percentage of meals served for the building |
| TRANSPTPCT | Percent of students, in the district, bused for the building |
Initial Eye Exam Group Attribute Codes
| Code | Description |
|---|---|
| EYEREQCNTA | Number of students with an IIEP written within the stated time frame. |
| EYERECCNTB | Number of students with an IIEP written within the stated time frame who received an eye exam within three months of beginning services. |
| EYENRCCNT1 | Number of students with an IIEP written within the stated time frame who received an eye exam more than three months after beginning services. |
Medical Group Attribute Codes
Physical Education Group Attribute Codes
| Code | Description |
|---|---|
| PHYSEDLMKG | Count of students at the limited level in the KG-02 grade band |
| PHYSEDPFKG | Count of students at the proficient level in the KG-02 grade band |
| PHYSEDADKG | Count of students at the advanced level in the KG-02 grade band |
| PHYSEDNEKG | Count of students not evaluated in the KG-02 grade band |
| PHYSED**KG | 0000000000 |
| PHYSEDLM03 | Count of students at the limited level in the 03-05 grade band |
| PHYSEDPF03 | Count of students at the proficient level in the 03-05 grade band |
| PHYSEDAD03 | Count of students at the advanced level in the 03-05 grade band |
| PHYSEDNE03 | Count of students at the advanced level in the 03-05 grade band |
| PHYSED**03 | 0000000000 |
| PHYSEDLM06 | Count of students at the limited level in the 06-08 grade band |
| PHYSEDPF06 | Count of students at the proficient level in the 06-08 grade band |
| PHYSEDAD06 | Count of students at the advanced level in the 06-08 grade band |
| PHYSEDNE06 | Count of students not evaluated in the 06-08 grade band |
| PHYSED**06 | 0000000000 |
| PHYSEDLM09 | Count of students at the limited level in the 09-12 grade band |
| PHYSEDPF09 | Count of students at the proficient level in the 09-12 grade band |
| PHYSEDAD09 | Count of students at the advanced level in the 09-12 grade band |
| PHYSEDNE09 | Count of students not evaluated in the 09-12 grade band |
| PHYSED**09 | 0000000000 |
Student Group Attribute Codes
| Code | Description |
|---|---|
| STUKGBRDAY | The date by which student is required to be 5 years old for kindergarten admittance. |
| STUHOMESCL | Count of home-schooled resident students. |
| STUKGLFREE | Used to report the count of all-day kindergarten students who pay tuition and are eligible for free lunch. |
| STUKGLRCED | Reports the count of all-day kindergarten students who pay tuition and are eligible for reduced price lunch. |
| STUKGNFEES | Used to report the maximum amount charged to all-day kindergarten students for fees. |
| STUKGTUITN | Reports the maximum amount charged to all-day kindergarten students for tuition. |
| STUNPNTSRV | Count of resident and non-resident nonpublic students who are in grades K-12 within district boundaries eligible for special education services but not being served by the district. |
| STUNPNTELG | Count of resident and non-resident nonpublic students who are in grades K-12 within district boundaries evaluated and determined ineligible for special education services |
| STUPSTCBTR | Count of preschool transition conferences held by 3rd birthday, no disability suspected, no additional evaluation |
| STUPSTCATR | Count of preschool transition conferences held after 3rd birthday, no disability suspected, no additional evaluation |
Generating the Extract
- Select the Organization General Information (DN) Extract Type.
- Use the Group field to indicate the attribute for which to generate a report. Use the Ctrl key to select one, or more, attributes. The attribute within each group reports a record. Records are sorted by group and by calendar.
- Select the appropriate Reporting Period for the selected Group.
- Enter the desired Date Range in mmddyyyy format or by clicking the calendar icons and selecting dates. Indicates date range from which the report will extract data.
- Select the extract Format. For submission to the state, select the State Format (Fixed width) option. To review data before submission to the state, select any of the other available formats.
- Select which calendar(s) to include within the extract. Information regarding the selected group for the school(s) in the selected calendar(s) will appear in the report. Calendars may be listed by active year, school or year by selecting the appropriate radio button.
- Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate. If generating multiple extracts at a time, requests can only be submitted to the Batch Queue.
Users have the option of submitting a Organization General Information (DN) report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Extract Layout
Element Name | Description & Format | Campus Location |
|---|---|---|
Filler | Filler - 8 characters | N/A |
Sort Type Code | Identifies the record type. This will always report as DN for the Organization General Information extract. Alphanumeric, 2 characters | Not Dynamically Stored |
Filler 2 | Filler - 1 character | N/A |
Fiscal Year | Identifies the end of the school year. The fiscal year is July 1st through June 30th. Date Field, 4 characters, CCYY | System Administration > Calendar > School Years > End Year calendar.endDate |
Reporting Period Code | The reporting period from which the data is being pulled. Alphanumeric, 1 character | OH State Reporting > OH Extracts > Reporting Period Not Dynamically Stored |
District IRN | Identifies the state assigned six-digit information retrieval number of the district.
FOR:
Numeric, 6 digits | System Administration > Resources > District Information > State District Number district.number |
Organization IRN | Identifies the six-digit information retrieval number of the organization. When reporting a Medical Group, reports the information retrieval number of the district.
FOR:
Numeric, 6 digits | System Administration > Resources > School > State School Number; District > State District Number school.number |
Attribute Name | Identifies an attribute of the group selected on the extract editor. Each attribute within the selected group reports for the selected calendar(s). This field is reused and can have multiple meanings dependent upon the group selected on the extract editor. Alphanumeric, 10 characters | System Administration > Calendar > Calendar > Days > Day > Day Events Day.eventType |
Attribute Date | Identifies the attribute's date of occurrence. Date Field, 8 characters, CCYYMMDD | System Administration > Calendar > Calendar > Days > Day > Day Detail > Date day.date |
Attribute Text | Identifies additional text associated with the reported attribute name. For the Calendar Group, attributes report the State Grade Level + the Attendance Pattern Code. If Attendance Pattern is null, reports as **. For the District Group:
For the Student Group:
For the Medical Group, reports as blank space. For the Assessment, College Credit Plus, Financial, Initial Eye Exam, and Physical Education Evaluation Groups, spaces report. Alphanumeric, 6 characters | System Administration > Calendar > Calendar > Days > Day > Day Detail > Comments day.comments |
Attribute Number | For the Calendar Group, the DBLZZARD attribute calculates as follows: If the Day Event has Instruction Minutes entered, reports the Instruction Minutes entered divided by 60. If Instruction Minutes is null, reports as described below. For the Calendar Group, the DBLZZARD, HRSLNGTH, HSHRTNOP, HSHRTPLN, and HRSWKEND attributes calculate as the Start Time of the day minus the End Time of the day minus Lunch Minutes, divided by 60. For the HSHRTNOP, HRSLNGTH, HSHRTWEA, and HRHRTPLN calendar events, if the Day Event has Instructional Minutes entered, reports that value divided by 60, otherwise based on the calculation above. For the Calendar Group, the PRFLMEET and PTCONFRC attributes calculate as the day event Duration divided by 60. For the Medical Group:
For the College Credit Plus Group:
For the District Group:
For the Financial Group:
For the Initial Eye Exam Group:
For the Physical Education Evaluation Group:
Values report with an implied 4 place decimal. For example, 2.25 hours reports as 0000022500. All other attributes report as 0000000000. Alphanumeric, 10 characters | System Administration > Calendar > Calendar > Days > Day > Day Events day.eventType Medicaid Group: System Administration > Health > Medication Name > Medication Classification; Student Information > Health > Health Office Visits > Medication Doses |
Previous Version
Organization General Information (DN) (Ohio Extracts) [.2243 - .2307]
Organization General Information (DN) (Ohio Extracts) [.2211 - .2239]
