DM_CurrentGrade (ver7.0.0)
Data Mart table containing references to Current Grade records. This table is refreshed with data nightly from the PowerSchool core tables related to current grades. Table is used by ReportWorks as a source when creating current grades reports.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CCID | 7.0.0 | Number(10) | Source is CC table. Required. |
Course_Number | 7.0.0 | Varchar2(20) | Source is Sections table. |
GradeScaleID | 7.0.0 | Number(10) | Source is Sections table. |
GradeScaleItemDCID | 7.0.0 | Number(10) | Source is GradeScaleItem table. |
ID | 7.0.0 | Number(19) | Source is a sequence. Required. |
PGFinalGradesDCID | 7.0.0 | Number(10) | Source is PGFinalGrades table for current grade records. Required. |
SchoolID | 7.0.0 | Number(10) | Source is Sections table. |
SectionID | 7.0.0 | Number(10) | Source is PGFinalGrades table for current grade records. |
StoreCode | 7.0.0 | Varchar2(10) | Source is PGFinalGrades table for current grade records. |
StudentID | 7.0.0 | Number(10) | Source is PGFinalGrades table for current grade records. Required. |
TeacherID | 7.0.0 | Number(10) | Source is Sections table. |
TermID | 7.0.0 | Number(10) | Source is Sections table. |
TermsDCID | 7.0.0 | Number(10) | Source is Terms table. |
YearID | 7.0.0 | Number(10) | Source is Terms table. |