DM_StandardGrade (ver7.0.0)

Data Mart table containing references to Standard Grade records. This table is refreshed with data nightly from the PowerSchool core tables related to standard grades. Table is used by ReportWorks as a source when creating standard grades reports from PowerTeacher Gradebook (PTG).

Note: This table does not include Standard Grade records from PowerTeacher Pro.

Column Name

Initial Version

Data Type

Description

Course_Number

7.0.0

Varchar2(11)

Source is Sections table Course_Number column.

ID

7.0.0

Number(19)

Source is a sequence. Required.

PSMGradeScaleID

7.0.0

Number(19)

Source is PSM_GradeScale table ID column.

PSMParentStandardID

7.0.0

Number(19)

Source is PSM_Standard table ParentStandardID column.

PSMParentStandardIdentifier

7.0.0

Varchar2(20)

Source is Standards table Identifier column.

PSMStandardIdentifier

7.0.0

Varchar2(50)

Source is PSM_Standard table Identifier column.

PSMReportCardItemCommentID

ver...

Number(19)

Source is PSM_ReportCardItemComment table ID column.

PSMReportCardItemGradeID

ver...

Number(19)

Source is PSM_ReportCardItemGrade table ID column.

PSMReportingTermID

7.0.0

Number(19)

Source is PSM_ReportingTerm table ID column.

PSMSectionEnrollmentID

ver...

Number(19)

Source is PSM_SectionEnrollment table ID column.

PSMStandardID

7.0.0

Number(19)

Source is PSM_Standard table ID column.

PSMSubjectAreaID

ver...

Number(19)

Source is PSM_SubjectArea table ID column.

PSMTermID

7.0.0

Number(19)

Source is PSM_Term table ID column.

SchoolID

7.0.0

Number(10)

Source is Sections table SchoolID column. Required.

SectionID

7.0.0

Number(19)

Source is PSM_SectionEnrollment table SectionID column.

Section_Number

7.0.0

Varchar2(10)

Source is Sections table Section_Number column.

StandardID

7.0.0

Number(10)

Source is Standards table ID column.

StandardIdentifier

7.0.0

Varchar2(50)

Source is Standards table Identifier column.

StoreCode

7.0.0

Varchar2(200)

Source is PSM_ReportingTerm table Name column.

StudentID

7.0.0

Number(19)

Source is Students table. Required.

TeacherID

7.0.0

Number(10)

Source is Sections table Teacher column.

TermID

7.0.0

Number(10)

Source is Sections table TermID column.

YearID

7.0.0

Number(19)

Source is PSM_Term table SchoolYear column. Column value is calculated from this field. Required.

Copyright © 2021 PowerSchool Group LLC