HIT 2100 MOD 1 ASSN

· HIT 2100 EOL 21

For this assignment, you will complete two activities in EHR Go. Specifically, this week's assignment will include:

· Query - Basic Orientation

· Query - Advanced Orientation

Please follow the instructions below, and reach out to your professor if you have any questions.

1. Click on the  Query - Basic Orientation Links to an external site.and enter your EHR Go credentials to begin. 

1. If you have not yet set up your EHR Go account, you will need to do so before you can begin. Please follow the instructions below.

2. Download the Query - Basic Orientation activity from the "Overview & Resources" tab of the assignment link.

3. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.

4. Use the activity sheet to work through the assignment and formulate your answers

5. Submit your Progress report as an attachment to this assignment link

2. Click on the  Query - Advanced OrientationLinks to an external site. and enter your EHR Go credentials to begin. 

1. Download the Query - Advanced Orientation activity from the "Overview & Resources" tab of the assignment link.

2. Click on the 2nd tab "Review EHR" to review the chart and begin the assignment.

3. Use the activity sheet to work through the assignment and formulate your answers

4. Submit your Progress report as an attachment to this assignment link

Skills Activity: Query – Basic Orientation (Associate)

Prerequisites

It is highly recommended this activity be completed prior to any additional query activities.

Student instructions

1. If you have questions about this activity, please contact your instructor for assistance.

2. You will use the EHR Go queries tool to complete this activity. Your instructor has provided you with a link to the Query – Basic Orientation (AS) activity. Click on 2: Launch EHR to launch the queries tool and begin this activity.

3. You’ve been granted access to certain data in the EHR to complete this activity. The approved data has already been linked to the queries tool in the EHR.

4. You will generate queries in EHR Go as instructed below. When you complete this activity, you will download your Progress Report in EHR Go under 3: Download Work, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS). 

Introduction

Electronic heath records (EHRs) are generating enormous amounts of healthcare data. Analyzing and bringing meaning to this data is a rapidly growing aspect of the Big Data field. Big Data aims to find patterns and trends, draw conclusions, and even predict outcomes from the aggregated data that’s obtained from the individual patient records. Every aspect of healthcare is impacted by Big Data – from facilities, financials, operations, treatment, education, populations, performance, quality, efficiency, and more – with the goal to improve patient care and to save lives.

One way to analyze the data is to use queries. Queries filter the data based on rules and logic in order to answer questions. An example of a question that could be answered through a query is, “how many Cesarean births happened in the current year at the Shoreline Clinic?”

In EHR Go, the querying tool enables sample data sets from the EHR to be analyzed similarly to what is done in a hospital, clinic, or healthcare system. It is based on Structured Query Language (SQL) to create the queries. This activity introduces you to the query tool and the concepts needed to answer questions around a birth outcome dataset. The following terms will be used throughout this activity and the additional EHR Go query activities.

Query: A combination of one of more rules used to filter a database, often in order to answer a question.

Field: A single unit of data that has been stored. It can be used as part of the filter criteria when developing a query as well as in determining how the data is displayed. For example, Date of Birth (DOB) is a commonly stored field associated with health records.

Record: A single entry in a database consisting of populated fields, similar to a single row in a spreadsheet. An electronic health record contains a compilation of fields for a patient.

Rule: Also known as a condition. A string consisting of a field, operator, and matching value. For example, “type of birth equals Cesarean”. Type of birth = field; operator = ‘equal’; and matching value = Cesarean.

Logical operator: AND or OR function used to join two or more rules. For example, “type of birth equals Cesarean AND birth year equals current year.” AND is the logical operator used to combine the two rules meaning both rules must be true for a record to be included in the results. The logical operator OR is used when only one of the rules needs to be true.

Note: Groups will be explored in the next activity, Query - Advanced Orientation.

The activity

Recently, the Shoreline Birth Center was called out in the local paper as having a high rate of Cesarean births. The report seems unfair to Shoreline’s management team, as they have been trying to decrease their Cesarean rates for the past five years. They would like to know, 1) if their efforts have helped, and 2) if their current rates Cesarean births are lower than the national average of 32.1%. You’ve been tasked with running queries to gather the data needed.

Access the EHR queries tool and corresponding dataset under 2: Launch EHR. Click the New Session button to launch the EHR.

On the Queries tab, select New to initiate a new query.

First, generate queries to determine the rate of Cesarean births that happened 5 years ago.

1. Name the query ‘ Total Births – 5 years ago’.

2. Then enter the following query rule:

Query rule(s): ‘Birth year’ equal ‘5 years ago’

3. Select Query to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.

4. Select Close to return to the Queries tab. Your query will be displayed as a row on the summary view. (Note the Total Record(s) amount has been removed from the image below.)

Next, determine how many Cesarean births happened 5 years ago.

5. Select New to begin another query.

6. Name the query ‘ Cesarean births – 5 years ago’

7. Then enter the following query rule:

Query rule(s): ‘Birth year’ equal ‘5 years ago’

8. Select Add rule to add another rule and select AND as the logic (default).

9. Enter the following second rule:

Query rule(s): ‘Type Of Birth’ equal ‘Cesarean’

10. Select Query then Close to return to the summary view. Both queries should now be listed.

11. The rate of Cesarean births from 5 years ago could be determined by using a calculator to divide the number of Cesarean births by the total births.

Next, you will generate the same queries for the current year to determine the current rate of Cesarean births.

12. Name the query ‘ Total Births – Current year’.

13. Then enter the following query rule:

Query rule(s): ‘Birth year’ equal ‘Current year’

14. Select Query to run the query. The Total record(s) field will populate, and the data will appear under the Query Results.

15. Select Close to return to the Queries tab. Your query will be displayed as a row on the summary view.

16. Select New to begin another query.

17. Name the query ‘ Cesarean births – Current year’

18. Then enter the following query rule:

Query rule(s): ‘Birth year’ equal ‘Current year’

19. Select Add rule to add another rule and select AND as the logic (default).

20. Enter the following second rule:

Query rule(s): ‘Type Of Birth’ equal ‘Cesarean’

21. Select Query then Close to return to the summary view. All 4 queries should now be listed.

22. The rate of Cesarean births from the current year could be determined by dividing the number of Cesarean births by the Total births for the current year.

23. Select Close Session and submit your progress report as described in the next section. Note: you do not need to turn in the calculated Cesarean rates, only the progress report.

Submit your work

You will complete the query in EHR Go as instructed. Remember to save your work. When finished, click on the Close Session button at the top right of the screen. Download your Progress Report in EHR Go under 3: Download Work, save the Progress Report to your device, and then upload the Progress Report to your Learning Management System (LMS). If you have any questions about submitting your work to your LMS, please contact your instructor.

Learning objectives

1. Apply health informatics concepts to the management of health information (3)

2. Utilize technologies for health information management (3)

3. Manage data within a database system (5)

EHR Go Skills Activity: Query – Basic Orientation (Associate) HAS1033.2

Archetype Innovations LLC ©2024

2

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image1.png

image2.png

image12.jpg