CLR Clarity Data Model Final Exam Actual
Exam Newest 2026-2027 With Complete
Questions And Correct Detailed Answers| Brand
New Version!
Since different tables can have different frequencies some of your data
in Clarity may be more up to date than other data. - ANSWER-Make
sure you know the exact frequencies of the tables that you use.
A key question to ask when writing a report is What is the meaning of
one row in my results? - ANSWER-When constructing your query take
note of how cardinality of a join or prescence of a filter may modify
your reports granularity.
Dont forget that the foreign key section in the Clarity Dictionary online
does not provide all possible joins in Clarity. - ANSWER-Clarity
Dictionary should only be used for joins between category lists and the
ZC_tables
Most networked items point to records. However some networked
items point directly to a contact within a record. - ANSWER-Identify
whether a networked item links to a record or a contact by looking 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.
1|Page
,If the first field reads Contact pointer then the link its to a contact.
Example: Patient CSN is an example of a networked item that points to
a contact.
ER Diagrams show some joins that are possible between Clarity tables. -
ANSWER-ER Diagrams will not document all possible joins between
Clarity tables. More research is needed to understand that contents of
each table and column and its relevance within a report.
Since Clarity views can be complex using a view in Clarity report can
hide this complexity. When using a view in a Clarity query any logic it
contains will execute alongside your code, which can affect
performance. - ANSWER-if query performance is an issue consider
querying tables directly or copying a portion of the view script for use
within your own reports
Epic SQL Functions will be found in the Clarity Compass but they are not
found in the Clarity Dictionary - ANSWER-Not found in Epic released
The StartDate and Enddate columns in Caboodle will not always
represent when data for the row was accurate. They are specifically the
ETL timestamps. - ANSWER-The purpose is to show what the contents
of a column looked like in the past. However data may not have been
updated exactly when its real world counterparts changed so
investigation is still required.
2|Page
,The general strategy for audit reporting is to use items in Chronicles for
audit reporting if they are available. - ANSWER-The item auditing tables
should be used as a last resort.
ACCESS_LOG And ACCESS_WRKF and their associated tables are some
of the largest in the Clarity database. When working with these tables
you should always include a filter on ACCESS_TIME. Failing to do so will
cause reports to run for a very long time and likely crash your
workstation. - ANSWER-Try to avoid linking two copies of these tables.
There are two columns that contain information about when an event
occurred: ACCESS_TIME and ACCESS_INSTANT. ACCESS_TIME is in
human readable format while ACCESS_INSTANT is an internal
representation of a time. - ANSWER-The two columns may not always
contain the same exact time.
ACCESS_TIME is the time at which the user access the data: when the
even took place.
ACCESS_INSTANT is the time at which the even was logged to the even
logging data structure.
Example: If a home health nurse saw a patient at 8am but doesnt sync
her laptop until 10pm ACCESS_TIME the time the event took place
would be 8am and ACCESS_INSTANT the time the event was logged to
the event log would be 10pm.
3|Page
, If both the ACCESS_LOG_TYPE_C and METRIC_WRKF_TYP_C columns
are populated then the even definition is tracked using both types of
event logging so one event populates both ACCESS_LOG and
ACCESS_WRKF - ANSWER-Keep this in mind if you are creating a report
that counts rows in each of these tables.
The Clarity data base is largely determined by the structure of -
ANSWER-Chronicles
Upon receiving a report request you will typically - ANSWER-1. Identify
the data elements you will need for the report
2. Find the INI and Item numbers of the data points to use on the report
3. Use the INI and item numbers to find the appropriate Clarity tables
and columns
4. Join the Clarity tables together using the correct foreign key
information
The INI and item number is the Chronicles address for a piece of data. -
ANSWER-It is with this Chronicles address that you can map the data
point to the appropriate table and column in Clarity.
Chronicles Research - ANSWER-Activities to look up Chronicles data
information:
Item Information window CTRL Click
4|Page
Exam Newest 2026-2027 With Complete
Questions And Correct Detailed Answers| Brand
New Version!
Since different tables can have different frequencies some of your data
in Clarity may be more up to date than other data. - ANSWER-Make
sure you know the exact frequencies of the tables that you use.
A key question to ask when writing a report is What is the meaning of
one row in my results? - ANSWER-When constructing your query take
note of how cardinality of a join or prescence of a filter may modify
your reports granularity.
Dont forget that the foreign key section in the Clarity Dictionary online
does not provide all possible joins in Clarity. - ANSWER-Clarity
Dictionary should only be used for joins between category lists and the
ZC_tables
Most networked items point to records. However some networked
items point directly to a contact within a record. - ANSWER-Identify
whether a networked item links to a record or a contact by looking 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.
1|Page
,If the first field reads Contact pointer then the link its to a contact.
Example: Patient CSN is an example of a networked item that points to
a contact.
ER Diagrams show some joins that are possible between Clarity tables. -
ANSWER-ER Diagrams will not document all possible joins between
Clarity tables. More research is needed to understand that contents of
each table and column and its relevance within a report.
Since Clarity views can be complex using a view in Clarity report can
hide this complexity. When using a view in a Clarity query any logic it
contains will execute alongside your code, which can affect
performance. - ANSWER-if query performance is an issue consider
querying tables directly or copying a portion of the view script for use
within your own reports
Epic SQL Functions will be found in the Clarity Compass but they are not
found in the Clarity Dictionary - ANSWER-Not found in Epic released
The StartDate and Enddate columns in Caboodle will not always
represent when data for the row was accurate. They are specifically the
ETL timestamps. - ANSWER-The purpose is to show what the contents
of a column looked like in the past. However data may not have been
updated exactly when its real world counterparts changed so
investigation is still required.
2|Page
,The general strategy for audit reporting is to use items in Chronicles for
audit reporting if they are available. - ANSWER-The item auditing tables
should be used as a last resort.
ACCESS_LOG And ACCESS_WRKF and their associated tables are some
of the largest in the Clarity database. When working with these tables
you should always include a filter on ACCESS_TIME. Failing to do so will
cause reports to run for a very long time and likely crash your
workstation. - ANSWER-Try to avoid linking two copies of these tables.
There are two columns that contain information about when an event
occurred: ACCESS_TIME and ACCESS_INSTANT. ACCESS_TIME is in
human readable format while ACCESS_INSTANT is an internal
representation of a time. - ANSWER-The two columns may not always
contain the same exact time.
ACCESS_TIME is the time at which the user access the data: when the
even took place.
ACCESS_INSTANT is the time at which the even was logged to the even
logging data structure.
Example: If a home health nurse saw a patient at 8am but doesnt sync
her laptop until 10pm ACCESS_TIME the time the event took place
would be 8am and ACCESS_INSTANT the time the event was logged to
the event log would be 10pm.
3|Page
, If both the ACCESS_LOG_TYPE_C and METRIC_WRKF_TYP_C columns
are populated then the even definition is tracked using both types of
event logging so one event populates both ACCESS_LOG and
ACCESS_WRKF - ANSWER-Keep this in mind if you are creating a report
that counts rows in each of these tables.
The Clarity data base is largely determined by the structure of -
ANSWER-Chronicles
Upon receiving a report request you will typically - ANSWER-1. Identify
the data elements you will need for the report
2. Find the INI and Item numbers of the data points to use on the report
3. Use the INI and item numbers to find the appropriate Clarity tables
and columns
4. Join the Clarity tables together using the correct foreign key
information
The INI and item number is the Chronicles address for a piece of data. -
ANSWER-It is with this Chronicles address that you can map the data
point to the appropriate table and column in Clarity.
Chronicles Research - ANSWER-Activities to look up Chronicles data
information:
Item Information window CTRL Click
4|Page
