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.

Here are the 4 benefits user entities that you can use in HCM extracts:

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.