Identify the Caboodle table and column for the following data point: Provider's
primary specialty
Give this one a try later!
ProviderDim.PrimarySpecialty
Identify the Caboodle table and column for the following data point: The patient's
phone number
Give this one a try later!
PatientDim.HomePhoneNumber
,True or False: All inferred rows in Caboodle have a primary key of -1.
Give this one a try later!
False. Inferred rows in Caboodle have non-negative primary key values
because they represent an entity that Caboodle has inferred the existence
of. The lookup columns for such rows will be set to -1 until the Caboodle
ETL process updates the data.
Identify the Caboodle table and column for the following data point, INI, and Item #:
Patient's Age, none
Give this one a try later!
ImmunizationEventFact.AgeKey
Identify the Caboodle table and column for the following data point: Column to
identify deleted primary care providers
Give this one a try later!
ProviderDim._IsDeleted = 1
Identify the Caboodle table and column for the following data point: First Reaction
(LPL 3008)
Give this one a try later!
, AllergyFact.FirstReaction
Identify the Caboodle table and column for the following data point: Allergy Severity
(ECT 7150)
Give this one a try later!
AllergyFact.Severity
Why might a BID choose to use a data mart table when writing a report?
Give this one a try later!
Data mart tables are designed for specific reporting topics. If a report was
about opioid orders, the OpioidOrderDataMart consolidates much of the
information necessary for a report. Consider researching in Reporting with
Caboodle to see Epic released data marts for reporting topics
Identify the Caboodle table and column for the following data point, INI, and Item #:
The immunizations in the VCG grouper, I VCG .1
Give this one a try later!
ImmunizationSetDim.ValueSetEpicId = '1137225'
primary specialty
Give this one a try later!
ProviderDim.PrimarySpecialty
Identify the Caboodle table and column for the following data point: The patient's
phone number
Give this one a try later!
PatientDim.HomePhoneNumber
,True or False: All inferred rows in Caboodle have a primary key of -1.
Give this one a try later!
False. Inferred rows in Caboodle have non-negative primary key values
because they represent an entity that Caboodle has inferred the existence
of. The lookup columns for such rows will be set to -1 until the Caboodle
ETL process updates the data.
Identify the Caboodle table and column for the following data point, INI, and Item #:
Patient's Age, none
Give this one a try later!
ImmunizationEventFact.AgeKey
Identify the Caboodle table and column for the following data point: Column to
identify deleted primary care providers
Give this one a try later!
ProviderDim._IsDeleted = 1
Identify the Caboodle table and column for the following data point: First Reaction
(LPL 3008)
Give this one a try later!
, AllergyFact.FirstReaction
Identify the Caboodle table and column for the following data point: Allergy Severity
(ECT 7150)
Give this one a try later!
AllergyFact.Severity
Why might a BID choose to use a data mart table when writing a report?
Give this one a try later!
Data mart tables are designed for specific reporting topics. If a report was
about opioid orders, the OpioidOrderDataMart consolidates much of the
information necessary for a report. Consider researching in Reporting with
Caboodle to see Epic released data marts for reporting topics
Identify the Caboodle table and column for the following data point, INI, and Item #:
The immunizations in the VCG grouper, I VCG .1
Give this one a try later!
ImmunizationSetDim.ValueSetEpicId = '1137225'
