CLR110 CLARITY DATA MODEL FUNDAMENTALS EXAM WITH GUARANTEED ACCURATE ANSWERS|VERIFIED, Exams of Computer Communication Systems

Download CLR110 CLARITY DATA MODEL FUNDAMENTALS EXAM WITH GUARANTEED ACCURATE ANSWERS|VERIFIED and more Exams Computer Communication Systems in PDF only on Docsity! CLR110 CLARITY DATA MODEL FUNDAMENTALS EXAM WITH GUARANTEED ACCURATE ANSWERS|VERIFIED What is the first step in the report writing process? - answer-Analyze request for key features... -Who needs it -What purpose -How much data should it return -How up to date does the data need to be -How does the data need to be formatted The most important decision of the report writing process is... - answer-Which reporting tool can best be used to meet the reporting need In general, Operational Reports share the following key characteristics: - answer-1. Time-sensitive 2. Relatively small 3. Easily accessible * Actionable ____ _____ generally put more emphasis on filtering out unnecessary information than they do on showing a comprehensive picture. - answer-Operational reports What is the difference between operational and analytical reports? - answer-Operational reports are real-time reports needed by end users to do their jobs. Analytical reports are over-time reports that show long-term trends and data. Why should you use Clarity for analytical reporting needs? - answer-Clarity reports can be run over very large data sets without slowing down your production server. They also can include complex grouping and mathematics, and can be used to do integrated reporting on Epic and non-Epic data. Why should you not use Clarity for operational reporting needs? - answer-Most importantly, Clarity data is not real-time, so any operational reports built from Clarity data will be out-of-date from the moment they're generated. They also cannot be used interactively, such as in a workflow where the report jumps a user to a patient's chart. You have a reporting need, and there is no pre-built application report to meet it. Do you need to use Clarity to meet this need? - answer-Not necessarily. Reporting Workbench can be used for many non- standard reporting needs. Would the following report be an operational or analytical report? Create a report that counts the number of logs each surgeon has been documented as performing in during the past year. Display the log ID, the name of the surgeon, and the log's primary procedure. - answer-Analytical report The report should display all patient encounters where the patient was less than 18 years old at the time of the encounter. The report should be grouped by the primary visit provider, and then by patient. Visits without a visit provider should be excluded. For each provider, the report should show the provider's name. For each patient, the report should show the patient's name, primary MRN, and sex. For each encounter, the report should show the date of the encounter, the patient's age at the time of the encounter, and the patient's weight at the time of the encounter. Is this report operational or analytical? - answer-Analytical. Analytical reports are designed to make sense out of large patterns. To discern large patterns, they need access to large amounts of data. An operational report might display ten data points; an analytical report might display ten million. - answer-Comprehensive Which Analytical report characteristic is described below... While the analytical report might be based on ten million data points, there are very few people that want a ten million line document. Generally, analytical reports are grouped and summarized. Gleaning a few key numbers out of a vast bulk of data can require much more sophisticated mathematics than are generally required by operational reports. - answer-Summarized Which Analytical report characteristic is described below... The readers of analytical reports are often not Epic end users; they're managers and executives who expect their data to be presented in a certain format. In addition, they may want to see non-Epic data, such as payroll information, integrated with Epic data. - answer-Standardized When faced with an analytical reporting need, there's generally one tool of choice: - answer-Clarity _____ is a tool that extracts data from your Chronicles production system, transforms it into a relational format, and loads it onto a separate reporting server - answer-Clarity Consider the example reporting request: Total number of appointments scheduled in each of your clinics over the last year, broken down by clinic and showing the average length of each clinic's appointments You might try to attack this reporting need using the operational reporting tools discussed above, but you'd likely run into two problems: - answer-Performance - over a year's worth of data /a significant drain on system resources Flexibility - total number and average length of appointments in each clinic. Operational reports generally do not display summary information. Name the advantages to meeting an analytical need with Clarity - answer-Performance If you report on Clarity data rather than production data, running your report will not impact your end users in production. This means you can run reports of arbitrarily large size without any problems (other than slowing down other Clarity reports running at the same time). Flexibility Since Clarity data is in an industry-standard format, you can access it using industry-standard tools such as Crystal Reports. These tools generally support a wide range of calculation, formatting and summarization tools. Since your Clarity server runs industry-standard database software (Oracle, MS-SQL Server, or Teradata), you can load data from your Clarity database into a ____ _____ along with your non epic data. - answer- data warehouse If your report needs large quantities of data, complex mathematics or summarization, or data integration with other systems, then _____ is your tool - answer-Clarity Take the following example of a report that should not be attempted using Clarity: Currently admitted patients requiring a new IV within the next two hours. A user should be able to jump from a patient shown on this report to the patient's chart. If you tried to meet this reporting need with Clarity, you would quickly run into two deal-breakers: - answer-Real-Time Data Clarity extracts data from production on a daily, weekly, or even less-often basis. Clarity data should always be assumed to be at least 24 hours out of date. Clarity reports are often delivered via email or an external reporting portal. The reports are not going to be as integrated into end-users' workflows as, for example, Application Reports. You may find a reporting need that requires real-time data and large quantities of it. Once you've established that the reporting need really does require real-time data, how should you find a way to meet the need? - answer-Use an operational tool by breaking the report down into several smaller reports that can be run at different times. Since Clarity data is not extracted in real-time, the need for real-time data precludes the use of Clarity. Clarity data has historically been distributed by means outside of Hyperspace, such as - answer-Email delivery or a third-party reporting portal What are two mechanisms available that allow you to integrate your Clarity reports into Hyperspace: - answer-Epic-Crystal Integration Radar. Using ____-____ _____, a Crystal Report based off of Clarity data can be configured to appear in the My Reports activity in Hyperspace right next to the Reporting Workbench reports - answer-Epic-Crystal Integration A user can subscribe to a Crystal report by adding it to their favorites. The user ____ ____ _____ _____ _____, but a process regularly scans for which users are subscribed to which reports. - answer-cannot run the report on demand A Crystal report will be set to run on a regular basis, and when it does, a version will be generated for each person who is subscribed to the report, according to their _____. - answer-parameters Each person who is subscribed to a report have what they need right there in _____. - answer- Hyperspace _____ is Epic's information center, a portal that hosts personalizable Home pages to display Epic data, reports, and links to other pages. - answer-Radar In the context of reporting you can think of Radar as a front-end for _____ _____. - answer-My Reports Radar allows a user to run and view Reporting Workbench reports, along with viewing Clarity reports via - answer-Epic-Crystal Integration ______ exist to store data - answer-Items Most item numbers can be used for different purposes by different master files. For example, for an EPT (patient) record, item 60 hold the patient's ______ . However, in an ORD record, item 60 holds the order's ______ - answer-city class There are two items that have the same meaning in every record, regardless of master file. All Chronicles items are identified by whole numbers, except for these two: - answer-Item .1 - Record ID Item .2 - Record Name The most fundamental trait that differentiates one item from another is what kind of ______ it can ______ . - answer-DATA it can STORE Any combination of characters is known as which Data Type - answer-String Which Data Type can be any number, integer or a decimal? - answer-Number In Chronicles the date is actually stored as the number of days since ______ . - answer-12/31/1840 In Chronicles the time is actually stored as the number of seconds since ______ . - answer-Midnight A date and a time stored in a single item are known as which Data Type. - answer-Instant A pre-defined list of choices is known as which Data Type - answer-Category ______ ______ determines how many lines of data an item can hold for a single contact - answer- Response Type Only one line of data can be stored per contact applies to which Response Type? - answer-Single Response This response type has multiple lines of data that can be stored per contact. These lines might be discrete pieces of data, such as multiple symptoms, or they might be multiple lines of a large block of text, such as an address applies to which Response Type? - answer-Multiple Response Multiple lines of data can be stored per contact, and each one of these lines is related to a line in another item. Take a patient's phone numbers is an example of which Response Type? - answer-Related Group If the number on line 1 is deleted, the number on line 2 should not move up to fill the gap, or it would look like 608-555-1979 was the patient's home number. The line is kept together because these two items have a response type of ______ and have the same ______ ______ - answer-related group number An item's______ ______ determines whether a different value for the item can be stored on each contact, or whether values are stored directly to the record - answer-add type ______ items store data directly on a record, not a specific contact - answer-No-Add ______ ______ ______ items store values separately on each of a record's contacts - answer-Response each time A patient's date of birth is a ______ item, and you can assume that no matter how many contacts the patient has, his date of birth is the same - answer-No-add If a response each time item is blank for a certain contact, it should be considered ______ - answer- unknown ______ items store values separately on each contact, but assume that the last value entered remains true until a new value is entered - answer-Lookback The system automatically enters a patient's age on each contact, but only if their age is different from the last time the patient was seen is an example of which Add Type? - answer-Lookback If a patient's blood pressure is not collected during a certain visit to the doctor, you cannot assume that it has not changed since the last time the patient's blood pressure was taken is an example of which Add Type? - answer-Response Each Time Since both, "response each time" and "lookback" items store data on the contact, these add types may collectively be referred to as ______ add types - answer-Overtime What end users don't generally know is that none of these names are actually stored in Paul's patient record. Instead, they are looked up as needed using a Chronicles technique called ______ . - answer- networking The EPT items for Hospital Account, Department, and Attending Providers are all ______ items - that means that they hold a reference to data from another record someplace else. - answer-networked Networked items in Chronicles are similar to the relational database concept of ______ ______ . - answer-foreign keys Sometimes the data point in question isn't explicitly displayed anywhere in Chronicles, for example a system-generated ______ - answer-Timestamp. A physician needs a report involving patient weights. Weights are entered in Hyperspace in flowsheets, and the Ctrl+left click method does not work on flowsheets. You need to find out where in Chronicles a patient's weight lives. To meet this need, you would start with the ______ ______ - answer-Record Viewer You can also search by ______ ______ instead of by INI and item - answer-column name Clarity Compass Generally, you should not search by column name unless you're returning to a column you've already found by ______ and ______ . - answer-INI and item Clarity Compass Searching by ______ and ______ ensures the column you find extracts the data you want - answer-INI and item Once you're in a column's Clarity Compass entry, the first pieces of information you'll want to look for are these: - answer-INI and Item # Clarity Compass You will generally see an empty grid in one of two cases - if the column extracts are ______ -______ data, or if the column extracts ______ data - answer-Non-Chronicles Calculated If you see two columns in one table that otherwise appear to be identical, make sure to read the column ______ - answer-descriptions The datatypes used by Chronicles are String, Number, Date, Time, Instant, and Category. However, when we transform this data into relational formats, all Strings become ______ , and all Numbers become ______ - answer-VARCHARs NUMERICs The datatypes used by Chronicles are String, Number, Date, Time, Instant, and Category. However, when we transform this data into relational formats Dates, Times, and Instants all become ______ - answer- DATETIMEs Depending on the column's datatype, there may be a secondary characteristic defined as well. For example, for a VARCHAR, you can define the ______ ______ the column can hold - answer-maximum length The table or column will still exist in your Clarity database and all existing data will still be there, no new data will be extracted best describes tables/columns being ______ - answer-Deprecated. Do not assume that if ______ says yes, that the column will actually be extracting data. ______ will almost always be set to yes - it's a flag used by ETL administrators that can cause unexpected behavior if used inappropriately. - answer-Extracted Extracted In the example below, the "_C" denotes a ______ ______ PATIENT.SEX_C - answer-Category List 1.Female 2.Male 3.Unknown You can find out which category list an item points to by opening up the corresponding column in the Compass, and looking at the ______/______ section - answer-Format INI / Item You can also find out which ZC_ table to link a _C column to using the Foreign Keys listing in the ______ ______ ______ - answer-Compass Table Summary True or False Not all Chronicles items are extracted to Clarity. - answer-True Sometimes the item ... -is a piece of internal data that would be incomprehensible to a non-programmer. -changes by the second, and extracting a fixed snapshot of it would be pointless. -Clarity table just hasn't been created yet. The Clarity Compass stores information for ______ ______, ______ ______, and ______ - answer- Extracted Tables Derived Tables Views ______ ______ (which usually have names that start with "F_") are populated by scripts on Clarity tables and other data sources available on the Clarity server. - answer-Derived tables ______ (which usually have names that start with "V_") don't hold data in themselves, but run queries against other Clarity tables and present the results in a form that can be used as table. - answer-Views The ______ ______ gives us information about the table itself - answer-Table Summary Certain tables have enough columns to warrant splitting them up into different tables. These are called - answer-Grouped Tables The Extracted field in the table summary does not dictate whether or not the table is extracted at your organization. Rather, the field signifies that the tables can be extracted through the normal ______ ______. - answer-ETL process The ______ ______ ______, a compiled HTML version of the contents of the Clarity Compass - answer- Clarity Data Dictionary Anything that can be found in the Table Summary section of the Compass can generally be found in the ______ ______ ______ as well - answer-Clarity Data Dictionary In some cases, your report is on entries in the parent table that have a certain number of rows in the child entity. In this case you will want to put your parent table on the ______ . - answer-left To avoid confusion use descriptive ______ instead of ______ when assigning aliases - answer-words numbers If we were to use two copies of CLARITY_SER in a report, we would have to give an ______ to at least one of the copies - answer-alias The ______ ______ of a table will generally tell you what kind of Chronicles data is extracted into a table - answer-primary key In Chronicles tables the ______ ______ and ______ ______ of a table will dictate what the primary key of a table will consist of - answer-Add Type Response Type Now that we have created a Clarity report, we need to validate that the report does the following: - answer-• The report is not including wrong information • The report is not skipping records that it should include • The report is pulling the correct data for the included records and contacts Two of the main methods to Test for Accuracy are ______ ______ and ______ ______ - answer-spot checking data seeding ______ ______ is defined as making sure the details in the report match the information populating the report - answer-spot checking ______ ______ is defined as completing workflows in Hyperspace and making sure that that data populates the report correctly - answer-data seeding Before you are able to ______ ______ data in Chronicles, you need to select what information to look for. When you select records, you should drill down to the lowest level of details and choose a few records at random - answer-spot check When ______ ______, go into Hyperspace and check that the information in the report reflects what is in Chronicles - answer-data seeding Data seeding should never be performed in your ______ ______ - answer-Production environment The ______ ______ is where end users work. It contains live data and is where patient information is stored. - answer-Production environment The report should be checked with a realistic amount of realistic data. This ______ ______ should take place as soon as you have enough data in the system to accurately reflect typical usage - answer-volume testing You should plan on having at least one ______ test case and at least one ______ test case when seeding data. - answer-inclusive exclusive A report that has the record selection statement of "patients admitted on or after 3/1/2011 and before 4/1/2011" has two boundary values. Each ______ ______ should be tested for an inclusive and exclusive test. - answer-boundary value A report that has the record selection statement of "patients admitted on or after 3/1/2011 and before 4/1/2011" has two boundary values. This report should have at least ______ boundary test cases - answer-four True or False. End users can run Epic-Crystal reports by adding the report to their favorites. - answer- False. Adding the report to their favorites subscribes the user to the report. They still need to wait for the batch job to run the report. Reports in ______ ______ are made from templates - answer-Reporting Workbench ______ control many things about a report, including what master files the query searches, what criteria are available, and many aspects of the user interface. - answer-Templates A report might have a Departments parameter, which could be automatically filled in according to the configuration of the ______ user - answer-subscribing True or False. End users can run Epic-Crystal reports by adding the report to their favorites. - answer- False. Adding the report to their favorites subscribes the user to the report. They still need to wait for the batch job to run the report. True or False. The Set queue order is disabled for Epic-Crystal templates because the reports will always run on the shadow server. - answer-False True or False. The Report frequency will not tell you how often reports made from the Epic-Crystal template will run. - answer-True You've created a template whose reports should be run on a weekly basis. In the ______ -______ ______ you set the Report frequency to Weekly - answer-Epic-Crystal template Users with the right security can set override values in an Epic-Crystal report. These override values perform the same functions as their counterparts in the ______ -______ ______ - answer-Epic-Crystal template ______ ______ allow you to preserve multiple versions of the report results on the BOE server - answer- Historical instances