Path: OH State Reporting > OH Extracts > Exiting Student Follow Up (FW)
The Exiting Student Follow Up (FW) extract reports data from records on the Follow Up Data (FW) tab.
The FW extract editor.
Report Logic
A record reports for each student who has an Follow Up Data record with an Effective Date that falls during the extract Date Range. If a student has more than one record, data reports from the record with the most recent effective date. Records marked as State Data do not report.
Generating the Extract
- Select the Exiting Student Follow Up (FW) Extract Type.
- Select the Reporting Period for which the extract is being generated.
- Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date. Follow Up Data records with an Effective Date within this date range are reported.
- 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.
- Select an Ad hoc Filter, if applicable, to limit data based on an existing Ad hoc filter.
- Indicate if the extract should Include Protected Identity Info, which reports Demographics information from Census > People > Identities > Active Identity > Protected Identity Information.
- Select which calendar(s) to include within the extract.
- 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, requests can 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 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.
Extract Layout
If the Include Protected Identity Info checkbox is marked in the extract editor, Demographics 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 Set | Always reports as S. | N/A |
| District IRN | The state-assigned 6-digit identification number of the district. 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 | Reports 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 Flag | Reports 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 Flag | Reports 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 Concentration | Reports 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 | If CTE is marked on the Follow Up record, reports the State Disctrict Number (IRN) 6 characters | System Administration > Resources > District Information > State District Number District.number |
| Graduate Follow Up LEA IRN | If Graduate is marked on the Follow Up record, reports the State Disctrict Number (IRN) 6 characters | System Administration > Resources > District Information > State District Number District.number |
Students with Disabilities Follow Up LEA IRN | If SWD is marked on the Follow Up record, reports the State Disctrict Number (IRN) 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 Week | Reports 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 Duration | Reports 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 Type | Reports 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 Setting | Reports 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 Opportunity | Reports 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 Status | Reports the Apprenticeship Status code selected, or as * if 99. | Student Information > Program Participation > State Programs > Follow Up Data (FW) > Apprenticeship Status FollowUpData.apprenticeShip |
| Apprenticeship Type | Reports 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 Status | Reports 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 Type | Reports 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 Training | Reports 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 Duration | Reports 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 Status | Reports 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 Status | Reports 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 Status | Reports 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 |
