vStudent_Test_Scores view

Contains multiple records per student; each record with a different test type and its accompanying score.

Oracle source: ReportsNet. TEST_SCORES

Oracle objects: sortest

Updated: not necessary – this view pulls directly from the Oracle database

Oracle Field/Calc	Description or Sample
SPRIDEN_ID	Banner Id (@12345678)
Sortest_tesc_code	Test code
Stvtesc_desc	Test description
case when isdate(to_char(SORTEST_TEST_DATE), 'dd-mm-yyyy') = 1 then SORTEST_TEST_DATE else null end as TEST_DATE	Date of test
Sortest_test_Score	Test score
Sortest_activity_date	Date the record was entered in the sortest table