CHD-3 - Uploading Hospital Discharge Data by Zip code

Figure 1. CHD-3 - Uploading Hospital Discharge Data by Zip code

Please complete the following steps to enter locality data identifying the number of hospital discharges by zip code.

1. Using the link provided, download the Excel data template to input data.
2. Using the template, complete each row of data entry by reporting (a) each zip code used by your program and (b) the corresponding number of hospital discharges. Note: Populate the CHD-3 form with records with complete 5-digit zip codes. This information is required. Please use "88888" for international records with no 5-digit zip code.
3. When you have completed data entry using the template, save your work to a local folder.
4. Using the attach file button, upload your saved file into BPMH (e.g., using the browse function to select your file from your local folder).

Warning
The structure of the data entry template must not be altered (i.e., do not add/remove/edit/rearrange columns or column headers). Doing so will lead to uploading errors.

Note

If you have difficulty downloading the template file, contact your Government Project Officer.

Note

Once uploaded into BMPH, template data cannot be downloaded back into an Excel format.

Note

Populate the CHD-3 Form with records with complete 5-digit zip codes. Using ‘00000’ for unknown zip codes will generate an error message. Please use ‘88888’ for international records with no 5-digit zip code.

CHD-3 - Processing Hospital Discharge Data by Zip code

Figure 2. CHD-3 - Processing Hospital Discharge Data by Zip code

• Once your file has been uploaded, select the “Process Data” button, which will populate the table below with the data you entered into the excel template (i.e., zip codes and discharge counts).

• Next, select the “Save” button to automatically populate the city and state fields (based on the zip codes you have provided) and run the form validations.

• After you have verified that all data are present and accurate, select the Save/Validate button to proceed to the next subform.

Note
Errors in editable fields will be identified with a “Row” number and can be corrected either (a) within the BMPH system or (b) corrected in the original excel template and then re-uploaded.

To Complete the Form: Click on the “Save and Validate” button located on the bottom right corner of your screen. If no errors are found, the BPMH system will automatically route you to the next required subform.