PSRW_StandardGrade (ver7.0.0)
This view returns standards grade records. The main source tables for this view are PSM_ReportCardItemGrade, PSM_ReportCardItemComment, and DM_StandardGrade. The DM_StandardGrade table is refreshed with data nightly from the PowerSchool core tables from PowerTeacher Gradebook (PTG).
Note: This table does not include Standard Grade records from PowerTeacher Pro.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActualGradeEntered | 7.0.0 | Varchar2(8) | Source is PSM_ReportCardItemGrade table ActualGradeEntered column. |
AllowScore | 7.0.0 | Number(10) | Source is PSM_Standard table AllowScore column. |
Corequisites | 7.0.0 | Varchar2(4000) | Source is Courses table Corequisites column. |
Course_Name | 7.0.0 | Varchar2(40) | Source is Courses table Course_Name column. |
Course_Number | 7.0.0 | Varchar2(11) | Source is Sections table Course_Number column. |
Credit_Hours | 7.0.0 | Number | Source is Courses table Credit_Hours column. |
CreditType | 7.0.0 | Varchar2(20) | Source is Courses table CreditType column. |
CrhrWeight | 7.0.0 | Number | Source is Courses table CrHrWeight column. |
DateEnrolled | 7.0.0 | Date | Source is PSM_SectionEnrollment table. |
DateLeft | 7.0.0 | Date | Source is PSM_SectionEnrollment table. |
Exclude_ADA | 7.0.0 | Number(10) | Source is Sections table Exclude_ADA column. |
ExcludeFromClassRank | 7.0.0 | Number(10) | Source is Sections table ExcludeFromClassRank column. |
ExcludeFromGPA | 7.0.0 | Number(10) | Source is Sections table ExcludeFromGPA column. |
ExcludeFromHonorRoll | 7.0.0 | Number(10) | Source is Sections table ExcludeFromHonorRoll column. |
Expression | 7.0.0 | Varchar2(80) | Source is Sections table Expression column. |
GradeScaleDescription | 7.0.0 | Varchar2(4000) | Source is PSM_GradeScale table Description column. |
GradeScaleID | 7.0.0 | Number(19) | Source is PSM_GradeScale table ID column. |
GradeScaleName | 7.0.0 | Varchar2(50) | Source is PSM_GradeScale table Name column. |
House | 7.0.0 | Varchar2(10) | Source is Sections table House column. |
ID | 7.0.0 | Number(19) | Source is a sequence. |
IsCalculated | 7.0.0 | Number(3) | Source is psm_reportcarditemgrade table IsCalculated column. |
LastUpdated | 7.0.0 | Date | Source is psm_reportcarditemgrade table LastUpdated column. |
MaxEnrollment | 7.0.0 | Number(10) | Source is Sections table MaxEnrollment column. |
No_Of_Students | 7.0.0 | Number(10) | Source is Sections table No_of_Students column. |
Original_Expression | 7.0.0 | Varchar2(80) | Source is Sections table Oiginal_Expression column. |
Parent_Section_ID | 7.0.0 | Number(10) | Source is Sections table Parent_Section_ID column. |
ParentStandardID | 7.0.0 | Number(19) | Source is PSM_Standard table ParentStandardID column. |
ParentStandardIdentifier | 7.0.0 | Varchar2(10) | Source is Standards table Identifier column. |
PreRequisites | 7.0.0 | Varchar2(4000) | Source is Courses table PrerequisitesValue column. |
Remaining_Available_seats | 7.0.0 | Number | Source is Sections table calculated from columns MaxEnrollment and No_of_Students. |
ReportCardCommentText | 7.0.0 | Varchar2(4000) | Source is PSM_ReportCardItemComment table CommentText column. |
ReportCardItemDescription | 7.0.0 | Varchar2(4000) | Source is PSM_Standard table Description column. |
ReportCardItemName | 7.0.0 | Varchar2(300) | Source is PSM_Standard table Name column. |
RoomNumber | 7.0.0 | Varchar2(10) | Source is Sections table Room column. |
Sched_Department | 7.0.0 | Varchar2(12) | Source is Courses table Sched_Department column. |
Sched_Do_Not_Print | 7.0.0 | Number(10) | Source is Courses table Sched_Do_Not_Print column. |
Sched_LunchCourse | 7.0.0 | Number(10) | Source is Courses table Sched_LunchCourse column. |
SchoolID | 7.0.0 | Number(10) | Source is Sections table SchoolId column. |
SchoolName | 7.0.0 | Varchar2(60) | Source is Schools table Name column. |
SchoolYear | 7.0.0 | Number(10) | Source is PSM_Term table SchoolYear column. |
Section_Number | 7.0.0 | Varchar2(10) | Source is Sections table Section_Number column. |
SectionID | 7.0.0 | Number(10) | Source is Sections table ID column. |
SortOrder | 7.0.0 | Number(10) | Source is PSM_Standard table SortOrder column. |
StandardID | 7.0.0 | Number(10) | Source is Standards table ID column. |
StandardIdentifier | 7.0.0 | Varchar2(20) | Source is PSM_Standard table Identifier column. |
StoreCode | 7.0.0 | Varchar2(30) | Source is PSM_ReportingTerm table Name column. |
StudentID | 7.0.0 | Number(19) | Source is Students table. |
SubjectArea | 7.0.0 | Varchar2(50) | Source is PSM_SubjectArea table Name column. |
TeacherID | 7.0.0 | Number(10) | Source is Sections table Teacher column. |
TeacherName | 7.0.0 | Varchar2(41) | Source is Teachers table concatenated First_Name and last_name columns. |
TermCode | 7.0.0 | Varchar2(30) | Source is PSM_Term table TermCode column. |
TermID | 7.0.0 | Number(10) | Source is Sections table TermID column. |
TermName | 7.0.0 | Varchar2(4000) | Source is PSM_Term table Description column. |
YearID | 7.0.0 | Number | Source is PSM_Term table SchoolYear column. Column value is calculated from this field. |