PowerSchool SIS Illinois

S_IL_SGR_X (ver 16.8.0)

This table is an extension of the StoredGrades table.

Column Name

Version

Data Type

Description

StoredGradesDCID

16.8.0

Number(10,0)

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

Articulated_Credit

16.8.0

Varchar2(2)

Migrated from [StoredGrades]IL_Articulated_Credit.

Course_End_Date

16.8.0

Date

Migrated from [StoredGrades]IL_Course_End_Date.

Course_Level

16.8.0

Varchar2(2)

Migrated from [StoredGrades]IL_Course_Level.

Course_Setting

16.8.0

Varchar2(2)

Migrated from [StoredGrades]IL_Course_Setting.

Course_Start_Date

16.8.0

Date

Migrated from [StoredGrades]IL_Course_Start_Date.

Dual_Credit

16.8.0

Varchar2(2)

Migrated from [StoredGrades]IL_Dual_Credit.

IPEDS_Number

16.8.0

Varchar2(6)

Migrated from [StoredGrades]IL_IPEDS_Number.

Max_Numeric_Grade

16.8.0

Number(25,10)

Migrated from [StoredGrades]IL_Max_Numeric_Grade.

OC_Facility_Type

16.8.0

Varchar2(2)

Migrated from [StoredGrades]IL_OC_Facility_Type.

Override_Section_Number

16.8.0

Varchar2(16)

Migrated from [StoredGrades]IL_Override_Section_Number.

RCDTS_Serving_School

16.8.0

Varchar2(15)

Migrated from [StoredGrades]IL_RCDTS_Serving_School.

State_Course_Code

16.8.0

Varchar2(9)

Migrated from [StoredGrades]IL_State_Course_Code.

State_ExcludeFromReporting

16.8.0

Number(1,0)

Indicates whether this stored grade record is excluded from state reporting (1 = excluded). Migrated from [StoredGrades]IL_ExcludeFromStateReporting.

Term

16.8.0

Varchar2(2)

Migrated from [StoredGrades]IL_Term.

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.