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
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
Requested by:
Approved by:
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
Requested by:
Approved by:
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
Requested by:
Approved by:
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
Requested by:
Approved by:
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
Requested by:
Approved by:
Test Type
The full exam name given
Source: Health Banner Table: STVTESC
Requested by:
Approved by:
Test Type Code
Abbreviated Exam Names for given exam
Source: Health Banner Table: STVTESC
Requested by:
Approved by: