Teacher Course Assignment File
| Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPLUS? | Notes |
|---|---|---|---|---|---|---|---|
| 1 | District | reg_district | O | ||||
| 2 | School Year | Prompted School Year in theTeacher Course Assignment page | M | 15 | regtb_school_year | School year cannot be less than 2011. | |
| 3 | Building | schd_ms building where the course is being taught | M | 15 | |||
| 4 | Submission type | Update as ‘STAFCOURSE’ | Required for summary/search | ||||
| 5 | Reporting Date | Start date from prompt | M | 10 | Use this date to extract the information. | ||
| 6 | IEIN | reg_staff. staff_state_ID | M | ||||
| 7 | Local Teacher ID | reg_staff. staff_ID | M | 50 | |||
| 8 | Teacher Last Name | reg_staff.last_name | M | 30 | |||
| 9 | Teacher First Name | reg_staff.first_name | M | 30 | |||
| 10 | Teacher birthdate | reg_staff.birthdate | M | 10 | |||
| 11 | Teacher Serving RCDTS | Serving RCDTS is the state code equivalent of the building for reg_building.state_code_equiv | M | 15 | |||
| 12 | Employer RCDTS | reg_district.state_code_equiv | M | 4 | |||
| 13 | Term | reg_mp_weeks.state_code_equiv table and override is at district level.reg_user_district; screen_number = 515; field_number = 1 | M | 2 | The state code equivalent for the marking period setup. Data will be extracted based on reporting period dates and marking period dates. | ||
| 14 | State Course Code | Data is extracted from mr_crsequ_det.state_code _equiv for the course_id that is being processed. | M | 9 | For example: 02002A005 Only courses that have the state course should be extracted for reporting. | ||
| 15 | Local Course ID | schd_ms.course | O | 50 | For example: 52102A005 Use the Master schedule Course information for the school year being processed. Match with the course id extracted for student course assignment. | ||
| 16 | Local Course Title | schd_ms.description for the course_id being processed. | O | 100 | Use the description from Master schedule for the course being processed. Match with the course description extracted for student course assignment. For example: Engineering and design drafting | ||
| 17 | Section Number | Concatenate local_course_id and course_section for the course /section_key being processed. | M | 10 | If local course = ‘1001’ and course_section = 2 , then the section number will be 10012. If local course is 10 chars long then Trim it to/ restrict it to 8 characters and include complete detail for the course section. For Example: if course is ‘1000000021’and Course section is 5. Trim and submit it as 1000000005 for section number. | ||
| 18 | Teacher course Start Date | Data is extracted from schd_ms_staff_date.start_date for staff_id and for the section key being processed. | M | 10 | The date format is mm/dd/yyyy. When extracting the data from schd_ms_staff_date, make sure that the dates are within the prompted start - end date. If no data is available, then check for calculated field that uses: Prompt dates in reg_mp_dates and Marking period information in schd_ms_mp This helps you check when the course meets and you can arrive at the start date for the course. | ||
| 19 | Role of Professional | District-defined field at staff level.Data is extracted from schd_ms_staff_user.field_number = 1 for the staff_id and section_key being processed. If no value is defined in the table specified above, then check in reg_user_staff screen_number =700, field_number = 1.If data does not exist at both these locations, then default to code 01. | M | 2 | Override the data at Master Schedule Course Staff level if value exists. If no value exists, then check staff district-defined. If value is not available in either of these locations, then default to code 01. | ||
| 20 | Teacher Commitment | District-defined fieldData is extracted from schd_ms_staff_user.field_number = 3 for the staff_id and section_key being processed. If no value is defined in the table specified above, then check in reg_user_staff screen_number =700, field_number = 3.If data does not exist at both these locations, then default to 1.00 | M | 2 | Override the data at Master Schedule Course Staff level if value exists. If no value exists, then check staff district-defined. If value is not available in either of these locations, then default to code 1.00 | ||
| 21 | Actual Attendance (class) | Blank | O | ||||
| 22 | Total Attendance (class) | Blank | O | ||||
| 23 | Teacher Course end date | Data is extracted from schd_ms_staff_date.start_date for staff_id and for the section key being processed. | M | 10 | The date format is mm/dd/yyyy. When extracting the data from schd_ms_staff_date, make sure that the dates are within the prompted start - end date. If no data is available, then check for calculated field that uses: Prompt dates in reg_mp_dates and Marking period information in schd_ms_mp This helps you check when the course meets and you can arrive at the start date for the course. | ||
| 24 | Reason for Exit | District-defined fieldData is extracted from schd_ms_staff_user.field_number = 2 for the staff_id and section_key being processed. If no value is defined in the table specified above, then check in reg_user_staff screen_number =700, field_number = 2.If data does not exist in both of these locations, then default to code 01. | M | Override the data at Master Schedule Course Staff level if value exists. If no value exists, then check staff district-defined. If value is not available in either of these locations, then default to code 01 |