Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse REWARDS RECOGNITION MAP Table


View exposing mappings between rewards-and-recognition groups, cost collectors, and HR organizational units including effective dates.


Field Name

Description

Data Type

Length

COST_COLLECTOR_ID

Business identifier for the cost collector.

VARCHAR2

7

HR_ORG_UNIT_ID

Business identifier for the hr org unit.

VARCHAR2

46

RR_GROUP

Rr group associated with the record.

VARCHAR2

100

RR_GROUP_CODE

Code identifying rr group.

VARCHAR2

10

RR_MAP_BEGIN_DATE

Date associated with rr map begin.

DATE

RR_MAP_END_DATE

Date associated with rr map end.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE