S_OH_STU_GV_X (ver 19.1.0)
This table is an extension of the [STUDENTS] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Reported_SSID | 19.1.0 | VarChar(9) | Primary key that relates the extended table back to the Students table. |
| Attending_building_IRN | 19.1.0 | VarChar2(6) | Indicates the Attending_building_IRN imported from the (CTFL-001) CTE March Follow Up Extract (All Students) |
| Apprentice_Element | 19.1.0 | VarChar2(2) | The apprenticeship status of a CTE Concentrator in the second (2nd) quarter following the program year in which the student left secondary |
| CTE_Concentration_Code_1 | 19.1.0 | VarChar2(2) | The Program of Concentration Code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| CTE_Concentration_Code_2 | 19.1.0 | VarChar2(2) | The Program of Concentration Code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
CTE_Concentration_Code_3 | 19.1.0 | VarChar2(2) | The Program of Concentration Code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| CTE_Concentration_Code_4 | 19.1.0 | VarChar2(2) | The Program of Concentration Code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| CTE_Concentration_Code_5 | 19.1.0 | VarChar2(2) | The Program of Concentration Code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| CTE_Concentration_Flag_1 | 19.1.0 | VarChar2(1) | Indicates if a student is considered a concentrator in the corresponding CTE Program of Concentration Code. |
| CTE_Concentration_Flag_2 | 19.1.0 | VarChar2(1) | Indicates if a student is considered a concentrator in the corresponding CTE Program of Concentration Code. |
| CTE_Concentration_Flag_3 | 19.1.0 | VarChar2(1) | This indicates that the student is considered a concentrator in the corresponding CTE Program of Concentration Code. |
| CTE_Concentration_Flag_4 | 19.1.0 | VarChar2(1) | This indicates that the student is considered a concentrator in the corresponding CTE Program of Concentration Code. |
| CTE_Concentration_Flag_5 | 19.1.0 | VarChar2(1) | This indicates that the student is considered a concentrator in the corresponding CTE Program of Concentration Code. |
| CTSO_Participation | 19.1.0 | VarChar2(2) | Indicates student participation level in Career-Technical Student Organization (CTSO) programs related to the student’s |
| Diploma_Received_Date | 19.1.0 | Date | Indicates the Diploma Received Date imported from the (CTFL-001) CTE March Follow Up Extract (All Students) if any. |
| Diploma_Reported | 19.1.0 | VarChar2(2) | Indicates the Diploma Reported imported from the (CTFL-001) CTE March Follow Up Extract (All Students) if any. Obsolete as of FY21. |
Diploma_Type | 19.1.0 | VarChar2(1) | Indicates the Diploma Type imported from the (CTFL-001) CTE March Follow Up Extract (All Students) if any. |
| Employment_Placement | 19.1.0 | VarChar2(2) | The employment status of a CTE Concentrator in the second (2nd) quarter following the program year in which the student left secondary |
| Fiscal_Year | 19.1.0 | Number(4,0) | The four-digit fiscal year entered on the GV Import Page indicating which to which reporting fiscal year the record relates. |
| FY_CTE_Concentration_1 | 19.1.0 | Number(4,0) | The fiscal year the corresponding CTE Program of Concentration was reported. |
| FY_CTE_Concentration_2 | 19.1.0 | Number(4,0) | The fiscal year the corresponding CTE Program of Concentration was reported. |
| FY_CTE_Concentration_3 | 19.1.0 | Number(4,0) | The fiscal year the corresponding CTE Program of Concentration was reported. |
| FY_CTE_Concentration_4 | 19.1.0 | Number(4,0) | The fiscal year the corresponding CTE Program of Concentration was reported. |
| FY_CTE_Concentration_5 | 19.1.0 | Number(4,0) | The fiscal year the corresponding CTE Program of Concentration was reported. |
| How_Received_Code | 19.1.0 | VarChar2(1) | Indicates the How Received Code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| How_Received_IRN | 19.1.0 | VarChar2(6) | Indicates the How Received IRN imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| ImportID | 19.1.0 | Number(3,0) | Assigned to each record imported from a single file. Used to remove an import, if required. |
| Legal_DOR_IRN | 19.1.0 | VarChar2(6) | Indicates the Legal District of Residence IRN imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Military_Placement | 19.1.0 | VarChar2(2) | The military status of a CTE Concentrator in the second (2nd) quarter following the program year in which the student left secondary education. |
| Other_Follow_Up_Status | 19.1.0 | VarChar2(1) | Status not reported in any of the other CTE Concentrator follow-up status elements. |
| Post_Secondary_Advanced | 19.1.0 | VarChar2(2) | The post-secondary and/or advanced education status of a CTE Concentrator in the second (2nd) quarter following the program year in which the student left secondary education. |
Reported_DOB | 19.1.0 | Date | The student's date of birth imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Reported_Student_Name | 19.1.0 | VarChar2(42) | The student's first and last name imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Reported_Withdrawal_Date | 19.1.0 | Date | The student's withdrawal date imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Reported_Withdrawal_Reason | 19.1.0 | VarChar2(2) | The withdrawal reason imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Service_Prog_Placement | 19.1.0 | VarChar2(2) | The service program status of a CTE Concentrator in the second (2nd) quarter following the program year in which the student left secondary education. |
| Student_Standing_Key | 19.1.0 | VarChar2(10) | The Student Standing Key imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Tech_Prep | 19.1.0 | VarChar2(1) | The Tech Prep code imported from the (CTFL-001) CTE March Follow Up Extract (All Students). |
| Work_Based_Learning_Hrs | 19.1.0 | Number(4,0) | The number of work-based learning hours related to the CTE Program of Concentration that the student accumulated during secondary education. |