Tool Search: Teacher Course Assignment
The Teacher Course Assignment Errors and Warnings Report provides a list of all course sections scheduled where a teacher has a state role assigned but there are no students scheduled into the course section.
Errors and Warnings Report Editor
Report Logic
Teachers must have a value between 200-699 in the State Role field on the Section Staff History tab.
Teachers must also have a start date on the Staff History tab that is either NULL or within or before the dates entered on the extract editor. End dates (on the Staff History tab) must also be NULL or be within or after the dates entered on the extract editor.
Courses marked as State Exclude or are not active are NOT included.
The Course section cannot have any students actively scheduled in it within the dates entered on the extract editor.
Report Editor
Field | Description |
|---|---|
Report Type | Determines which Teacher Assignment report will generate. For this instance, select Teacher Course Assignment Errors and Warnings. |
| File Identifier | A numeric field that notes the number of times the report has been generated. This field is used in the File Naming Convention when submitting the extract in the State Format (RCDTS or District Name + __ + MMDDYYY_File Identifier). |
Date Range (Start Date and End Date) | Starting Date and Ending Date from which teaching data is pulled. Dates are entered in mmddyy format or use the calendar icon to select a date. |
| Strip Apostrophes | When marked, the following marks are removed from student names and other reported data:
When not marked, these marks are not removed. |
| Report Protected Identities | When marked, identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
Format | Selection determines how the report will generate. Options are State Format (Comma Delimited), HTML and Tab Delimited. Use the HTML format or the Tab Delimited format for data review prior to sending to the state. |
| Ad hoc Filter | Select which students to include in the extract by choosing a filter that was created in the Filter Designer. When a filter is selected, only those students included in the filter are included in the report. This is optional. Students can also be selected by grade level. Or choose both a grade level and an ad hoc filter. |
Calendar Selection | Selection indicates from which school year and school teacher data is pulled. Multiple calendars may be selected. The calendar chosen in the Campus toolbar is automatically selected in the extract editor. |
Report Generation | The report can be marked to generate immediately using the Generate Report button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue information for additional guidance. |
Generate the Report
- Select Teacher Course Assignment Errors and Warnings as the Report Type.
- Enter the File Identifier value.
- Enter the Start Date for the report.
- Enter the End Date for the Report.
- If desired, mark the Strip Apostrophes checkbox.
- If desired, mark the Report Protected Identities checkbox.
- Select the Format in which the report should be generated.
- If desired, select an Ad hoc Filter.
- Select the Calendar(s) from which to pull data.
- Click the Generate Report button to display the information immediately or click the Submit to Batch button to display the report at a later time.
Errors and Warning Report, State Format (Comma Delimited)
Errors and Warnings, HTML Format
Errors and Warnings Reports, Tab Delimited Format
Errors and Warnings Report Layout
Element | Description | Campus Application |
|---|---|---|
| Report Header | ||
Report Name | The name of the extract being generated. This will always report a value of Teacher Course Assignment Errors and Warnings Report. | N/A |
Total Records | The total amount of records generated. | N/A |
File Name | TEW_RCDT Code_Date.extension This must be the same file name used for the actual file name when the save as action is performed. | N/A |
Date | The date the extract was generated. | N/A |
RCDTS Code | The Region-County-District-Type-School code that uniquely identifies the school generating the extract. RRCCCDDDDTTSSSS, 15 characters | System Administration > Resources > District Information > State District Number, Type, Region Number, County System Administration > Resources > School > State School Number District.districtID District.county District.region School.number |
| Report Layout | ||
Illinois Educator Identifying Number (IEIN) | Teacher's State Staff ID number. Numeric, 10 digits | Census > People > Demographics > Staff State ID Person.staffStateID |
Local Teacher ID | School- or District-assigned teacher number. Numeric, up to 50 digits | Census > People > Demographics > Local Staff Number Person.localStaffID |
Teacher Last Name | Teacher's last name. When the Report Protected Identities checkbox is marked on the report editor, the teacher's last name reports from the Legal Last Name field if populated. Alphanumeric, 30 characters | Census > People > Identity Information > Last Name Identity.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
Teacher First Name | Teacher's first name. When the Report Protected Identities checkbox is marked on the report editor, the teacher's first name reports from the Legal First Name field if populated. Alphanumeric, 30 characters | Census > People > Identity Information > First Name Identity.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.LegalfirstName |
Term | Identifies the calendar term in which the section occurs. Numeric, 2 digits | Scheduling > Courses > Course > Section > Term Code Section.term |
Local Course ID | School-assigned or District-assigned number of the course. Alphanumeric, up to 50 characters | Scheduling > Courses > Course > Number Course.number |
Local Course Title | Course Name. Alphanumeric, up to 100 characters | Scheduling > Courses > Course > Name Course.name |
Section Number | Reports the concatenated value of the Course Number and Section Number. Numeric, up to 10 digits | Scheduling > Course > Course > Sections > Section Number Section.number |
