Exiting Student Follow Up (FW) (Ohio Extracts)

Last Modified on 04/10/2024 12:57 pm CDT

Tool Search: OH Extracts

The Exiting Student Follow Up (FW) extract reports data from records on the Follow Up Data (FW) tab. 

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

Report Logic

  1. A record reports for each student with a Follow Up Data record with an Effective Date that falls on, or between, the extract 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
  2. Records marked as State Data do NOT report.
  3. If CTE, Grad, and SWD all = false on the FW record, do NOT report.

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 prior to 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 Demographics information from Census > People > Identities > Active Identity > Protected Identity Information.
  7. Select the calendar(s) to include in the extract.
  8. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when to generate the report. If generating multiple extracts at a time, requests may only be submitted to the Batch Queue.

Users have the option of submitting a FW report request to the batch queue by clicking Submit to Batch instead of Generate Extract. 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

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 is considered the end of the year of the school year (i.e. 2022 for the 2021- 2022 school year).


YYYY, 4 characters

System Administration > Calendar > School Year > End Year


Not dynamically stored.

Data SetAlways reports as S.N/A
District IRNThe state-assigned 6-digit identification number of the district.

  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 FlagReports as Y if CTE is marked, otherwise N.

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

FollowUpData.cte
Graduate Follow-Up FlagReports as Y if Graduate is marked, otherwise N.

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

FollowUpData.graduate
Students with Disabilities Post-School Engagement Follow-Up FlagReports as Y if SWD is marked, otherwise N.

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

FollowUpData.disability
Career and Technical Education Program of ConcentrationReports the Program of Concentration from the student's FW record. If null, reports as **.

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

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

6 characters		System Administration > Resources > District Information > State District Number
System Admin > Resources > District Info > District Detail > 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		System Administration > Resources > District Information > 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		System Administration > Resources > District Information > State District Number

District.number

Employment Status

Reports the Employment Status code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Status

FollowUpData.employmentStatus

Employment Career Field

Reports the Employment Career Field code selected, or as ** if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Career Field

FollowUpData.employmentField
Employment Typical Hours Per WeekReports the Employment Typical Hours per Week code selected, or as ** if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Typical Hours per Week

FollowUpData.employmentHours
Employment DurationReports the Employment Duration code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Duration

FollowUpData.employmentDuration
Employment Compensation TypeReports the Employment Compensation Type code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Compensation Type

FollowUpData.employmentCompensation
Employment SettingReports the Employment Settings code  selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Settings

FollowUpData.employmentSetting
Employment Advanced OpportunityReports the Employment Advanced Opportunity code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Employment Advanced Opportunity

FollowUpData.employmentAdvanced
Apprenticeship StatusReports the Apprenticeship Status code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Apprenticeship Status

FollowUpData.apprenticeShip
Apprenticeship TypeReports the Apprenticeship Type code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Apprenticeship Type

FollowUpData.apprenticeShipType
Post-Secondary StatusReports the Post-Secondary Status code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary Status

FollowUpData.postSecondaryStatus
Post-Secondary Education TypeReports the Post-Secondary Education Type code selected, or as ** if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary Education Type

FollowUpData.postSecondaryEducation
Post-Secondary and Advanced TrainingReports the Post-Secondary and Advanced Training code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary and Advanced Training

FollowUpData.postSecondaryAdvanced
Post-Secondary Enrollment DurationReports the Post-Secondary Enrollment Duration code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Post-Secondary Enrollment Duration

FollowUpData.postSecondaryEnrollment
Military Enlistment StatusReports the Military Enlistment Status code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Military Enlistment Status

FollowUpData.militaryEnlistment
Service Program StatusReports the Service Program Status code selected, or as * if 99.Student Information > Program Participation > State Programs > Follow Up Data (FW) > Service Program Status

FollowUpData.serviceProgram
Other Follow-Up StatusReports the Other Follow-up Status code selected, or as * if 99.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