Contains information about various student tests, such as “English Level”, “Math Level”, “Basic Math”, etc. There will be a record for every test the student takes, so there is likely to be multiple records per student.
Oracle source: ReportsNet.TestScores
Oracle objects: sortest, spriden, stvtesc
Updated: nightly
Oracle Field/Calc | DW Field | Description or Sample |
PIDM | PIDM | Student’s internal Banner Id |
STUDENTID | STUDENTID | Banner Id of the student |
TESC_CODE | TESC_CODE | Test code. See Test Codes in Appendix |
TESC_DATE | TESC_DESC | Test code description. |
TEST_DATE | TEST_DATE | Date of the test |
TEST_SCORE | TEST_SCORE | The test score (9.9) |
ACTIVITY_DATE | ACTIVITY_DATE | When this record was added to Banner |
0 Comments