Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse DUNNING AREA Table


Dunning Areas used at the Institute. Can be joined to FINANCIAL_DETAIL using the field DUNNING_AREA_KEY.


Field Name

Description

Data Type

Length

DUNNING_AREA_CODE

The code identifying a unique Dunning Area

VARCHAR2

3

DUNNING_AREA_DESCRIPTION

The description of a Dunning Area

VARCHAR2

50

DUNNING_AREA_KEY

The key identifying a unique entry in the DUNNING_AREA table; should be used to join this table to others.

VARCHAR2

3

WAREHOUSE_LOAD_DATE

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

DATE

8