Data Lineage

Question 1

What are the two item numbers that keep their meaning across all master files?

Answer 1

1. (Dot 1) .1 = Record ID
2. (Dot 2) .2 = Record Name
   (4. 10)

Question 2

What is the process that transfers data from one database to another?

Answer 2

ETL - Extract, Transform, and Load (4.4)

Question 3

What Epic database holds real-time data?

Answer 3

Chronicles (4.4, 4.16)

Question 4

Which Epic database includes non-Epic data?

Answer 4

Caboodle (4.5)

Question 5

What Epic databases are relational?

Answer 5

1. Clarity
2. Caboodle
   (4. 5)

Question 6

What is the relevance of INI and item number in locating Chronicles data?

Answer 6

• The INI and item number uniquely identify a data element.
• I EPT 70 = Item 70 in the patient master file.
(4.10)

Question 7

What is a “response each time” item in Chronicles?

Answer 7

An item that can contain different data across different contacts. Response Each Time is an add type which means the data is stored at the contact level instead of the record level. Since we store the data on the contact, we can store a different value on each contact. (4.12)

Question 8

What does Add Type tell you about an item?

Answer 8

The level the item is stored (4.12)

1. Record-level
   2. Contact-level

Question 9

No-add items store ___________-level data.

Answer 9

Record (4.12)

Question 10

True or False: The value of a no-add item is considered true for all contacts on the record.

Answer 10

True (4.12)
A patient’s date of birth is a no-add item, and is the same value on all contacts. If a no-add item is changed, the old value is replaced on all contacts.

Question 11

What Add Type’s store values separately on each contact?

Answer 11

1. Response Each Time
2. Lookback
   (4. 12)

Question 12

There are two Add Types that store values separately on each contact. How are they different?

Answer 12

1. Response Each Time (4.12)
   • If an item is blank for a certain contact, the value is considered unknown.
2. Lookback (4.12)
   • If an item is blank for a certain contact, the system ‘looks back’ to the most recent contact in which the time had a value, and treats that value as valid.

Question 13

What does Response Type determine?

Answer 13

• Determines how many lines of data an item can store (4.12)
• Response type determines how many values an item can hold at once.
For example, at any one time, a patient has only one date of birth but can have multiple symptoms.

Question 14

What are the three Response Type’s?

Answer 14

1. Single Response
2. Multiple Response
3. Related Group
   (4. 13)

Question 15

Which Response Type stores multiple lines of data at once, and each one of these lines is related to a line in another item?

Answer 15

Related Group (4.13)

Question 16

What do networked items reference?

Answer 16

Records or Contacts (4.13)

Question 17

What do networked items that point to records store?

Answer 17

.1 - Dot 1 - Record ID (4.13)

Question 18

What do networked items that point to contacts store?

Answer 18

CSN - Contact Serial Number (4.13)

Question 19

What is an example of Multiple Response?

Answer 19

• Multiple symptoms
• Multiple lines of a large block of text, such as an address
(4.13)