CLR 110 CLARITY DATA MODEL ACTUAL

CLR 110 CLARITY DATA MODEL ACTUAL

FINAL EXAM WIT H 300+ QUESTIONS

AND WELL-VERIFIED CORRECT ANSWERS

| ALREADY GRADED A+ | GUARAN TEED

PASS | CLR 110 CLARITY DATA MODEL

FUNDAMENTALS LATEST EXAM

[BRAND NEW]

A Chronicles item can store one or more options from a limited list. Which of the following could account for this behavior? (Choose all that apply)

• Single Response
• Multiple Response
• Networked
• Overtime
• No-Add
• Category - ANSWER- B, C and F. If a Chronicles item can store one or more

options it is a multiple response item. If the options come from a limited list, that item may be a category item, where the category list is the list of options, or networked, where the records or contacts in the destination master file is the list of options

What are the steps to writing a report request? - ANSWER- Identify the data elements you will need for the report. 1 / 4

• Find the INI + Item numbers of the data points to use on the report
• Use the INI + Item numbers to find the appropriate Clarity tables and columns.
• Join the Clarity tables together using the correct foreign key information

What value will be extracted to Caboodle for this item, and other networked items that are not filled out in Chronicles? - ANSWER- If the column is a key column, Caboodle will have a -1 letting report writers know that this value was not populated in the source, while still enforcing referential integrity.

When do null values exist in Clarity? - ANSWER- Not all fields are populated in Chronicles, ETL data cleansing deletes incorrectly formatted data, and/or a column is deprecated and can no longer extract data

What does the Item Editor show? - ANSWER- The Item Editor shows the definitions of a Chronicles Item. Note that it does not show a particular value stored in the item. Instead, it shows information about how the item behaves for all values.

What is a category list? - ANSWER- A category list is a list of defined values that can be stored in a Chronicles item.

What is the Release Range? - ANSWER- The Release Range describes which category values are released by Epic and cannot be changed. Note that any category values you see in Training that are outside the release range may differ from what you see back home at your organization.

A Chronicles item stores a single value, but can store a separate value for each contact on a record. Which of the following could account for this behavior?(Choose all that apply)

• Single Response 2 / 4

• Multiple Response
• Networked
• Overtime
• No-Add
• Category - ANSWER- A and D. If a Chronicles item can store only one value it

is a single response item. If a separate value is stored on each contact the add type is Overtime.

What is an Add Type? - ANSWER- An item's Add Type describes how long a piece of data is valid. It determines whether an item's value is stored on each contact, or directly to the record.

A lab manager tells you he wants a report on lab specimens, and shows you the field where he can input various information. What method would you use to find the INI + Item numbers of the data he's looking for? - ANSWER- Ctrl + Click

A clinical administrator requests a query to include data for a patient's registries.She's not sure of the INI and Item number, but she knows patient is on the Lung Cancer Screening registry. What tool would you use to find the INI and item number given this information? - ANSWER- Record Viewer

In Clarity, which of the following columns COULD contain a Null value?A.) A foreign key column that would store the patient's primary care provider B.) A date column that would store the discharge date for an encounter C.) A string col.umn that stores a patient's email address D.) A numeric column that stores the patient's age in years 3 / 4

E.) A column that is the primary key of a table - ANSWER- All but E. In Clarity the only column that CANNOT be NULL is a column in the primary key of a table.

What is the Item Information Window? - ANSWER- When you control-left click on a data entry field in Hyperspace, the Item Information window appears. This window shows the INI and item number in which this data is stored, along with other information about the item as a whole. If you click the More >> button, additional item details appear including the add type, response type, and networked INI if the item is a networked item.

What is Category List Maintenance? - ANSWER- Allows you to see all category values in a category list... Item editor only allows you to see the first 100

What is the three-step process to find Clarity tables and columns given a Chronicles sample data point? - ANSWER- 1. Find the INI + Item number of the data point to use on the report.

• Use the INI + Item number to find the appropriate Clarity table and column.
• Join the Clarity tables together using the correct foreign key.

What Clarity Tools may be used as resources for Clarity queries? - ANSWER- > Clarity Compass which is accessed with two activities in Hyperspace

• Column Search Database
• Object Search

> Analytics Catalog

Online resources for Clarity research include:

> Clarity Dictionary > Report Repository

• / 4