1. Implementing Benefits
  2. Overview of Extracting Benefits Data Using BENXML

Overview of Extracting Benefits Data Using BENXML

You can use Fusion Benefits Extracts, also known as BENXML, to populate the Benefits staging tables. Then, you use HCM Extracts to pull the staged data and make it available for reporting.

Here's a diagram that summarizes the extract flow.

Diagram that illustrates how you can extract date using BENXML and HCM Extracts

BENXML populates these staging tables with benefits data:
  • BEN_EXTRACT_REQUEST
  • BEN_EXTRACT_REQ_DETAILS

BENXML uses the carrier to filter benefits data before sending them to the staging tables. You configure the carrier using the Manage Plan Carriers task in the Plan Configuration work area. You then use the BEN_EXTRACT_JOINED_UE user entity in HCM Extracts to extract the staged data from the 2 tables. The BEN_EXTRACT_JOINED_UE user entity in HCM Extracts requires an additional carrier_id parameter. This is the same carrier ID that BENXML uses to filter and send benefits data to the staging tables.

Here's the structure of the extract definition that uses the BEN_EXTRACT_JOINED_UE user entity.

Diagram that shows the structure of the extract definition that uses the BEN_EXTRACT_JOINED_UE user entity