Clarity Data Model Fundamentals CORRECT QUESTIONS & SOLUTIONS!!!
7 views 0 purchase
Course
CLR110 Clarity Data Model Fundamentals
Institution
CLR110 Clarity Data Model Fundamentals
when would you use clarity compass / data dictionary? - ANSWER Clarity Compass - see custom category values and other organization specific settings.
Data dictionary - no access to hyperspace or want to be able to use control F to search the table summary.
Use ____________ to get information ab...
Clarity Data Model Fundamentals CORRECT
QUESTIONS & SOLUTIONS!!!
when would you use clarity compass / data dictionary? - ANSWER Clarity Compass - see custom category
values and other organization specific settings.
Data dictionary - no access to hyperspace or want to be able to use control F to search the table
summary.
Use ____________ to get information about tables when you're in Hyperspace - ANSWER Database
object search
If you know a Chronicles INI and item, and you want to know the Clarity column it extracts to, how can
you find it? - ANSWER Use Column Search, and enter the INI and Item.
What happens when a column is marked as Deprecated? - ANSWER No more data will be extracted into
the column, although any data already there will not be deleted.
What does it mean if a column's name ends with _C? - ANSWER The column holds a category value.
You'll need to link it to a ZC_ table to find what that category value means.
True or False: A Clarity table with only one column listed as the primary key will always hold no-add,
single-response data. - ANSWER False; for example, a table with a CSN listed as the primary key would
hold overtime, single-response data.
Which of the following columns from the PATIENT table holds a category value?
a. PAT_ID
b. PAT_NAME
c. STATE_C
d. PAT_STATUS - ANSWER c. STATE_C
, Which table would you use to display a patient's middle name (EPT 119) on a Clarity report?
a. PATIENT
b. PAT_ENC
c. PATIENT_TYPE
d. ZC_PATIENT_TYPE - ANSWER a. PATIENT - Use the column search to find where EPT 119 extracts to
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 This is an analytical report.
If you need to use two copies of ORDER_PROC, why shouldn't you give the two copies the aliases
ORDER_PROC_1 and ORDER_PROC_2? - ANSWER Looking in the Clarity Compass, there is a table named
ORDER_PROC_2. If you were to use ORDER_PROC_2 as an alias it would be difficult to determine if you
are using the ORDER_PROC_2 table or if it is an alias you have assigned to the ORDER_PROC table.
True or False. The best way to determine whether an inner join or a left outer join should be used is the
starting table's primary key. - ANSWER False. The reporting need, load type and frequency will determine
whether two tables should be joined using a left outer join or an inner join.
A Clarity table's primary key includes a "CSN." What does this mean? - ANSWER A CSN is a Contact Serial
Number, which identifies a specific contact within a specific record. A table with a CSN in its primary key
extracts overtime data - if it extracted no-add data, you wouldn't need to identify a contact.
A Clarity table's primary key includes a line count. What does this mean? - ANSWER Only Chronicles
items with a response type of multiple-response or related group have line counts, so you know the
table must extract multiple-response or related group items.
What are the two types of test cases that should be used? Why are both necessary? - ANSWER As a
report is being validated, both inclusive and exclusive cases should be examined. This is to make sure
that the correct information is being returned by the report, and that incorrect information is not being
returned.
True or False. You should use the Production environment to seed data only if the name you give records
includes the word "test". - ANSWER False. Only use a test environment to seed data
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 $11.99. You're not tied to anything after your purchase.