Bulk Upload Conversion Tutorial

1) To begin converting claims, first log into the Bulk Upload tool and click on the Get Template button.

2) The “Choose Template” box will appear with a list of templates that are available for downloading. Click on the “Convert Existing Claims” template to download it.

3) The “Choose Primary Trust” box will appear with a drop-down of Trust that the user has access too. Select the Trust for the new claims submissions.

4) After selecting the Trust and clicking the OK button. A “Save BulkUpload Template” box will appear prompting the user to save the new template. At this point the user may rename the file or leave the default name and select the directory where the new template will be stored.

5) After downloading the new template, double click on the file to open it. Find the tables located in the Tables view of the Access database and open the conversion table to begin entering data. The conversion table is the only table in this template that must be populated. If you have additional documents and exposures pertaining to the new claims, you may enter them in the tables provided.

6) To convert claims, the user will need only the Source claim numbers that will be used in the conversion process. The attorneyid, injuryid and injurydate do not have to be entered unless the values are changing from what they were on the original source claim. For example, you may convert a non-malignant claim to a new claim and upgrade the disease to a malignancy by entering the new disease in the injuryid.

7) The claims used as the Source claim can be any claim that the user has access too. Although any claim can be used as the source, you may only convert to one Trust at a time.

8) After entering all of the necessary data in the conversion table, you may supplement the new claims with additional exposure and documents. As you can see, the claim numbers only appear in the ‘conversionid’ once they have been entered in the conversion table.

9) After entering all of the information into the necessary tables, close the template. Log back into the Bulk Upload Tool and click on the Upload Template Button.

10) The “Upload BulkUpload Database” box will open, prompting the user to select the “Convert Existing Claims” template. After selecting the correct template, click “Open” to begin uploading the new exposure records.

11) The “Converting Claims” box will display the total number of claims that were successfully converted as well as the ones that failed. The next two sections display the number of exposures and documents that were successful and the number of exposures and documents that failed.

For the failed exposures and documents, open the template and their respective tables and check the message field which will provide a brief description of why they failed. On each of the documents table, you will see the following fields. After correcting the failed uploads, log back into the Bulk Upload tool and re-upload the conversion template with the corrections.