Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse COST COLLECTOR PARENT Table


View exposing parent-child relationships between cost collectors including relationship type and warehouse load date.


Field Name

Description

Data Type

Length

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

PARENT_COST_COLLECTOR_KEY

Surrogate key identifying the parent cost collector.

VARCHAR2

12

RELATIONSHIP_TYPE_CODE

Code identifying relationship type.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE