REWARDS RECOGNITION MAP Table
Mapping of org units to costs objects used by the Rewards and Recognition Office
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
7 |
HR_ORG_UNIT_ID |
8-digit unique number generated by SAP for each org unit. All levels within the HR org hierarcy (e.g. school, department, sub-department) are assigned an HR Org Unit ID. |
VARCHAR2 |
8 |
RR_GROUP |
Description matching RR_GROUP_CODE. Describes the grouping of hr org units with cost objects for the purposes of Rewards and Recognition Office |
VARCHAR2 |
100 |
RR_GROUP_CODE |
Code created in SAP HR to pull together hr org unit ids and cost objects for the purposes of Rewards and Recognition |
VARCHAR2 |
10 |
RR_MAP_BEGIN_DATE |
The Start Date of the relationship between the Cost Collector and Org Unit as defined by the Rewards and Recognition Office |
DATE |
8 |
RR_MAP_END_DATE |
The End Date of the relationship between the Cost Collector and Org Unit as defined by the Rewards and Recognition Office |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |