cog170 data lineage Flashcards
Which of Epic’s databases contains real-time data?
Chronicles
Which of Epic’s databases are relational databases?
Clarity & Caboodle
True or False. You can use the Record Viewer to look up a list of columns in the 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.
What is the difference between a record and a contact?
A record is a single entity. A contact represents a single set of data (usually representing a unique time period) on that record.
What is the difference between a multiple response item and a response each time item?
These refer to different item characteristics. ‘Multiple response’ refers to a particular Response Type. A multiple response item can hold multiple answers on one contact. ‘Response each time’ refers to a particular Add Type. A response each time item can hold different answers on different contacts.
True or False. A patient who has been seen twice at your facility should have two records in the Patient Master File.
False. The patient should only have one record, but that record will have two contacts.
When you can, write reports using _____ rather than _____.
Caboodle, Clarity
Use _____ if the information you’re looking for is not in _____.
Clarity, Caboodle
True or False. Every Master File has an Item .2 Record Name.
False. A record’s name does not have to be unique.
What is a ‘response each time’ item in Chronicles?
An item that can contain different data across different contacts.
_____ holds more Epic data than _____.
Clarity, Caboodle
When using Chronicles, use _____ _ _____ to find where an item is stored in Hyperspace.
CTRL + Click
One of the most common uses of _____ _____ is to locate a data point for use in a report.
Record Viewer
How many data types are in Chronicles?
6; String, Number, Date, Time, Instant, & Category
What is the purpose of Item Editor?
an activity that tells you an item’s characteristics and whether the item is indexed and/or networked.
The category list for an item can be viewed here for items with the category data type. If the list is not visible, it may be shared with one or more items.
True or False. Each Category list has a release range, which is the range of values reserved by Epic.
True
True or False. When multiple items share the same category list, all items will store the list.
False. Only the first item will store the list.
_____ _____ determines whether item values are specific to one contact, or whether values apply to all of the record’s contacts.
Add Type
What are the 3 different add types?
No-add, Response each time, and Lookback
What determines how many values an item can hold at once?
Response Type.
True or False: Many master files do not attach meaning to contacts.
True.
How can you identify an item as networked?
The item information window contains a ‘Network INI’ field, the item’s definition in Item Editor contains a ‘Network’ category, or the Record Viewer value for that item contains a hyperlink.
How can you identify an item as indexed?
The item information window contains an ‘Indexed’ field, the item’s definition in Item Editor contains an ‘Indexing’ category, or hovering over the item in the Record Viewer shows ‘Has Index’ in the help text.
True or False: Items that have been indexed in Chronicles will be indexed in Clarity and Caboodle as well.
False.
True or False. Chronicle item values are stored separately from item names.
True
If a patient’s last name changed, would a contact from prior to the name change store the old last name or the new last name?
New last name.
What nickname is used for the Response Each Time and Lookback add-types?
Overtime.
A networked item points to a record in another master file. What item from the destination record shares the value of the networked item?
0.1
Does a networked item store the name, the ID, or both the name and ID of the record/contact it points to?
ID Only.
Which tools can be used to identify whether an item is networked?
Item Information window, Item Editor, Record Viewer.
Does EPT .1 imply that SER .1 stores a provider’s internal ID?
Yes. .1 stores a record’s internal ID for any master file.
What are records in the ETR master file?
Transactions.
Chronicles 3 digit identifier of a master file
INI
board subject of chronicles (ie Patients, Payers, etc)
Master File
EPT
Patient Master File
ORD
Orders master file
Single item in master file (row), ie 1 order, 1 patient
Record (Master File)
Contact (Master File)
instance of service or issuance (ie EPT = Patient Encounter, ORD = specific issuance/administration of med or result)
Item (Master File)
Individual data point in a record
ie “column” - Patient Name, DOB
Line
when there is more than one “item” per “column”
ie Multiple DXs per Encounter “Contact”
CSN
Contact Serial Number
Unique Identifier of a contact under a master file
Which databases can Reporting Workbench build reports off of?
All of them!
Chronicles, Clarity, Caboodle