Test Type

Current Indicator

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_TYPE

Effective From Date

The first day of the year used for Testing Purposes

Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE

Effective To Date

The last day of the year used for Testing Purposes

Source: Derived or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE

Test Maximum Value

Highest score possible on a specific test

Source: Health Banner or WH_USR Table: STVTESC or TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE

Test Minimum Value

Lowest score possible on a given test

Source: Health Banner or WH_USR Table: STVTESC or TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE

Test Pass Value

Test Score/Value for a specific test.

Source: Defaulted to 0 or WH_USR Table: TEST_TYPE_OVERRIDE or EDU_EXAM_TYPE

Test Type

The full exam name given

Source: Health Banner Table: STVTESC

Test Type Code

Abbreviated Exam Names for given exam

Source: Health Banner Table: STVTESC