TestScores

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