Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ACAD CHAIR COST COLLECTOR Table


Stores associations between academic chairs and cost collectors. Each row represents a chair?cost collector mapping.


Field Name

Description

Data Type

Length

ACAD_CHAIR_COST_COLLECTOR_KEY

Surrogate key identifying the academic chair cost collector mapping.

VARCHAR2

24

COST_COLLECTOR_ID

Identifier of the cost collector associated with the academic chair.

VARCHAR2

7

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

COST_COLLECTOR_TYPE

Type of cost collector associated with the academic chair.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE