EXTERNAL TEST TIME Table
The time dimension table for the External Test Score Star Schema. It contains information about the year and the month the test was taken.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EXTERNAL_TEST_TIME_KEY |
Use this field to join together the EXTERNAL TEST TIME and the EXTERNAL TEST SCORE DETAIL tables. |
VARCHAR2 |
6 |
TEST_TAKEN_MONTH |
Month (in numeric) when the test was taken. |
VARCHAR2 |
2 |
TEST_TAKEN_MONTH_DESC |
Month when the test was taken. |
VARCHAR2 |
30 |
TEST_TAKEN_YEAR |
Year when the test was taken. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |