PSM_Standard (ver1.6)
This table contains information pertaining to standards. Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AllowScore | 1.6 | Number(10,0) | 1 indicates a new column in final grade mode for the ReportCardItem, 0 indicates only for display in related grades tab in the detail pane. |
Description | 1.6 | Varchar2(4000) | The actual standard stating objectives and criteria. Required. |
GradeScaleID | 1.6 | Number(19,0) | Internal ID of the PSM_GradeScale record to which this record is associated. |
ID | 1.6 | Number(19,0) | Unique sequential number generated by the application. Required. |
Identifier | 1.6 | Varchar2(20) | Code used by administrators for reporting and used by teachers for designating to assignments. Unique. Required. |
IncludeComment | 1.6 | Number(10,0) | 1 indicates a child ReportCardItem is created for the standard comment . |
MaxCommentLength | 2.3 | Number(10) | The approximate number of characters allowed when entering a standard grade comment. Valid values: 0 – 4000, Default set to 4000. Required. |
Name | 1.6 | Varchar2(256) | Name of the standard. Required. |
ParentStandard ID | 1.6 | Number(19,0) | Internal ID of the parent PSM_Standard record to which this record is associated. |
SortOrder | 1.6 | Number(10,0) | If specified for children sort by this number lowest to highest when displaying standards. Otherwise sort by Identifier. |
SubjectAreaID | 1.6 | Number(19,0) | Internal ID of the PSM_SubjectArea record to which this record is associated. |
WhenCreated | 1.6 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 1.6 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 1.6 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 1.6 | Varchar2(100) | The user login that modified the record. Defaults to database user. |