IL Course Assignment

Contents

Introduction

The IL Course Assignment report creates a data file for submission to the ISBE SIS from stored grade information for the Student Course Assignment V2 (SCA), Outside Course Assignment (OCA), College Course Assignment (CCA), and Preschool Student Course Assignment (PSCA) reports.

The SCA is used by districts to submit coursework completed by students at their district and is used for grades K-12.
The OCA is used by districts to report coursework completed by students transferring into their district from non-IL public districts. Records with no grades or earned credit awarded are not extracted. The OCA is no longer a required state submission.
The CCA is used by districts to submit the IPEDS number of the community college where a high school student is taking courses, and the name of the courses being taken.
The PSCA is used by districts to submit coursework completed by students at their district and is used for students who are assigned grade level, Pre-Kindergarten (PK).

The Extract Viewer link is available on the State Reports page in the description area for the IL Course Assignment report. The Extract Viewer can be used as a troubleshooting tool.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

For the IL Course Assignment report process, all students enrolled in the school or district at any time beginning July 1, 2010 are included in the process.

Student Selection

The report selects records from the Student table based on the following criteria:

The student must not be excluded from state reporting.

Grade Selection

The report selects grade records from the Historical Grades table based on the following criteria:

The grade was earned in the Year and Term selected on the Report Input page.
The grade must not be excluded from state reporting.
The grade must not be for section / course excluded from state reporting.

The report selects grade records from the Historical Grades table based on the following criteria:

If there are no Historical Grades, current classes (CC Table) are included in the selection and extracted without Course End Date, Grade, and Course Credit for grades K-8. Grade is determined from the State Course Code.
When run for CCA, records that extract are those that also extract for the SCA and have an IPEDS number.
When run for OCA, records that fall within the reporting term and that have a Facility Code extract.

Report Setup

You must map the following data prior to running the reports:

Letter Grade Mapping is used to map grade scales to the state Course Final Letter Grades.
Term Grade Mapping is used to map, for each school, the Store Code which should be extracted for each term ID.

Both are found on the District > District Setup page in the Illinois State Information area at the bottom of the page.

For example, for school 100, Term ID 2001 (first semester), the store code might be S2 for the final grade for that semester. You must enter a record to designate the Store Code to extract for that term.

You must run the Store Grades process for a given term to create Historical Grades. Grades entered manually into Historical Grades via Single Entry are also used by the report. When manually entering Historical Grades for grades earned at other Illinois public districts, select the Exclude this Historical Grade from State Reporting for each grade if you do not want to report those grades to ISBE. For grades earned at non-Illinois public districts, click the Show Additional State Fields at the bottom of the Single Entry page and populate the information. You must select the OC Facility Type for a record to extract on the OCA report.

During Stored Grades manual entry, if a Course Number is entered, data is pulled from that course if the fields are not populated in the Additional State Fields. If a course section is entered, the data is will be extracted from that section; if blank, data is extracted from the course. If no course number is entered, data is extracted only from the fields on the Stored Grades page. If blanks are found in fields there, blanks will extract for those fields.

During Stored Grades manual entry, you must be logged into the school from which the grades will be extracted, rather than at the District Office.

When running the report prior to storing grades, records are extracted for the current courses per the Term Grade Mapping Start and End Dates. Particularly for grades K-8, the report may be run prior to end of term. If no Historical Grades are present, Course End Date, Course Credit, and Grade do not extract.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to runningreport.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2011 @ 10:05 AM.
Select District	(Optional) If this option appears, select the District for which to run the report.
RCDTS Number	Enter the 15-digit RCDTS (Region, Country, District, Type, and School) number. The value entered in this field is used in the file name and the header in the report results.
Mode	Choose the report mode from the pop-up menu: Student Course Assignment V2 (SCA) – Generate the SCA extract file. Outside Course Assignment (OCA) – Generate the OCA extract file. College Course Assignment (CCA) – Generate the CCA extract file. Pre-K Course Assignment. (PSCA) - Generate the PSCA extract file.
Start Date	Enter the Report Start Date to extract class or grading information. This is the first date of semester records being pulled from CC or Stored Grades.
End Date	Enter the Report End Date to extract class or grading information. This is the last date of semester records being pulled from CC or Stored Grades. The end date should be after the [CC]DateLeft records being pulled when pulling from CC records only. Note:The End Date should be before the [CC]DateLeft records being pulled when only pulling from CC records.
Extract Section From:	Choose the source of the Section Number to extract from the pop-up menu: SectionID – The internally assigned numeric number which is unique to course, section, and teacher. An example SectionID may be viewed at the bottom of the Edit Section page. Section Number – The PowerSchool Section Number which you assign to each course section. Course + Section – This is a derived value. When the report runs it will append the Section Number to the Course Number. For example, if Course is MAT100 and Section Number is 1, a value of MAT1001 would be reported. When selecting which option to use, consider other reports such as the IL Teacher Course Assignment which contain a Section number that needs to match the Section number submitted via this report; be consistent. The value in the Override Section Number field on the Historical Grades page is reported; if blank, the section extracted is based on the option selected here.
Include standards-based grades	Select Yes to include standards-based grades. Note: Only those standards that are selected from District > Standards Mapping will be pulled in the report. The Course must not be excluded from SCA/OCA/TCA Reports. Ensure following settings are done for standard grade to appear in the report Letter Grade mapping is done for standard Grade scale. Final grade calculation setting is mapped for standard (District → PowerTeacher Pro Settings → Grade Preferences for School) Standard list is mapped to standard Grade scale
Run from Extract Viewer	Choose one of the following: Yes – This processes the extract from the extract viewer. No – Select No when running any extract for the first time. Note: If you select No, the data in the extract viewer is replaced with the data from the extract.

Report Output – Student Course Assignment V2 (SCA)

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Student ID	The student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). This value should be blank upon first submission of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]State_StudentNumber	Numeric	9
2	SAP ID	The PowerSchool student identification code. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]Student_Number	Alpha-numeric	50
3	Legal Last Name	The legal last name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal Last Name field is blank, the student’s last name entered on the Demographics page is extracted Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_Last_Name If blank, [Students]Last_Name	Alpha-numeric	30
4	Student First Name	The legal first name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal First Name field is blank, the student’s first name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_First_Name If blank, [Students]First_Name	Alpha-numeric	30
5	Birth Date	The student’s birth date. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]DOB	Numeric	10
6	RCDTS Home School	Defaults to the RCDTS Home School Number selected at report runtime. If the RCDTS Home School Number field is blank, this value is the Region, County, District, Type, School (RCDTS) code that uniquely identifies the student’s home school, extracted from the Student information > Assessment Pre-ID Information tab. If the RCDTS Home School Number is blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School entered on the Edit School page is reported. District Setup > Schools/School Info > Edit School.	[S_IL_STU_X]RCDTS_Home_School If blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
7	RCDTS Serving School	The Region, County, District, Type, School (RCDTS) code which uniquely identifies the student’s serving school. Extracted from the Stored Grades page, Student Selection > Historical Grades. If the RCDTS Serving School field is blank in the Historical Grades table, the RCDTS Serving School is extracted from the Student information > Assessment Pre-ID Information tab. If the RCDTS Serving School is blank on both pages, then the RCDTS Home School is extracted from the Student information > Assessment Pre-ID Information tab If both the RCDTS Home School and RCDTS Serving School fields are blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School entered on the Edit School page is extracted, District Setup > Schools/School Info > Edit School.	[S_IL_SGR_X]RCDTS_Serving_School If blank, [S_IL_STU_X]RCDTS_Serving_School If blank, [S_IL_STU_X]RCDTS_Home_School If both blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
8	School Year	The school year of the student’s last active enrollment. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[CC]TermID [StoredGrades]TermID	Numeric	4
9	Term	The term in which the student earned the grade for this course. See the Appendix for valid Term Codes. Notes: If the Term field is blank, the term value is extracted from the Term Grade Mappings table [S_IL_Term_Grade_Mapping_S]termPeriod (District >Term Grade Mapping). The term Q5, Quarterly Summer is supported and districts can report on their summer school course data before or after the end of year rollover.	Selected at run time	Numeric	2
10	State Course Code	The unique code assigned to this course by the ISBE. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the State Course Code field is blank, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]State_Course_Code If blank, [S_IL_CRS_X]State_Course_Code	Alpha-numeric	9
11	Local Course ID	The unique course code assigned by the school district. This field is extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]course_number If blank, [Courses]Course_Number	Alpha-numeric	50
12	Local Course Title	The course name assigned by the school district. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]course_name If blank, [Courses]Course_Name	Alpha-numeric	100
13	Student Course Start Date	The date this the course started in the selected term. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Student Course Start Date is blank, the student’s Enrollment Date is extracted from the student enrollment record.	[S_IL_SGR_X]Course_Start_Date If blank, [CC]DateEnrolled	Alpha- numeric	10
14	Section Number	The section number. If no Override Section Number value is found, extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades page. Note: The Section Number = 999 in the following situations: If there is not a section number. Or if the Section Number format is Course+Section, and either the Course or Section is blank.	[S_IL_SGR_X]Override_Section_Number If blank, [StoredGrades]SectionID or [StoredGrades]SectionNumber is extracted as requested on the report interface. [Sections]SectionNumber [Sections]SectionID	Alpha-numeric	10
15	Course Level	The code identifying the course’s level of rigor. Extracted from the Historical Grades page, Start Page > Student Selection > Historical Grades. If the Course Level field is blank in the Historical Grades table, the value is extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Course Level is blank on the Edit Section page, Extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Course_Level If blank, [S_IL_SEC_X]Course_Level If both blank, [S_IL_CRS_X]Course_Level	Alpha-numeric	2
16	Course Credit	The number of credits the student will earn upon successful completion of the course requirements. Extracted from the Historical Grades page, Start Page > Student Selection > Historical Grades. Reports to the third decimal place (x.xxx). Course Credit for all terms (except Q5) must be between 0.001 and 3.000. See the Appendix for Term Codes.	[StoredGrades]Potentialcrhrs if blank then CoursesCredit_Hours	Numeric	4
17	Articulated Credit	If this value is 01 (Yes), the student will receive both high school and college credit for this course, if the student has a written agreement between the high school and the college. If this value is 02 (No) or blank, the student will receive only high school credit for completion of this course. The Articulated Credit value is extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Articulated Credit field is blank in the Historical Grades table, the value is extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Articulated Credit is blank on the Edit Section page, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Articulated_Credit If blank, [S_IL_SEC_X]Articulated_Credit If both blank, [S_IL_CRS_X]Articulated_Credit Default value is 02 (No)	Alpha-numeric	2
18	Dual Credit	If this value is 01 (Yes), the student will receive both high school and college credit for completion of this course. If this value is 02 (No) or blank, the student will receive only high school credit for this course. The Dual Credit value is extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Dual Credit field is blank in the Historical Grades table, the value is extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Dual Credit is blank on the Edit Sections page, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Dual_Credit If blank, [S_IL_SEC_X]Dual_Credit If both blank, [S_IL_CRS_X]Dual Credit Default value is 02 (No)	Alpha-numeric	2
19	Student Course Setting	The code identifying the location of setting of course instruction. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Course Setting field is blank in the Historical Grades table, the value is extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Course Setting field is blank on the Edit Sections page, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Course_Setting If blank, [S_IL_SEC_X]Course_Setting If both blank, [S_IL_CRS_X]Course_Setting	Alpha-numeric	2
20	Actual Attendance	Currently reported as blank.	N/A	Numeric	5
21	Total Attendance	Currently reported as blank.	N/A	Numeric	5
22	Single Parents including a Single Pregnant Women (Reported for CTE Courses Only)	Collected only for CTE Courses. If the value is 01 (Yes), the student is enrolled in a CTE course and meets the criteria for a single parent including a single pregnant woman statistic. Otherwise, the value is 02 (No). Extracted from the General tab of the Illinois State Information page, Student Selection > State/Province – IL > General.	[S_IL_STU_X]Single_Pregnant_Woman	Alpha-numeric	2
23	Displaced Homemaker	This data is collected only for CTE Courses. If the value is 01 (Yes), the student is enrolled in a CTE course and meets the criteria for a displaced homemaker. Otherwise, this value is 02 (No). The Displaced Homemaker value is extracted from the General tab of the Illinois State Information page, Student Selection > State/Province – IL > General.	[S_IL_STU_X]Displaced_Homemaker	Alpha-numeric	2
24	Course Numeric Grade	Currently blank on the extract. If this value were extracted it would come from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade.	[StoredGrades]percent	Numeric	5
25	Maximum Numeric Grade (Term)	Currently blank on the extract. If this value were extracted it would be extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade.	[S_IL_SGR_X]Max_Numeric_Grade	Numeric	5
26	Student Course End Date	The last scheduled date for course attendance in the reporting term. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Student Course End Date is blank, the last in session day prior to the end of section is extracted. If the course end date is greater than the report end date, this value is reported as blank Note: If the course is not yet completed and no final grades are populated, this value is blank.	[S_IL_SGR_X]Course_End_Date If blank, [CC]DateLeft [StoredGrades]grade must be populated for a value to report.	Alpha-numeric	10
27	Course Final Letter Grade/Completion Status (Term)	The state value identifying the final letter grade earned by the student upon completion of this course. For valid values, see the Appendix. Notes: If a student is withdrawn, the report output is "17 - Withdrew from course. Student did not receive course term credit. Student was not enrolled on Course End Date". The report outputs 31 if a PK student drops a completed class and the Course Final Letter Grade/Completion Status Override is "31 - Student has completed course (Pre-K only)" on her/his enrollment page.	[StoredGrades]grade converted to mapped value in the Letter Grade Mapping table: [S_IL_Letter_Grade_Mapping_S]Code01 through [S_IL_Letter_Grade_Mapping_S]Code20 If no mapped value exists for a [StoredGrades]grade, “NO MATCH FOR xx IN LETTER GRADE MAPPING” extracts. If there is no stored grade record associated with a class, blank extracts.	Alpha-numeric	2
28	Language Course Was Taught In	The language in which the course was taught. Extracted from Start Page > Student Selection > Historical Grades > Edit Stored Grade If the Language Course Was Taught In field is blank in the Historical Grades table, extracted from Start Page > School Setup > section name > Edit Section. If the Language Course Was Taught is blank on the Edit Sections page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses > Edit Course District Information. If the Language Course Was Taught is blank on the stored grade, section, and course pages, the default of English (000) is extracted	[S_IL_SGR_X]Language_Course_Taught if blank, [S_IL_SEC_X]Language_Course_Taught if both blank, [S_IL_CRS_X]Language_Course_Taught Else, default value 000	Alpha-numeric	3
29	Competency Based Education	Indicates whether the course is considered competency based education. Extracted from Start Page > Student Selection > Historical Grades > Edit Stored Grade If the Competency Based Education field is blank in the Historical Grades table, extracted from Start Page > School Setup > section name > Edit Section. If the Competency Based Education is blank on the Edit Sections page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses > Edit Course District Information. If the Competency Based Education is blank on the stored grade, section, and course pages, the default of 02 (No) is extracted.	[S_IL_SGR_X]Competency_Based_Ed if blank, [S_IL_SEC_X]Competency_Based_Ed if both blank, [S_IL_CRS_X]Competency_Based_Ed Else, default value 02	Alpha-numeric	2

Report Output – Outside Course Assignment (OCA)

Each of the fields displayed in the output of the report are described below.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Student ID	The student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). This value should be blank for all students upon first submission. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]State_StudentNumber	Numeric	9
2	SAP ID	The PowerSchool student identification code. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]Student_Number	Alpha-numeric	50
3	Legal Last Name	The legal last name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal Last Name field is blank, the student’s last name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_Last_Name If blank, [Students]Last_Name	Alpha-numeric	30
4	Legal First Name	The legal first name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal First Name field is blank, the student’s first name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_First_Name If blank, [Students]First_Name	Alpha-numeric	30
5	Birth Date	The student’s birth date. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]DOB	Numeric	10
6	RCDTS Home School	Defaults to the RCDTS Home School Number entered at report runtime. If the RCDTS Home School Number field is blank, then Region, County, District, Type, and the School (RCDTS) code that uniquely identifies the student’s home school is extracted. Extracted from the Student information > Assessment Pre-ID Information tab. If the RCDTS Home School Number is blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School entered on the Edit School page is used in the report. District Setup > Schools/School Info > Edit School.	[S_IL_STU_X]RCDTS_Home_School If blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
7	Outside Course School Year	The year the student earned the grade for this course is displayed. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]TermID	Alpha-numeric	15
8	Outside Course Grade Level	The grade level in which the student was enrolled when the student earned this grade. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]grade_level	Alpha-numeric	2
9	Outside Course Facility Type	The code identifying the type of outside facility the student attended when enrolled in this course. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[S_IL_SGR_X]OC_Facility_Type	Alpha-numeric	15
10	Outside Course Facility Name	The name of the outside facility. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]SchoolName	Alpha-numeric	30
11	Term	The term in which the student earned the grade for this course. See the Appendix for valid Term Codes.	[S_IL_SGR_X]Term If blank, [S_IL_Term_Grade_Mapping_S]termPeriod	Numeric	2
12	State Course Code	The unique code assigned to this course by the ISBE. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the State Course Code field is blank, Extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]State_Course_Code If blank, [S_IL_CRS_X]State_Course_Code	Alpha-numeric	9
13	Local Course ID	The unique course code assigned by the school district to this course by the ISBE. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Local Course ID field is blank, the state course code is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[StoredGrades]course_number If blank, [S_IL_CRS_X]State_Course_Code	Alpha-numeric	50
14	Local Course Title	The course name assigned by the school district. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[CoursesStoredGrades]cCourse_Nname	Alpha-numeric	100
15	Student Course Start Date	The date the course started in the selected term. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Student Course Start Date is blank, the student’s Enrollment Date is extracted from the student enrollment record.	[S_IL_SGR_X]Course_Start_Date If blank, [CC]DateEnrolled	Alpha- numeric	10
16	Section Number	The section number. If no Override Section Number value is found, extracted from the Historical Grades page, Start Page > Student Selection > Historical Grades page.	[S_IL_SGR_X]Override_Section_Number If blank, [StoredGrades]SectionID or [StoredGrades]SectionNumber is extracted as requested at report runtime	Alpha-numeric	10
17	Course Level	The code identifying the course’s level of rigor. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Course Level field is blank in the Historical Grades table, Extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Course Level is blank on the Edit Section page, Extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Course_Level If blank, [S_IL_SEC_X]Course_Level If both blank, [S_IL_CRS_X]Course_Level	Alpha-numeric	2
18	Course Credit	The number of credits the student will earn upon successful completion of the course requirements. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. Reports to the third decimal place (x.xxx). Course Credit for all terms (except Q5) must be between 0.001 and 3.000. See the Appendix for Term Codes.	[StoredGrades]Potentialcrhrs if blank then CoursesCredit_Hours	Numeric	N/A4
19	Articulated Credit	If this value is 01 (Yes), the student will receive both high school and college credit for this course; Articulated credit is awarded by the college to students who successfully complete a course/program while in high school and meet all college requirements as outlined in the Articulation Agreement. If the student has a however, college credit is available through a written agreement between the high school and the college. If this value is 02 (No) or blank, the student will receive only high school credit for completion of this course. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If Articulated Credit is blank in the Historical Grades table, the value is extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If Articulated Credit is blank on the Edit Section page, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Articulated_Credit If blank, [S_IL_SEC_X]Articulated_Credit If both blank, [S_IL_CRS_X]Articulated_Credit	Alpha-numeric	2
20	Dual Credit	If this value is 01 (Yes), the student will receive both high school and college credit for completion of this course. If this value is 02 (No) or blank, the student will receive only high school credit for this course. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Dual Credit field is blank in the Historical Grades table, Extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Dual Credit is blank on the Edit Sections page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Dual_Credit If blank, [S_IL_SEC_X]Dual_Credit If both blank, [S_IL_CRS_X]Dual Credit	Alpha-numeric	2
21	Course Setting	The code identifying the location of setting of course instruction. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Course Setting field is blank in the Historical Grades table, extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Course Setting field is blank on the Edit Sections page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Course_Setting If blank, [S_IL_SEC_X]Course_Setting If both blank, [S_IL_CRS_X]Course_Setting	Alpha-numeric	2
22	Actual Attendance	Currently reported as blank.	N/A	Numeric	5
23	Total Attendance	Currently reported as blank.	N/A	Numeric	5
24	Single Parents including a Single Pregnant Women (Reported for CTE Courses Only)	This data is collected only for CTE Courses. If this value is 01 (Yes), the student is enrolled in a CTE course and meets the criteria for a single parent including a single pregnant woman statistic. Otherwise, the value is 02 (No). Extracted from the General tab of the Illinois State Information page, Student Selection > State/Province – IL > General.	[S_IL_STU_X]Single_Pregnant_Woman	Alpha-numeric	2
25	Displaced Homemaker	This data is collected only for CTE Courses. If this value is 01 (Yes), the student is enrolled in a CTE course and meets the criteria for a displaced homemaker. Otherwise, the value is 02 (No). Extracted from the General tab of the Illinois State Information page, Student Selection > State/Province – IL > General.	[S_IL_STU_X]Displaced_Homemaker	Alpha-numeric	22
26	Course Numeric Grade	Currently blank in the extract. If this value were extracted, it would come from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade.	[StoredGrades]percent	Numeric	5
27	Maximum Numeric Grade (Term)	Currently blank in the extract.. If the value were extracted, it would come from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade.	[S_IL_SGR_X]Max_Numeric_Grade	Numeric	5
28	Student Course End Date	The date the last scheduled date for course attendance in the reporting term. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Student Course End Date is blank, the last in session day prior to the end of section is extracted.	[S_IL_SGR_X]Course_End_Date If blank, [CC]DateLeft	Alpha-numeric	10
29	Course Final Letter Grade/Completion Status (Term)	The state value identifying the final letter grade earned by the student upon completion of this course. For valid values, see the Appendix.	[StoredGrades]grade converted to mapped value in the Letter Grade Mapping table: [S_IL_Letter_Grade_Mapping_S]Code01 through [S_IL_Letter_Grade_Mapping_S]Code20	Alpha-numeric	2

Report Output – College Course Assignment (CCA)

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Student ID	The student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). This value should be blank for all students upon first submission. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]State_StudentNumber	Numeric	9
2	SAP ID	The PowerSchool student identification code. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]Student_Number	Alpha-numeric	50
3	Legal Last Name	The legal last name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal Last Name field is blank, the student’s last name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_Last_Name If blank, [Students]Last_Name	Alpha-numeric	30
4	Student First Name	The legal first name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal First Name field is blank, the student’s first name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_First_Name If blank, [Students]First_Name	Alpha-numeric	30
5	Birth Date	The student’s birth date. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]DOB	Numeric	10
6	RCDTS Home School	Defaults to the RCDTS Home School Number, selected at report runtime. If the RCDTS Home School Number field is blank, then the Region, County, District, Type, School (RCDTS) code that uniquely identifies the student’s home school is extracted. Extracted from the Student information > Assessment Pre-ID Information tab If the RCDTS Home School Number is blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School entered on the Edit School page is used in the report. District Setup > Schools/School Info > Edit School.	[S_IL_STU_X]RCDTS_Home_School If blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
7	RCDTS Serving School	The Region, County, District, Type, School (RCDTS) code which uniquely identifies the student’s serving school. Extracted from the Stored Grades page, Student Selection > Historical Grades. If the RCDTS Serving School field is blank in the Historical Grades table, the RCDTS Serving School value is extracted from the Student information > Assessment Pre-ID Information tab If the RCDTS Serving School is blank on both pages, then the RCDTS Home School value is extracted from the Student information > Assessment Pre-ID Information tab If both the RCDTS Home School and RCDTS Serving School fields are blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School entered on the Edit School page is extracted, District Setup > Schools/School Info > Edit School.	[S_IL_SGR_X]RCDTS_Serving_School If blank, [S_IL_STU_X]RCDTS_Serving_School If blank, [S_IL_STU_X]RCDTS_Home_School If both blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
8	School Year	The school year of the student’s last active enrollment. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[CC]TermID [StoredGrades]TermID	Numeric	4
9	Term	The term in which the student earned the grade for this course. See the Appendix for valid Term Codes. If the Term field is blank, the value is extracted from the Term Grade Mappings table [S_IL_Term_Grade_Mapping_S]termPeriod (District >Term Grade Mapping).	Selected at run time	Numeric	2
10	State Course Code	The unique code assigned to this course by the ISBE. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the State Course Codefield is blank, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]State_Course_Code If blank, [S_IL_CRS_X]State_Course_Code	Alpha-numeric	9
11	Local Course ID	The unique course code assigned by the school district. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]course_number If blank, [Courses]Course_Number	Alpha-numeric	50
12	Local Course Title	The course name assigned by the school district. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]course_name If blank, [Courses]Course_Name	Alpha-numeric	100
13	Student Course Start Date	The date this the course started in the selected term. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Student Course Start Date is blank, the student’s Enrollment Date is extracted from the student enrollment record.	[S_IL_SGR_X]Course_Start_Date If blank, [CC]DateEnrolled	Alpha- numeric	10
14	Section Number	The section number. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades page. If no Override Section Number value is found. Note: The Section Number = 999 in the following situations: If there is not a section number Or if the Section Number format is Course+Section, and either the Course or Section is blank	[S_IL_SGR_X]Override_Section_Number. If blank, [StoredGrades]SectionID or [StoredGrades]SectionNumber is extracted as requested on the report interface. [Sections]SectionNumber [Sections]SectionID	Alpha-numeric	10
15	Course Level	The code identifying the course’s level of rigor. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Course Level field is blank in the Historical Grades table, extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Course Level is blank on the Edit Section page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Course_Level If blank, [S_IL_SEC_X]Course_Level If both blank, [S_IL_CRS_X]Course_Level	Alpha-numeric	2
16	Course Credit	The number of credits the student will earn upon successful completion of the course requirements. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. Reports to the third decimal place (x.xxx). Course Credit for all terms (except Q5) must be between 0.001 and 3.000. See the Appendix for Term Codes. Note: When pulling from CC records rather than final grades, if the term has not yet ended, extracts as blank.	[StoredGrades]Potentialcrhrs if blank then CoursesCredit_Hours	Numeric	4
17	Articulated Credit	If this value is 01 (Yes), the student will receive both high school and college credit for this course, if the student has a written agreement between the high school and the college. If this value is 02 (No) or blank, the student will receive only high school credit for completion of this course. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Articulated Credit field is blank in the Historical Grades table, extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Articulated Credit is blank on the Edit Section page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Articulated_Credit If blank, [S_IL_SEC_X]Articulated_Credit If both blank, [S_IL_CRS_X]Articulated_Credit Default value is 02 (No)	Alpha-numeric	2
18	Dual Credit	If this value is 01 (Yes), the student will receive both high school and college credit for completion of this course. If this value is 02 (No) or blank, the student will receive only high school credit for this course. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Dual Credit field is blank in the Historical Grades table, extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Dual Credit is blank on the Edit Sections page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]Dual_Credit If blank, [S_IL_SEC_X]Dual_Credit If both blank, [S_IL_CRS_X]Dual Credit Default value is 02 (No)	Alpha-numeric	2
19	Student Course Setting	The code identifying the location of setting of course instruction. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Course Setting field is blank in the Historical Grades table, extracted from the Edit Sections page, Start Page > School Setup > section name > Edit Section. If the Course Setting field is blank on the Edit Sections page, extracted from the Edit Course District Information page, Start Page > School Setup > Courses > Edit Course District Information.	[S_IL_SGR_X]Course_Setting If blank, [S_IL_SEC_X]Course_Setting If both blank, [S_IL_CRS_X]Course_Setting	Alpha-numeric	2
20	Actual Attendance	Currently reported as blank.	N/A	Numeric	5
21	Total Attendance	Currently reported as blank.	N/A	Numeric	5
22	Single Parents including a Single Pregnant Women (Reported for CTE Courses Only)	This data is collected only for CTE Courses. If the value is 01 (Yes), the student is enrolled in a CTE course and meets the criteria for a single parent including a single pregnant woman statistic. Otherwise, the value is 02 (No). Extracted from the General tab of the Illinois State Information page, Student Selection > State/Province – IL > General.	[S_IL_STU_X]Single_Pregnant_Woman	Alpha-numeric	2
23	Displaced Homemaker	This data is collected only for CTE Courses. If this value is 01 (Yes), the student is enrolled in a CTE course and meets the criteria for a displaced homemaker. Otherwise, this value is 02 (No). Extracted from the General tab of the Illinois State Information page, Student Selection > State/Province – IL > General.	[S_IL_STU_X]Displaced_Homemaker	Alpha-numeric	2
24	Course Numeric Grade	Reports as blank. If this value were extracted it would come from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade.	[StoredGrades]percent	Numeric	5
25	Maximum Numeric Grade (Term)	Currently blank on the extract. If this value were extracted it would be extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade.	[S_IL_SGR_X]Max_Numeric_Grade	Numeric	5
26	Student Course End Date	The date the last scheduled date for course attendance in the reporting term. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Student Course End Date is blank, the last in session day prior to the end of section is extracted. When pulling from CC records rather than final grades, and the term has not yet ended, extracts as blank.	[S_IL_SGR_X]Course_End_Date If blank, [CC]DateLeft	Alpha-numeric	10
27	Course Final Letter Grade/Completion Status (Term)	The state value identifying the final letter grade earned by the student upon completion of this course. For valid values, see the Appendix.	[StoredGrades]grade converted to mapped value in the Letter Grade Mapping table: [S_IL_Letter_Grade_Mapping_S]Code01 through [S_IL_Letter_Grade_Mapping_S]Code20 If no mapped value exists for a [StoredGrades]grade, “NO MATCH FOR xx IN LETTER GRADE MAPPING” extracts. If there is no stored grade record associated with a class, blank extracts.	Alpha-numeric	2
28	IPEDS Number	The community college number where the high school student is taking this course.	[S_IL_SGR_X]IPEDS_Number Or [S_IL_SEC_X]IPEDS_Number	Alpha-numeric	6

Report Output – Preschool Student Course Assignment (PSCA)

Each of the fields displayed in the output of the report are described below.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Student ID	The student identification code assigned to each student in your district by the Illinois State Board of Education (ISBE). This value should be blank for all students upon first submission. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]State_StudentNumber	Numeric	9
2	SAP ID	The PowerSchool student identification code. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]Student_Number	Alpha-numeric	50
3	Legal Last Name	The legal last name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal Last Name field is blank, the student’s last name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_Last_Name If blank, [Students]Last_Name	Alpha-numeric	30
4	Student First Name	The legal first name of the student. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the Legal First Name field is blank, the student’s first name entered on the Demographics page is extracted, Start Page > Student Selection > Demographics.	[S_IL_STU_Demographics_X]Legal_First_Name If blank, [Students]First_Name	Alpha-numeric	30
5	Birth Date	The student’s birth date. Extracted from the Demo tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information.	[Students]DOB	Numeric	10
6	RCDTS Home School	Defaults to the RCDTS Home School Number selected at report runtime. If the RCDTS Home School Number field is blank, then the Region, County, District, Type, School (RCDTS) code that uniquely identifies the student’s home school is extracted from the Student information > Assessment Pre-ID Information tab of the Illinois State Information page, Start Page > Student Selection > Illinois State Information > ISBE SIS Student Demographic/ Enrollment Information. If the RCDTS Home School Number is blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School value entered on the Edit School page is extracted, District Setup > Schools/School Info > Edit School.	[S_IL_STU_X]RCDTS_Home_School If blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
7	RCDTS Serving School	The Region, County, District, Type, School (RCDTS) code which uniquely identifies the student’s serving school. Extracted from the Stored Grades page, Student Selection > Historical Grades. If the RCDTS Serving School field is blank in the Historical Grades table, the RCDTS Serving School value is extracted from the Student information > Assessment Pre-ID Information tab. If the RCDTS Serving School is blank on both pages, then the RCDTS Home School is extracted from the Student information > Assessment Pre-ID Information tab. If both the RCDTS Home School and RCDTS Serving School fields are blank on the Student information > Assessment Pre-ID Information tab, the RCDTS Home School value entered on the Edit School page is extracted. District Setup > Schools/School Info > Edit School.	[S_IL_SGR_X]RCDTS_Serving_School If blank, [S_IL_STU_X]RCDTS_Serving_School If blank, [S_IL_STU_X]RCDTS_Home_School If both blank, [S_IL_SCH_X]RCDTS_Home_School	Alpha-numeric	15
8	School Year	The school year of the student’s last active enrollment. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[CC]TermID [StoredGrades]TermID	Numeric	4
9	Term	The term in which the student earned the grade for this course. See the Appendix for valid Term Codes. If the Term field is blank, the value is extracted from the Term Grade Mappings table [S_IL_Term_Grade_Mapping_S]termPeriod (District >Term Grade Mapping).	Selected at run time	Numeric	2
10	State Course Code	The unique code assigned to this course by the ISBE. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the State Course Code field is blank, the value is extracted from the Edit Course District Information page, Start Page > School Setup > Courses >Edit Course District Information.	[S_IL_SGR_X]State_Course_Code If blank, [S_IL_CRS_X]State_Course_Code	Alpha-numeric	9
11	Local Course ID	The unique course code assigned by the school district. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]course_number If blank, [Courses]Course_Number	Alpha-numeric	50
12	Local Course Title	The course name assigned by the school district. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades.	[StoredGrades]course_name If blank, [Courses]Course_Name	Alpha-numeric	100
13	Student Course Start Date	The date this the course started in the selected term. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades. If the Student Course Start Date is blank, the student’s Enrollment Date is extracted from the student enrollment record.	[S_IL_SGR_X]Course_Start_Date If blank, [CC]DateEnrolled	Alpha-numeric	10
14	Section Number	The section number. Extracted from the Historical Grades table, Start Page > Student Selection > Historical Grades page. If no Override Section Number value is found. Note: The Section Number = 999 in the following situations: If there is not a section number. Or if the Section Number format is Course+Section, and either the Course or Section is blank.	[S_IL_SGR_X]Override_Section_Number. If blank, [StoredGrades]SectionID or [StoredGrades]SectionNumber is extracted as requested on the report interface. [Sections]SectionNumber [Sections]SectionID	Alpha-numeric	16
15	Actual Attendance	Currently reported as blank.	N/A	Numeric	5
16	Total Attendance	Currently reported as blank.	N/A	Numeric	5
17	Student Course End Date	The last scheduled date for course attendance in the reporting term. Extracted from the Edit Stored Grades page, Start Page > Student Selection > Historical Grades > Edit Stored Grade. If the Student Course End Date field is blank, the last in session day prior to the end of section is extracted. When pulling from CC records rather than final grades, and the term has not yet ended, this value is blank.	[S_IL_SGR_X]Course_End_Date If blank, [CC]DateLeft	Alpha-numeric	10
18	Course Final Letter Grade	The state value identifying the final letter grade earned by the student upon completion of this course.	[StoredGrades]grade converted to mapped value in the Letter Grade Mapping table: [S_IL_Letter_Grade_Mapping_S]code31 If no mapped value exists for a [StoredGrades]grade, “NO MATCH FOR xx IN LETTER GRADE MAPPING” extracts. If there is no stored grade record associated with a class, blank extracts.	Alpha-numeric	2