Exam (elaborations)
CLR110 Clarity Data Model Fundamentals.
- Course
- Institution
CLR110 Clarity Data Model Fundamentals.
[Show more]
Seller
Follow
lydiaomutho
Content preview
CLR110 Clarity Data ModelFundamentals
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
,Hot Keys
Opening Chart Search - Ctrl + Space
What is a category list?
a list of defined values that can be stored in a Chronicles item
Benefits and limitations of using category as a filter
1. more efficient
2. cannot only see first 100 values in item editor - must use category list maintenance to
see complete list
add types
no add
response each time
lookback
what is an add type
describes how long a piece of data is valid
no add
considered true for all cases.
if changed then old value is replaced
example: SSN, birthday
response each time
data stored separate on each contact record
if blank then it is considered unknown
example: weight, blood pressure
lookback
store each item separately but if blank considers last value to be true
Example: age, address
No‐Add
add type
stored on record, not contact.
considered true for all contacts
!Since both respond each time and lookback items store data on the contact, these add
types are referred to as overtime add types.
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.
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
All but E. In Clarity the only column that CANNOT be NULL is a column in the primary
key of a
table.
Item Information Window
window that populates after control click
Item Editor
shows information on how the item behaves for all values
useful for investigating properties on a given item
type item editor in chart search
records
Information about individual entities within a master file
For example, a record in the patient master single patient.
contacts
information about points in time for a record.
Tools for Chronicles research
▪ Item Information window (ctrl + click
▪ Record Viewer
▪ Item Editor
▪ Category List Maintenance
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﴿
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller lydiaomutho. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76658 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now