In this assignment, you will demonstrate your ability to construct SQL queries at a beginning skill level and to use the results of that query for administrative decision making. While you may not be required to use SQL on a day-to-day basis, understanding the logic and the ability to read and write simple queries will enhance your insight into the storage of healthcare data—and also enable you to better communicate with the IT personnel responsible for managing that information.
The following simple relational database schema represents a core subset of EHR functionality: tracking patient encounters. The ability to track patient encounters impacts several factors, including efficiency of care, productivity, patient safety, and ultimately revenue generation, among other areas.
This database has four tables, with one table representing each category of patients, procedures, providers, and encounters. To examine this database design, observe that the encounters table has a field for storing the ID of a patient, a provider, and a procedure. An encounter comprises the enactment of a procedure by a provider for a patient.
You are a healthcare executive who has been tasked by leadership to utilize your knowledge of SQL queries to help guide strategic planning. Leadership is considering expansion of various medical practices and needs to know the following:
1- Total number of patients seen at the organization for the year after January 1, 2019
2- The ten most common billing codes by specialty
3- Provide a count of the number of procedures per specialty
4- Ratio of providers to patients by specialty
To successfully complete this assignment, provide the steps you will take to determine each of these values using SQL queries. Include the query language for these items and the logic you used in developing the query language. Additionally, indicate how you would translate the SQL query results to practical application, to help guide the strategic planning leadership is conducting. Finally, what are the salient points related to the data that you would point out to leadership?
Length: Minimum of 3-5 pages, not including title and reference pages.
For This or a Similar Paper Click Here To Order Now
