Overview of Extracting Benefits Data Using User Entities in HCM Extracts
You can use benefits user entities in HCM Extracts to access benefits tables and extract data to make it available for reporting.
User Entity | Details |
---|---|
BEN_EXT_ENRT_RSLT_UE | Enrollment results |
BEN_EXT_ENRT_DPNT_UE | Enrollment results and dependents |
BEN_EXT_ENRT_BNF_UE | Enrollment results and beneficiaries |
BEN_EXT_ENRT_RTCVG_UE | Enrollment results, rates, and coverage |
Here's a diagram that summarizes the extract flow.
These user entities query the actual benefits transaction tables to pull in data from enrollments, dependents, beneficiaries, and rates along with a few additional supporting tables. There are over 400 database items that cover almost all attributes, such as basic person details, enrollment results, person events, covered dependents, beneficiaries, person habits, participant rate and coverage. You can use other BEN database items using formulas.
To use the user entities, you need to build a new extract definition in HCM Extracts. Here's a concise version of an extract definition that uses benefits user entities.