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(20) | 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. |