Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES FINANCIAL COUNT Table


View exposing counts of financial role assignments by roles function and cost collector used for access reporting and analysis.


Field Name

Description

Data Type

Length

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

COUNT

Count associated with the record.

NUMBER

ROLES_FUNCTION_KEY

Surrogate key identifying the roles function.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE