CLR CLARITY DATA MODEL EXAM VERSION A -
COMPLETE QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE THIS YEAR JUST RELEASED
Question 1: What is the meaning of one row in my results (key
question to ask when writing a report)
Answer:
When constructing your query take now of how cardinality of a join or
prescence of a filter may modify your reports granularity.
Question 2: Starting a join with the most granular table will
maintain a consistent granularity with each subsequent join.
Answer:
Linking between tables
Question 3: Research on Chronicles
Answer:
Save time and energy by starting research in Chronicles rather than
going straight to Clarity. Understanding how the data is structured in
Chronicles will allow you to better understand the structure of Clarity.
Researching the record in the Record viewer will allow you to validate
the data in the source and explore link between data points. You cannot
trust the naming conventions in Clarity
Question 4: Clarity Dictionary Foreign Keys
Answer:
The foreign key section of Clarity Dictionary does not provide all possible
joins in Clarity and should only be used for the joins between category
,lists and ZC tables
Question 5: Networked Items
Answer:
Networked items in Chronicles define relationships between an item in
one master file and a record or contact. Each networked item will store
the ID of a Chronicles record or contact. A particular networked item will
always reference the same master file. Exmple: EPT 470 holds the ID of
the user who last changed the patients address. No matter the patient or
user EPT 470 can only store the .1 of an EMP records. This relationship
is part of the item definition.
Question 6: Finding a Networked INI
Answer:
From a field in Hyperspace: CTRL Click in the field to find the item
information window. More will reveal the item information and Network
INI. From Record Viewer : Hover over the item to show Net. Or hover
over the value to show Network to database. You may also open the
linked record to find the network INI. From Item Editor : Under the
network section look for the value in Target INI
Question 7: Most networked items point to records. Some
networked items point directly to a contact within a record.
Answer:
To identify whether a networked item links to a record or a contact look
at the Network section within the Item Editor. If the first field within that
section reads Record pointer then the link is to a record. If instead the
first field reads Contact pointer then the link is to a contact.
Question 8: Networked INI in Record Viewer
,Answer:
Record Viewer makes it easy to explore networked relationships. To see
the information contained in a linked record find a networked item and
click on the blue hyperlink in the items value. The link takes you to the
networked record where you can continue your search.
Question 9: How does a networked item compare to a category item
Answer:
Both networked items and category items store a value from a list. A
networked item points to an ID or contact within a master file. This
record or contact can store a wide variety of information depending on
the master file. A category item points to a value in a category list. This
category list contains little information other than the category value and
name. Both networked items and category items get extracted to foreign
key columns in Clarity. Networked items often extract to Clarity columns
that end in _ID and can be used as a foreign key to tables that store
records or contacts from the target master file. Category items extract to
Clarity columns that end in _C and can be used as foreign keys to ZC
tables in order to look up the name of the category value.
Question 10: When working with tables extracted from different
records there is often more than one way to join two tables
together
Answer:
Example There are multiple source columns in PAT_ENC_HSP that may
link to CLARITY_SER such as ADMISSION< DISCHARGE or
FOLLOWUP_PROV_ID. If you would like your query to show names of
all three providers you would need to join to CLARITY_SER three times
using each separate source column
, Question 11: If an items add type is no add and the response type
is single what element will be present in the primary key of the
table that extracts the item?
Answer:
Record ID
Question 12: What value is stored in a networked item?
Answer:
The .1 of a Chronicles record or the CSN of a contact on a Chronicles
record
Question 13: You have a patient query and would like to display the
name of the patients providers. Item EPT 18867 Admitting Provider
is a networked item that points to the SER master file. How can you
use Column Search help to display the name of the admitting
provider
Answer:
Use Column Search on EPT 18867 to find the foreign key column in the
starting table. You can also use Column Search on SER .2 to find the
table that stores provider names. Use the foreign key of the starting table
to join to the primary key of the destination table.T
Question 14: True or False Would it be possible to have more than
one copy of the same table in one report? Why or Why not?
Answer:
True because Chronicles master files can reference each other multiple
times there are multiple ways to link Clarity tables together.?
COMPLETE QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE THIS YEAR JUST RELEASED
Question 1: What is the meaning of one row in my results (key
question to ask when writing a report)
Answer:
When constructing your query take now of how cardinality of a join or
prescence of a filter may modify your reports granularity.
Question 2: Starting a join with the most granular table will
maintain a consistent granularity with each subsequent join.
Answer:
Linking between tables
Question 3: Research on Chronicles
Answer:
Save time and energy by starting research in Chronicles rather than
going straight to Clarity. Understanding how the data is structured in
Chronicles will allow you to better understand the structure of Clarity.
Researching the record in the Record viewer will allow you to validate
the data in the source and explore link between data points. You cannot
trust the naming conventions in Clarity
Question 4: Clarity Dictionary Foreign Keys
Answer:
The foreign key section of Clarity Dictionary does not provide all possible
joins in Clarity and should only be used for the joins between category
,lists and ZC tables
Question 5: Networked Items
Answer:
Networked items in Chronicles define relationships between an item in
one master file and a record or contact. Each networked item will store
the ID of a Chronicles record or contact. A particular networked item will
always reference the same master file. Exmple: EPT 470 holds the ID of
the user who last changed the patients address. No matter the patient or
user EPT 470 can only store the .1 of an EMP records. This relationship
is part of the item definition.
Question 6: Finding a Networked INI
Answer:
From a field in Hyperspace: CTRL Click in the field to find the item
information window. More will reveal the item information and Network
INI. From Record Viewer : Hover over the item to show Net. Or hover
over the value to show Network to database. You may also open the
linked record to find the network INI. From Item Editor : Under the
network section look for the value in Target INI
Question 7: Most networked items point to records. Some
networked items point directly to a contact within a record.
Answer:
To identify whether a networked item links to a record or a contact look
at the Network section within the Item Editor. If the first field within that
section reads Record pointer then the link is to a record. If instead the
first field reads Contact pointer then the link is to a contact.
Question 8: Networked INI in Record Viewer
,Answer:
Record Viewer makes it easy to explore networked relationships. To see
the information contained in a linked record find a networked item and
click on the blue hyperlink in the items value. The link takes you to the
networked record where you can continue your search.
Question 9: How does a networked item compare to a category item
Answer:
Both networked items and category items store a value from a list. A
networked item points to an ID or contact within a master file. This
record or contact can store a wide variety of information depending on
the master file. A category item points to a value in a category list. This
category list contains little information other than the category value and
name. Both networked items and category items get extracted to foreign
key columns in Clarity. Networked items often extract to Clarity columns
that end in _ID and can be used as a foreign key to tables that store
records or contacts from the target master file. Category items extract to
Clarity columns that end in _C and can be used as foreign keys to ZC
tables in order to look up the name of the category value.
Question 10: When working with tables extracted from different
records there is often more than one way to join two tables
together
Answer:
Example There are multiple source columns in PAT_ENC_HSP that may
link to CLARITY_SER such as ADMISSION< DISCHARGE or
FOLLOWUP_PROV_ID. If you would like your query to show names of
all three providers you would need to join to CLARITY_SER three times
using each separate source column
, Question 11: If an items add type is no add and the response type
is single what element will be present in the primary key of the
table that extracts the item?
Answer:
Record ID
Question 12: What value is stored in a networked item?
Answer:
The .1 of a Chronicles record or the CSN of a contact on a Chronicles
record
Question 13: You have a patient query and would like to display the
name of the patients providers. Item EPT 18867 Admitting Provider
is a networked item that points to the SER master file. How can you
use Column Search help to display the name of the admitting
provider
Answer:
Use Column Search on EPT 18867 to find the foreign key column in the
starting table. You can also use Column Search on SER .2 to find the
table that stores provider names. Use the foreign key of the starting table
to join to the primary key of the destination table.T
Question 14: True or False Would it be possible to have more than
one copy of the same table in one report? Why or Why not?
Answer:
True because Chronicles master files can reference each other multiple
times there are multiple ways to link Clarity tables together.?
