S_OH_STU_FW_X ver 1.0
This table is an extension of the [STUDENTS] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
Fiscal_Year | 1.0 | Number(4,0) | The four-digit fiscal year imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Reporting_District_IRN | 1.0 | VarChar2(6) | Indicates the Reporting District IRN imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
SSID | 1.0 | VarChar2(9) | Primary key that relates the extended table back to the Students table imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students).. |
First_Name | 1.0 | VarChar2(30) | The student's first name imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Middle_Name | 1.0 | VarChar2(30) | The student's middle name imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Last_Name | 1.0 | VarChar2(30) | The student's last name imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
CTE_Flag | 1.0 | VarChar2(1) | The Career Technical Education Workforce Development Follow-Up Flag imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Graduate_Flag | 1.0 | VarChar2(1) | The Graduate Follow-Up Flag imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
SWD_Flag | 1.0 | VarChar2(1) | The Students with Disabilities Post-School Engagement Follow-Up Flag imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
CTE_Program | 1.0 | VarChar2(2) | The Career-Technical Education Program of Concentration imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
CTE_LEA_IRN | 1.0 | VarChar2(6) | Indicates the Career-Technical Follow-Up LEA IRN imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Graduate_LEA_IRN | 1.0 | VarChar2(6) | Indicates the Graduate Follow-Up LEA IRN imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
SWD_LEA_IRN | 1.0 | VarChar2(6) | Indicates the Students with Disabilities Follow-Up LEA IRN imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Employment_Status | 1.0 | VarChar2(1) | The employment status of this former student in the year after the student left secondary education. |
Employment_Career_Field | 1.0 | VarChar2(2) | The career field in which this former student is working. |
Employment_Hours_Week | 1.0 | VarChar2(2) | The typical number of hours this former student works in a week. |
Employment_Duration | 1.0 | VarChar2(1) | Indicates if this former student has worked at least 90 days since leaving school. |
Employment_Comp_Type | 1.0 | VarChar2(1) | This former student performed work that was compensated at a rate that meets the requirements for competitive integrated employment. |
Employment_Setting | 1.0 | VarChar2(1) | This former student performed work at a location that meets the requirements for competitive integrated employment. |
Employment_Advancement | 1.0 | VarChar2(1) | This former student performed work that provides advancement opportunities that meet the requirements for competitive integrated employment. |
Apprentice_Status | 1.0 | VarChar2(1) | The apprenticeship status of this former student in the year after the student left secondary education. |
Apprentice_Type | 1.0 | VarChar2(1) | The type of apprenticeship status in which this former student is enrolled. |
Postsecondary_Edu_Status | 1.0 | VarChar2(1) | The postsecondary or advanced training status of the former student in the year after the student left secondary education. |
Postsecondary_Edu_Type | 1.0 | VarChar2(2) | The type of postsecondary education or advanced training in which this former student has enrolled. |
Postsecondary_Adv_Training | 1.0 | VarChar2(1) | Indicates that this former student has enrolled in multiple options in the year after leaving school. |
Postsecondary_Duration | 1.0 | VarChar2(1) | The postsecondary enrollment term completion status for this former student. |
Military_Status | 1.0 | VarChar2(1) | The military status of this former student in the year after the student left secondary education. |
Service_Program_Status | 1.0 | VarChar2(1) | The service program status of this former student in the year after the student left secondary education. |
Other_Status | 1.0 | VarChar2(1) | Status not reported in any of the other follow-up status elements. |
Exclude_From_FW | 1.0 | Boolean | Flag to determine whether the student should be excluded from the FW report. |
Active_Flag | 1.0 | VarChar2(1) | Flag to determine whether the student is active imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
EMISID | 1.0 | VarChar2(9) | The students EMIS ID imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
Building_IRN | 1.0 | VarChar2(6) | Indicates the last reported building attended IRN imported from the (FLUP-001) Exiting Student Follow Up Extract (All Students). |
ImportID | 1.0 | Number(3,0) | Assigned to each record imported from a single file. Used to remove an import, if required. |