CC, 4 (ver3.6.1)
This table maintains the student schedules. It contains information such as Section ID, Student ID, Term ID and Teacher ID.
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 reports. |
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_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. |
AsmtScores | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Attendance | 3.6.1 | CLOB | The actual attendance record for this course. It is stored in a text string using blanks to represent the student as present. |
Attendance_Type_Code | 3.6.1 | Number(10,0) | If this record is associated to a Parent Section then 0 is assigned, otherwise if associated to a Child Section then 1 is assigned. Indexed. |
Log | 3.6.1 | CLOB | Stores information when importing schedules or when classes are dropped. |
Course_Number | 3.6.1 | Varchar(20) | The course number associated with this class. This is implied by the SectionID but stored here for convenience. Indexed. |
CurrentAbsences | 3.6.1 | Number(10,0) | A precalculated total of absences this student has in this course. |
CurrentTardies | 3.6.1 | Number(10,0) | A precalculated total of tardies this student has in this course. |
Custom | 3.6.1 | CLOB | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DateEnrolled | 3.6.1 | Date | The date the student was enrolled in the class. Indexed. |
DateLeft | 3.6.1 | Date | The date the student exited the class. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Expression | 3.6.1 | Varchar(80) | The internal schedule expression from the Sections.Expression field. Represents the day and period the class is offered. May contain multiple if offered over several days, such as 2(A) would be read as 2nd period A days. |
FinalGrades | 3.6.1 | CLOB | |
FirstAttDate | 3.6.1 | Date | Marks the date that attendance was to begin calculating for this student in this class. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. Indexed. |
LastAttMod | 3.6.1 | Date | Tracks the date the attendance was modified. This field is used to speed up attendance calculations by avoiding sections that don't need calculation. Indexed. |
LastGradeUpdate | 3.6.1 | Date | The date this record was last updated from PowerTeacher Gradebook. Note: This field is no longer used as part of PowerTeacher Pro. |
OrigSectionID | 3.6.1 | Number(10,0) | This field triggers an enrollment or withdrawal in a class in the future:
|
Period_Obsolete | 3.6.1 | Varchar(7) | The period this class meets but it is replaced by Expression making this column obsolete. This used to be named just Period. |
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. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. |
Section_Number | 3.6.1 | Varchar(10) | The section number associated with this class. This is implied by the SectionID but stored here for convenience. |
StudYear | 3.6.1 | Number(10,0) | The Student ID * 100 + YearID. Speeds selection of student courses this year. Indexed. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
StudentSectEnrl_GUID | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
TeacherComment | 3.6.1 | CLOB | Public comments stored by the teacher in PowerGrade for this student in this class. |
TeacherID | 3.6.1 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
TeacherPrivateNote | 4.3.0/5.0.7 | CLOB | Used for Teacher Private Notes (not visible to Parents) in Support of PowerGrade. |
TermID | 3.6.1 | Number(10,0) | The internal number for the term to which this CC record is associated. Indexed. |
Unused2 | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Unused3 | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |