Ehr Go Query - Advanced Orientation (Informatics) IK1034.4 | 2026 Update | 100% Correct & verified

It is highly recommended the following activities are completed prior to this activity: • Query – Basic Orientation (Informatics) 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 – Advanced Orientation 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. Document your answers directly on this activity document as you complete the activity. When you are finished, you will save this activity document to your device and upload this activity document with your answers to your Learning Management System (LMS). Introduction The previous activity, Query - Basic Orientation, explored the fundamental concepts of querying data. Queries with a single logical operator (i.e. AND) were used to determine the number of Cesarean births. However, in many cases, queries need to use both AND and OR logical operators. For example, how many Cesarean births occurred in high risk patients OR in patients age 35 and older? Visually, this query may be depicted like this: 1 Or written out, it may look something like this: ‘Birth outcome = Cesarean’ AND (‘Risk = High’ OR ‘Age at Time of Birth = 35’) The parentheses indicate the order it should be executed otherwise it may result in a different answer. This is just like the order of operations in math! In EHR Go, the group function is used to create a query with both logical operators. Any time a query requires both an AND logical operator and an OR logical operator, the group function is required. Important! In the EHR Go query tool, the group function, when needed, must be added as the first step when building the query. By adding a group, the AND logical operator can be used for one set of rules and the OR logical operator can be used for another set of rules. This is also referred to as a nested query. The image below shows how the group function would be used to build the example query. 2 The first part of the query that has the connector lines on the outside is referred to as the main query. The second, or inner part of the query is known as the sub-condition. This activity will take a deeper look at the birth outcomes dataset using both basic and advanced queries. The activity Shoreline’s birth data revealed a cesarean section rate of 34.0%, which is 1.9% higher than the national average of 32.1%. The medical director believes the Birth Center has a higher cesarean section rate because they are the area’s only high-risk birth center. Being a high-risk birth center means that Shoreline receives a higher percentage of high-risk births. She believes that Shoreline’s high rate of cesarean section is related to the high-risk births and that cesarean section results in a safer birth experience for these families. Shoreline's Public Relations officer is happy to hear that Shoreline's high rate of cesarean may be related to a high rate of high-risk patients, but she feels the public also needs to know that Shoreline is the safest place to give birth. You have been asked to gather data from the EHR database to support the development of a comprehensive report that can be presented to the Shoreline Board of Directors. Access the EHR queries tool and corresponding dataset under 2: Launch EHR. Click the New Session button to launch the EHR. Follow the instructions to generate queries to answer the questions in the next section. 3 On the Queries tab, select New to initiate a new query. Name the query ‘Birth Outcome’. You’ll be running various queries to answer the following questions. For each question, run the query, then enter the Total record(s) result for the answer. Note that there are often multiple ways to query the data to get the same result. For grading purposes, enter your answers in the Answers section found later in this activity document. 1. Of the 8379 births at Shoreline, how many were high risk pregnancies? 1603 2. Of the 8379 births at Shoreline, what percentage were high risk pregnancies? Round to the nearest tenth. 19.13% Enter the following rules to determine the number of high-risk pregnancies then select Query. Query rule(s): ‘Risk’ equal ‘High’