Student Graduate Follow-Up File Layout
Field # | Field Name | Data Type | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPLUS? |
---|---|---|---|---|---|---|
5 | Collection Version | Text | 50 | calculated | ||
10 | Current School Year | Integer | 4 | |||
25 | Reporting District Code | Text | 6 | reg_district.district converted to state code | Administration > General Setup > District > District > Preferences panel > Other panel: State Code Equivalent | |
30 | Reporting School Code | Text | 4 | reg_entry_with.building converted to state code | reg_buildings | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Building |
35 | CTE Attending District Code | Text | 6 | registration user defined screen CTE Mosis - screen number 552, field number - 9 | motb_dese_district | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: CTE Attending School field—first 6 characters |
40 | CTE Attending School Code | Text | 4 | registration user defined screen CTE Mosis - screen number 552, field number - 4 | reg_buildings or regtb_state_bldg for the program | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: CTE Attending School field—last 4 characters |
45 | MOSIS Student ID | Text | 10 | reg_personal.state_report_id | Registration > Entry & Reports > Student Demographic > Personal > General panel: State Reporting ID | |
50 | Local Student ID | Text | 20 | reg_entry_with.student_id | Student ID | |
55 | Legal Last Name | Text | 60 | reg.last_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name | |
60 | Legal First Name | Text | 60 | reg.first_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name | |
65 | Legal Middle Name | Text | 60 | reg.middle_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Middle Name | |
70 | Legal Name Suffix | Text | 10 | reg.generation | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Generation | |
75 | Date of Birth | Text | 10 | reg.birthdate | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date | |
80 | Social Security Number | Text | 11 | reg_persona.ssn | Registration > Entry & Reports > Student Demographic > Personal > General panel: Social Security Number | |
85 | Gender | Text | 1 | reg.gender | M or F | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Gender |
90 | Race/Ethnicity | Text | 1 | if reg_personal.hispanic = "Y" then report "H" else reg_personal.ethnic_code converted to state code | regtb_ethnicity | Registration > Entry & Reports > Student Demographic > Personal > Federal panel: Hispanic/Latino Ethnicity or Race field If a student is marked Y in the Hispanic/Latino Ethnicity field, an H will be sent in this field. If a student is not Hispanic and has one Race, then the state equiv code of the Primary Race will be sent. If a student is not Hispanic and has multiple races, an M is sent. |
95 | Perkins Concentrator | Boolean | 1 | registration user defined screen CTE Mosis - screen number 552, field number - 7 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Perkins Concentrator | |
100 | IEP/Disabled | Boolean | 1 | reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='IEPDISAB' | Registration > Entry & Reports > Student District Defined > MOSIS Special Ed: IEP Disability (program where the state code equiv = ‘IEPDISAB’) | |
105 | Disadvantaged | Boolean | 1 | reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='DISADVANT' Converted to state code using regtb_academic_dis | Registration > Entry & Reports > Student Demographic > Personal > Educational Factors panel: Academically Disadvantaged (program where the state code equiv = ‘DISADVANT’) | |
110 | Nontraditional Student | Boolean | 1 | registration user defined screen CTE Mosis - screen number 552, field number - 8 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Nontraditional | |
115 | Single Parent | Boolean | 1 | registration user defined screen CTE Mosis - screen number 552, field number - 9 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Single Parent | |
120 | Displaced Homemaker | Boolean | 1 | registration user defined screen CTE Mosis - screen number 552, field number - 10 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Displaced Homemaker | |
125 | Other Barriers | Boolean | 1 | registration user defined screen CTE Mosis - screen number 552, field number - 11 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Other Barriers | |
130 | LEP / ELL | Text | 3 | reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='LEP/ELL' If student has CTE Flag value as Y and if this field is blank then default this field to NLP. Else convert program_value to state code using motb_lep_code table. | motb_lep_code | Registration > Entry & Reports > Student District Defined > MOSIS LEP/ELL: LEP/ELL If a student does not have a value in the LEP/ELL field or the LEPELL program and is in a CTE Program, then the value will be defaulted to NLP. |
135 | Follow-Up Status | Text | 3 | registration user defined screen CTE Mosis - screen number 552, field number - 14. Convert it to state code equiv using motb_followup. | motb_followup | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Graduate Follow-up Status |
140 | CTE Placement Relation | Text | 2 | registration user defined screen CTE Mosis - screen number 552, field number - 12. converted to state code using motb_cte_placement | motb_placement | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: CTE Placement Relation |
145 | CIP Code | Text | 6 | Get the value from motb_state_course.cip_code, IF null then use Course user defined screen Mosis Course - screen number 550, field number - 12. Get the most recent value | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Primary CIP Code | |
150 | CTE Program Code | Text | 4 | Course user defined screen Mosis Course - screen number 550, field number - 1. Get the most recent value. | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Primary CTE Program | |
155 | Placement Zip Code | Integer | 5 | registration user defined screen CTE Mosis - screen number 552, field number - 13 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: Placement Zip Code | |
160 | Educator SSN | Text | 9 | reg_staff.ssn Not included in file | Not included in file | |
162 | SPED Follow-up Definition Met | Text | 1 | registration user defined screen MOSIS Demographics - screen number 551, field number - 16. | Registration > Entry & Reports > Student District Defined > MOSIS Demographics: SPED FollowUp Definition Met | |
165 | NSC Comment | Text | 256 | Registration > Entry & Reports > Student District Defined > MOSIS CTE/Graduate Followup: NSC Discrepancy |