PSSIS_Student_Test_Scores (ver5.0.0)
This view provides Test Score information related to Students.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Name | 5.0.0 | String35 | [From Students] The Student Last Name, First Name. Indexed. |
Special_Ed_Student | 9.0.0 | String3 | [From Gen,SpEnrollments] Indicates if student in any special program for the current day. |
Student_Number | 5.0.0 | Real | [From Students] The unique Student identifier. Indexed. |
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. |
Test_Name | 5.0.0 | String35 | [From Test] Name provided for this test, such as ACT I, SAT2, etc. Indexed. |
Test_Date | 5.0.0 | Date | [From StudentTest] The date this test was given. Indexed. |
Test_Subtest | 5.0.0 | String35 | [From TestScore] Name provided for this test score. Ex; Verbal, Math. |
Num_score | 5.0.0 | Real | [From StudentTestScore] The numeric score student received for this test. |
Alpha_Score | 5.0.0 | String20 | [From StudentTestScore] The letter grade student received for this test. |
Percent_Score | 5.0.0 | Real | [From StudentTestScore] The percentage score student received for this test. |