Standards_Migration_Backup, 53 (ver3.6.1)
This table is no longer used by the application. The Standards table was renamed Standards_Migration_Backup. The Standard table has been created in its place.
Note: The information that appeared in the Standards table can now be viewed as the Standards reporting view.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AlignmentIdentifier | 3.6.1 | Varchar2(20) | Identify standard alignment to other types of standards; for example, from district to state or from state to national. |
AllowAssignments | 3.6.1 | Number(10,0) | Indicates if this standard shows up for teachers to assign from PowerGrade. True or False. |
CalculationParent | 3.6.1 | Varchar2(20) | The Identifier of the standard you want the scores in this standard to rollup to. |
ConversionScale | 3.6.1 | Number(10,0) | The conversion scale this standard uses to convert percentages into the standard score they want displayed. |
Courses | 3.6.1 | CLOB | Comma separated list of courses with which this standard is associated. For school standards only. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Required. Indexed. |
Description | 3.6.1 | CLOB | The actual standard stating objectives and criteria. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Identifier | 3.6.1 | Varchar2(20) | Code used by administrators for reporting and by teachers for designating to assignments. Must be unique. Indexed. |
IncludeComment | 4.2.1 | Number(10,0) | Standards comment value, if applicable. |
IsMigrated | 9.0.0 | Number(1,0) | Indicates if the row was migrated to the new Standards SIS view. |
ListParent | 3.6.1 | Varchar2(20) | The hierarchical identifier of the standard you want this standard to be listed under. Indexed. |
MaxCommentLength | 7.0.3 | Number(10,0) | The approximate number of characters allowed when entering a standard grade comment. Valid values: 0รป4000, Defaults to 4000 . Required. |
MigrationFailureReason | 9.0.0 | Varchar2(200) | Describes whether a row was successfully migrated or not. |
Name | 3.6.1 | Varchar2(80) | The name of the standard. |
OriginalIdentifier | 9.0.0 | Varchar2(20) | Records the original identifier if the original identifier was renamed due to an existing duplicate identifier. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and PearsonSuccessNet/PearsonSuccessNetPlus. Indexed. |
SortOrder | 3.6.1 | 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. |
SubjectArea | 3.6.1 | Varchar2(40) | For reference as to which the subject with which this standard is associated. |
Type | 3.6.1 | Number(10,0) | The subcategory this standard falls into.1 = National,2 = State,3 = District, 4 = School.Indexed. |
Unused1 | 4.2.1 | Number(10,0) | Currently unused field. |