Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse IAP SUBJECT SESSION Table


View exposing IAP subject session detail including sequence, title, description, location, date, and session start and end times.


Field Name

Description

Data Type

Length

HAS_SESSION_INFO

Has session info associated with the record.

VARCHAR2

1

IAP_SUBJECT_SESSION_KEY

Surrogate key identifying the iap subject session.

VARCHAR2

32

SESSION_DATE

Date associated with session.

DATE

SESSION_DESCRIPTION

Description of session.

VARCHAR2

2000

SESSION_END_TIME

Time associated with session end.

VARCHAR2

6

SESSION_LOCATION

Session location associated with the record.

VARCHAR2

20

SESSION_SEQUENCE

Session sequence associated with the record.

NUMBER

3

SESSION_START_TIME

Time associated with session start.

VARCHAR2

6

SESSION_TITLE

Session title associated with the record.

VARCHAR2

150

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE