Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BURN RATE DETAIL Table


View exposing payroll burn rate detail records including cost collector, fiscal period, expense category, and average payroll expense measures used for payroll cost analysis and forecasting.


Field Name

Description

Data Type

Length

AVERAGE_AMOUNT

Average amount as provided by the source.

NUMBER

17,2

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

EXPENSE_CATEGORY_DESCRIPTION

Description of expense category.

VARCHAR2

40

TIME_MONTH_KEY

Surrogate key identifying the time month.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE