Sending Data to Benefit Providers

After the Enrollment Reporting Snapshot process runs, you can send enrollment data to your plan providers. Two ways are available to send this information:

  • Run the appropriate SQR Provider Extract process to create a provider extract file.

  • Use the PeopleSoft Carrier Reporting process in eBenefits.

This section discusses how to:

  • Create SQR provider extracts.

  • Run carrier extracts.

Provider requirements for enrollment data are seldom the same. The Manage Base Benefits business process includes a set of sample extract SQR programs that you can modify for your providers. Each sample SQR program:

  • Includes a realistic set of data fields for the associated plan types.

  • Records a history of each run.

  • Sends an enrollment termination to a provider only once.

After determining file layout requirements for your providers, clone the appropriate sample SQR program for each file layout that you need and make any necessary changes using the database record layout information for BN_SNAP_PER, BN_SNAP_JOB, and BN_SNAP_PLAN.

Four sample SQRs and two library files are available:

  • BEN102.SQR: sample file extract for health (1x) plans.

  • BEN103.SQR: sample file extract for life/AD&D (2x) plans.

  • BEN104.SQR: sample file extract for disability (3x) plans.

  • BEN105.SQR: sample file extract for savings (4x) plans.

  • BENCRFNC.SQC: library of useful functions for developing provider extracts.

  • BENCRTBL.SQC: library of internal cache tables.

Create a flat file that can be sent to your plan providers. Use the Health, Life/ADD, Disability, and Savings Extract pages, or your own provider-specific pages to do this.

If you rerun an extract because of a problem and have set up the extract to send terminations only once, delete the run history record for this extract on the Review Interface Run History page before running the extract again.