Exiting Student Follow Up (FW) (Ohio Extracts)

Last Modified on 01/07/2025 8:37 am CST

Tool Search: OH Extracts

The Exiting Student Follow Up (FW) extract reports data from records on the Follow Up Data (FW) tab. The FW Record is reported the year after a student exits secondary education. Information on students who were career-technical concentrators is used for federal reporting based on the data submitted during the Initial Exiting Student Collection. However, data for all students may be updated in both the Initial and Final Exiting Student Collections.

Screenshot of the Ohio State Extracts: Exiting Student Follow Up (FW) Extract Editor
Ohio State Extracts: Exiting Student Follow Up (FW) Extract Editor


Reporting Population and Business Rules

#Requirements
R1

Report a record if the student has any enrollment in the district and an FW record with:

  1. An FW tab record Effective Date that is on or inside the extract editor Start and End Date range
  2. State Data = False on the FW record
    AND
  3. One or more of the following are true in the FW record:
    1. CTE, Grad and/or SWD = checked
R1.BR1

Only one record should report for each student. Follow the following priority:


    • Report the FW record with the most recent effective date prior to the Start Date of the extract editor.
    • The calendar for the student's enrollment with the most recent Primary enrollment Start Date <= the FW record Effective Date is selected on the extract editor.
      1. When student has > 1 Primary enrollment with the same most recent Start Date, reports for the calendar tied to the enrollment with the most recent enrollment ID.
R1.BR2If State Data = True on the FW record, do not report
R1.BR3If CTE, Grad and SWD all = False on the FW record, do not report
R1.BR4
  • CTE:
    1. When CTE is checked:
      1. When the associated "District IRN Override" field is NOT null:
        1. Reports the District IRN in the associated "District IRN Override" field.
      2. When the associated "District IRN Override" field is null:
        1. Reports the State District Number of the current district (System Admin > Resources > District Info > District Detail > State District Number)
    2. When CTE is NOT checked:
      1. Reports null
  • Graduate:
    1. When Graduate is checked:
      1. When the associated "District IRN Override" field is NOT null:
        1. Reports the District IRN in the associated "District IRN Override" field.
      2. When the associated "District IRN Override" field is null:
        1. Reports the State District Number of the current district (System Admin > Resources > District Info > District Detail > State District Number)
    2. When Graduate is NOT checked:
      1. Reports null
  • SWD:
    1. When SWD is checked:
      1. When the associated "District IRN Override" field is NOT null:
        1. Reports the District IRN in the associated "District IRN Override" field.
      2. When the associated "District IRN Override" field is null:
        1. Reports the State District Number of the current district (System Admin > Resources > District Info > District Detail > State District Number)
    2. When SWD is NOT checked:
      1. Reports null
  • The calendar for the student's enrollment with the most recent Primary enrollment Start Date <= the FW record Effective Date is selected on the extract editor.
    1. When student has > 1 Primary enrollment with the same most recent Start Date, reports for the calendar tied to the enrollment with the most recent enrollment ID.

  • From the Follow Up Data (FW) tab records with an Effective Date on or between the extract editor Date Range:

    1. Find all FW tab records on and between the extract Effective Date

    2. Sort the FW tab records with the most recent Effective Date record in the first position and earliest FW tab record in the last position.

    3. From across all identified and sorted FW tab records, apply the following reporting logic to the fields on the tab from "CTE Program of Concentration" field down to "Other Follow-up Status" field, starting with the sorted topmost FW tab record, and working through all remaining tab records:

      1. Pull all results for each field from across the records and prioritize values in the same logic category by FW tab Effective Date:
        1. Field value hierarchy:
          1. When the field = Y, report Y
          2. When the field NOT = null or N, report the Code selected
          3. When the field = N, report N
          4. Otherwise, treat the field as null
    4. Example:

      1. The most recent FW tab record may have an N in one of the fields, but if that same field in an earlier FW tab record has a value = Y, the Y is the code reported since it's higher in the field value hierarchy.

R2The report can be run against a district’s active year as well as any prior year.
R3The report can be run in District Editions.
R4The report will be generated in fixed width and CSV formats as well as a human-readable format (HTML). The fixed width format is the State Format.

Generating the Extract

  1. Select the Exiting Student Follow Up (FW) Extract Type.
  2. Select the Reporting Period for which to generate the extract.
  3. Enter the Date Range in mmddyy format or by clicking the calendar icon. Follow Up Data records with an Effective Date within this date range report.
  4. Select the extract Format. For submission to the state, use the State Format (Fixed width) option. To review data before state submission, use any of the other available Format options.
  5. Select an Ad hoc Filter, if applicable, to limit data based on an existing Ad hoc filter. 
  6. Indicate if the extract should Include Protected Identity Info, which reports Demographic information from Census > People > Identities > Active Identity > Protected Identity Information.
  7. To report records from the selected calendars and no others, mark the Records only for selected calendars option. 
  8. Select the calendar(s) to include in the extract.
  9. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when to generate the report. Requests may only be submitted to the Batch Queue if generating multiple extracts at a time.

Users can submit an FW 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 Campus. See the Batch Queue article for more information about submitting a report to the batch queue.

Extract Layout

If the Include Protected Identity Info checkbox is marked in the extract editor, Demographic fields report from Census > People > Identities > Active Identity > Protected Identity Information.

Element Name

Description & Format

Campus Location

Filler

 8 characters

 

Sort Type

Always reports a value of FW.


2 characters

N/A

Filler

1 character

 

Fiscal Year

The Fiscal Year will be the end of the school year. The fiscal year is July 1-June 30. Report end year of reporting school year. Example, 2020 (CCYY)


YYYY, 4 characters

System Administration > Calendar > School Year > End Year


Not dynamically stored.

Data SetAlways reports as S.N/A
District IRNReport the State District Number. The state assigned six-digit information retrieval number (IRN) of the building.

  1. When (System Admin > Resources > School > School Detail > District IRN Override) NOT = null, reports the value entered into the District IRN Override field.
  2. When District IRN Override = null, reports entry in (System Admin > Resources > District Information > District Info > State District Number).

6 characters		System Administration > Resources > District Information > State District Number

District.number
SSID

Reports the student state ID. If null, field zero fills.


9 characters

Census > People > Demographics > Person Identifiers > Student State ID


Person.stateID


First Name

The student's legal first name.


30 characters

Census > People > Person Identifiers > First Name


Identity.firstName

Middle Name

The student's legal middle name


30 characters

Census > People > Person Identifiers > Middle Name


Identity.middleName

Last Name

The student's legal last name


30 characters

Census > People > Person Identifiers > Last Name


Identity.lastName

Career-Technical Education Workforce Development Follow-Up Flag
  • If CTE is true, report Y
  • If CTE is null, report N

1 character		Student Information > Program Participation > State Programs > Follow Up Data (FW) > CTE

FollowUpData.cte
Graduate Follow-Up Flag
  • If Grad is true, report Y
  • If Grad is null, report N

1 character		Student Information > Program Participation > State Programs > Follow Up Data (FW) > Graduate

FollowUpData.graduate
Students with Disabilities Post-School Engagement Follow-Up Flag
  • If SWD is true, report Y
  • If SWD is null, report N

1 character		Student Information > Program Participation > State Programs > Follow Up Data (FW) > SWD

FollowUpData.disability
Career and Technical Education Program of Concentration
  1. If field contains a value, report code.
  2. If CTE program of Concentration is null, report **


2 characters

Student Information > Program Participation > State Programs > Follow Up Data (FW) > CTE Program of Concentration


*If the CTE Program of Concentration dictionary requires updating, it must be updated in FollowUpData and CTEProgram


FollowUpData.cteConcentration
Career and Technical Follow Up LEA IRN

  1. If CTE is true and Follow Up Data > CTE IRN Override is not null, reports CTE IRN Override.

  2. If CTE is true and Follow Up Data > CTE IRN Override is null, reports the entry in System Admin > Resources > School > School Detail > District IRN Override when NOT = null for the school the student is enrolled.

    1. If District IRN Override = null, reports entry in (System Administration>Resources>District Information>District Info > State District Number)

  3. If CTE is null, does not report

The IRN of the district responsible for reporting CTE follow up information for this former student.


6 characters

Student Participation > State Programs > Follow Up Data > CTE IRN Override


System Admin > Resources > School > School Detail > District IRN Override


System Administration>Resources>District Information>District Info > State District Number


District.number
Graduate Follow Up LEA IRN

  1. If Graduate is true and Follow Up Data > Graduate IRN Override is not null, reports Graduate IRN Override.

  2. If Graduate is true and Follow Up Data > Graduate IRN Override is null, reports the entry in System Admin > Resources > School > School Detail > District IRN Override when NOT = null for the school the student is enrolled.

    1. If District IRN Override = null, reports entry in (System Administration>Resources>District Information>District Info > State District Number)

  3. If Graduate is null, does not report

6 characters

Student Participation > State Programs > Follow Up Data > Graduate IRN Override


System Admin > Resources > School > School Detail > District IRN Override


System Administration>Resources>District Information>District Info > State District Number


District.number

Students with Disabilities Follow Up LEA IRN

  1. If SWD is true and Follow Up Data > SWD IRN Override is not null, reports SWD IRN Override.

  2. If SWD is true and Follow Up Data > SWD IRN Override is null, reports the entry in System Admin > Resources > School > School Detail > District IRN Override when NOT = null for the school the student is enrolled.

    1. If District IRN Override = null, reports entry in (System Administration>Resources>District Information>District Info > State District Number)

  3. If SWD is null, does not report.

6 characters

Student Participation > State Programs > Follow Up Data > SWD IRN Override


System Admin > Resources > School > School Detail > District IRN Override


System Administration>Resources>District Information>District Info > State District Number


District.number

Employment Status

  1. If field contains a value, report the code.
  2. If code = 99, report *

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Status

FollowUpData.employmentStatus

Employment Career Field

  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Career Field

FollowUpData.employmentField
Employment Typical Hours Per Week
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Typical Hours per Week

FollowUpData.employmentHours
Employment Duration
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Duration

FollowUpData.employmentDuration
Employment Compensation Type
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Compensation Type

FollowUpData.employmentCompensation
Employment Setting
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Settings

FollowUpData.employmentSetting
Employment Advanced Opportunity
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Advanced Opportunity

FollowUpData.employmentAdvanced
Apprenticeship Status
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Apprenticeship Status

FollowUpData.apprenticeShip
Apprenticeship Type
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Apprenticeship Type

FollowUpData.apprenticeShipType
Post-Secondary Status
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary Status

FollowUpData.postSecondaryStatus
Post-Secondary Education Type
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary Education Type

FollowUpData.postSecondaryEducation
Post-Secondary and Advanced Training
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary and Advanced Training

FollowUpData.postSecondaryAdvanced
Post-Secondary Enrollment Duration
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary Enrollment Duration

FollowUpData.postSecondaryEnrollment
Military Enlistment Status
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Military Enlistment Status

FollowUpData.militaryEnlistment
Service Program Status
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Service Program Status

FollowUpData.serviceProgram
Other Follow-Up Status
  1. If field contains a value, report the code.
  2. If code = 99, report **

Student Information > Program Participation > State Programs > Follow Up Data (FW) > Other Follow-up Status

FollowUpData.otherFollowUp


Save

Save

Save

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com