CLR110 CLARITY DATA MODEL FUNDAMENTALS
EXAM WITH GUARANTEED ACCURATE
ANSWERS|VERIFIED 2024
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.
Compared to views, derived tables generally take less time to run because the data has been
stored on the DB
True, views are saved queries, their use can affect performance. Derived tables are stored
procedures and thus perform better
After receiving a report request, you consult Clarity resources such as Clarity Compass
and the Clarity Dictionary without consulting Chroncile resources such as Item Editor and
record viewer. What problems may you run into?
Analytics catalog
Database object search
Column search
Clarity Dictionary on the
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?
Ctrl + Click
I IDM 130 is a networked item that is not filled in for this record. What value will be
extracted to Clarity for this item, and other Chronicles items that are not filled out?
Null
What value will be extracted to Caboodle for this item, and other networked items that are
not filled out in Chronicles?
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.
T/F columns that are non primary keys contain null values
True, even foreign key may be null.
Why do null values exist in Clarity
,Not all fields are populated in Chronicles
ETL data cleansing deletes incorrectly formatted data
Data is deprecated y no longer extracted
!Appendix E: Record Viewer Tip Sheet contains more information on the filtering options
available in the record viewer
Item Editor
Shows the definition of chronicle items.
Shows information about how the item behaves for all values
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.
Time frame for this report is unclear
If the requester followed up saying that the report would only be run for the last five days, the report
could be considered operational.
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.
!Since both respond each time and lookback items store data on the contact, these add
types are referred to as overtime add types.
No‐Add data is stored at the record level Overtime data is stored at the contact level.
Response Each Time
Response type
stored separately on each of the records contacts
if blank, should be considered unknown
Lookback
add type
stored separately on each contact
assume that last value entered remains true
Response Type
determines how many lines an item can hold at one time
- Single Response
- Multiple Response
- Related Group
!Since both multiple response and related group items store more than one type of data,
these response types may collectively be referred to as multiple response types.
Single data stores one line of data, while Multiple data stores multiple lines of data.
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?
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 column that stores a patient's email address
D. A numeric column that stores the patient's age in years
E. A column that is the primary key of a table
