Tool Search: Ohio Extracts
The Student Detail Attendance (FM) extract reports student attendance data for funding purposes: present hours, unexcused absent hours, and excused absent hours.
Student Detailed Attendance (FM) Extract EditorReport Population and Business Rules
Reports three records per student enrollment returning calculated: present hours, unexcused absent hours, and excused absent hours to the hundredth in the selected reporting range. Should a student have more than one active enrollment in the reporting range, multiples of three records report.
There must be at least one Student Detailed Attendance (FM) Record for each Student Standing (FS) Record reported for a student.
- When within the date range of a Student Standing (FS) Record, a student has hours in attendance, excused absence hours, and unexcused absence hours, there must be at least three Student Detailed Attendance (FM) Records reported. In addition, a student should have at least one FM Record that includes each day in that student’s calendar for which attendance is expected. Although these records are minimums, a district can break down the date ranges into smaller groupings, as long as there are no overlapping dates between Student Detailed Attendance (FM) Records with the same attendance type and detail values.
- The start and end dates on each Student Detailed Attendance (FM) Record must be between the start and end dates of a single Student Standing (FS) Record. A single Student Standing (FS) Record can span the dates of multiple Student Detailed Attendance (FM) Records. As long as a student has at least one FM Record reported for each FS Record date span that includes required attendance days for a student based on their calendar, then it is not necessary to report every combination of Attendance Type and Attendance Detail unless the total Attendance Hours for that combination and date range is greater than zero.
Reports one record per student’s enrollment, per Attendance Type in the reporting range.
- When the student is enrolled in multiple calendar enrollments in the reporting range, multiple three-record sets reports.
- When the student DROPS then re-enrolls in the reporting range, (6 records may report one per attendance type multiplied by 2 enrollments) (i.e. Record SET):
- Three records report per consecutive enrollment in the reporting range:
- An “AT” record reporting calculated total present hours (Student’s Absence maps to ABSENT EXEMPT - or - the student is NOT MARKED ABSENT).
- When the student was not Present during the reporting range - reports as 0000.00 (assumes CSV format).
- An “EX” record reporting calculated total hours in which the student’s absence maps to ABSENT EXCUSED.
- When the student was not Absent Excused at any time in the reporting range - reports as 0000.00 (assumes CSV format).
- An UN record reporting calculated total hours in which the student’s absence maps to ABSENT UNEXCUSED
- When the student was not Absent Unexcused at any time in the reporting range - reports as 0000.00 (assumes CSV format).
- An “AT” record reporting calculated total present hours (Student’s Absence maps to ABSENT EXEMPT - or - the student is NOT MARKED ABSENT).
- Three records report per consecutive enrollment in the reporting range:
When the FS reporting population matches:
- When a student has multiple consecutive or concurrent (Service Type P or N) enrollments within the reporting range, multiple records report.
- When a student has an enrollment where Service Type = S: Partial and no other enrollments in the reporting range, no record reports.
- When a student is dual enrolled (2 concurrent enrollments) where 1 enrollment is flagged as P: Primary or N: Special Ed Service AND the second enrollment is flagged as S: Partial, one record reports to the Primary Enrollment Building IRN returning calculated attendance hours from both calendars.
The report can be run against a district’s active year and any prior year.
The report can be run in District Editions.
The report can be generated in CSV (State Format) formats and a human-readable format (HTML).
File Name/Format: StudentDetailAttendanceFM_MMDDYYYY_MMDDYYYY.csv (when the first date is the Start Date selected on the extract editor, and the second date is the End Date selected on the extract editor.
Extract Editor Fields
| Field | Description |
|---|---|
| Extract Type | The type of extract being generated. In this case, select Student Detailed Attendance (FM). |
| Reporting Period | Indicates when the report is being submitted. Options are:
|
| Calculate Positive Attendance | Includes positive attendance in the report calculations. |
| Date Range | The dates that determine which student enrollments are included in the report, based on the Start and End Dates of enrollments within the selected calendar(s). |
| Membership Being Date | Limits the report to those students with a specific Membership Begin Date. |
| Format | The format in which the report will generate. Options are CSV (State Format) and HTML. |
| Ad hoc Filter | Allows a previously created Ad hoc Filter to be selected, which limits which students appear in the report. Filters are created in the Filter Designer. |
| Select Calendars | Students enrolled in the selected calendar(s) are reported. |
| Generate Extract or Submit to Batch | Click Generate Extract to generate the report immediately, or click Submit to Batch. 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
CSV Header example: SortType, FiscalYear, DataSet, DistrictIRN, EMISstudentIDNumber, EffectiveStartDate, AttendanceType, AttendanceDetail, EffectiveEndDate, AttendanceHours
| Data Element Label | Description | Location |
|---|---|---|
| Sort Type | Always reports as FM. Alphanumeric, 2 characters | N/A |
| Fiscal Year | Reports the calendar End Year in CCYY format. Date field, 4 digits (CCYY) | Calendar Information > End Date |
| Data Set | Reports the Reporting Period code selected on the extract editor at the time of report generation. Alphanumeric, 1 character | Extract Editor > Reporting Period |
| District IRN | The value entered in the District IRN Override field on the School Information tool. Otherwise, the State District Number reports. Numeric | School Information > District IRN Override District Information > State District Number |
| EMIS Student ID Number | The student number. | Demographics > Person Identifiers > Student Number |
| Effective Start Date | First Reported FM Record Per Student:
All Other Records: Reports the Enrollment Start Date. One record per student's enrollment where the Start Date falls within the Reporting Date Range reports. Date field, CCYYMMDD, CCYY/MM/DD, or MM/DD/CCYY are accepted state formats | Enrollments > State Reporting Fields > Membership Begin Date Enrollments > Start Date |
| Attendance Type |
Alphanumeric, 2 characters | Calculated |
| Attendance Detail | Reports based on the Attendance Type:
Alphanumeric, 2 characters | N/A |
| Effective End Date | Reports the End Date per student enrollment record reported.
When null, reports as blank. Date field, CCYYMMDD, CCYY/MM/DD, or MM/DD/CCYY are accepted state formats | Enrollment > End Date |
| Attendance Hours | The actual number of hours the student was (AT, EX, or UN) from the enrollment of record on or between the reporting range selected on the extract editor. Reported hours are inclusive & encompass the first and last days of the student’s enrollment/reporting range. When the student drops and then re-enrolls during the reporting range, multiple records are reported. AT (present hours) records calculate per date in the reporting range as follows (Student’s Possible minutes of attendance) - ( (Student’s minutes marked Absent Unexcused) + (Student’s minutes marked Absent Excused) )
EX (Absent excused) records calculate as follows:
UN (Absent Unexcused) records calculate as follows:
Additional Logic Numeric fields must be right-justified and filled with leading zeroes in fixed-length files. Fields in CSV files do not require leading or trailing spaces.
| Calculated |
