StoredGrades, 31 (ver3.6.1)
All of the students' historical grade information is maintained in this table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AB_Course_Cmp_Fun_Flg | 5.2.1.5 | Varchar(2) | Course Completion Fund Flag – CCFF. For use by Alberta Canada for import and |
AB_Course_Cmp_Ext_Crd | 5.2.1.5 | Varchar(2) | Course Completion External Credential - CCEC. For use by Alberta Canada for import and reports. |
AB_Course_Cmp_Fun_Sch | 5.2.1.5 | Varchar(3) | Course Completion Funding Schedule - CCFS. For use by Alberta Canada for import and reports. |
AB_Course_Cmp_Met_Cd | 5.2.1.5 | Varchar(4) | Course Completion Method Code - CCMC. For use by Alberta Canada for import and reports. |
AB_Course_Eva_ Pro_Cd | 5.2.1.5 | Varchar(2) | Course Evaluation Province Code - CEPC. For use by Alberta Canada for import and reports. |
AB_Course_Cmp_Sta_Cd | 5.2.1.5 | Varchar(3) | Course Completion Status Code - CCSC. For use by Alberta Canada for import and reports. |
AB_Pri_Del_Met_ Cd | 5.2.1.5 | Varchar(3) | Primary Delivery Method Code - PDMC. For use by Alberta Canada for import and reports. |
AB_Lng_Cd | 5.2.1.5 | Varchar(2) | Language Code (Instruction) - LC. For use by Alberta Canada for import and reports. |
AB_Dipl_Exam_Mark | 5.2.1.5 | Varchar(3) | Diploma Exam Mark. For use by Alberta Canada for import and reports. |
AB_Final_Mark | 5.2.1.5 | Varchar(3) | Final (Blended) Mark. For use by Alberta Canada for import and reports. |
Absences | 3.6.1 | Float | A precalculated total of absences this student has in this course. Copied from the absences field in the CC record. |
Behavior | 3.6.1 | Varchar(7) | The Citizenship field in PGFinalGrades. |
Comment_Value (aka:Comment) | 3.6.1 | CLOB | Copied from TeacherComment field in CC table. Renamed in 5.2.0 |
Course_Equiv | 3.6.1 | Varchar(20) | Populated when entering a stored grade or editing a stored grade. This is not stored in the store final grades process. Currently used only for Texas State Reporting and is flag Y or N to indicate a loss of credit to excessive absences. |
Course_Name | 3.6.1 | Varchar(100) | Name of the course. Copied from the Course_Name field in the Course table. |
Course_Number | 3.6.1 | Varchar(20) | Course Number assigned. Copied from the Course_Number field in the Course table. |
Credit_Type | 3.6.1 | Varchar(20) | Copied from the CreditType field in the Course table. The type of credit this counts as toward graduation, such as Math or elective. |
Custom | 5.1.2 | CLOB | This field holds all the storedgrades' custom data in name/value pairs delimited by non-printable characters. |
DateStored | 3.6.1 | Date | The date the grade was stored. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
EarnedCrHrs | 3.6.1 | Float | Checks to see if the student earns that amount of credit based on the grade in the gradescale. |
ExcludeFromClassRank | 3.6.1 | Number(10,0) | Indicates whether this course grade should be excluded during class ranking. Valid values: 1=True, to be excluded, 0=False. |
ExcludeFromGPA | 3.6.1 | Number(10,0) | Indicates whether this course grade should be excluded during GPA calculations. Valid values: 1=True, to be excluded, 0=False. |
ExcludeFromGradeSuppression | 7.8.1 | Number(10,0) | Indicates whether this course grade should be excluded grade suppression calculation. Valid values: 1=True, to be excluded, 0=False. Defaults to 0. |
ExcludeFromGraduation | 7.8.1 | Number(10,0) | Indicates whether this course grade should be excluded during graduation calculations. Valid values: 1=True, to be excluded, 0=False. Defaults to 0. |
ExcludeFromHonorRoll | 3.6.1 | Number(10,0) | Indicates whether this course grade should be excluded during Honor Roll calculations. Valid values: 1=True, to be excluded, 0=False. |
ExcludeFromTranscripts | 7.8.0 | Number(10,0) | Indicates whether this course grade should be excluded from transcripts. Valid values: 1=True, to be excluded, 0=False. |
GPA_AddedValue | 3.6.1 | Float | Number to be added to GPA for this course. Usually for AP courses there is a bump to the GPA, such as 0.125. |
GPA_Custom1 | 3.6.1 | Varchar(79) | Used by Texas State Reporting. Stores Explanation Code. This indicates Honors course, High School course satisfactorily completed before grade 9, Course taken for Local Credit, etc. Also to store this information at the Course and Section level, but it could possibly be stored grade specific. |
GPA_Custom2 | 3.6.1 | Float | Used by Texas State Reporting. Stores the Pass Fail Credit Indicator. The state does not care what the specific grade is. Instead they want to know whether or not a course was passed and, if not, why. The have a list of codes to choose from. |
GPA_Points | 3.6.1 | Float | If the class counts in the GPA it figures how many points this is worth based on the points in the grade scale. |
Grade | 3.6.1 | Varchar(7) | The letter grade for this student for this section from PGFinalGrades unless the attendance threshold is not met. |
GradeReplacementPolicy_ID | 7.9.0 | Number(10,0) | The internal number and ID of the associated GradeReplacementPolicy record. |
GradeScale_Name | 3.6.1 | Varchar(50) | Name of the Gradescale associated to the Section ID. |
Grade_Level | 3.6.1 | Number(10,0) | The grade level the student was in when the grade was stored. This simply copies the students' current grade level in to this field. Indexed. |
IsEarnedCrHrsFromGB | 6.2.1 | Number(10,0) | 1 indicates the EarnedCrHrs value has been applied from EarnedVarCreditValue in PGFinalGradeAttrib. |
IsPotentialCrHrsFromGB | 6.2.1 | Number(10,0) | 1 indicates the PotentialCrHrs value has been applied from PotentialVarCreditValue in PGFinalGradeAttrib. |
Log | 3.6.1 | CLOB | Tracks the date, time, userID, SchoolID and whether the record was created or modified. |
Percent | 3.6.1 | Float | The percentage grade earned at the time. This is copied from the students' current percent in their PGFinaGrades record at the time of storage. |
PotentialCrHrs | 3.6.1 | Float | The credit hours from Courses table - the amount to award specified for the store procedure. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus.If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
Replaced_DCID | 7.8.0 | Number(10,0) | The DCID of the grade record that replaced this grade record. |
Replaced_Equivalent_Course | 7.9.0 | Varchar(20) | If different from the Course_Number of this record, the Course_Number used by the repeated course grade suppression process when calculating permanently store grades. |
Replaced_Grade | 7.8.0 | Varchar(2) | During the Permanently Store Grades process, repeated course grade suppression may be evaluated by the repeated course grade suppression rules. Valid values: R=Stored grade is for a replaced course grade, Blank=Stored grade is not for a replaced course grade, M=Maximum credit hours. R grades can be included in or excluded from transcripts, graduation, GPA calculations, class rank calculations, and honor roll calculations. M grades can be included in or excluded from graduation. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. Indexed. Note: This is the school that stored the grade and not necessarily the school the class was taken. |
SchoolName | 3.6.1 | Varchar(31) | Name of school associated to this record. This is the school where the class was actually taken. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. |
StoreCode | 3.6.1 | Varchar(10) | The code used to represent this grade level to TermID and SchoolID. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Tardies | 3.6.1 | Float | A precalculated total of tardies this student has in this course. Copied from the tardies field in the CC record. |
Teacher_Name | 3.6.1 | Varchar(305) | Name of Teacher who assigned this grade. Converted from the teacher ID stored in the students CC record. |
TermBinsName | 7.6 | Varchar(8) | The TermBin name for the source TermBin of this stored grade. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term this class was offered. This also needs to be school related because this ID is duplicated on that table. Indexed. |