Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PENSION COSTSHARE DETAIL Table


View exposing pension cost share records including employer and employee contributions and related financial attributes.


Field Name

Description

Data Type

Length

BENEFITS_COSTSHARE_TYPE_KEY

Surrogate key identifying the benefits costshare type.

VARCHAR2

30

COST_SHARE_COMMENT

Cost share comment associated with the record.

VARCHAR2

100

COST_SHARE_PERCENT

Cost share percent associated with the record.

NUMBER

5,2

PERSONNEL_KEY

Surrogate key identifying the personnel.

VARCHAR2

8

RECORD_VALID_FROM_DATE

Date associated with record valid from.

DATE

RECORD_VALID_TO_DATE

Date associated with record valid to.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE