Defining External Reward Data
PeopleSoft delivers the Total Rewards External Data data source that allows third-party compensation data to be incorporated and displayed in total reward statements. You can load external reward data into the delivered Total Rewards External Data (TRW_EX_TMP_DATA) table. There are a number of PeopleTools technologies you can use to load external reward data to PeopleSoft. For more information, refer to the Total Rewards - Loading and Viewing External Reward Data (document ID: 1460363.1, https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?id=1460363.1) red paper that is available on My Oracle Support.
Before loading the data, you need to define one or more external data IDs that are used to identify the data.
This topic discusses how to define external reward data.
Note: In addition to the delivered data sources, you have the ability to create your own reward data sources and incorporate them into your rewards statements. For more information, refer to the Total Rewards - How to Create a New Reward Data Source (document ID: 1541710.1, https://mosemp.us.oracle.com/epmos/faces/DocumentDisplay?id=1541710.1) red paper that is also available on My Oracle Support.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
TRW_EXTDATA_TBL |
Define an External Data ID that will identify the external data loaded into the External Rewards Data table. |
|
|
TRW_EXTERNAL_DATA |
Manually enter external data to the PeopleSoft system or update data that has been loaded to the system. |
Use the Define External Reward Data page (TRW_EXTDATA_TBL) to define an External Data ID that will identify the external data loaded into the External Rewards Data table.
Navigation
Image: Define External Reward Data page
This example illustrates the fields and controls on the Define External Reward Data page.
|
Field or Control |
Definition |
|---|---|
| External Data ID |
An abbreviation that uniquely identifies external rewards data. |
| Description |
A description of the external reward data that will be displayed in the total rewards detail. |
| Detail Description |
A detail description providing a functional explanation of the external rewards data that is being loaded into the External Rewards Data table. |
Use the Update External Reward Data page (TRW_EXTERNAL_DATA) to manually enter external data to the PeopleSoft system or update data that has been loaded to the system.
Navigation
Image: Update External Rewards Data page
This example illustrates the fields and controls on the Update External Rewards Data page.
|
Field or Control |
Definition |
|---|---|
| External Data ID |
An abbreviation that uniquely identifies external rewards data. |
| Description |
A description of the external reward data ID. |
| Rewards Date |
Date the reward was granted to the employee. |
| Currency Code |
The currency for the external reward data. |
| Employee Paid Amount |
The amount the employee paid or contributed to for the external reward data. |
| Employer Paid Amount |
The amount the employer paid or contributed to for the external reward data. |
| Company Provided Amount |
The amount the company provided for the external reward data. |
| Units |
The number of units for the external reward data. |
| Unit of Measure |
The Unit of Measure that displays for the external rewards data. The following is a list of the units of measures delivered:
|