How Do I Find Social Security Numbers For All Patients Admitted Last Year?

Issue

I am trying to generate a list of all patient's social security numbers that were admitted in the past 12 months.

Environment

Kipu EMR, Roles: Super Admin & Records Admin, Features: Manage Reports, Clinical Reports

Resolution

1. Select the Reports tab, then choose either Public or Private depending on how the report is viewed.
   
   

   • For Master Instances: To only pull data from a specific location, select the desired location from the header drop-down. If the report has My Locations selected, the report will pull data from all locations.

2. From the Reports tab, click the New Report button.
   
   
3. Within the pop-up select the Clinical report type.
   
4. Name your new report, then under the date range drop-down either select Last Year or, if you need a specific date range, select Custom and enter in your start and end times. Then click the Continue button.
   
5. The Data Fields Section fields will populate allowing you to select the checkboxes for Admission and SSN (if you need to identify which patient it is add in the MR and/or the Name options). Click the Run Report button at the bottom.
   
6. The report progress screen will appear and once done it will redirect you to the populated data.
7. The data can either be viewed inthe Kipu EMR or can be exported to XLSX or CSV.
   

Note: If you need to refer back to the report at a later time, it can be found within the initial Reports page (either Private or Public) depending on how it was created.

Additional Information

• To learn more about clinical reports, click here.