Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HASS CONCENTRATION Table


View exposing HASS concentration reference data including concentration code, name, active indicator, and modification date.


Field Name

Description

Data Type

Length

HASS_CONCENTRATION_CODE

Code identifying hass concentration.

VARCHAR2

4

HASS_CONCENTRATION_KEY

Surrogate key identifying the hass concentration.

VARCHAR2

32

HASS_CONCENTRATION_NAME

Hass concentration name associated with the record.

VARCHAR2

60

IS_ACTIVE

Indicator identifying whether active (Y/N).

VARCHAR2

1

MODIFIED_DATE

Date associated with modified.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE