Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OVERHEAD RATES Table


View exposing overhead rate records including rate values, effective dates, and related attributes used in financial allocation and costing processes.


Field Name

Description

Data Type

Length

ALLOC_OFFSET_COST_COLLECTOR_ID

Business identifier for the alloc offset cost collector.

VARCHAR2

7

OVERHEAD_KEY

Surrogate key identifying the overhead.

VARCHAR2

6

OVERHEAD_KEY_FLAG

Indicator identifying whether overhead key (Y/N).

VARCHAR2

1

OVERHEAD_KEY_TYPE

Overhead key type associated with the record.

VARCHAR2

4

RATE

Rate associated with the record.

NUMBER

11,2

RATE_VALID_FROM_DATE

Date associated with rate valid from.

DATE

RATE_VALID_THRU_DATE

Date associated with rate valid thru.

DATE

SURCHARGE_BASE_KEY

Surrogate key identifying the surcharge base.

VARCHAR2

4