Using the PrismHR Benefits Batch Offered Benefit Plan (OBP) Import

You can import PrismHR Benefits Batch Offered Benefit Plans (OBPs) from PrismHR.

You initiate the import by clicking the OBP Import link in the Action Center of the Benefits Batch dataform. A popup window displays that allows you to specify one of three import options:

  • Insert Only - Insert (i.e., add) OBPs from PrismHR that do not exist in ClientSpace.

  • Update Only - Update previously imported OBPs with any updates from PrismHR.

  • Both - Perform both inserting and updating of OBPs.

For the Update Only and Both options, you also have an additional Update Contributions option.

Once you select an import option and start the import, the system goes through the following steps:

  • Locate plans: Benefit Plans are located using the Client Number.

Note: This feature supports multi-tenancy. In multi-tenant environments where the Client Number may not be unique, Benefit Plans are located using the Import ID which is created using a combination of the Client Number and PEO ID.

  • Evaluate plan dates: Benefits data is only imported when the Benefits Batch effective date in ClientSpace is within a range that is greater than or equal to the PrismHR Benefit Plan Start Date and less than or equal to the PrismHR Benefit Plan End Date (i.e., the ClientSpace Benefits Batch effective date falls within the PrismHR plan start and end dates.)

  • Process each plan meeting the plan dates criteria: One plan at a time is processed.

  • Evaluate for a matching Rate Group: The system now tries to find a matching Rate Group between PrismHR and ClientSpace on the plan being processed. If a match is found, the risk factor details are retrieved for the appropriate plan effective dates. If no matching Rate Group is found, an error is logged and displayed when processing is complete.

  • Build Offered Plan data in ClientSpace: Offered benefit plans are added and/or updated based on the import option you selected. For new plans, any new Benefit Groups are also added.

  • Update contributions: Contributions are updated if you selected this option.

  • Save the Offered Benefit Plan: Each insert or update is saved in ClientSpace on the default pipeline.

    Note: The default pipeline represents default business rules or behaviors in the system. In this case, it determines which rules are applied when data is saved.

  • Display import results: At the end of import processing, the final import results display in the OBP Import from Prism window. The window shows the number of new groups, new OBPs, updated OBPs, skipped records and records with errors.

The feature is Inactive by default. Please contact your Professional Services team representative or log an extranet case for activation.

Before You Begin: Mapping Your PrismHR Coverage Levels

Mapping your PrismHR Coverage Levels in ClientSpace is typically a one-time step. Prism coverage level fields act as import mapping fields from the Prism Benefit Plan rules to ClientSpace Offered Plan Employee Contributions. This allows ClientSpace to correctly update ClientSpace Offered Plan contributions with contribution data imported from PrismHR.

ClientSpace does this by setting the Contribution Method field Employer Contributions section of the Offered Benefits Plan record to Manually Set Dollars, and then updating the Dollar Amount field for each coverage level (where a match could be made to a PrismHR coverage level).

You enter coverage level fields in the PrismHR Coverage Labels of the Benefits Plan dataform near the bottom of the form. You can add up to five (5) labels as shown in the example below:

Benefits Plan Prism Coverag Levels

Coverage level labels can be set from the following locations:

  • The Admin Workspace for master benefit plans and model benefit plans (which are managed in the Admin Workspace like master plans but are used as templates for client-level plans.)

  • Directly in a client workspace for client-level plans.

If you leave the fields blank, ClientSpace uses the following default PrismHR values:

  • EE for CoverageLevel1

  • ES for CoverageLevel2

  • EC for CoverageLevel3

  • EF or FAM for CoverageLevel4

  • EK for CoverageLevel5

Note: 

  • The default values will not populate the PrismHR Coverage Labels fieldset. Only your entries (if provided) are ever displayed in the fieldset otherwise the fields are blank. The default values are the typical values defined in PrismHR as the Plan Type. If your Plan Type values differ from the default values, you should map the fields in the PrismHR Coverage Labels fieldset as shown in the example image above.

  • If you do not set coverage level labels and the system cannot make a match using default values, contribution updates are skipped. In the case of new offered benefit plans, this will result in contribution amounts being left blank.

  • When you set coverage level labels on an Active plan, upon renewing the plan, the labels are carried forward to the new plan.

To set PrismHR Coverage Labels:

  1. Open the Active Benefits Plan where you want to set the labels.
  2. Scroll to the Prism Coverage Labels section.
  3. Enter the desired PrismHR label names in CoverageLevel1 through CoverageLevel5 as applicable.
  4. Click Save or Apply.

Importing OBPs

To import OBPs from PrismHR:

  1. Access the Benefits Batch to which you will import OBPs.

    1. From the modules bar, click Workspaces.
      The Workspace Search dashboard opens.
    2. Select the desired workspace and click (Open).
      The Workspace page opens.

    3. Move down the page to the administrative tiles where you see the dataform categories.

    4. Enter "Benefits Batch" in the search for dataform field and then click the Benefits Batch tile.

      The Benefits Batch search window displays.

    5. Open the desired batch by double-clicking it or by clicking click (Open) next to it.

  2. On the Benefits Batch form, in the Action Center under Links, click OBP Import.

    Benefits Batch Window with Renew Link Highlighted

    The Plan Import from PrismHR window displays.

  3. Select an import option from the Action field:

    • Insert Only: Insert (i.e., add) OBPs from PrismHR that do not exist in ClientSpace.

    • Update Only: Update previously imported OBPs with any updates from PrismHR.

    • Both: Perform both inserting and updating of OBPs.

  4. What do you want to do?

    • To update contributions: If you selected Update Only or Both options in Step 3, you also have an additional Update Contributions option. Select Update Contributions if you want to update the Employer Contributions sections of any Offered Benefit Plans where the contributions amounts have been updated in PrismHR.

      Note: Your coverage level labels should have been reviewed and appropriately mapped at this point. See the preceding Before You Begin: Mapping Your PrismHR Coverage Levels section for details.

    • To import a single plan: If you selected Update Only in Step 3, an Option field displays. Select All Plans if you want to import all plans or select Single Plan if you want to import a single OBP.

      If you select Single Plan, the Plan field displays. Select the OBP to import.

  5. Click Import.

    When the process is complete, the Plan Import from PrismHR window displays Done along with import details and import totals:

    Note: "Skipped" indicates the number of records that were skipped, but not because of an error. For instance, a record may have met the date criteria but was skipped because it was previously imported and already up to date. "Errored" indicates that an error such as "Could not find a matching Benefit Plan" or "Could not find a matching Rate Group" was encountered that prevented the record from being inserted or updated. Error details are displayed in the OBP Import window import details preceded by a red Info icon.