Student Standing (FS) (Ohio Extracts)

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

  1. Select Student Standing (FS) as the Extract Type.
  2. Select the Reporting Period.
  3. 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.
  4. Enter a Membership Begin Date to indicate the Effective Start Date.
  5. 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.
  6. Indicate which Calendar(s) should appear in the report.
  7. 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.

Reports for the first enrollment in the first calendar in which the student is enrolled with a Service Type of P or N as of the start date of the Reporting Date Range. The following logic applies to the record reported:

  • If Membership Begin Date is entered and District Entry Reason is 7, reports Membership Begin Date.
  • If Membership Begin Date is entered and District Entry Reason is not 7, reports enrollment Start Date.
  • If Membership Begin Date is entered, District Entry Reason is not and Start Status is 7, reports Membership Begin Date.
  • If Membership Begin Date it entered, District Entry Reason is not and Start Status is not 7, reports enrollment Start Date.
  • If Membership Begin Date is not entered, reports enrollment Start Date.

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.

This field will look at a student’s schedule and report the first day of instruction on or after the enrollment record Start Date. If the student does not have an established schedule, the enrollment record Start Date will be used. Only enrollments with a Service Type of P or N will report.


Date field, 8 characters, YYYYMMDD

Student Information > General > Enrollments > Start Date AND System Administration > Calendar > Calendar > Days


Enrollment.startDate
days.date

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.

If the Legal District of Residence field is null, the District Code based on the student's most recent Primary household address reports. If the household address is null, the District Number reports.


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.

If the Building IRN Override is null, the State School Number will report.


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
EnrollmentOH.attendanceIRN

Assigned Building Area IRN

The IRN of the building the student would normally attend according to the standard district attendance policy.

If the Assigned Building IRN field is null, a value of ****** will report.


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.

If the Student Status field is null, a value of ** will report.


Alphanumeric, 1 character

Student Information > General > Enrollments > State Reporting Fields > Student Status


Enrollment.stateAid

How Received IRN

The district which received the student.

If the How Received IRN field is null, a value of ****** will report.


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. 

 If there is a significant change in the student’s data and a new record is created, the original record will count the days beginning with the first day of the count week including the Effective End Date. 

 If the student’s significant change is not the withdrawal of the student from the district, the newly created record will count the days from the Effective Start Date to the last days of the district’s 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 > 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



Save

Save

Save

Save