Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse COST COLLECTOR PARENT Table


XXX


Field Name

Description

Data Type

Length

COST_COLLECTOR_KEY

Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

12

PARENT_COST_COLLECTOR_KEY

XXX

VARCHAR2

12

RELATIONSHIP_TYPE_CODE

XXX

VARCHAR2

1

WAREHOUSE_LOAD_DATE

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

DATE