Please complete the following steps to enter locality data identifying the number of hospital discharges by zip code.  First, download the excel template to enter the required data (see link below; alternatively, you can contact your Government Project Officer to acquire this template).  Note that the structure of the Excel template must not be altered (i.e., do not add/remove/edit/rearrange columns or column headers).  Complete each row of data entry by reporting (a) each zip code used by your program and (b) the corresponding number of hospital discharges.  If you are reporting an overseas zip code, use code “88888”.  If the zip code is unknown, enter “00000”. 

When you have completed data entry using the template, save your work to a local folder and follow the instructions to upload this file into BPMH (e.g., using the browse function to select your file from your local folder).  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.  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.  (Note- once uploaded into BMPH, template data cannot be downloaded back into an Excel format).  After you have verified that all data are present and accurate, select the Save/Validate button to proceed to the next subform.  Please refer to the instruction manual and/or contact your Government Project Officer if you have any questions about how to complete this form.