Benefits (Transaction Data)

Technical name: 0HR_PA_BN_1

Technical Data

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.

Use

This DataSource contains information about benefit plans and their costs for employer and employee per calendar year/month.

Delta Update

Delta updates are not supported.

Fields of Origin for the Extract Structure

Field in the
Extract Structure

Description

Source Table

Field in the
Source Table

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

Particular Features of the Extractor

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.