Student Assignment Layout
| Field # | Field Name | Data Type | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPLUS? |
|---|---|---|---|---|---|---|
| 5 | Collection Version | Text | 50 | calculated | Value is '2010Oct1.0StuAssign' for the 2010 Student/Assignment October 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. | ||
| 25 | Reporting District Code | Text | 6 | reg_district.district converted to state code equiv | Administration > General Setup > District > District > Preferences panel > Other panel: State Code Equivalent | |
| 30 | Reporting School Code | Text | 4 | schd_ms.building converted to state code | reg_building | Scheduling > Student Schedules > Student > Schedule Entry: Building |
| 45 | MOSIS ID | Text | 10 | reg_personal.state_report_id | Registration > Entry & Reports > Student Demographic > Personal > General panel: State Reporting ID | |
| 55 | Student Local Student ID | Text | 20 | reg.student_id | Student ID | |
| 60 | Student Legal Last Name | Text | 60 | reg.last_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name | |
| 65 | Student Legal First Name | Text | 60 | reg.first_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name | |
| 70 | Student Legal Middle Name | Text | 60 | reg.middle_name | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Middle Name | |
| 75 | Student Legal Name Suffix | Text | 10 | reg.generation | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Generation | |
| 80 | Student Date of Birth | Text | 10 | reg.birthdate | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date | |
| 95 | Student Grade Level | Text | 2 | reg_entry_with.grade converted to state code equiv | reg_grade | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > Regular School Year panel: Grade |
| 100 | Student Gender | Text | 1 | reg.gender | M or F | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Gender |
| 105 | Race/Ethnicity | Text | 1 | Pre-defined Race / Ethnic 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. |
| 110 | Assignment Number | Integer | 20 | schd_ms.section_key | Section Key for the course-section Cannot be seen through eSchoolPLUS, this is a unique key for course-sections. | |
| 120 | Dual Credit Site | Text | 4 | schd_stu_user.field_value where screen_number='550' and field_number='3' | motb_dual_site | Scheduling > Student Schedules > Student > Schedule Entry > click course to display detail > expand Other Student Course Information > click link for MOSIS Course Information: Dual Credit Site |
| 125 | Receiving Coll/Dist Code | Text | 6 | schd_stu_user.field_value where screen_number='550' and field_number='1' | motb_dese_college | Scheduling > Student Schedules > Student > Schedule Entry > click course to display detail > expand Other Student Course Information > click link for MOSIS Course Information: Receiving College/District |
| 130 | Sending District Code | Text | 6 | schd_stu_user.field_value where screen_number='550' and field_number='2', left 6 digits | regtb_state_bldg | Scheduling > Student Schedules > Student > Schedule Entry > click course to display detail > expand Other Student Course Information > click link for MOSIS Course Information: Sending District School Code first 6 characters |
| 140 | Sending School Code | Text | 4 | schd_stu_user.field_value where screen_number='550' and field_number='2', right 4 digits | regtb_state_bldg | Scheduling > Student Schedules > Student > Schedule Entry > click course to display detail > expand Other Student Course Information > click link for MOSIS Course Information: Sending District School Code last 4 characters |
| 150 | ED SSN | Text | 9 | reg_staff.ssn | Get the course staff member from Scheduling > Courses > Course Sections > Master Schedule > Session Information panel > Staff and Room Information panel: Primary Staff or Secondary Staff link Get the reported staff member's Social Security Number from Scheduling > Courses > Resources > Staff > Staff Information panel: Social Security Number | |
| 160 | Position Code | Text | 2 | reg_user_staff.field_value where screen_number='550' and field_number = '1' and screen_number 550. Converted to state_code_equiv using motb_position | motb_position | Scheduling > Courses > Resources > Staff > District-Defined panel > MOSIS Staff: Position Code Only non teachers need a value. Defaults to Teacher Code if blank. |
| 170 | CTE Program Type | Text | 1 | schd_ms_user.field_value where screen_number=’550’ and field_number=’1’ | motb_cte_program | Scheduling > Courses > Course Sections > MOSIS Course Information: CTE Program Type |
| 180 | Disadvantaged | Boolean | 1 | reg_programs_column.state_code_equiv = 'DISADVANT' , If you donot get value then use reg_personal.ACADEMIC_DIS . Converted to statecode using regtb_academic_dis | Registration > Entry & Reports > Student Demographic > Personal > Educational Factors panel: Academically Disadvantaged (program where the state code equiv = ‘DISADVANT’) | |
| 270 | IEP Disability (Primary) | Text | 2 | reg_programs.program_value where program_id and field_number maps to reg_program_column.state_code_equiv='IEPDISAB' | motb_disability | Registration > Entry & Reports > Student District Defined > MOSIS Special Ed: IEP Disability (program where the state code equiv = ‘IEPDISAB’) |
| 280 | Adult | Boolean | 1 | N is reported | ||
| 282 | Local Course Number | Text | 12 | schd_ms.course | Scheduling > Courses > Course Sections > Master Schedule > Course panel: Course | |
| 284 | Local Course Name | Text | 60 | schd_ms.description | Scheduling > Courses > Course Sections > Master Schedule > Course-Section panel > General Information panel: Description | |
| 286 | Local Section Number | Text | 6 | schd_ms.course_section | Scheduling > Courses > Course Sections > Master Schedule > Course panel: Section | |
| 288 | State Course Number | Text | 6 | schd_course_user or schd_ms_user.field_value where screen_number=’550’ and field_number=’2’ Converted to state code using motb_state_course | motb_state_course | Scheduling > Courses > Course Sections > MOSIS Course Information: State Course Number |