Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEM INSTRUCTOR SCHEDULE DETAIL Table


XXX


Field Name

Description

Data Type

Length

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

6

SESSION_END_DATE

XXX

DATE

SESSION_MEETING_DATE

XXX

DATE

SESSION_MEETING_END_TIME

XXX

VARCHAR2

9

SESSION_MEETING_NO_OF_HOURS

XXX

NUMBER

7,2

SESSION_MEETING_START_TIME

XXX

VARCHAR2

9

SESSION_START_DATE

XXX

DATE

TEM_CLASS_KEY

XXX

VARCHAR2

10

TEM_INSTRUCTOR_KEY

XXX

VARCHAR2

10

TEM_LOCATION_KEY

XXX

VARCHAR2

10

TEM_PROVIDER_KEY

XXX

VARCHAR2

10

TEM_SESSION_CODE

XXX

VARCHAR2

10

TEM_SESSION_STATUS_KEY

XXX

VARCHAR2

5

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE