CLR 110 Clarity Data Model Fundamentals ACTUAL
EXAM 2026/2027 | Comprehensive Q&A | Verified
Q&A | Pass Guaranteed - A+ Graded
Section A: Multiple Choice (Questions 1–50)
Q1: Which Clarity table contains the primary source of truth for a patient's legal name and date of birth?
A. ENCOUNTER
B. PATIENT [CORRECT]
C. PAT_ALIAS
D. CONTACT
Correct Answer: B
Rationale: The PATIENT table stores core demographic information including legal name (NAME,
FIRST_NAME, LAST_NAME), date of birth (BIRTH_DATE), sex (SEX_C), and the unique PAT_ID primary
key. ENCOUNTER contains visit-specific data; PAT_ALIAS stores alternate names (maiden names,
nicknames); CONTACT stores emergency contact and next-of-kin information.
Verified Source: Clarity Data Dictionary – PATIENT table, v.2026
Topic: Core Tables – Patient Demographics
Q2: A clinical analyst needs to identify all encounters where a patient was admitted as an inpatient.
Which field in the ENCOUNTER table indicates the encounter type?
A. ADT_STATUS_C
B. ENC_TYPE_C [CORRECT]
C. VISIT_TYPE_C
D. PAT_CLASS_C
Correct Answer: B
Rationale: ENC_TYPE_C (Encounter Type) categorizes encounters (e.g., Inpatient, Outpatient,
Emergency, Surgery). ADT_STATUS_C tracks admission/discharge/transfer status (Admitted,
Discharged). PAT_CLASS_C indicates patient classification (Inpatient, Outpatient, Emergency) but is less
granular than ENC_TYPE_C. VISIT_TYPE_C is not a standard Clarity ENCOUNTER field.
,Verified Source: Clarity Data Dictionary – ENCOUNTER table, v.2026
Topic: Core Tables – Encounter Classification
Q3: Which table stores the link between a provider and their National Provider Identifier (NPI)?
A. PROVIDER
B. CLARITY_SER
C. IDENTITY_ID [CORRECT]
D. USER_ID
Correct Answer: C
Rationale: IDENTITY_ID is the crosswalk table linking internal Clarity IDs (like PROV_ID) to external
identifiers including NPI, DEA numbers, and UPIN. PROVIDER/CLARITY_SER contains provider
demographics and employment details but not external IDs directly. USER_ID tracks system login
accounts, not clinical provider credentials.
Verified Source: Clarity Data Dictionary – IDENTITY_ID table, v.2026
Topic: Core Tables – Provider Identification
Q4: In the ORDER table, which field identifies the specific medication or procedure ordered?
A. ORDER_ID
B. PAT_ID
C. ORDER_PROC_ID [CORRECT]
D. ENCOUNTER_ID
Correct Answer: C
Rationale: ORDER_PROC_ID links to the CLARITY_EAP or ORDER_CATALOG table to identify the specific
procedure, medication, or lab test ordered. ORDER_ID is the unique identifier for the order instance;
PAT_ID links to the patient; ENCOUNTER_ID links to the visit context.
Verified Source: Clarity Data Dictionary – ORDER table, v.2026
Topic: Core Tables – Order Identification
Q5: A data analyst needs to find all laboratory results for hemoglobin A1c. Which table contains the
actual result values?
A. ORDER
,B. ORDER_RESULT
C. RESULT [CORRECT]
D. LAB_COMPONENT
Correct Answer: C
Rationale: The RESULT table stores actual result values (RESULT_VAL, NUMERIC_RESULT_VAL) with
COMPONENT_ID linking to component definitions. ORDER_RESULT is a linking table between orders and
results. ORDER stores the order request, not results. LAB_COMPONENT defines test components but
doesn't store patient-specific values.
Verified Source: Clarity Data Dictionary – RESULT table, v.2026
Topic: Core Tables – Result Storage
Q6: Which table contains ICD-10 diagnosis codes associated with patient encounters?
A. DIAGNOSIS [CORRECT]
B. PATIENT
C. PROBLEM_LIST
D. EDG_CURRENT_ICD10
Correct Answer: A
Rationale: The DIAGNOSIS table stores encounter-specific diagnoses with DX_ID linking to
EDG_CURRENT_ICD10 for code descriptions. PROBLEM_LIST stores the patient's active and historical
problem list (chronic conditions), which is distinct from encounter-specific diagnoses. PATIENT does not
store diagnosis data.
Verified Source: Clarity Data Dictionary – DIAGNOSIS table, v.2026
Topic: Core Tables – Diagnosis Documentation
Q7: To find Current Procedural Terminology (CPT) codes for procedures performed during an encounter,
which table should be queried?
A. ORDER
B. PROCEDURE [CORRECT]
C. CLARITY_EAP
D. BILL_PROCEDURE
, Correct Answer: B
Rationale: The PROCEDURE table stores procedure records with PROC_ID linking to CLARITY_EAP for
CPT/HCPCS codes and descriptions. BILL_PROCEDURE stores billing-specific procedure data. ORDER
tracks orders placed, not necessarily procedures performed.
Verified Source: Clarity Data Dictionary – PROCEDURE table, v.2026
Topic: Core Tables – Procedure Documentation
Q8: Which table stores medication administration records (MAR) showing what was actually given to the
patient?
A. ORDER
B. MEDICATION
C. MAR [CORRECT]
D. PHARMACY
Correct Answer: C
Rationale: MAR (Medication Administration Record) stores actual administration events including
administration time, dose given, and administering nurse. MEDICATION stores medication orders and
dispensing information but not bedside administration. ORDER stores the original order. PHARMACY is
not a standard Clarity table.
Verified Source: Clarity Data Dictionary – MAR table, v.2026
Topic: Core Tables – Medication Administration
Q9: Which field in the ENCOUNTER table would you use to determine if an encounter is currently active
versus historical?
A. CONTACT_DATE
B. EFFECTIVE_DATE
C. ENC_CLOSE_DATE [CORRECT]
D. ADMIT_DATE
Correct Answer: C
Rationale: ENC_CLOSE_DATE indicates when an encounter was closed/completed. If NULL, the
encounter is still active. CONTACT_DATE is the encounter date; ADMIT_DATE is admission date;
EXAM 2026/2027 | Comprehensive Q&A | Verified
Q&A | Pass Guaranteed - A+ Graded
Section A: Multiple Choice (Questions 1–50)
Q1: Which Clarity table contains the primary source of truth for a patient's legal name and date of birth?
A. ENCOUNTER
B. PATIENT [CORRECT]
C. PAT_ALIAS
D. CONTACT
Correct Answer: B
Rationale: The PATIENT table stores core demographic information including legal name (NAME,
FIRST_NAME, LAST_NAME), date of birth (BIRTH_DATE), sex (SEX_C), and the unique PAT_ID primary
key. ENCOUNTER contains visit-specific data; PAT_ALIAS stores alternate names (maiden names,
nicknames); CONTACT stores emergency contact and next-of-kin information.
Verified Source: Clarity Data Dictionary – PATIENT table, v.2026
Topic: Core Tables – Patient Demographics
Q2: A clinical analyst needs to identify all encounters where a patient was admitted as an inpatient.
Which field in the ENCOUNTER table indicates the encounter type?
A. ADT_STATUS_C
B. ENC_TYPE_C [CORRECT]
C. VISIT_TYPE_C
D. PAT_CLASS_C
Correct Answer: B
Rationale: ENC_TYPE_C (Encounter Type) categorizes encounters (e.g., Inpatient, Outpatient,
Emergency, Surgery). ADT_STATUS_C tracks admission/discharge/transfer status (Admitted,
Discharged). PAT_CLASS_C indicates patient classification (Inpatient, Outpatient, Emergency) but is less
granular than ENC_TYPE_C. VISIT_TYPE_C is not a standard Clarity ENCOUNTER field.
,Verified Source: Clarity Data Dictionary – ENCOUNTER table, v.2026
Topic: Core Tables – Encounter Classification
Q3: Which table stores the link between a provider and their National Provider Identifier (NPI)?
A. PROVIDER
B. CLARITY_SER
C. IDENTITY_ID [CORRECT]
D. USER_ID
Correct Answer: C
Rationale: IDENTITY_ID is the crosswalk table linking internal Clarity IDs (like PROV_ID) to external
identifiers including NPI, DEA numbers, and UPIN. PROVIDER/CLARITY_SER contains provider
demographics and employment details but not external IDs directly. USER_ID tracks system login
accounts, not clinical provider credentials.
Verified Source: Clarity Data Dictionary – IDENTITY_ID table, v.2026
Topic: Core Tables – Provider Identification
Q4: In the ORDER table, which field identifies the specific medication or procedure ordered?
A. ORDER_ID
B. PAT_ID
C. ORDER_PROC_ID [CORRECT]
D. ENCOUNTER_ID
Correct Answer: C
Rationale: ORDER_PROC_ID links to the CLARITY_EAP or ORDER_CATALOG table to identify the specific
procedure, medication, or lab test ordered. ORDER_ID is the unique identifier for the order instance;
PAT_ID links to the patient; ENCOUNTER_ID links to the visit context.
Verified Source: Clarity Data Dictionary – ORDER table, v.2026
Topic: Core Tables – Order Identification
Q5: A data analyst needs to find all laboratory results for hemoglobin A1c. Which table contains the
actual result values?
A. ORDER
,B. ORDER_RESULT
C. RESULT [CORRECT]
D. LAB_COMPONENT
Correct Answer: C
Rationale: The RESULT table stores actual result values (RESULT_VAL, NUMERIC_RESULT_VAL) with
COMPONENT_ID linking to component definitions. ORDER_RESULT is a linking table between orders and
results. ORDER stores the order request, not results. LAB_COMPONENT defines test components but
doesn't store patient-specific values.
Verified Source: Clarity Data Dictionary – RESULT table, v.2026
Topic: Core Tables – Result Storage
Q6: Which table contains ICD-10 diagnosis codes associated with patient encounters?
A. DIAGNOSIS [CORRECT]
B. PATIENT
C. PROBLEM_LIST
D. EDG_CURRENT_ICD10
Correct Answer: A
Rationale: The DIAGNOSIS table stores encounter-specific diagnoses with DX_ID linking to
EDG_CURRENT_ICD10 for code descriptions. PROBLEM_LIST stores the patient's active and historical
problem list (chronic conditions), which is distinct from encounter-specific diagnoses. PATIENT does not
store diagnosis data.
Verified Source: Clarity Data Dictionary – DIAGNOSIS table, v.2026
Topic: Core Tables – Diagnosis Documentation
Q7: To find Current Procedural Terminology (CPT) codes for procedures performed during an encounter,
which table should be queried?
A. ORDER
B. PROCEDURE [CORRECT]
C. CLARITY_EAP
D. BILL_PROCEDURE
, Correct Answer: B
Rationale: The PROCEDURE table stores procedure records with PROC_ID linking to CLARITY_EAP for
CPT/HCPCS codes and descriptions. BILL_PROCEDURE stores billing-specific procedure data. ORDER
tracks orders placed, not necessarily procedures performed.
Verified Source: Clarity Data Dictionary – PROCEDURE table, v.2026
Topic: Core Tables – Procedure Documentation
Q8: Which table stores medication administration records (MAR) showing what was actually given to the
patient?
A. ORDER
B. MEDICATION
C. MAR [CORRECT]
D. PHARMACY
Correct Answer: C
Rationale: MAR (Medication Administration Record) stores actual administration events including
administration time, dose given, and administering nurse. MEDICATION stores medication orders and
dispensing information but not bedside administration. ORDER stores the original order. PHARMACY is
not a standard Clarity table.
Verified Source: Clarity Data Dictionary – MAR table, v.2026
Topic: Core Tables – Medication Administration
Q9: Which field in the ENCOUNTER table would you use to determine if an encounter is currently active
versus historical?
A. CONTACT_DATE
B. EFFECTIVE_DATE
C. ENC_CLOSE_DATE [CORRECT]
D. ADMIT_DATE
Correct Answer: C
Rationale: ENC_CLOSE_DATE indicates when an encounter was closed/completed. If NULL, the
encounter is still active. CONTACT_DATE is the encounter date; ADMIT_DATE is admission date;
