Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TEM SESSION STATUS Table


View exposing TEM session-status reference data including status code, status description, cancel reason, and warehouse load date.


Field Name

Description

Data Type

Length

SESSION_CANCEL_REASON

Session cancel reason associated with the record.

VARCHAR2

50

SESSION_CANCEL_REASON_CODE

Code identifying session cancel reason.

VARCHAR2

4

SESSION_STATUS

Session status associated with the record.

VARCHAR2

30

TEM_SESSION_STATUS_CODE

Code identifying tem session status.

VARCHAR2

5

TEM_SESSION_STATUS_KEY

Surrogate key identifying the tem session status.

VARCHAR2

5

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE