Test Type - Universe Folder
Test Type
There can be multiple records for a given test type code in the dimension table (due to different test max/min/pass values or effective dates). Current Indicator represents the current/active record, out of those multiple records for a given test type. Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPECurrent Indicator
The first day of the year used for Testing Purposes Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPEEffective From Date
The last day of the year used for Testing Purposes Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPEEffective To Date
Highest score possible on a specific test Source: Health Banner or WH_USR Table: STVTESC or TEST_TYPE_OVERRIDE or EDU_EXAM_TYPETest Maximum Value
Lowest score possible on a given test Source: Health Banner or WH_USR Table: STVTESC or TEST_TYPE_OVERRIDE or EDU_EXAM_TYPETest Minimum Value
Test Score/Value for a specific test. Source: Defaulted to 0 or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPETest Pass Value
The full exam name given Source: Health Banner Table: STVTESCTest Type
Abbreviated Exam Names for given exam Source: Health Banner Table: STVTESCTest Type Code