The report primarily pulls from Historical Grades / StoredGrades. If stored grades are missing or incomplete, the report may extract blank values for course end date, course credit, or final grade.

Understand the purpose of SCA, OCA, CCA, and PSCA modes before generating the extract.

Verify Letter Grade Mapping, Term Grade Mapping, Historical Grades, course setup, section setup, and state reporting exclusions.

Use Historical Grades, Extract Viewer, mappings, credit values, and enrollment history to resolve blank grades, missing credits, mapping errors, and withdrawn course records.

The OCA is no longer a required state submission, but the mode may still be available in the report.

The Extract Viewer link is available on the State Reports page in the description area for the IL Course Assignment report.

Use the Extract Viewer as a troubleshooting tool to review extracted data before submission.

• Select No for Run from Extract Viewer the first time the extract is generated.
• If No is selected, the current Extract Viewer data is replaced with the newly generated extract.
• Select Yes only when intentionally processing from the Extract Viewer.

A student is selected when:

• The student is not excluded from state reporting.

Historical Grade records are selected when:

• The grade was earned in the year and term selected on the report input page.
• The grade is not excluded from state reporting.
• The grade is not tied to a section or course excluded from state reporting.

If no Historical Grade records exist, the report may use current class enrollment records from the CC table for grades K–8. However, when the report pulls from current class enrollment instead of StoredGrades, the following fields may extract as blank:

• Course End Date
• Grade
• Course Credit

Letter Grade Mapping is used to map PowerSchool grade scale values to Illinois state Course Final Letter Grade values.

If a stored grade value is not mapped, the extract may return an error such as:

Term Grade Mapping identifies which Store Code should be extracted for each term and school.

For example, a school may map the following reporting terms to Store Codes:

A mapping record must exist to tell the report which stored grade code to use for the selected reporting term.

The IL Course Assignment report relies heavily on Historical Grades / StoredGrades.

Grades may be created by:

• Running the Store Grades process
• Manually entering grades in Historical Grades
• Importing StoredGrades records

If grades are not stored, the report may extract blank values for final grade, course credit, and course end date.

When manually entering Historical Grades:

• Be logged into the school from which the grade should be extracted.
• Do not enter the record from District Office if the grade should report from a specific school.
• If the grade was earned at another Illinois public district and should not be reported by the current district, select Exclude this Historical Grade from State Reporting.
• For grades earned at non-Illinois public districts, use Show Additional State Fields and populate the required outside course fields.
• For OCA reporting, the OC Facility Type must be selected for the record to extract.

Go to the Illinois State Reports area and select IL Course Assignment.

Navigation may vary by PowerSchool SIS version and state reporting plugin version.

If running at the school level, the report includes records associated with the current school that meet the criteria.

If running the report for a single student or group of students, select the students before running the report.

Enter the 15-digit RCDTS number. The RCDTS value is used in the file name and report header.

Use the same section-number logic as related Illinois reports, such as the IL Teacher Course Assignment report, so submitted section numbers match across files.

If the Override Section Number field is populated on the Historical Grade record, that value is reported. If it is blank, the section number is extracted based on the option selected at runtime.

Select Yes to include standards-based grades.

To include standards-based grades, confirm the following:

• Standards are selected in District → Standards Mapping.
• The course is not excluded from SCA/OCA/TCA reports.
• Letter Grade Mapping exists for the standard grade scale.
• Final grade calculation is mapped for standards under PowerTeacher Pro grade preferences.
• The standards list is mapped to the standard grade scale.

The Course Final Letter Grade / Completion Status field is one of the most important fields in the IL Course Assignment report.

The report converts the PowerSchool StoredGrades grade value using the Illinois Letter Grade Mapping setup.

If no mapping exists, the report may extract:

If there is no stored grade record associated with the class, the final grade value may extract as blank.

If a student withdrew from a course and did not receive course term credit, the report may output:

Review dropped-course records carefully to determine whether the value is correct or whether the student has another completed section that should report instead.

Course Credit is extracted from the Historical Grade record.

The report uses:

If that field is blank, the report may use the course credit hours.

Course Credit reports to the third decimal place.

For all terms except Q5, Course Credit must be between:

If Historical Grades are missing or credits are incorrect, the report may show blank, incorrect, or inflated course credit values.

The Student Course End Date is pulled from Historical Grades when populated.

If the Historical Grade Course End Date is blank, the report may use the student course enrollment end date from the CC record.

If the course is not completed and final grades are not populated, the Course End Date may extract as blank.

For SCA, the StoredGrades grade must be populated for a Course End Date value to report.

If no Historical Grade record exists, the report may use current class enrollment records for grades K–8.

However, when the report pulls from CC records instead of StoredGrades, the following may extract blank:

• Course End Date
• Course Credit
• Final Grade

This is why grade storage is critical before final state reporting.

• Missing Historical Grades: If grades were not stored, the report may not have a grade record to extract. This can result in blank Course Final Letter Grade, blank Course Credit, and blank Course End Date.
• Blank Stored Grade: If a Historical Grade record exists but the Grade field is blank, the Course Final Letter Grade may extract as blank.
• Missing Letter Grade Mapping: If the StoredGrades grade value is not mapped, the report may return a “NO MATCH” message instead of a valid state grade code.
• Missing Term Grade Mapping: If Term Grade Mapping does not identify the correct Store Code for the reporting term, the report may pull the wrong Store Code or fail to extract the intended stored grade.
• Section or Course Excluded from State Reporting: If the section or course is excluded from state reporting, the grade record may not extract.
• Historical Grade Excluded from State Reporting: If the grade record is marked as excluded from state reporting, it will not be included.
• Manual Grade Entered from the Wrong School Context: If a Historical Grade was manually entered while logged into District Office or the wrong school, reporting fields may not populate correctly for the intended school.
• Student Changed Sections: If a student changed sections during the year, the report may extract the dropped section, current section, or stored grade record depending on the Historical Grade and CC records available. Review the student’s Historical Grades and course enrollment history to confirm which section should report.

1. Open the student in PowerSchool SIS.
2. Go to Historical Grades.
3. Confirm whether a Stored Grade exists for the course and reporting term.
4. Confirm the Grade field is populated.
5. Confirm the grade is not excluded from state reporting.
6. Confirm the section and course are not excluded from state reporting.
7. Confirm the grade value exists in Letter Grade Mapping.
8. Confirm the correct Store Code is configured in Term Grade Mapping.
9. Confirm the correct report mode, start date, and end date were used.
10. Re-run the extract or review the Extract Viewer.

1. Review the Historical Grade record.
2. Confirm Potential Credit Hours is populated.
3. If Potential Credit Hours is blank, review the course credit hours setup.
4. Confirm the credit value is valid for the reporting term.
5. Review duplicate Historical Grade records for the same student/course/term.
6. Confirm the student did not receive duplicate credit from multiple sections or schools.

When the extract displays NO MATCH FOR [grade] IN LETTER GRADE MAPPING, review:

1. The student’s Historical Grade value.
2. The grade scale used by the course.
3. Illinois Letter Grade Mapping.
4. Whether the grade should be mapped to a valid state Course Final Letter Grade value.
5. Whether the grade should be corrected, excluded, or officially reported.

Review:

• Student course enrollment dates
• Section changes
• Dropped classes
• Historical Grade records
• Whether the student completed the course in another section
• Whether the student should receive course term credit

If a student dropped one section but completed the same course in another section, verify that the completed section has the correct Historical Grade and that the dropped section is not incorrectly driving the reporting result.

• Store grades before running final IL Course Assignment reports.
• Confirm Letter Grade Mapping and Term Grade Mapping before extraction.
• Use Extract Viewer for troubleshooting.
• Export Historical Grades before performing mass corrections.
• Avoid mass grade storage if final grades do not exist in teacher gradebooks.
• Correct Historical Grades directly when the official grade exists outside the gradebook.
• Review blank, duplicate, and excluded Historical Grades before submission.
• Verify Course Credit values before submitting.
• Review students who changed sections during the year.
• Keep final extract files and validation documentation for audit purposes.

The IL Course Assignment report is used to submit student course assignment data to ISBE. The report depends heavily on Historical Grades / StoredGrades, Letter Grade Mapping, Term Grade Mapping, and section/course state reporting setup.

If grades are not stored, if StoredGrades are blank, or if mappings are incomplete, the report may extract blanks, incorrect credits, or “NO MATCH” messages.

To resolve issues:

1. Confirm grades are stored for the correct term.
2. Confirm Historical Grade records are populated and reportable.
3. Verify Letter Grade Mapping.
4. Verify Term Grade Mapping.
5. Review section/course state reporting exclusions.
6. Correct or import Historical Grades as needed.
7. Re-run the report and validate the extract before submission.