Enhancements to the Uniform Data System were made available in the EHBs on 9/13/18. Additional enhancements have also been added to UDS on 11/11/2019 and 11/4/2022 and those updates are included below.
This instructional page was created using fake data, solely for the purpose of training and testing.
UDS Performance Report Navigation Modernization
The Status Overview page has been updated significantly and now displays several new panels.
The top of the Status Overview page shows the UDS Performance Report due date and the number of days left till the submission period ends.
Several functionalities and sections are located on the right side of the Status Overview page:
The Offline Excel Tool widgets allow you to quickly download Excel files in different formats:
|5.||The Compare Versions widget allows you to select years or versions of the performance report to compare and easily see what data has changed year over year.|
The Report Details section specifies the report’s Bureau of Primary Health Care’s Health Center Management Information System Identification Number (BHCMIS ID) and the person that last submitted the report.
And the Submit and Print section includes buttons that allow you to print or submit the UDS Performance Report.
The Status Overview page UDS Report Status section has changed in appearance:
At the table level, several enhancements have been made:
On the Table Patients by ZIP Code page you can do the following:
On all table pages, the 'Mark as Complete' action has been removed, as pages now automatically checks pages for completion, reducing the number of clicks.
Offline Excel Feature
The Offline Excel Feature is a downloadable excel template of the UDS Performance Report forms where you can perform data entry without being connected to the internet and upload the completed Excel file to the EHBs.
To access the Offline Excel feature, click the Download File link in the left-hand menu from the ‘Status Overview’ page. This will open the ‘Download File’ page. Or, click Download a Custom Template from the widget in the Offline Excel Tool section.
On the ‘Download File’ page, scroll down to the Download Template section. Select the Offline Excel option and select Excel with Data or Blank Excel. Then check the tables and forms you would like to download. You can choose to download the tables individually, in groups, or all the tables. After you have made your selections, click the Download button. This will initiate the download of the offline excel.
If you select to download the Table Patients by ZIP Code, you have the option to include a list of prior year ZIP codes, making it easier to enter data if the ZIP codes are similar to those used the previous year. This is not an option available if you download the Offline HTML format.
Open the downloaded file and save it to your computer. Each of the tables and associated funding streams are organized in Excel worksheets. Complete data entry on each of the worksheets. The Note at the top of each worksheet provides details of what kind of information should be entered.
From the UDS Report Resources section, open the Excel Mapping Document to help navigate the Excel file.
The Excel Mapping Document lists the corresponding cell location for all the fields in the offline Excel file.
To upload the offline Excel file, from the ‘Status Overview’ page, click Upload File in the left-hand menu. Or, use the Upload File option from the Offline Excel Tool widget.
On the ‘Upload File’ page, scroll down to the Upload File section. Click the Browse button and select the Excel file that you just saved. Return to the ‘Upload File’ page and click the Process File button to upload the data in the Excel file and generate the Error Summary report.
Once the Excel file has been uploaded and processed, the EHBs system will assign it a file name that contains your UDS Report tracking number and the version number. The version number will allow you to track the most recently uploaded file.
A success message also displays when the system has finished uploading and processing the Excel file. This message includes a list of the table(s) that were uploaded.
In the Error Summary section, the "Number of Edits Verified" and "Number of Edits Failed" values will display after the file is processed. The Error Summary Report can be downloaded by clicking the file link in the Download column.
The Error Summary Report file shows the edit codes, error messages, and the tables and funding streams where the errors have occurred. Use this file to make corrections to the data.
Click the Action History link in the UDS Report Resources section to view the history of file uploads.
|13.||The list of uploads will display along with other actions, including report submission.|
Click the Upload History link in the UDS Reports Resources section to access previously uploaded Offline Excel files.
The Upload History page includes the following columns of information.
A. Document Name - Provides a hyperlink to quickly view the uploaded file.
B. Table(s) - Lists all tables uploaded in the file.
C. Error File - Provides a hyperlink to view the error file associated with the upload. With this new feature there will be record of the error file for each upload.
D. Uploaded File Name - Shows the original source file name for the uploaded document.
Offline HTML Feature
The Offline HTML Feature is a downloadable HTML application that has a similar UI to the EHBs, basic table functionalities, and field edits. You can perform data entry on this application, save data, and export data in an Excel file. You must have Google Chrome installed to use to the Offline HTML feature. Data can only be exported from the Offline HTML in an Excel file, which can be uploaded to the EHBs.
From the ‘Status Overview’ page, click the Download File link in the left-hand menu to access the Offline HTML feature. This will open the ‘Download File’ page. Or, click Download a Custom Template from the widget in the Offline Excel Tool section.
On the ‘Download File’ page, scroll down to the Download Template section. Select the Offline HTML option and check the tables and forms you would like to download. You can choose to download all the tables. After you have made your selections, click the Download button. Please note that this will initiate the download of the Offline HTML ZIP file.
Extract the content of the ZIP file and choose a file location for the extracted content.
Before completing the extraction, you will be prompted to enter a password, which is your UDS Report tracking number.
After extracting the ZIP file, open the UDS-Submission Chrome HTML Document.
The Offline HTML file retains the UI of the EHBs and will include all the tables that you had selected on the ‘Download File’ page. Because the HTML file looks very similar to the EHBs, the top of each page has an alert to easily identify if you are using the UDS Reporting Environment in the EHBs or using the Offline HTML application.
Data can be entered directly into this file and saved just as in the EHBs. Data entry checks occur as you enter your UDS Data.
You can import Offline Excel files into the Offline HTML file. This allows users to exchange data between the Offline Excel and Offline HTML functionalities.
From the ‘Status Overview’ page, click the Import File button in the left-hand menu.
Choose the Excel file you would like to import and click the Import File button.
Once data has been entered into the Offline HTML or imported from an Offline Excel file, the data can then be exported from the Offline HTML data as an Excel file.
From the ‘Status Overview’ page, open the ‘Export File’ page by clicking the Export File button on the left-hand menu.
On the ‘Export File’ page, click the Export File button. This will export the data entered into Offline HTML file as an Excel file. This file can then be uploaded into the EHBs from the Upload File page.
Preliminary Reporting Environment (PRE)
The UDS Reporting environment is now available to health centers before January 1st. This early access is called the Preliminary Reporting Environment (PRE) and it allows health centers to become familiar with annual updates to UDS reporting requirements before the official reporting period begins on January 1st.
|2.||Health centers can enter their UDS data during the PRE-period but cannot submit their UDS Report until January 1st.|
During the PRE period, a message will appear on the top of the UDS Report indicating that you are now using the PRE and that UDS Reports cannot be submitted until January 1st.
After the PRE has ended on January 1st, you can submit your report. A message on the top of the screen will indicate this.
Clear Data Feature
The Clear Data Feature allows users to delete all data from selected tables or the entire report.
To access the Clear Data feature, click the Clear Data link in the left-hand menu from the ‘Status Overview’ page. This will open the ‘Clear Data’ page.
On the 'Clear Data' page select the table(s) from which you want to delete information. Once you have selected the table(s) you want to clear, click the Clear Data button.
Be sure to read the caution note in the Instructions section, as using this function permanently deletes information from the table.
|3.||Before permanently deleting the data, you will see a Confirmation message listing the table(s) you selected. If you are ready to delete the data from the table(s) listed, click the Confirm button. If you do not want to delete the data at that time, click Cancel and no changes will be made to the table(s).|
|1.||Access the Compare Versions feature from the Resources section or Widget on the right side of the Status Overview page.|
If you select Compare Versions from the Resources menu you will land on the Select version page. Select the Reference Year/Version and the Compare To Year/Version, then click Next.
Note: If you use the Compare Versions widget on the Status Overview page you will skip this page.
|3.||Once on the Select Table page, select which tables you want to compare between the two versions, then click Compare.|
|4.||The Result Page lists all tables you selected. The page lists the data for each version, and you can easily see which fields have differences by looking for the blue circle next to the field data.|
View Submitted Reports
|After submitting the performance report, you can view the data from the Submissions - All page by clicking Performance Report in the Options column.|
On The Review and Report List page from the Action column you can Download or View the data in different formats, including Excel, for the whole report or just for each table.
You can also select to Print All Forms.
To view the Submit Confirmation page with the tracking number, select Continue to Next Page.
|3.||On the Submit Confirmation page you can view the details about the submitted report, including the tracking number.|
For Help and Support To access additional EHBs-related resources and training materials, once logged into EHBs, please click the Support (EHBs Help) icon located in the toolbar at the lower right of the screen. System navigation, UDS reporting acronyms, quick reference sheets for accessing reports, submission and review process, and other useful training materials and resources can be accessed here.
UDS reporting questions:
UDS Help Desk email@example.com or 866-837-4357 (866-UDS-HELP) Monday through Friday (except federal holidays) 8:30 AM to 5:30 PM (ET)
Health Center Program or EHBs questions:
BPHC Contact Form or 877-464-4772 Monday through Friday (except federal holidays) 7AM to 8PM (ET)
|For additional guidance on viewing UDS standard reports, go to the BPHC Contact Form and select Uniform Data System (UDS), UDS Reporting, Accessing UDS Reports in EHBs.|
For technical issues with the HRSA Electronic Handbooks, go to the BPHC Contact Form select EHBs Tasks/EHBs Technical Issues.