Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EXTERNAL TEST TIME Table


View exposing time-related reference data associated with external tests used in student records processing and reporting.


Field Name

Description

Data Type

Length

EXTERNAL_TEST_TIME_KEY

Surrogate key identifying the external test time.

VARCHAR2

6

TEST_TAKEN_MONTH

Test taken month associated with the record.

VARCHAR2

2

TEST_TAKEN_MONTH_DESC

Description of test taken month.

VARCHAR2

30

TEST_TAKEN_YEAR

Test taken year associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE