PSRW_CurrentGrade (ver7.0.0)
This view returns current grade records. The main source tables for this view are PGFinalGrades and DM_CurrentGrade. The DM_CurrentGrade table is refreshed with data nightly from the PowerSchool core tables.
Column Name | Initial | Data Type | Description |
---|---|---|---|
Citizenship | 7.0.0 | Varchar2(7) | Source is PGFinalGrades table for current grade records. |
Class_Expression | 7.0.0 | Varchar2(80) | Source is CC table Expression column. |
Comment_Value | 7.0.0 | Clob | Source is PGFinalGrades table for current grade records. |
CoRequisites | 7.0.0 | Clob | Source is Courses table. |
Course_End_Date | 7.0.0 | Date | Source is CC table DateLeft column. |
Course_Name | 7.0.0 | Varchar2(40) | Source is Courses table. |
Course_Number | 7.0.0 | Varchar2(12) | Source is Sections table. |
Course_Start_Date | 7.0.0 | Date | Source is CC table DateEnrolled column. |
Credit_Hours | 7.0.0 | Number | Source is Courses table. |
CreditType | 7.0.0 | Varchar2(20) | Source is Courses table. |
CrHrWeight | 7.0.0 | Number | Source is Courses table. |
EndDate | 7.0.0 | Date | Source is PGFinalGrades table for current grade records. |
Exclude_ADA | 7.0.0 | Number(10) | Source is Sections table. |
ExcludeFromClassRank | 7.0.0 | Number(10) | Source is Sections table. |
ExcludeFromGPA | 7.0.0 | Number(10) | Source is Sections table. |
ExcludeFromHonorRoll | 7.0.0 | Number(10) | Source is Sections table. |
Expression | 7.0.0 | Varchar2(80) | Source is Sections table. |
Grade | 7.0.0 | Varchar2(7) | Source is PGFinalGrades table for current grade records. |
GradeBookType | 7.0.0 | Number(10) | Source is PGFinalGrades table for current grade records. |
GradeScaleID | 7.0.0 | Number(10) | Source is Sections table. |
GradeScaleName | 7.0.0 | Varchar2(50) | Source is GradeScaleItem table. |
House | 7.0.0 | Varchar2(10) | Source is Sections table. |
ID | 7.0.0 | Number(19) | Source is a sequence. |
LastGradeUpdate | 7.0.0 | Date | Source is PGFinalGrades table for current grade records. |
MaxEnrollment | 7.0.0 | Number(10) | Source is Sections table. |
No_Of_Students | 7.0.0 | Number(10) | Source is Sections table. |
Original_Expression | 7.0.0 | Varchar2(80) | Source is Sections table. |
OverRideFG | 7.0.0 | Varchar2(2) | Source is PGFinalGrades table for current grade records. |
Parent_Section_ID | 7.0.0 | Number(10) | Source is Sections table. |
Percent | 7.0.0 | Number | Source is PGFinalGrades table for current grade records. |
Points | 7.0.0 | Number | Source is PGFinalGrades table for current grade records. |
PointsPossible | 7.0.0 | Number | Source is PGFinalGrades table for current grade records. |
PreRequisites | 7.0.0 | Clob | Source is Courses table. |
Remaining_Available_Seats | 7.0.0 | Number | Source is Sections table. Calculated from MaxEnrollment less No_of_Students. |
RoomNumber | 7.0.0 | Varchar2(10) | Source is Sections table. |
Sched_Department | 7.0.0 | Varchar2(12) | Source is Courses table. |
Sched_Do_Not_Print | 7.0.0 | Number(10) | Source is Courses table. |
Sched_LunchCourse | 7.0.0 | Number(10) | Source is Courses table. |
SchoolID | 7.0.0 | Number(10) | Source is Sections table. |
SchoolName | 7.0.0 | Varchar2(60) | Source is Sections table from the SchoolID. |
Section_Comment_Value | 7.0.0 | Clob | Source is Sections table. |
Section_Number | 7.0.0 | Varchar2(10) | Source is Sections table. |
SectionID | 7.0.0 | Number(10) | Source is PGFinalGrades table for current grade records. |
StartDate | 7.0.0 | Date | 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. |
TeacherName | 7.0.0 | Varchar2(41) | Source is Teachers table. |
TermAbbreviation | 7.0.0 | Varchar2(6) | Source is Terms table. |
TermID | 7.0.0 | Number(10) | Source is Sections table. |
TermName | 7.0.0 | Varchar2(30) | Source is Terms table. |
VarCredit | 7.0.0 | Number | Source is PGFinalGrades table for current grade records. |
YearID | 7.0.0 | Number(10) | Source is Terms table. |