PowerSchool SIS Illinois

S_IL_CRS_X (ver 20.12.1)

This table is an extension of the Courses table.

Column Name

Version

Data Type

Description

CoursesDCID

16.6.2

Number(10,0)

Primary key that relates the extended table to the [Courses] table.

Articulated_Credit

16.6.2

Varchar2(2)

Migrated from [Courses]IL_Articulated_Credit

Course_Level

16.6.2

Varchar2(2)

Migrated from [Courses]IL_Course_Level

Course_Setting

16.6.2

Varchar2(2)

Migrated from [Courses]IL_Course_Setting

Dual_Credit

16.6.2

Varchar2(2)

Migrated from [Courses]IL_Dual_Credit

State_ExcludeFromReporting

16.6.2

Number(1,0)

Migrated from [Courses]IL_Exclude_SCA_TCA

State_Course_Code

16.6.2

Varchar2(9)

Migrated from [Courses]IL_State_Course_Code

Language_Course_Taught

19.9.1.0

Varchar2(2)

Language in which the course was taught.

Competency_Based_Ed

19.9.1.0

Varchar2(2)

Indicates whether the course is considered Competency Based Education.

Accelerated_Placement

20.12.1.0

Varchar2(2)

Indicates the type of Accelerated Placement (if any)

Course_Classification

24.3.2.0

Varchar2(2)

Course Classification Course level field for TCA Report