DM_HistoricalGrade (ver7.0.0)
Data Mart table containing references to Historical Grade records. This table is refreshed with data nightly from the PowerSchool core tables related to historical grades. Table is used by ReportWorks as a source when creating historical grades reports.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 7.0.0 | Number(19) | Source is a sequence. Required. |
SchoolID | 7.0.0 | Number(10) | Source is StoredGrades table. |
StoreCode | 7.0.0 | Varchar2(10) | Source is StoredGrades table. |
StoredGradesDCID | 7.0.0 | Number(10) | Source is StoredGrades table. Required. |
StudentID | 7.0.0 | Number(10) | Source is StoredGrades table. Required. |
TermBinsDCID | 7.0.0 | Number(10) | Source is TermBins table. |
TermsDCID | 7.0.0 | Varchar2(6) | Source is Terms table. |
TermID | 7.0.0 | Number(10) | Source is StoredGrades table. |
YearID | 7.0.0 | Number(10) | Source is StoredGrades table. |