Standard (ver9.0.0)
This table is used to store the standards the district needs/wants to assess students on.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ConversionScale | 9.0.0 | Number(10,0) | The conversion scale this standard uses to convert percentages into the standard score they want to be displayed. |
DeactivateDate | 9.0.0 | Timestamp(6) | The date a standard went from being active to inactive. |
Description | 9.0.0 | Varchar2(4000) | The actual standard stating objectives and criteria. |
DisplayPosition | 9.0.0 | Number(10,0) | The order to show items if they have the same list parent and you do not want it done in alpha order. Required. |
ExternalID | 10.1.0 | Varchar2(50) | An identifier to reference the unique ID of the standard from an external provider, such as Academic Benchmarks. |
GradeScaleItemDCID | 9.0.0 | Number(10,0) | Foreign Key. Internal number for the associated GradeScaleItem.DCID record. Indexed. |
Identifier | 22.5.0 | Varchar2(50) | Code used by administrators for reporting and by teachers for designating to assignments. Must be unique. Indexed. Required. |
ImportBatchTracking | 9.0.0 | Varchar2(30) | A name given to an import batch run to track what rows were inserted for anyone run. |
IsActive | 9.0.0 | Number(1,0) | Is this standard active. Applies to PowerTeacher Pro. Valid values: 0 = Not Active, 1 = Active. Defaults to 1. Required. |
IsAssignmentAllowed | 9.0.0 | Number(1,0) | Indicates if this standard shows up for teachers to assign from PowerGrade. Valid values: 0 = False, 1 = True. Defaults to 1. Required. |
IsCommentIncluded | 9.0.0 | Number(10,0) | Is a comment included. Valid values: 0 = No Comment, 1 = Comment. Defaults to 0. Required. |
IsExcludedFromReports | 9.0.0 | Number(1,0) | Is this standard excluded from reports. Valid values: 0 = Standard Included in Report, 1 = Standard Excluded from Report. Defaults to 0. Required. |
LongitudinalID | 9.0.0 | Number(10,0) | The a unique key of the table when combined with the year ID. Contains the legacy DCID value for records migrated from table Standards. Required. |
MaxCommentLength | 9.0.0 | Number(10,0) | The approximate number of characters allowed when entering a standard grade comment. Valid values: 0 - 4000, Defaults to 4000. Required. |
Name | 9.0.0 | Varchar2(400) | The name of the standard. Required. |
ParentStandardID | 9.0.0 | Number(10,0) | Foreign Key. The hierarchical parent standard ID of the standard you want this standard to be listed under. Indexed. |
ParentStandardID_NVL | 12.1.1 | Number(10,0) | Virtual column. If the value of ParentStandardID is not NULL then ParentStandardID is returned. If the value is NULL then -1 is returned. Indexed. |
PSGUID | 9.0.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
StandardID | 9.0.0 | Number(10,0) | Primary Key. Unique sequential number generated by the application. Indexed. Required. |
SubjectArea | 9.0.0 | Varchar2(40) | For reference to the subject with which this standard is associated. |
TransientCourseList | 9.0.0 | CLOB | Deprecated column. Contains a comma-separated list of courses for the standard. |
WhenCreated | 9.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.0.0 | Varchar2(100) | The user login that created the record. Defaults to the database user. Required. |
WhoModified | 9.0.0 | Varchar2(100) | The user login that modified the record. Defaults to the database user. Required. |
YearID | 9.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Required. |