SectionReadiness (ver11.0.0)
This table stores data teachers' grades that have been verified and are ready for report cards. Data is stored per section and store code.
Note: This is used by both PowerTeacher Pro (as teachers make updates) and PowerSchool administrators (as administrators view its report).
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
IsVerified | 11.0.0 | Number(1,0) | Indicates if teachers grades have been verified and are ready for report cards. Valid values are 0 (not verified), 1 verified; Defaults to 0. Required |
SectionDCID | 11.0.0 | Number(10,0) | DCID of the related Sections table row. Required. Indexed. |
SectionReadinessID | 11.0.0 | Number(16,0) | Sequential number generated by the application, uniqueness in the table is guaranteed. Indexed.Required. |
StoreCode | 11.0.0 | Varchar(8) | The code used to store grades for this term. Often matches the term abbreviation. Usually one letter then one number. Required. |
VerifiedComment | 11.0.0 | Varchar2(4000) | Comment related to the verification. |
VerifiedDate | 11.0.0 | Date | Date on which verification took place. |
WhenCreated | 11.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 11.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 11.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
WhoModified | 11.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. Required. |