PATH: OH State Reporting > OH Extracts > Student Attributes Effective Date Record (FD)
The Student Attributes Effective Date Record (FD) extract contains a combination of student demographic and attendance data for each student reported in EMIS during the date range entered.
Users must submit a new October extract if any reported student has their disability condition change between the October reporting period through December 1.
All students active or inactive within the selected calendar(s) and the Date Range entered on the extract editor will report a record.
Image 1: Extract generator overview
Report Logic
- Students do not need to have an active enrollment to appear in the report.
- Each enrollment record that occurs during the Date Range entered in the extract editor will be included in the report. Multiple records may generate for each student.
- Only enrollments with a Service type of P or N will report in the extract.
- Split Record Population Logic- ETR - Primary Disability
- The Primary Disability from a locked and active ETR to the next cannot be the same. If consecutive ETR's contain the same Primary Disability, additional FD records will not report.
- If Primary Disability is not the same and Meeting Date does not match the enrollment Start Date but is within range of the enrollment, an FD record reports. EffectiveStartDate = Meeting Date. The the day prior to the Meeting Date will be the EffectiveEndDate for the closed record.
- If multiple locked and active state specific ETR's are found within the range of the enrollment, a new record reports using the above logic ONLY if there is a change in Primary Disability from one ETR to the next.
- Split Record Population Logic- SPED Dates
- If the student has a SPED Dates status with an Exit Date within the range of a student's enrollment and has an Exit Reason = ETEX or ETNE, an FD record reports. EffectiveStartDate = SPED Exit Date. The day prior to the Exit Date will be the EffectiveEndDate for the closed record. DisabilityCondition of the current record will reports as **. Any enrollment created beyond the current record will report as ** in DisabilityCondition until a new ETR is found containing a Primary Disability.
- Only ETRs and an Exit Reason = ETEX or ETNE cause a split record to be generated.
- Split Record Population Logic - English Learners (EL)
- If Identified Date or EL Service Start Date is on or before the enrollment Start Date, reports English Learners (EL) Status.
- If Identified Date, EL Service Start Date or Program Exit Date do not equal enrollment Start Date but fall during the enrollment, a split record will be created with a change in English Learners (EL) Status.
- If multiple EL statuses fall within the enrollment, a new record reports if there was a change in EL Status between records.
- Split Record Population Logic - Homeless
- Reports a split record if the Effective Start Date, Effective End Date, Homeless Status, or Unaccompanied Youth fields have been changed.
- If the student has a Homeless record with a Start Date prior to the enrollment Start Date, reports Homeless Status and Unaccompanied Youth from the current record.
- If the student has a Homeless record with a Start Date within the enrollment date range, reports a split record with Homeless Status and Unaccompanied Youth reporting from the current record.
- If multiple Homeless records are found during the enrollment, a new record is reported only if there is a change to the Homeless Status or Unaccompanied Youth.
- For SPED Dates or EL split records to report, there must be Day records created from 7/1/20xx to 6/30/20xx. The Day Resent tool on the Days tab creates the necessary records.
Determining English Learners (EL):
| Status | Condition | Other Logic |
|---|---|---|
| N: No | Program Status: Exited EL Program Exit Date: not null | N/A |
| Y: Yes | Program Status: EL Identified Date: not null | Trumped by statuses of L and M |
| L: LEP - Enrolled in U.S. Schools for First Time | Services has a State Service Type of L: Date Entered U.S. School less than 180 days Start Date: not null | Trumps a status of Y. |
| S: LEP - Enrolled in U.S. Schools for 2nd Year | Service has a State Service Type of S: LEP - Enrolled in U.S. Schools for 2nd Year State Date: not null | Trumps a status of Y. |
| M: LEP - Trial-Mainstream | Service has a State Service Type of M: Trial-Mainstream Start Date: not null | Trumps all other statuses |
Report Editor
The following table describes the options available in the extract editor.
Editor Field | Description |
|---|---|
Extract Type | The type of extract being generated. In this case, select Student Attributes Effective Date Record (FD). |
Reporting Period | Indicates when the report is being submitted. Options are:
|
Date Range | The dates which determine which student enrollments will appear on the report, 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. |
Membership Begin Date | Used to determine the Effective Start Date. Ohio tracks membership by fiscal year, beginning on 7/1. Enter a date of 7/1/XX to report enrollments for that year. |
Format | The format in which the report will 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. |
Ad hoc Filter | Allows a previously created Ad hoc Filter to be selected that will limit what students appear in the report. Filters are created in the Filter Designer. |
Calendar(s) | Students enrolled in the selected calendar(s) will appear in the report. |
Generating the Extract
- Select the Student Attributes Effective Date Record (FD) Extract Type.
- Select the appropriate Reporting Period.
- Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date.
- If reporting for the October Reporting Period, enter a Count Week date range in mmddyyyy format or by clicking the calendar icons and selecting dates.
- Enter a Membership Begin Date.
- Select the proper Format. For submission to the state, select the State Format (Fixed width). To review data prior to state submission, select any of the other available formats.
- Select which calendar(s) to include within the extract.
- Select an Ad hoc Filter, if applicable.
- 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 Attributes Effect Date Record 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 Attributes Effective Date Record (FD) - State Format
Image 3: Student Attributes Effective Date Record (FD) - HTML
Image 4: Student Attributes Effective Date Record (FD) - CSV
Image 5: Student Attributes Effective Date Record (FD) - XML
Extract Layout
Element Name | Description & Format | Campus Location |
|---|---|---|
Filler | 7 characters |
|
Filler | 1 character |
|
Sort Type | Indicates the Sort Type. This field will always report a value of FD for the Student Attributes Effective date Record (FD). Alphanumeric 2 characters | N/A |
Filler | 1 character |
|
Fiscal Year | The Fiscal Year is determined by the end year of the reporting school year (i.e., 2009 for the 2008-2009 school year). YYYY, 4 characters | System Administration > Calendar > School Year > End Year Not Dynamically Stored |
Reporting Period | 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 | The district's state assigned six-digit information retrieval number (IRN). Alphanumeric 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 | 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:
YYYYMMDD, 8 characters | Student Information > General > Enrollments > Start Date Enrollment.startDate |
| Effective End Date | The last day the values in this record are valid. Reports the End Date for each enrollment record being reported, or as applicable for split record logic. YYYYMMDD, 8 characters | Student Information > General > Enrollments > End Date Enrollment.endDate |
State Equivalent Grade Level | The grade level in which the student will be included for reporting purposes. Alphanumeric 2 characters | Student Information > General > Enrollments > State Reporting Fields > State Equivalent Grade Level; Student Information > General > Enrollments > Grade Enrollment.stateEquivalentGrade |
Attendance Pattern | The student's weekly attendance pattern. Alphanumeric 1 character | Student Information > General > Enrollments > State Reporting Fields > Attendance Pattern Enrollment.attendancePattern |
Disadvantagement | Identifies students who meet the definition of economic and/or academic disadvantagement. Reports based on the School History tab. If an active Provision is found for the school, all students will report 1. If no Provision is found, students will reports based on the Disadvantaged field in Enrollments. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Disadvantaged AND System Administration > Resources > School > School History > Provision Enrollment.disadvantaged |
Preschool Poverty Level | The poverty level of the preschool student’s family, as determined by Federal Poverty Guidelines. Alphanumeric 1 character | Student Information > General > Enrollments > State Reporting Fields > Preschool Poverty Level Enrollment.preSchoolPoverty |
Disability Condition | Describes the disability of a student at or below 22 years of age who has been officially identified with a disability. If the student has a locked and active ETR (Evaluation Team Report), reports the Primary Disability. If no ETR is found, reports Disability Condition. If Disability Condition is null, a value of ** will report. Alphanumeric 2 characters | Student Information > Special Ed > Documents > ETR > Primary Disability; Student Information > General > Enrollments > Special Education Fields > Disability Condition Enrollment.disability1 |
Student Being Served by 504 Plan | Identifies students with a disability under Section 504 of the Rehabilitation Act of 1973 and is being served by a 504 plan developed to meet the student’s specific needs. Y or N, 1 character | Student Information > General > Enrollments > State Reporting Fields > Student Being Served by a 504 Plan Enrollment.section504 |
Homeless Status | Students who lack a fixed regular and adequate night time residence and have a primary night time residence indicated. Reports the Primary Nighttime Residence selected for the student. Reports as * if null. Alphanumeric 1 character | Student Information > Program Participation > Homeless > Primary Nighttime Residence Homeless.primaryNighttimeResidence |
Homeless Unaccompanied Youth | A homeless student not within physical custody of a parent or guardian. Alphanumeric 1 character | Student Information > Program Participation > Homeless > Unaccompanied Youth Homeless.unaccompaniedYouth |
Limited English Proficiency | Indicates if the student is considered an English Learner. If the student has an EL record with the Identified Date or Service Start Date on or before the Start Date the enrollment, reports as Y. If the Service Start Date or Program Exit Date do not match the enrollment dates but the record is active during the enrollment, reports a new FD record and this field reports as Y. If multiple EL records are found, new records are reported only if there is a change in how this field will report. If student is enrolled in a State Grade of PS: Preschool, reports as *. Y or N, 1 character | Student Information > Program Participation > English Learners (EL) > Program Status LEP.programStatus |
Migrant Status | Identifies whether or not the student is considered an migrant. Alphanumeric 1 character | Student Information > General > Enrollments > State Reporting Fields > Migrant Enrollment.migrant |
Foreign Exchange Graduation Plan | Identifies the foreign exchange status of a student as it relates to the student’s graduation plans. Alphanumeric 1 character | Student Information > General > Graduation> State Reporting Fields > Foreign Exchange Graduation Plan Graduation.postsecondaryEnrollmentPlans |
Immigrant Status | Immigrant Status is defined Per Section 3301 (6) of the Elementary and Secondary Education Act as a student who is age 3 through 21, not born in any U.S. State and has not attended one or more schools in any one or more States for more than 3 full academic years. Alphanumeric 1 character | Student Information > General > Enrollments > State Reporting Fields > Immigrant Status Enrollment.immigrant |
Filler | 236 characters |
|
