Download Understanding Epic's Data Lineage and Databases and more Exams Advanced Education in PDF only on Docsity!
COG170 Cogito Fundamentals Chapter 4
Data Lineage Exam Questions And
Answers
- Which of Epic's databases contains real-time data? a. Chronicles b. Clarity c. Caboodle - Correct Answer - a. Chronicles
- Which of Epic's databases are relational databases? a. Chronicles b. Clarity c. Caboodle - Correct Answer - b. Clarity c. Caboodle
- True or False. You can use the Record Viewer to look up the definition of a table in Clarity. - Correct Answer - False. Use the Record Viewer to view data from a record in Chronicles. Use the Clarity Dictionary to look up the definition of a table in Clarity. All Epic data is stored in one of three databases: __________, _________________, or ______________ - Correct Answer - Chronicles, Clarity and Caboodle.
A _____________________ is an organized collection of data. The purpose of a _______________ defines its structure. Chronicles, Clarity and Caboodle each have different purposes, so each has a different structure, and each is separate from the others. In many reporting tools, databases are also called __________________________. - Correct Answer - database, database, data sources. __________ refers to the origin of data as they flow from one database to another. Epic data lineage starts with Chronicles. This is where end users put in data. - Correct Answer - Data lineage
- First, Epic users enter data into _________, usually through _____________________. - Then, every night, Clarity _____________________transfers data from Chronicles to Clarity. - Last, ________________transfers data from Clarity to Caboodle the same night as Clarity ETL. - Correct Answer - Chronicles, Hyperspace. Clarity ETL (Extract, Transform, and Load) Caboodle ETL ___________________ is designed to be efficient for daily healthcare operations. ______________meets this need by storing a patient's
notes, & departments. - Correct Answer - Master file, Master files, Master files Master files contain ______. ___________ contain information about individual entities within a master file. For example, a ___________ in the patient master file contains information about a single patient. A ___________ in the orders master file contains information about a single order. - Correct Answer - Record Records Records contain __________. __________ contain information about points in time for a record. For example, the patient master file uses __________ for patient encounters. - Correct Answer - Contact Individual data within a record or contact are stored in _______s. For example, the patient master file has an_______ that stores social security number and an _______that stores admission date. _______ that store multiple pieces of information at a time have multiple lines. For example, there is an _______ for diagnoses that has one line for each diagnosis entered. - Correct Answer - Item _______ is designed to be efficient and flexible for reporting on large amounts of data over long periods of time. _______ stores data in tables that look like a two dimensional grid with rows and columns. Each column holds a piece of information, similar to an item in Chronicles. Each row represents an entity that the data in the columns are about. For example, there is a table that has one row for every patient, and each column has
information about patients. It is not specific to Epic's software. Since data are extracted nightly to _______, it does not contain today's data. - Correct Answer - Clarity ___________ is similar to Clarity in that it is a relational database consisting of tables with rows and columns and is accessed using SQL. ___________ is designed to make reporting simpler and more efficient than it is in Clarity. For example, in Clarity, information about providers is stored in a table called CLARITY_SER, while ___________ stores the same information in a more intuitively named table, ProviderDim. Many columns in ProviderDim can provide information directly, while the equivalent columns in CLARITY_SER require additional work or processing time to make sense of. - Correct Answer
- Caboodle __________ is a data warehouse, which means it can hold data from multiple sources, in this case both Epic and non-Epic data. These are major advantages of __________ , but Clarity holds much more information than __________. Similar to Clarity, __________ does not contain today's data. Not all Epic data is in __________. More information is being added to it with every release, but some reports that can be written using Epic's other databases can't be written using __________. - Correct Answer - Caboodle What is ETL - ETL (Extract, Transform, and Load) - Correct Answer - The process of copy down that Copies data from Epic's Chronicles, To Clarity to Caboodle.
Add Type Response Type Networking Indexing Each item in a Chronicles master file has a unique item number. Although most item numbers do not carry meaning in different INIs, there are two items that do preserve their meaning across all master files: ___________ and _______________ - Correct Answer - the "dot one" and the "dot two". What is Item .1 - Record ID - Correct Answer - Every record in Chronicles has a unique identifier held in item .1. A record ID is guaranteed to be unique within a master file, though not necessarily across master files. There may be a patient with the EPT Record ID 1000 and a provider with the SER Record ID 1000. What is Item .2 - Record Name - Correct Answer - For master files where a name makes sense, item .2 stores the name of the record. Unlike its record ID, a record's name does not have to be unique. You might have several patients named "John Smith" in your system, and each store the name "John Smith" in item .2. However, each would have a different record ID in item .1, making them uniquely identifiable.
Data Type - String - Correct Answer - String Any combination of characters. The format of string items is often restricted in the user entry interface in Hyperspace. Data Type - Number - Correct Answer - Number Any number - can be an integer, decimal or use scientific notation. Also, due to how M operates, any leading and trailing zeroes will be stripped. Data Type - Date A date without a time. - Correct Answer - Date A date without a time. End users will generally enter dates in a standard format, such as "4/1/2009". However, in Chronicles the date is actually stored as the number of days since 12/31/1840. "4/1/2009" would actually be stored as "61452". This number is converted back into standard format for display. Data Type - Time A time without a date.. - Correct Answer - Time A time without a date. End users will generally enter dates in a standard format, such as "12:00 pm". However, in Chronicles the time is actually stored as the number of seconds since midnight. "12:00 pm" would actually be stored as "43200". This number is converted back into standard format for display. Data Type - Instant - Correct Answer - Instant A date and a time stored in a single item. Instants are usually automatically generated by the system - for example, audit trail time stamps are generally stored as instants. In Chronicles, an instant is stored as the number of seconds since midnight on 12/31/1840. "12:00 pm on 4/1/2009" would
whether a different value for the item can be stored on each contact, or whether values are stored directly to the record. (think Weight vs birthday). __________ items store data directly on a record, not a specific contact. The value of a _______ item should be considered true for all contacts on that record. For example, a patient's date of birth is a no- add item, and you can assume that no matter how many contacts the patient has, his date of birth is the same. If a No-Add item is changed, the old value is replaced. - Correct Answer - No-Add ______________ items store values separately on each of a record's contacts. If a ______________ item is blank for a certain contact, it should be considered unknown. For example, if a patient's blood pressure is not collected during a certain visit to the doctor, you cannot assume that it has not changed since the last time the patient's blood pressure was taken. - Correct Answer - Response Each Time (Overtime) ___________________ items store values separately on each contact, much like Response Each Time items. The only difference is that if a _________ item is not populated, the system _________ to the most recent contact in which the item had a value, and treats that value as valid. - Correct Answer - Lookback (Overtime) Since both response each time and lookback items store data on the contact, these add types may collectively be referred to as
___________________________. - Correct Answer - overtime add types. Overtime data is stored at the _____________ while No-Add data is stored at the ______________. - Correct Answer - Overtime data is stored at the contact level, while No-Add data is stored at the record level. An add type of___________ means an item value is the same for all contacts within a record. The value of a ___________ item can be changed. When the value is modified it is changed for all contacts, not only the contact in which the change took place. - Correct Answer - No-add An item's ____________ determines how many lines of data an item can hold. For example, at any one time, a patient has only one date of birth, but she can have multiple symptoms, or a multi-line address. - Correct Answer - Response Type _____________ Only one line of data can be stored per contact. Example DOB - Correct Answer - Single Response Only one line of data can be stored per contact. ________________ lines of data can be stored per contact. These lines might be discrete pieces of data, such as multiple symptoms, or they
Indexing only affects searching Chronicles data. An indexed Chronicles item may or may not be indexed in Caboodle or Clarity. - Correct Answer - Only Epic Only some items are indexed. You can identify an item as indexed if: (list three things) Each of these locations will also tell you the INI of the networked master file. - Correct Answer - • The Item Information window for that item contains a "Indexed" field, set to true.
- The item's definition in Item Editor contains a "Indexing" category. - Hovering over the item in the Record Viewer shows "Index: Y" in the help text. The Chronicles hierarchy contains the following levels. - Correct Answer - Master File A master file, abbreviated with an INI, contains information about a single subject. Record A record contains information about individual entities within a master file. Contact A contact stores a snapshot of data at one point of time in a record. Item An item stores individual data within a record or contact. Line Lines are used for items that store multiple pieces of information.
The SQL column title and SQL description fields within the Item Information window do not refer to Clarity or Caboodle columns. What do they refer to? - Correct Answer - These fields refer to the KB_SQL columns used in the Clarity ETL process. What is the difference between a record and a contact? - Correct Answer - A record is a single entity. What kind of thing depends on the master file - a record in the patient master file is a patient, a record in the provider master file is a provider, etc. 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? - Correct Answer - 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. - Correct Answer - False - The patient should only have one record, but that record will have two contacts.
