Teacher Course Assignment Report - Teacher Course Assignment Errors and Warnings (Illinois)

Classic View: IL State Reporting > Teacher Course Assignment Reports > Teacher Course Assignment Errors and Warnings 

Search Terms: 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.

Image 1: 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 IdentifierA 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:

  • Apostrophes ('), Commas (,), Periods (.)
  • Umlaut (Ö)
  • Tilde (Ñ)
  • Grave Accents (Ò), Acute Accents (Ó)
  • Circumflex (Ô)

When not marked, these marks are not removed.

Report Protected IdentitiesWhen 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

  1. Select Teacher Course Assignment Errors and Warnings as the Report Type.
  2. Enter the File Identifier value.
  3. Enter the Start Date for the report.
  4. Enter the End Date for the Report.
  5. If desired, mark the Strip Apostrophes checkbox.
  6. If desired, mark the Report Protected Identities checkbox.
  7. Select the Format in which the report should be generated.
  8. If desired, select an Ad hoc Filter.
  9. Select the Calendar(s) from which to pull data.
  10. 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