Tool Search: OH Extracts
The Ohio Organization General Information (DN) extract reports 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-excluded records will be reported. 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 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 days 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. Hours are reported in the Teacher Days code if a day only includes staff. |
| 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 course cost. |
| 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, laptops, tablets, etc.) to all students in one or more grade levels so that they can complete schoolwork at their primary residence. |
| TFRPSESCYS | The district provides preschool special education services for resident children and has authorized the Department to transfer funds for preschool special education students. |
| TFRPSESCNO | An Educational Service Center (ESC) provides preschool special education services for resident children, but the district has not authorized the Department to transfer funds for preschool special education students to the ESC that provides those services. |
| LCLWELLPOL | Local Wellness Policy. |
| LEAPRVWIFI | Indication of Wi-Fi accessibility to students outside of the building. |
| LITERACY INSTRUCTION | The core curriculum and instructional materials used for English language arts in grades preschool through five. The reading intervention programs used in grades preschool through twelve. |
| 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 to organize and maintain 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 the 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. Select the State Format (Fixed Width) option for submission to the state. To review data before submission, 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 be generated. Users can submit an 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 be generated in the background without disrupting the use of Campus. See the Batch Queue article for more information about submitting a report to the batch queue.
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 | Calendar Setup > School Years Setup > End 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 district's state-assigned six-digit information retrieval number.
FOR:
Numeric, 6 digits | District Information > District Detail > 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 | School Information > School Detail > State School Number District Information > District Detail > 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 depending upon the group selected on the extract editor. Alphanumeric, 10 characters | Day Setup > Day Detail > Day Events Day.eventType |
Attribute Date | Identifies the attribute's date of occurrence. Date Field, 8 characters, CCYYMMDD | Day Setup > 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 the Attendance Pattern is null, reports as **. For the District Group:
For the Student Group:
The Medical Group reports a blank space. Spaces report for the Assessment, College Credit Plus, Financial, Initial Eye Exam, and Physical Education Evaluation Groups. Alphanumeric, 6 characters | Day Setup > 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, report 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 are calculated 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 | Day Setup > Day Detail Day Events > Type day.eventType Medicaid Group: Medication Name Setup > Classification Health > Health Office Visits > Medication Doses |
Previous Version
Organization General Information (DN) (Ohio Extracts) [.2243 - .2307]
Organization General Information (DN) (Ohio Extracts) [.2211 - .2239]
