Standards (ver9.0.0)
This view, formerly the Standards table, provides information about the standards the district need/wants to assess students on.
Note: This view maintains compatibility for SQL written prior to PowerSchool SIS 9.0. This view is no longer used for active development.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AllowAssignments | 3.6.1 | Number(10,0) | [From Standard.isAssignmentAllowed] Indicates if this standard shows up for teachers to assign from PowerGrade. True or False. |
ConversionScale | 3.6.1 | Number(10,0) | [From Standard.conversionscale] The conversion scale this standard uses to convert percentages into the standard score they want displayed. |
Courses | 3.6.1 | CLOB | [From Courses.course_number] Comma separated list of courses with which this standard it associated. For school standards only. |
DCID | 4.0.0 | Number(10,0) | [From Standard.LongitudinalId] Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | [From Standard.description] The actual standard stating objectives and criteria. |
ID | 3.6.1 | Number(10,0) | [From Standard.LongitudinalId] Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Identifier | 3.6.1 | Varchar( 20) | [From Standard.identifier] Code used by administrators for reporting and by teachers for designating to assignments. Must be unique. Indexed. |
IncludeComment | 4.2.1 | Number(10,0) | [From Standard.isCommentIncluded] Standards comment value, if applicable. |
Level | 3.6.1 | Number(10,0) | It is a reference pointer for the end user to indicate where it is in the parent child chain. |
ListParent | 3.6.1 | Varchar( 20) | [From Standard.identifier] of the parent record. The hierarchical identifier of the standard you want this standard to be listed under. Indexed. |
MaxCommentLength | 7.0.3 | Number(10) | [From Standard.maxcommentlength] The approximate number of characters allowed when entering a standard grade comment. Valid values: 0 – 4000, Defaults to 4000. Required. |
Name | 3.6.1 | Varchar(80) | [From Standard.name1] The name of the standard. |
PSGUID | 7.8.0 | Varchar(50) | [From Standard.psguid] If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SortOrder | 3.6.1 | Number(10,0) | [From Standard.DisplayPosition] The order to show items if they have the same list parent and you don't want it done in alpha order. |
SubjectArea | 3.6.1 | Varchar(40) | [From Standard.subjectarea] For reference as to which the subject with which this standard is associated. |