PSSIS_Standards (ver5.0.0)
This view provides information from the Standards and Gen tables.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ID | 5.0.0 | Longint | [From Standards] The Standards Identifier. Indexed. |
AllowAssignments | 5.0.0 | Longint | [From Standards] The Allowed Assignments for this Standard. |
CalculationParent | 5.0.0 | String20 | [From Standards] Standards Parent Calculation. |
ConversionScaleName | 5.0.0 | String50 | [From Gen] The Conversion Scale Name where the gen.category = 'stdconvscale'. |
ConversionScaleText | 5.0.0 | Text | [From Gen] The Conversion Scale Text value where the gen.category = 'stdconvscale'. |
ConversionScaleReal | 5.0.0 | Real | [From Gen] The Conversion Scale Real value where the gen.category = 'stdconvscale'. |
Courses | 5.0.0 | Text | [From Standards] Course information from the Standards table. |
StandardDescription | 5.0.0 | Text | [From Standards] The standards description. |
Identifier | 5.0.0 | String20 | [From Standards] Unique identifier for this Standard. |
IncludeComment | 5.0.0 | Longint | [From Standards] Standards comment text. |
LevelValue | 5.0.0 | Longint | [From Standards] Standards Level Value. |
ListParent | 5.0.0 | String20 | [From Standards] Parent standard value. |
Name | 5.0.0 | String80 | [From Standards] Standard name value. |
SubjectArea | 5.0.0 | String40 | [From Standards] Specific subject area for this Standard. |
Type | 5.0.0 | String8 | [Derived] Depending upon the Standards type value (e.g., 'National', 'District', 'State', 'School'). |