CLR110 QUESTIONS AND VERIFIED ANSWERS GRADED A+
NEWEST 2025/2026 ASSURED SUCCESS REVIEW
Reviewing a colleagues report you see and unfamiliar table and
want to find out more about it. However you try looking it up but
cant find it in the Clarity Dictionary. Why might this happen and
where should you look instead? - ---Answers-----The Clarity
Dictionary from the userweb contains only Epic released
definitions. Any modifications made by your database admin will
not be reflected. To find all customizations access the Clarity
Compass in Hyperspace.
What Chronicles item characteristics allow multiple values to be
stored for a single record? - ---Answers-----Add type and
Response Type:
All data in a single extracted table in Clarity typically come from
the same Chronicles MASTERFILE.
All data in a single extracted table in Clarity typically com from
items with the same ADD TYPE and RESPONSE TYPE.
Multiple response Chronicles items typically extract to
SEPARATE Clarity tables unless they are part of the same
related group.
Define the Cardinality of a relationship - ---Answers-----It
describes the numerical relationship between entities in two
tables
What is the primary key of ORDER_PROC? - ---Answers-----
ORDER_PROC_ID
Based on the primary key what is the add type of the items
extracted to ORDER_PROC? - ---Answers-----NO ADD
,Based on the primary key ORDER_PROC_ID what is the response
type of the items extracted to this table? - ---Answers-----
Single
What is the primary key of ORDER_RESULTS? - ---Answers-----
ORDER_PROC_ID, ORDER_DATE_REAL and LINE
Based on the Primary key what is the add type of the items
extracted to ORDER_RESULTS? - ---Answers-----Overtime
Based on the primary key what is the response type of the items
extracted to this table? ORDER_RESULTS - ---Answers-----
Multiple Response
IF you were joining these tables together using the linking
diagram what should the join be? - ---Answers-----FROM
ORDER_RESULTS
INNER JOIN ORDER_PROC
ON ORDER_RESULTS.ORDER_PROC_ID =
ORDER_PROC.ORDER_PROC_ID
What is the granularity of the PATIENT table? - ---Answers-----
One row per patient
What is the granularity of the result set returned by joining
PATIENT to PATIENT_DOCS? - ---Answers-----One row per
document per patient
Describe the result set for the query by joining PATIENT to
PATIENT_DOCS - ---Answers-----For each patient find the list
of documents that the patient has provided.
,Would using a left outer join change the result set of PATIENT to
PATIENT_DOCS? - ---Answers-----Yes it would include patients
who have not turned in any documents
What is the granularity of the result set returned by joining
PATIENT_DOCS to PATIENT? - ---Answers-----One row per
document provided per patient
Would using a left outer join change the result set of
PATIENT_DOCS to PATIENT? - ---Answers-----No because
PATIENT_DOCS extracts EPT data every row has a match in the
PATIENT table
What is the result set when HSP_ATND_PROV and PAT_ENC_HSP
are joined on their PAT_ID columns - ---Answers-----For every
attending provider the query would return each of the hospital
encounters the patient had even if they were not attending
provider for that encounter.
What foreign key column should be used to join from
HSP_ATND_PROV to PAT_ENC_HSP? - ---Answers-----
PAT_ENC_CSN_ID
What is the primary key of PAT_ADDRESS? - ---Answers-----
PAT_ID and LINE
What is the primary key of OTHER_COMMUNCTN? - ---Answers-
----PAT_ID and LINE
What is the result when PAT_ADDRESS and OTHER_COMMUNCTN
are joined on their PAT_ID Columns? - ---Answers-----One row
per combination of a line in a patients address and phone
number for a patient.
, What is the result when PAT_ADDRESS and OTHER_COMMUNCTN
are joined on their PAT_ID and LINE columns? - ---Answers----
-The first line of the patients address is matched to the first
listed phone number, the second line of the address is matched
to the second listed phone number etc. IF there are more lines in
one table than in another those will be filtered out by an inner
join.
If a report required both patient addresses and patient phone
number how would you handle this data?
Pivot the data, such that each phone number was listed in a
separate column. Limit the results to only the first 2 lines of the
address and the first phone number. Clarify the report request to
determine whether all lines were needed or only the first few
lines.
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? - ---Answers-----Record ID
What value is stored in a networked item? - ---Answers-----The
.1 of a Chronicles record or the CSN of a contact on a Chronicles
record.
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 to help display the name of the admitting
provider? - ---Answers-----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 the
primary key of the destination table.
NEWEST 2025/2026 ASSURED SUCCESS REVIEW
Reviewing a colleagues report you see and unfamiliar table and
want to find out more about it. However you try looking it up but
cant find it in the Clarity Dictionary. Why might this happen and
where should you look instead? - ---Answers-----The Clarity
Dictionary from the userweb contains only Epic released
definitions. Any modifications made by your database admin will
not be reflected. To find all customizations access the Clarity
Compass in Hyperspace.
What Chronicles item characteristics allow multiple values to be
stored for a single record? - ---Answers-----Add type and
Response Type:
All data in a single extracted table in Clarity typically come from
the same Chronicles MASTERFILE.
All data in a single extracted table in Clarity typically com from
items with the same ADD TYPE and RESPONSE TYPE.
Multiple response Chronicles items typically extract to
SEPARATE Clarity tables unless they are part of the same
related group.
Define the Cardinality of a relationship - ---Answers-----It
describes the numerical relationship between entities in two
tables
What is the primary key of ORDER_PROC? - ---Answers-----
ORDER_PROC_ID
Based on the primary key what is the add type of the items
extracted to ORDER_PROC? - ---Answers-----NO ADD
,Based on the primary key ORDER_PROC_ID what is the response
type of the items extracted to this table? - ---Answers-----
Single
What is the primary key of ORDER_RESULTS? - ---Answers-----
ORDER_PROC_ID, ORDER_DATE_REAL and LINE
Based on the Primary key what is the add type of the items
extracted to ORDER_RESULTS? - ---Answers-----Overtime
Based on the primary key what is the response type of the items
extracted to this table? ORDER_RESULTS - ---Answers-----
Multiple Response
IF you were joining these tables together using the linking
diagram what should the join be? - ---Answers-----FROM
ORDER_RESULTS
INNER JOIN ORDER_PROC
ON ORDER_RESULTS.ORDER_PROC_ID =
ORDER_PROC.ORDER_PROC_ID
What is the granularity of the PATIENT table? - ---Answers-----
One row per patient
What is the granularity of the result set returned by joining
PATIENT to PATIENT_DOCS? - ---Answers-----One row per
document per patient
Describe the result set for the query by joining PATIENT to
PATIENT_DOCS - ---Answers-----For each patient find the list
of documents that the patient has provided.
,Would using a left outer join change the result set of PATIENT to
PATIENT_DOCS? - ---Answers-----Yes it would include patients
who have not turned in any documents
What is the granularity of the result set returned by joining
PATIENT_DOCS to PATIENT? - ---Answers-----One row per
document provided per patient
Would using a left outer join change the result set of
PATIENT_DOCS to PATIENT? - ---Answers-----No because
PATIENT_DOCS extracts EPT data every row has a match in the
PATIENT table
What is the result set when HSP_ATND_PROV and PAT_ENC_HSP
are joined on their PAT_ID columns - ---Answers-----For every
attending provider the query would return each of the hospital
encounters the patient had even if they were not attending
provider for that encounter.
What foreign key column should be used to join from
HSP_ATND_PROV to PAT_ENC_HSP? - ---Answers-----
PAT_ENC_CSN_ID
What is the primary key of PAT_ADDRESS? - ---Answers-----
PAT_ID and LINE
What is the primary key of OTHER_COMMUNCTN? - ---Answers-
----PAT_ID and LINE
What is the result when PAT_ADDRESS and OTHER_COMMUNCTN
are joined on their PAT_ID Columns? - ---Answers-----One row
per combination of a line in a patients address and phone
number for a patient.
, What is the result when PAT_ADDRESS and OTHER_COMMUNCTN
are joined on their PAT_ID and LINE columns? - ---Answers----
-The first line of the patients address is matched to the first
listed phone number, the second line of the address is matched
to the second listed phone number etc. IF there are more lines in
one table than in another those will be filtered out by an inner
join.
If a report required both patient addresses and patient phone
number how would you handle this data?
Pivot the data, such that each phone number was listed in a
separate column. Limit the results to only the first 2 lines of the
address and the first phone number. Clarify the report request to
determine whether all lines were needed or only the first few
lines.
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? - ---Answers-----Record ID
What value is stored in a networked item? - ---Answers-----The
.1 of a Chronicles record or the CSN of a contact on a Chronicles
record.
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 to help display the name of the admitting
provider? - ---Answers-----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 the
primary key of the destination table.
