CLR110 Clarity Data Model Fundamentals CORRECT QUESTIONS & SOLUTIONS(GRADED A)
7 views 0 purchase
Course
CLR110 Clarity Data Model Fundamentals
Institution
CLR110 Clarity Data Model Fundamentals
Compared to views, derived tables generally take less time to run because the data has been stored on the DB - ANSWER True, views are saved queries, their use can affect performance. Derived tables are stored procedures and thus perform better
Which tools can be used to learn more about Clarity ...
CLR110 Clarity Data Model Fundamentals CORRECT
QUESTIONS & SOLUTIONS(GRADED A)
Compared to views, derived tables generally take less time to run because the data has been stored on
the DB - ANSWER True, views are saved queries, their use can affect performance. Derived tables are
stored procedures and thus perform better
Which tools can be used to learn more about Clarity tables and columns? - ANSWER 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? - ANSWER 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? - ANSWER Null
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.
T/F columns that are non primary keys contain null values - ANSWER True, even foreign key may be null.
Why do null values exist in Clarity - ANSWER 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 - ANSWER
Item Editor - ANSWER Shows the definition of chronicle items.
Shows information about how the item behaves for all values
Hot Keys - ANSWER Opening Chart Search - Ctrl + Space
What is a category list? - ANSWER a list of defined values that can be stored in a Chronicles item
Benefits and limitations of using category as a filter - ANSWER 1. more efficient
2. cannot only see first 100 values in item editor - must use category list maintenance to see complete
list
add types - ANSWER no add
response each time
lookback
what is an add type - ANSWER describes how long a piece of data is valid
no add - ANSWER considered true for all cases.
if changed then old value is replaced
example: SSN, birthday
response each time - ANSWER data stored separate on each contact record
if blank then it is considered unknown
example: weight, blood pressure
lookback - ANSWER store each item separately but if blank considers last value to be true
, Example: age, address
No‐Add - ANSWER 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.
No‐Add data is stored at the record level Overtime data is stored at the contact level. - ANSWER
Response Each Time - ANSWER Response type
stored separately on each of the records contacts
if blank, should be considered unknown
Lookback - ANSWER add type
stored separately on each contact
assume that last value entered remains true
Response Type - ANSWER 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. - ANSWER
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
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 shantelleG. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.