Upload data on patients and procedures in bulk

Patients can register themselves through Oracle Health Immunization Management Patient Portal or an agent can register them when they arrive for walk-in appointments. Healthcare workers can then enter their procedure data during the appointment. But, administrators can also upload patient and procedure data (for example, from a third-party vendor) to get it into Oracle Health Immunization Management.

Oracle Health Immunization Management provides a CSV template file that you can use to provide the required field data for multiple patients. When complete, you can browse to the file to upload it to the system. For more information, see Bulk Upload.

To upload patient and procedure data for multiple patients:

1. Select the Administration tab from the banner.
2. Select Load Patient Procedures to open the Upload Patient Procedures page. It lists names of the previously uploaded CSV files (if any). Each line item includes details on the file name and when the load started and completed.
3. Select Upload File from the top of the page to open the Upload Patient Procedure page.
4. Scroll down the page and select Download Patients Sample and open it in Excel. The top row includes the name of each field (for example, first, middle, and last name and contact method, address, and country).
5. Enter the field information for the patient and procedures. Required fields appear in red. You can also see more details on the fields by selecting the Procedure Required Fields and List of Values tabs.

   Note:

   To ensure optimum performance, do not exceed the limit of 5,000 records per file.
6. Save the file with an appropriate name.
7. Enter a short description of the file in the File Description field.
8. Select anywhere in the Choose File field to browse to the file you want to upload.
9. Select Upload File. When done, you see a success message in the banner (for example, "Loaded 25 patients"). The Loaded tab now shows details on the file you just added at the top of the list. Select Download from the end of the row if you need to download the file for any reason.

   Note:

   • You can select Refresh as the file uploads to see the number of lines (rows) processed. If you selected Patients to upload a patient file and the file contains errors, you see a section that lists the rows with errors in red. The Error column lists details on the problem and stops uploading the data. If you see warnings instead of errors the rows show messages in blue and the system continues to upload the data.
   • The upload process opens to the All Lines tab to see the records in the file. But, you can also see an Errors tab to show the number of errors (if any) and a Loaded tab to the number of records loaded into the system.
   • If you see warnings during the upload (for example, missing required field information), you can select Delete File to stop the upload process if necessary. You can then correct the warnings in the file, save it, and try uploading the file again. You can also download the errors to a CSV file by selecting Download Warnings.
   • If your file contains errors, you can select the Errors tab to see more details. You can also download the errors to a CSV file by selecting Download Errors. You must fix the errors in the file, save it, and upload it again by repeating steps 7-9.
   • If your file contains duplicates (for patients only), the system shows a warning and continues the upload. But, it skips exact matches to patients already in the system. For close matches (more than or equal to 75%), it flags the patient data as a duplicate and continues uploading the file. You can resolve the duplicate data later as described in Merge duplicate patient data.