PSRW_HistoricalGrade (ver7.0.0)
This view returns historical grade records. The main source tables for this view are StoredGrades and DM_HistoricalGrade. The DM_HistoricalGrade table is refreshed with data nightly from the PowerSchool core tables.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Absences | 7.0.0 | Number | Source is StoredGrades table. |
Behavior | 7.0.0 | Varchar2(7) | Source is StoredGrades table. |
Comment_Value | 7.0.0 | Clob | Source is StoredGrades table. |
Course_Name | 7.0.0 | Varchar2(40) | Source is StoredGrades table. |
Course_Number | 7.0.0 | Varchar2(11) | Source is StoredGrades table. |
Credit_Type | 7.0.0 | Varchar2(20) | Source is StoredGrades table. |
DateStored | 7.0.0 | Date | Source is StoredGrades table. |
EarnedCrHrs | 7.0.0 | Number | Source is StoredGrades table. |
ExcludeFromClassRank | 7.0.0 | Number(10) | Source is StoredGrades table. |
ExcludeFromGPA | 7.0.0 | Number(10) | Source is StoredGrades table. |
ExcludeFromHonorRoll | 7.0.0 | Number(10) | Source is StoredGrades table. |
GPA_AddedValue | 7.0.0 | Number | Source is StoredGrades table. |
GPA_Points | 7.0.0 | Float(126) | Source is StoredGrades table. |
Grade | 7.0.0 | Varchar2(7) | Source is StoredGrades table. |
Grade_Level | 7.0.0 | Number(10) | Source is StoredGrades table. |
GradeScale_Name | 7.0.0 | Varchar2(50) | Source is StoredGrades table. |
ID | 7.0.0 | Number(19) | Source is a sequence. |
Log | 7.0.0 | Clob | Source is StoredGrades table. |
Percent | 7.0.0 | Number | Source is StoredGrades table. |
PotentialCrHrs | 7.0.0 | Number | Source is StoredGrades table. |
SchoolID | 7.0.0 | Number(10) | Source is StoredGrades table. |
SchoolName | 7.0.0 | Varchar2(60) | Source is StoredGrades table. |
SchoolYear | 7.0.0 | Varchar2(30) | Source is Terms table. |
SectionID | 7.0.0 | Number(10) | Source is StoredGrades table. |
StoreCode | 7.0.0 | Varchar2(10) | Source is StoredGrades table. |
StoreCodeEndDate | 7.0.0 | Date | Source is TermBins table. |
StoreCodePortion | 7.0.0 | Varchar2(42) | Source is Terms table. |
StoreCodeStartDate | 7.0.0 | Date | Source is TermBins table. |
StoredGradesDCID | 7.0.0 | Number(10) | Source is StoredGrades table. |
StudentID | 7.0.0 | Number(10) | Source is StoredGrades table. |
Tardies | 7.0.0 | Number | Source is StoredGrades table. |
Teacher_Name | 7.0.0 | Varchar2(40) | Source is StoredGrades table. |
TermAbbreviation | 7.0.0 | Varchar2(6) | Source is Terms table. |
TermID | 7.0.0 | Number(10) | Source is StoredGrades table. |
TermName | 7.0.0 | Varchar2(30) | Source is Terms table. |
YearID | 7.0.0 | Number(10) | Source is StoredGrades table. |