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|
[From Standard.isAssignmentAllowed] Indicates if this standard shows up for teachers to assign from PowerGrade. True or False.
[From Standard.conversionscale] The conversion scale this standard uses to convert percentages into the standard score they want displayed.
[From Courses.course_number] Comma separated list of courses with which this standard it associated. For school standards only.
[From Standard.LongitudinalId] Unique identifier for this table. Indexed. Required.
[From Standard.description] The actual standard stating objectives and criteria.
[From Standard.LongitudinalId] Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed.
[From Standard.identifier] Code used by administrators for reporting and by teachers for designating to assignments. Must be unique. Indexed.
[From Standard.isCommentIncluded] Standards comment value, if applicable.
It is a reference pointer for the end user to indicate where it is in the parent child chain.
[From Standard.identifier] of the parent record. The hierarchical identifier of the standard you want this standard to be listed under. Indexed.
[From Standard.maxcommentlength] The approximate number of characters allowed when entering a standard grade comment. Valid values: 0 – 4000, Defaults to 4000. Required.
[From Standard.psguid] If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus.
[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.
[From Standard.subjectarea] For reference as to which the subject with which this standard is associated.