Benefits (Transaction Data)
Technical name: 0HR_PA_BN_1
|
DataSource Type |
Transaction data |
|
Application Components |
Benefits Administration (0PA_BN) |
|
Available as from OLTP Release |
4.5B |
|
Available as from PlugIn Release |
PI-A 99 |
|
RemoteCube-Capable |
No |
This DataSource is generated by the function module HR_BW_EXTRACT_IS_BENPLAN.
This DataSource contains information about benefit plans and their costs for employer and employee per calendar year/month.
Delta updates are not supported.
|
Field in the |
Description |
Source Table |
Field in the |
|
BAREA |
Benefit area |
PA0171 |
BAREA |
|
BPLAN |
Benefit plan |
T5UBU |
BPLAN |
|
BEEPST |
Bonus employee post-tax cost/contribution |
--- |
--- |
|
BEEPRE |
Bonus employee pre-tax cost/contribution |
--- |
--- |
|
BERCTB |
Bonus employer contribution |
--- |
--- |
|
CALMONTH |
Calendar year/month |
--- |
--- |
|
CSTV1 |
Cost grouping |
--- |
--- |
|
COVGR |
Coverage grouping |
--- |
--- |
|
FLXGR |
Credit grouping |
--- |
--- |
|
CURRE |
Currency key |
--- |
--- |
|
KEYDT |
Date |
--- |
--- |
|
DEPCV |
Dependent coverage |
PA0167 |
BPCAT |
|
ELIGR |
Eligibility grouping |
--- |
--- |
|
ELIGIBLE |
Eligibility indicator |
--- |
--- |
|
EECGR |
Employee contribution grouping |
--- |
--- |
|
EEPST |
Employee post-tax cost/contribution amount |
--- |
--- |
|
EEPRE |
Employee pre-tax cost/contribution amount |
--- |
--- |
|
ERCTB |
Employer contribution amount |
--- |
--- |
|
ERCGR |
Employer contribution grouping |
--- |
--- |
|
ERCST |
Employer cost amount |
--- |
--- |
|
ERCRD |
Employer credit amount |
--- |
--- |
|
BENGR |
First program grouping |
PA0171 |
BENGR |
|
HICMP |
Highly compensated indicator |
PA0375 |
HICMP |
|
IMINC |
Imputed income |
--- |
--- |
|
PARTICIP |
Participation indicator |
--- |
--- |
|
PERNR |
Personnel number |
--- |
--- |
|
BPCAT |
Plan category |
T5UB1 |
BPCAT |
|
PLTYP |
Plan type |
T5UBA |
PLTYP |
|
OPTIO |
Plan option |
PA0167 PA0168 PA0377 |
BOPTI BCOVR LEVL1 |
|
ACCST |
Provider cost amount |
--- |
--- |
|
BSTAT |
Second program grouping |
PA0171 |
BSTAT |
You can select data for the initial load by time period and personnel number.
In order to improve system performance, you can exclude certain data from the extraction. If you do not require the data provided by the following fields, remove them from the transfer structure:
|
Field |
Data Provided |
|
COSTCONTRB |
Costs and contributions |
|
ELIGIBLE |
Eligibility |
|
CSTV1 |
Return values for Cost grouping feature |
|
COVGR |
Return values for Coverage grouping feature |
|
FLXGR |
Return values for Credit grouping feature |
|
ELIGR |
Return values for Eligibility grouping feature |
|
EECGR |
Return values for Employee contribution grouping feature |
|
ERCGR |
Return values for Employer contribution grouping feature |

In a full update, you should only extract data for past (closed) months. Furthermore, you should only extract data once for each month.