Student Enrollment and Attendance File Layout
Field # | Field Name | Data Type | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPLUS? |
---|---|---|---|---|---|---|
5 | Collection Version | Text | 50 | Collection version should contain this value '2010Feb1.0StuGradFllw' for the 2010 Student Graduate Follow-up February Cycle File Layout. | ||
10 | Current School Year | Integer | 4 | The ending year of the current school year. For example, use '2007' for the 2006-2007 school year. | ||
15 | Attending District Code | Text | 6 | reg.attending district field using state code equiv | reg_district | Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Attending District or Program where the state code equiv = 'ATTENDDIST' If field is blank, Reporting District Code will default. |
20 | Attending School Code | Text | 4 | reg.alternate accountability building field using state code equiv | reg_buildings | Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Alternate Building or Program where the state code equiv = ‘ATTENDBLDG’ If field is blank, Reporting District School will default. |
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 | Resident District Code | Text | 6 | reg.state_res_building left most 6 characters | reg_district | Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: District of Residence or Program where the state code equiv = ‘RESDIST’ If field is blank, Reporting District Code will default or if the Resident School Code is not blank, its district section will be used. |
40 | Resident School Code | Text | 4 | reg.state_res_building last 4 characters | regtb_state_bldg | Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: State Building of Residence or Program where the state code equiv = ‘RESBLDG’ The value’s building section will be used. If field is blank, Reporting District School will default. |
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 | Student Grade Level | Text | 2 | reg_district.district converted to state code, Get 3 chars from left | reg_grade | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Grade |
90 | Residency Status | Text | 2 | reg_entry_with.grade converted to state code | regtb_residency | Registration > Entry & Reports > Student Demographic > Personal > General panel: Residency or Program where the state code equiv = ‘RESIDENCY’ |
95 | Regular Hrs Attended | Number | 9 | Calculated | Attendance > All > Student > Day Totals > Day Totals panel: Present Minutes for the View Type you chose as the Regular Attendance View Type when you ran MOSIS Download | |
100 | Regular Hrs Absent | Number | 9 | Calculated | Attendance > All > Student > Day Totals > Day Totals panel: Absent Minutes for the View Type you chose as the Regular Attendance View Type when you ran MOSIS Download The total hours a student was absent for the time period this record using Regular Attendance View Type. | |
105 | Remedial Hrs Attended | Number | 9 | Calculated | Attendance > All > Student > Day Totals > Day Totals panel: Present Minutes for the View Type you chose as the Remedial Attendance View Type when you ran MOSIS Download The total hours a student attended (present) for the time period this record using Remedial Attendance View Type. | |
110 | Hours in Session | Number | 9 | Calculated | Administration > Registration Setup > Building District Defined > MOSIS Building: Hours in Session For students who have a Residency Code of ‘R2’. This is reported by the student’s resident building and shows the number of hours for the student in the attending building. | |
115 | Summer Attendance | Number | 9 | Calculated | Attendance > All > Student > Day Totals > Day Totals panel: Present Minutes for the View Type you chose as the Summer School Attendance View Type when you ran MOSIS Download The total hours a student attended (present) for the time period this record using Summer School Attendance View Type. | |
120 | Summer Membership | Number | 9 | Calculated | For the Summer School Attendance View Type, get the sum of Present Minutes and Absent Minutes from Attendance > All > Student > Day Totals > Day Totals panel The total hours a student membership (present + absent) for the time period this record using Summer School Attendance View Type. | |
125 | Entry Date | Date | 10 | reg_entry_with.entry_date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Entry Date | |
130 | Entry Code | Text | 4 | reg_entry_with.entry_code | regtb_entry | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Entry Code |
135 | Exit Date | Date | 10 | reg_entry_with.withdrawal_date | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Withdrawal Date | |
140 | Exit Code | Text | 4 | reg_entry_with.withdrawal_code | regtb_withdrawal | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Withdrawal Code |
145 | Exit Destination District Code | Text | 6 | The District Code is the first 6 characters of the Exit Destination School Code. | ||
150 | Exit Destination School Code | Text | 4 | regtb_state_bldgs | Registration > Entry & Reports > Student District Defined > MOSIS Demographics: Exit Destination or Program where the state code equiv = ‘EXITDES’ The School Code is the last 4 characters of the Exit Destination School Code. | |
155 | Exit Destination Comment | Text | 150 | Registration > Entry & Reports > Student District Defined > MOSIS Demographics: Exit Destination Comment or Program where the state code equiv = ‘EXITCOMM’ Align the start date of this program after the entry date of entry withdrawal record. | ||
156 | School Choice | Text | 1 | motb_school_choice | Registration > Entry & Reports > Student District Defined > MOSIS Demographics: School Choice or Program where the state code equiv = ‘CHOICE’ | |
157 | Extended School Hours | Number | 9 | Calculated | Attendance > All > Student > Day Totals > Day Totals panel: Present Minutes for the View Type you chose as the Extended School Attendance View Type when you ran MOSIS Download The total hours a student attended (present) for the time period used for creating this record based on the Extended School Attendance View Type. For details on setup needed to calculate this field, refer to August Cycle – Extended School Students Prerequisites and Processing. This field only applies for the August Cycle. |