PSSIS_Student_Stored_Standards (ver5.0.0)
This view provides Standards information related to Students. This will essentially be a join of the information from the Students, Standards and the StandardsGrades tables.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
Current_Grade_Level | 5.0.0 | Longint | [From Students] The Student's current grade level. Indexed. |
Current_School_Abbreviation | 5.0.0 | String20 | [From Schools] The Current School's abbreviation. |
Gender | 5.0.0 | String2 | [From Students] Gender indicator. Indexed. |
Ethnicity_Name | 5.0.0 | String50 | [From Gen] Ethnicity from the Gen table where category = 'Ethnicity'. |
Ethnicity_Code | 5.0.0 | String20 | [From Students custom field] The student's Primary Language as decoded in the CustomVarchars table. |
Special_Ed_Student | 5.0.0 | String3 | [From Students custom field] The student's Secondary Language as decoded in the CustomVarchars table. |
Standard_Identifier | 5.0.0 | String20 | [From Standards] Code used by administrators for reporting and by teachers for designating to assignments. Must be unique. Indexed. |
Standard_Name | 5.0.0 | String80 | [From Standards] The name of the standard. |
Subject_Area | 5.0.0 | String40 | [From Standards] For reference as to which the subject with which this standard is associated. |
Standard_Type | 5.0.0 | Longint | [From Standards] The subcategory this standard falls into. 1=National, 2=State, 3=District, 4=School. Indexed. |
Conversion_Scale_Name | 5.0.0 | String50 | [From Standards] The conversion scale this standard uses to convert percentages into the standard score they want displayed. |
Year | 5.0.0 | Longint | [From Standards] A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Indexed. |
Store_Code | 5.0.0 | String10 | [From StandardsGrades] The code used to represent this grade level to TermID and SchoolID. |
Number_Of_Scores | 5.0.0 | Longint | [From StandardsGrades] Number of scores which make-up the averages specified in the associated fields. |
High_Score | 5.0.0 | Real | [From StandardsGrades] High score for this student for this term. |
Average_Score | 5.0.0 | Real | [From StandardsGrades] Average score provided for this student fro this standard. School can either set up AverageScore, HighScore, TransAverageScore or TransHighScore to be entered. |
Translated_Average_Score | 5.0.0 | String50 | [From StandardsGrades] Translated average score provided for this student fro this standard. School can either set up AverageScore, HighScore, TransAverageScore or TransHighScore to be entered. Indexed. |
Translated_High_Score | 5.0.0 | String40 | [From StandardsGrades] Student High Score with the conversion scale applied. |
Comment_Value | 5.0.0 | Text | [From StandardsGrades] Comment associated with this specific standard. Note: Renamed in 5.2.0. |