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: The Encounter's
Epic CSN
Give this one a try later!
EdVisitFact.EncounterEpicCsn
Identify the Caboodle table and column for the following data point: The Epic ID for
the medication order
Give this one a try later!
MedicationOrderFact.MedicationOrderEpicId
A lookup column in Caboodle contains the value -3. What could this mean?
Give this one a try later!
There are two possibilities: Either the data that once populated this row in
Caboodle has been deleted from the source or this is the row with -3 as its
primary key, for which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative value
indicates that this row represents deleted data in the source.
Use the Cogito Dictionary to list 3 examples of <Entity>DataMart tables.
Give this one a try later!
, DiabetesRegistryDataMartX, HospitalReadmissionDataMart,
OpioidOrderDataMart... and many others
Identify the Caboodle table and column for the following data point, INI, and Item #:
Immunization Name, I LIM .2
Give this one a try later!
ImmunizationDim.Name
Identify the Caboodle table and column for the following data point: The date of the
Encounter
Give this one a try later!
EncounterFact.Date
Identify the Caboodle table and column for the following data point: The Primary Key
of AllergyFact
Give this one a try later!
AllergyFact.AllergyKey
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!
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: The Encounter's
Epic CSN
Give this one a try later!
EdVisitFact.EncounterEpicCsn
Identify the Caboodle table and column for the following data point: The Epic ID for
the medication order
Give this one a try later!
MedicationOrderFact.MedicationOrderEpicId
A lookup column in Caboodle contains the value -3. What could this mean?
Give this one a try later!
There are two possibilities: Either the data that once populated this row in
Caboodle has been deleted from the source or this is the row with -3 as its
primary key, for which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative value
indicates that this row represents deleted data in the source.
Use the Cogito Dictionary to list 3 examples of <Entity>DataMart tables.
Give this one a try later!
, DiabetesRegistryDataMartX, HospitalReadmissionDataMart,
OpioidOrderDataMart... and many others
Identify the Caboodle table and column for the following data point, INI, and Item #:
Immunization Name, I LIM .2
Give this one a try later!
ImmunizationDim.Name
Identify the Caboodle table and column for the following data point: The date of the
Encounter
Give this one a try later!
EncounterFact.Date
Identify the Caboodle table and column for the following data point: The Primary Key
of AllergyFact
Give this one a try later!
AllergyFact.AllergyKey
Identify the Caboodle table and column for the following data point, INI, and Item #:
The immunizations in the VCG grouper, I VCG .1
