Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse IAP SUBJECT SESSION Table


Individual session asscoiated with an IAP non-credit activity.


Field Name

Description

Data Type

Length

HAS_SESSION_INFO

XXX

VARCHAR2

1

IAP_SUBJECT_SESSION_KEY

Use this field to join together the IAP_SUBJECT_DETAIL and IAP_SUBJECT_SESSION tables.

VARCHAR2

32

SESSION_DATE

XXX

DATE

7

SESSION_DESCRIPTION

XXX

VARCHAR2

2000

SESSION_END_TIME

XXX

VARCHAR2

6

SESSION_LOCATION

XXX

VARCHAR2

20

SESSION_SEQUENCE

XXX

NUMBER

22

SESSION_START_TIME

XXX

VARCHAR2

6

SESSION_TITLE

XXX

VARCHAR2

150

WAREHOUSE_LOAD_DATE

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

DATE

8