Upload Benefit Enrollments Batch to Database Tables

Use the Upload Benefit Enrollments batch process to update the application database with enrollment data that you uploaded to interim tables from the integrated Microsoft Excel workbook.

The basic process for updating the database tables using the batch process is:

1. Run the Upload Benefit Enrollments batch process.

2. Download the enrollment processing results and fix any errors.

3. Review the results and reprocess.

Prerequisites

You must first upload your enrollment data batch to the interim tables. The details of this process are covered in the Uploading Enrollment Workbook Data to Interim Tables: Procedure topic.

Running the Upload Benefit Enrollments Batch Process

After uploading the batch lines:

1. In the Evaluation and Reporting work area, select the Processes tab.

2. In the Upload Benefit Enrollments row of the Election Processes section, click Submit.

3. In the Parameters section Batch Name field, select the name that corresponds to the name that you entered in your workbook.

4. Click Submit.

   Note the request number in the Confirmation dialog box when the request completes processing to review log files for details.

For each participant, the Upload Benefit Enrollments batch process completes:

1. All participant enrollments

2. All dependent designations

3. All beneficiary designations

The process then moves to the next participant.

Resolving Enrollment Process Errors

If there are any errors that require review, the process rolls back and continues to the next participant, dependent, or beneficiary.

If a participant enrollment fails, the batch process skips the associated designations, since they may be dependent on the participant enrollment completing without issues.

Reviewing the Results and Reprocessing

To view any data issues with the batch lines and the rows that show errors in the Row Batch Status cell, you download the batch details into the workbook.

1. In the Enrollment Uploads tab of the Evaluation and Reporting work area Overview page, click Prepare Enrollment Batch in Workbook.

2. Enter the name of the existing batch that you want to review.

3. Click Download.

   The workbook downloads all of the batch rows, not just the rows with errors.

4. View messages in the Message cells.

   Each message generally has a line ID indicating the row that is causing issues.

5. Fix the issue with each specified row.

6. Upload the batch again for reprocessing.

In the Audit Log field, if you select Yes when uploading the batch data, the upload process adds any error or information messages for each line to the audit log.