# QUESTION ANSWER
1 What is the Epic Clarity data Clarity is Epic's relational reporting
model? database, a collection of SQL tables
populated by the Caboodle ETL
process from Chronicles (the Epic
operational database), designed to
support analytics and reporting.
2 What is Chronicles in the context Chronicles is Epic's proprietary
of Epic? operational database that stores all
transactional data; it uses a
hierarchical/columnar structure and
serves as the source for the Clarity
ETL.
3 What does ETL stand for in ETL stands for Extract, Transform,
healthcare data? Load—the process that moves and
converts data from Chronicles (source)
into Clarity (destination) for reporting
purposes.
4 What is a 'master file' in Epic A master file is a top-level data
Chronicles? structure in Chronicles that groups
related records; each master file
corresponds to a set of Clarity tables
(e.g., Patient master file maps to
PATIENT table).
5 What is the primary patient table The PATIENT table (PAT) is the
in Clarity? primary patient demographics table in
Clarity, storing one row per patient
(indexed by PAT_ID).
6 What does PAT_ID represent in PAT_ID is the unique patient identifier
Clarity? in Clarity, corresponding to the
,# QUESTION ANSWER
patient's Enterprise Master Patient
Index (EMPI) record in Chronicles.
7 What is a contact serial number A Contact Serial Number (CSN) is a
(CSN)? unique identifier for each patient
encounter (visit/contact) in Epic; it links
encounter-level records across Clarity
tables.
8 What is an ENC_ID in Clarity? ENC_ID is an encounter identifier in
Clarity that maps to the patient
encounter; it is typically equivalent to
the CSN and is used to join encounter-
related tables.
9 What is the PAT_ENC table in PAT_ENC is the primary encounter
Clarity? table in Clarity, storing one row per
patient encounter, including visit type,
department, date/time, and encounter
status.
10 What is the difference between PAT_ENC stores all encounter types
PAT_ENC and PAT_ENC_HSP? (outpatient, inpatient, ED), while
PAT_ENC_HSP stores hospital
account-specific data for inpatient and
ED encounters.
11 What is an HAR (Hospital An HAR is a Hospital Account Record
Account Record) in Clarity? that represents a billing account for a
hospital (inpatient/ED) encounter; it is
stored in the HSP_ACCOUNT table in
Clarity.
12 What is a Guarantor Account in A Guarantor Account represents the
Clarity? responsible party for patient billing; it is
stored in the ACCOUNT table and
linked to patient encounters through
COVERAGE and ACCOUNT records.
13 What is an INI in Epic/Clarity? An INI (Item Number Identifier) refers
to a specific data item within a
Chronicles master file; it defines the
,# QUESTION ANSWER
type and structure of data stored in
that item (equivalent to a field/column).
14 What does the term 'related A related group (or RG) in Chronicles
group' mean in holds multiple values for a single
Chronicles/Clarity? record's repeating data; these are
extracted into separate child/related
tables in Clarity (e.g., PAT_ENC_DX
for diagnoses).
15 What is a 'line number' in Clarity A line number is a sequential integer
related tables? that, combined with the parent record
ID, uniquely identifies a row in a Clarity
child table derived from a Chronicles
related group.
16 What is the ORDER_PROC ORDER_PROC stores procedure
table in Clarity? orders (labs, imaging, referrals) placed
in Epic; each row represents one
order, keyed by ORDER_ID.
17 What is ORDER_RESULTS in ORDER_RESULTS stores result
Clarity? components for procedure orders
(particularly lab results), with each row
representing one result component
linked to an ORDER_ID.
18 What is the CLARITY_EDG CLARITY_EDG is the diagnosis table
table? in Clarity, storing diagnosis records
(ICD codes, descriptions, and
metadata) from the Epic diagnosis
master file.
19 What is the CLARITY_EAP CLARITY_EAP is the procedure
table? (order) catalog table in Clarity, storing
order master data such as procedure
names, types, and associated billing
codes from the EAP master file.
20 What does EAP stand for in EAP stands for 'Encounter-Associated
Epic? Procedure'—it is the order procedure
master file in Epic, cataloged in
CLARITY_EAP in Clarity.
, # QUESTION ANSWER
21 What is the CLARITY_DEP CLARITY_DEP is the department
table? master table in Clarity, storing
department IDs, names, specialty,
location, and other department
metadata from the DEP master file.
22 What is a 'department' in Epic A department is an organizational unit
Clarity? within Epic that represents a specific
clinical area (e.g., Cardiology Clinic,
ICU); it is used to classify encounters,
orders, and staff assignments.
23 What is PROV in Epic Clarity? PROV is the provider master file; the
CLARITY_SER table in Clarity stores
provider (staff) information including
NPI, specialty, and provider type.
24 What is CLARITY_SER? CLARITY_SER is the provider/staff
master table in Clarity, containing one
row per provider record with fields
such as PROV_ID, PROV_NAME,
NPI, and PROV_TYPE.
25 What is the difference between PROV_ID identifies a provider/clinician
PROV_ID and USER_ID in record (SER master file), while
Clarity? USER_ID identifies a system user
login record; a provider may have both
but they can differ.
26 What is the COVERAGE table in The COVERAGE table stores
Clarity? insurance/coverage information for
patients, including plan ID, subscriber,
payer, and coverage dates, linked to
patients via CVG_ID.
27 What is a CVG_ID in Clarity? CVG_ID is the unique identifier for a
coverage (insurance) record in Clarity,
stored in the COVERAGE table and
linked to patient encounters for billing
purposes.
28 What is the CLARITY_PLN CLARITY_PLN stores insurance plan
table? master data including plan names,
1 What is the Epic Clarity data Clarity is Epic's relational reporting
model? database, a collection of SQL tables
populated by the Caboodle ETL
process from Chronicles (the Epic
operational database), designed to
support analytics and reporting.
2 What is Chronicles in the context Chronicles is Epic's proprietary
of Epic? operational database that stores all
transactional data; it uses a
hierarchical/columnar structure and
serves as the source for the Clarity
ETL.
3 What does ETL stand for in ETL stands for Extract, Transform,
healthcare data? Load—the process that moves and
converts data from Chronicles (source)
into Clarity (destination) for reporting
purposes.
4 What is a 'master file' in Epic A master file is a top-level data
Chronicles? structure in Chronicles that groups
related records; each master file
corresponds to a set of Clarity tables
(e.g., Patient master file maps to
PATIENT table).
5 What is the primary patient table The PATIENT table (PAT) is the
in Clarity? primary patient demographics table in
Clarity, storing one row per patient
(indexed by PAT_ID).
6 What does PAT_ID represent in PAT_ID is the unique patient identifier
Clarity? in Clarity, corresponding to the
,# QUESTION ANSWER
patient's Enterprise Master Patient
Index (EMPI) record in Chronicles.
7 What is a contact serial number A Contact Serial Number (CSN) is a
(CSN)? unique identifier for each patient
encounter (visit/contact) in Epic; it links
encounter-level records across Clarity
tables.
8 What is an ENC_ID in Clarity? ENC_ID is an encounter identifier in
Clarity that maps to the patient
encounter; it is typically equivalent to
the CSN and is used to join encounter-
related tables.
9 What is the PAT_ENC table in PAT_ENC is the primary encounter
Clarity? table in Clarity, storing one row per
patient encounter, including visit type,
department, date/time, and encounter
status.
10 What is the difference between PAT_ENC stores all encounter types
PAT_ENC and PAT_ENC_HSP? (outpatient, inpatient, ED), while
PAT_ENC_HSP stores hospital
account-specific data for inpatient and
ED encounters.
11 What is an HAR (Hospital An HAR is a Hospital Account Record
Account Record) in Clarity? that represents a billing account for a
hospital (inpatient/ED) encounter; it is
stored in the HSP_ACCOUNT table in
Clarity.
12 What is a Guarantor Account in A Guarantor Account represents the
Clarity? responsible party for patient billing; it is
stored in the ACCOUNT table and
linked to patient encounters through
COVERAGE and ACCOUNT records.
13 What is an INI in Epic/Clarity? An INI (Item Number Identifier) refers
to a specific data item within a
Chronicles master file; it defines the
,# QUESTION ANSWER
type and structure of data stored in
that item (equivalent to a field/column).
14 What does the term 'related A related group (or RG) in Chronicles
group' mean in holds multiple values for a single
Chronicles/Clarity? record's repeating data; these are
extracted into separate child/related
tables in Clarity (e.g., PAT_ENC_DX
for diagnoses).
15 What is a 'line number' in Clarity A line number is a sequential integer
related tables? that, combined with the parent record
ID, uniquely identifies a row in a Clarity
child table derived from a Chronicles
related group.
16 What is the ORDER_PROC ORDER_PROC stores procedure
table in Clarity? orders (labs, imaging, referrals) placed
in Epic; each row represents one
order, keyed by ORDER_ID.
17 What is ORDER_RESULTS in ORDER_RESULTS stores result
Clarity? components for procedure orders
(particularly lab results), with each row
representing one result component
linked to an ORDER_ID.
18 What is the CLARITY_EDG CLARITY_EDG is the diagnosis table
table? in Clarity, storing diagnosis records
(ICD codes, descriptions, and
metadata) from the Epic diagnosis
master file.
19 What is the CLARITY_EAP CLARITY_EAP is the procedure
table? (order) catalog table in Clarity, storing
order master data such as procedure
names, types, and associated billing
codes from the EAP master file.
20 What does EAP stand for in EAP stands for 'Encounter-Associated
Epic? Procedure'—it is the order procedure
master file in Epic, cataloged in
CLARITY_EAP in Clarity.
, # QUESTION ANSWER
21 What is the CLARITY_DEP CLARITY_DEP is the department
table? master table in Clarity, storing
department IDs, names, specialty,
location, and other department
metadata from the DEP master file.
22 What is a 'department' in Epic A department is an organizational unit
Clarity? within Epic that represents a specific
clinical area (e.g., Cardiology Clinic,
ICU); it is used to classify encounters,
orders, and staff assignments.
23 What is PROV in Epic Clarity? PROV is the provider master file; the
CLARITY_SER table in Clarity stores
provider (staff) information including
NPI, specialty, and provider type.
24 What is CLARITY_SER? CLARITY_SER is the provider/staff
master table in Clarity, containing one
row per provider record with fields
such as PROV_ID, PROV_NAME,
NPI, and PROV_TYPE.
25 What is the difference between PROV_ID identifies a provider/clinician
PROV_ID and USER_ID in record (SER master file), while
Clarity? USER_ID identifies a system user
login record; a provider may have both
but they can differ.
26 What is the COVERAGE table in The COVERAGE table stores
Clarity? insurance/coverage information for
patients, including plan ID, subscriber,
payer, and coverage dates, linked to
patients via CVG_ID.
27 What is a CVG_ID in Clarity? CVG_ID is the unique identifier for a
coverage (insurance) record in Clarity,
stored in the COVERAGE table and
linked to patient encounters for billing
purposes.
28 What is the CLARITY_PLN CLARITY_PLN stores insurance plan
table? master data including plan names,
