The Student Standing (FS) extract describes the relationship of each student to the reporting district. Student Standing records are reported by a district for all enrolled students, students receiving/received services and/or students for whom the district has fiscal or other reporting responsibility.
Image 1: Ohio Student Standing Extract
If a student’s relationship with the reporting district is changed during the school year, their original Student Standing record is closed and a new record is opened. This means students may have more than one Student Standing record submitted during the reporting period however, only one Student Standing record can be considered open or active. Changes to the following extract elements require a student to begin a new record:
- Admission Date
- Admission Reason
- Assigned Building Area IRN
- Attending Building IRN
- District Relationship
- How Received
- How Received IRN
- Legal District of Residence
- Percent of Time
- Sent Reason
- Sent to IRN
- Sent to Percent of Time
- State Student ID
- Tuition Type
- Withdraw Reason
In order for a record to be considered closed, students must have their corresponding enrollment record End Dated.
Report Logic
- If a student has multiple enrollments, a record reports for the enrollment with the highest Student Percent of Time entered in the State Reporting Fields. If this field is equal on two or more enrollments, reports the enrollment with a Service Type of P: Primary. If multiple enrollments have equal Student Percent of Time values and a Service Type of P, reports the most recently created enrollment.
- For the Graduate reporting period, one record should be reported for each student that attended and graduated from the district between the first day of the recently completed school year and the day before the first day of the upcoming school year.
- If a Prior SSID End Date is entered, a split record will report beginning on the day after the Prior SSID End Date. The Prior SSID End Date will report as the Effective End Date for the closed record.
- Attendance for Partial Enrollments is included in the calculations for the following fields. The day being calculated is determined by the Primary Enrollment record, but multiple partial enrollments can be included in the calculation. if the calculated absence for a day exceeds a Whole Day Absence, only one day will be subtracted. Whole Day and Half Day absences are calculated based on the calendar of the Primary enrollment. If a particular day of attendance includes both excused and unexcused absences, the absence that contains the most time for the particular day will be reported.
- OctoberCountWeekAttendanceDays
- OctoberCountWeekExcusedAbsenceDays
- OctoberCountWeekUnexcusedAbsenceDays
- SchoolYearAttendanceDays
- SchoolYearExcusedAbsenseDays
- SchoolYearUnexcusedAbsenseDays
Calculating Attendance
For attendance to report, the following must be true:
- Period must be marked as Instructional to be included. Lunch time is not included.
- Courses must not be marked as Exclude from State Reporting.
- Calendar Day must be marked for Attendance and as Instructional.
Attendance is calculated based on the following logic:
- Calculated hourly (Total minutes divided by 60) and rounded to the nearest hundredth.
- Calculated based on the enrollment with a Service Type of Primary. If the student has multiple partial enrollments in the same district, daily attendance is aggregated for Primary and Partial enrollments.
- Calculated based on the student's schedule by comparing Roster Start and End Dates and Term Start and End Dates to Enrollment Start and End Dates.
- Absences are subtracted from the total possible membership for the day.
- Attendance fields are multiplied by the Enrollment Multiplier on the Enrollments tab. (As of Campus.1909)
- Times entered on the Calendar Day, and Day Events, override the standard period schedule when calculating attendance as follows:
- If Day Start and End Times are entered, total daily membership is between those times.
- If Day Start Time is entered but no End Time, total daily membership is between the Day Start Time and the End Time on the Period Schedule.
- If Day End Time is entered but no Start Time, total daily membership is between the Start Time on the Period Schedule and the Day End Time.
- If Day Start and End Times are blank, the day is not counted towards daily membership.
- These Day Events adjust possible membership for the day: C_DCMTYTKN, C_DPLANNED, C_DNOTPLAN, C_HRSLENGTH, C_HSHRTNOP, C_HSHRTPLN, C_HSHRTWEA, and C_HRSWKEND. Day Events can apply to all grade levels in a calendar or to specific grade level/attendance pattern combinations. Grade level/attendance pattern Day Events are appended with a suffix of XXNN, where XX is the Local Grade Name and NN is the Attendance Pattern.
Generating the Extract
- Select Student Standing (FS) as the Extract Type.
- Select the Reporting Period.
- Enter a Date Range in mmddyyyy format or by clicking the calendar icons and selecting dates. These dates determine which student enrollments are reported, based on the Start and End Dates of enrollments within the selected calendar(s). The first date defaults to 07/10 of the calendar start year.
- Enter a Membership Begin Date to indicate the Effective Start Date.
- Select the Format in which the report should generate. Options are State Format (Fixed width), HTML, CSV and XML. Use HTML, CSV or XML formats for data review and verification and State Format for submission to the State.
- Indicate which Calendar(s) should appear in the report.
- 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 (after Campus.1921), requests can only be submitted to the Batch Queue.
Users have the option of submitting a Student Standing report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow 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.
Image 2: Student Standing Extract - State Format
Image 3: Student Standing Extract - HTML Format
Image 4: Student Standing Extract - CSV Format
Image 5: Student Standing Extract - XML Format
Extract Layout
Element Name | Description & Format | Campus Location |
---|---|---|
Filler | ||
Sort Type | Reports as FS for this extract. | |
Filler | ||
Fiscal Year | The end year of the reporting school year. Date field, 4 digits, YYYY | System Administration > Calendar > School Year > End Year Calendar.endYear |
Reporting Period | The Reporting Period selected in the extract editor. Alphanumeric, 1 character | OH State Reporting > OH Extracts > Student Standing (FS) > Reporting Period Not dynamically stored |
District IRN | The state-assigned information retrieval number (IRN) of the district. Numeric, 6 characters | System Administration > Resources > District Information > State District Number District.number |
EMIS Student ID Number | The locally determined EMIS student ID. Alphanumeric, 9 characters | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
Effective Start Date | The first day all set values for this record are considered valid.
Date field, 8 characters, YYYYMMDD | Student Information > General > Enrollments > Start Date Enrollment.startDate |
Admission Date | The date of the student's first day of attendance at the school. Date field, 8 characters, YYYYMMDD | Student Information > General > Enrollments > Start Date AND System Administration > Calendar > Calendar > Days Enrollment.startDate |
Student Admission Reason | Describes the student's enrollment start status. Reports the District Entry Reason from the most recent enrollment. If null, reports the District Entry Reason from the enrollment in which the Admission Date falls. If null, reports the Start Status from historical enrollment. If no enrollment is found, reports as 7. Alphanumeric, 1 character | Student Information > General > Enrollments > Start Status Enrollment.startStatus |
Effective End Date | The last day all the values on this record are considered valid. Reports as 00000000 if End Date is Null. End Date will only be reported if it is within the extract Date Range. Date field, 8 characters, YYYYMMDD | Student Information > General > Enrollments > End Date Enrollment.endDate |
Withdrawal Reason | The reason the student withdrew from the school district. Reports the End Status selected for the student if the End Date of the enrollment falls within the extract Date Range. Reports as ** if End Status is Null. For Split Records, reports as ** for the current enrollment and the End Status for the prior record. Alphanumeric, 2 characters | Student Information > General > Enrollments > End Date Enrollment.endStatus |
SSID | The student's unique state-assigned identifier. All records found prior to the Prior SSID End Date will report the Prior SSID. All records after will report the current SSID. Alphanumeric, 9 characters | Census > People > Demographics > Person Identifiers > State ID; Student Information > General > Enrollments > State Reporting Fields > Prior SSID End Date, Prior SSID Person.stateID |
Student Percent of Time | The average percent of time during the week the student participates in any instruction provided by a certified/licensed employee. Reports the District Percent of Time, or as 100 if null. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting Fields > District Percent of Time Enrollment.admOverride |
Tuition Type | Identifies the student's form of tuition payment. Alphanumeric, 1 characters | Student Information > General > Enrollments > State Reporting Fields > Tuition Type EnrollmentOH.tuitionType |
District Relationship | The educational relationship between the student at the district. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > District Relationship Enrollment.districtRelationship |
Legal District of Residence | The IRN number of the city/municipal, local or exempted village school district in which the student’s parents reside. Numeric, 6 digits | Student Information > General > Enrollments > State Reporting Fields > Legal District of Residence OR Census > People > Households > Address Information > District Enrollment.residentDistrict |
Building IRN | The IRN of the building within the district the student attends. Numeric, 6 digits | Student Information > General > Enrollments >State Reporting Fields > Building IRN Override OR System Administration > Resources > School > School Editor > State School Number Enrollment.buildingIRNOverride |
Assigned Building Area IRN | The IRN of the building the student would normally attend according to the standard district attendance policy. Numeric, 6 digits | Student Information > General > Enrollments > State Reporting Fields > Assigned Building Area IRN Enrollment.assignedBuildingAreaIRN |
How Received | Describes how the student arrived at the district. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Student Status Enrollment.stateAid |
How Received IRN | The district which received the student. Numeric, 6 characters | Student Information > General > Enrollments > State Reporting Fields > How Received IRN Enrollment.servingDistrict |
Sent Reason 1 | The reason the student was sent to another district. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Sent Reason 1 Enrollment.servingDistrictStatus |
Sent to IRN 1 | The district to which the student was sent. Alphanumeric, 6 characters | Student Information > General > Enrollments > State Reporting Fields > Sent To IRN 1 EnrollmentOH.senttoIRN1 |
Sent to Percent of Time 1 | The average percent of time during the week the student participated in any instruction provided by an employee at a non-EMIS reporting entity. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting Fields > Sent to Percent of Time 1 EnrollmentOH.sentToPercentofTime1 |
Sent Reason 2 | The reason the student was sent to a second district. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Sent Reason 2 EnrollmentOH.sentReason2 |
Sent to IRN 2 | The district the student is sent if the student is simultaneously being sent to a second district. Alphanumeric, 6 characters | Student Information > General > Enrollments > State Reporting Fields > Sent To IRN 2 EnrollmentOH.senttoIRN2 |
Sent to Percent of Time 2 | The average percent of time for a week the student participated in any instruction provided by an employee at a non-EMIS reporting entity. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting Fields > Sent to Percent of Time 2 EnrollmentOH.sentToPercentofTime2 |
October Count Week Attendance Days | Currently reports as filler. The actual number of days a student is in attendance during the October Count Week. Alphanumeric, 3 characters | Student Information > General > Attendance > Instruction Days, Excused, Unexcused; OH State Reporting > OH Extracts > Reporting Period, Count Week; Student Information > General > Enrollments > State Reporting Fields > Student Percent of Time Calculated |
October Count Week Excused Absence Days | Currently reports as filler. The number of days the student was absent for excused reasons during the October Count Week. In the Fall reporting period, this field will only report attendance for records where the entered Count Week falls within the Effective Begin and End Date of the record. Alphanumeric, 3 characters | Student Information > General > Attendance > Excused Days; OH State Reporting > OH Extracts > Reporting Period, Count Week; Student Information > General > Enrollments > State Reporting Fields > Student Percent of Time Calculated |
October Count Week Unexcused Absence Days | Currently reports as filler. The number of days the student was absent for unexcused reasons during the October Count Week. In the Fall reporting period, this field will only report attendance for records where the entered Count Week falls within the Effective Begin and End Date of the record. Alphanumeric, 3 characters | Student Information > General > Attendance > Unexcused Days; OH State Reporting > OH Extracts > Reporting Period, Count Week; Student Information > General > Enrollments > State Reporting Fields > Student Percent of Time Calculated |
Filler4 | ||
School Year Attendance Hours | The number of hours the student is in attendance from all enrollment records between the Date Range entered on the extract editor. Attendance is calculated as Instructional Membership Hours - Excused and Unexcused Absence Hours, multiplied by the Enrollment Multiplier. The total across all enrollments is then multiplied by the Calculated District Percent of Time: Calculated District Percent of Time is determined as follows: District Percent of Time + Sent to Percent of Time 1 + Sent to Percent of Time 2. (Sent to Percent of Time 1 and 2 is only included if the respective Sent Reason is PS, MR, PI, or NP.) If sum exceeds 100, a value of 100 is used. For courses marked as positive attendance, student attendance is reported based on the positive attendance data recorded for the student. Alphanumeric, 5 characters | Student Information > General > Attendance > Instruction Days, Excused, Unexcused; Student Information > General > Enrollments > State Reporting Fields > District Percent of Time, Sent to Percent of Time 1, 2 Calculated |
School Year Excused Absence Hours | The number of hours of excused absence during the current school year within the Date Range entered on the extract editor. Reports the total number of Excused Hours (absent code AE) from all enrollments within the extract date range. Total Excused Hours is then multiplied by the Enrollment Multiplier. The total across all enrollments is then multiplied by the Calculated District Percent of Time: Calculated District Percent of Time is determined as follows: District Percent of Time + Sent to Percent of Time 1 + Sent to Percent of Time 2. (Sent to Percent of Time 1 and 2 is only included if the respective Sent Reason is PS, MR, PI, or NP.) If sum exceeds 100, a value of 100 is used. Alphanumeric, 5 characters | Student Information > General > Attendance > Excused Days; Student Information > General > Enrollments > State Reporting Fields > District Percent of Time, Sent to Percent of Time 1, 2 Calculated |
School Year Unexcused Absence Hours | The number of hours of unexcused absence during the current school year between the Date Range entered on the extract editor. Reports the total number of Unexcused Hours (absent code AU or A) from all enrollments within the extract date range. Total Unexcused Hours is then multiplied by the Enrollment Multiplier. The total across all enrollments is then multiplied by the Calculated District Percent of Time: Calculated District Percent of Time is determined as follows: District Percent of Time + Sent to Percent of Time 1 + Sent to Percent of Time 2. (Sent to Percent of Time 1 and 2 is only included if the respective Sent Reason is PS, MR, PI, or NP.) If sum exceeds 100, a value of 100 is used. Alphanumeric, 5 characters | Student Information > General > Attendance > Unexcused Days; Student Information > General > Enrollments > State Reporting Fields > District Percent of Time, Sent to Percent of Time 1, 2 Calculated |
Admitted from IRN | The IRN of the district from which the student was admitted. Numeric, 6 digits | Student Information > General > Enrollments > State Reporting Fields > Admitted from IRN EnrollmentOH.admittedFromIRN |
Withdrawn to IRN | The IRN of the district to which the student withdrew. Reports the Withdrawn to IRN from the student's most recent enrollment, or as ****** if null. For SSID Split records, reports the Withdrawn to IRN for the most recent record and as ****** for prior records. Numeric, 6 digits | Student Information > General > Enrollments > State Reporting Fields > Withdrawn to IRN EnrollmentOH.withdrawnToIRN |
County of Residence | The number of the county where the student resides. Reports the County of Residence, or the County number from the student's most primary household address or from the saved Country number on district information. If District County is null, reports as **. Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > County of Residence EnrollmentOH.countyOfResidence |
Filler |