Manage Person Benefit Balances in the Integrated Workbook
You can download person benefit balance information to the integrated Microsoft Excel workbook where you can add, edit, and delete balances. Then, upload your changes back into the application database tables.
The basic process for managing person benefit balances using the workbook is:
-
Generate and populate the workbook.
-
Edit, add, and delete person benefit balances in the workbook.
-
Upload edits.
-
Resolve errors.
Repeat these steps as many times as required to accommodate revisions.
Generating and Populating the Workbook
In the Evaluation and Reporting work area:
-
In the Upload Person Benefit Balances row of the Person Data Loaders tab, click the Go to Task button.
-
In the Upload Person Benefit Balances dialog box, enter a session effective date.
-
Click Prepare in Workbook.
Editing, Adding, and Deleting Person Benefit Balances in the Workbook
After the download completes, view, edit, add, and delete person benefit balances.
-
Edit the Value, Primary Assignment, and Benefits Relationship values.
The upload process ignores edits in any other columns.
-
Insert a row to add a person balance.
For each new balance, you must enter a value in either the Primary Assignment or Benefits Relationship field, but not both.
-
Delete data from the application database using these steps:
-
Double-click the Mark for Deletion field in each workbook row that you want to delete from the application database.
-
Click Delete Selected Rows.
-
Uploading Edits
After you complete your edits, click Upload.
The process:
-
Uploads to the application tables only those rows marked as Changed
-
Uses the session effective date that you set when you generated the workbook as the start date for any edits or new person benefit balances that you entered in the workbook
-
End dates prior balances as of the previous day for each edited row
-
Retains the history
-
Deletes permanently all of the related effective-dated records from the application database for each workbook row that's marked for deletion
Generate a new workbook after the successful upload to verify your edits.