Creating SQR Provider 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.