Data lineage Flashcards
Which of Epic’s databases contain real time data?
Chronicles
Which of Epic’s databases are relational databases?
Clarity and caboodle
True or false. You can use the record viewer to look up a list of columns and a Clarity table. 
False. Use the record viewer to view data from a record in chronicles. Use the data dictionary in the analytics catalog to look up the columns in a clarity table. 
Where does Epic’s data lineage begin?
It begins with chronicles, then, every night, clarity ETL transfers data from chronicles to clarity. Lastly, caboodle ETL transfers data from clarity to caboodle the same night as clarity ETL. 
What is the structure of Chronicles?
Tree structure. It is first divided into master files, each master file contains records, records contain contacts, and individual data points within a record or contact are stored as items. Items that store multiple pieces of information at a time have multiple lines. 
What type of data can caboodle hold?
Caboodle is designed to hold data from multiple sources, both epic and non-epic data. Clarity holds much more epic data than caboodle. 
What is an item number?
The item number uniquely identifies a data element in chronicles 
How many data types are there in Chronicles?
There are six. String, number, date, time, instant, category.
What is add type? 
Add type determines whether item values are specific to one contact or whether values apply to all of the record’s contacts. 
How many add types are there?
Three. No-add, response each time, look back. 
What is response type?
Response type determines how many values an item can hold at once.
What are the types of response types
Single response, multiple response, related group
What is a “response each time” item in Chronicles?
An item that can contain different data across different contacts 
