Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse IR SUM SALARY Table


View exposing summarized salary measures by person history key including original and FTE-adjusted salary base amounts for institutional research reporting.


Field Name

Description

Data Type

Length

FTE_ORIGINAL_BASE_AMOUNT

Fte original base amount associated with the record.

NUMBER

IR_PERSON_EMPLOYEE_HISTORY_KEY

Surrogate key identifying the ir person employee history.

VARCHAR2

13

ORIGINAL_BASE_AMOUNT

Original base amount associated with the record.

NUMBER