Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

My CLR110 Clarity Data Model Fundamentals > Investigating Chronicles > Flashcards

Investigating Chronicles Flashcards

1
Q

A lab manager tells you he wants a report on lab specimens and shows you the field where he can input various information. What method would you use to find the INI + Item numbers of the data he’s looking for?

A

Ctrl + Click

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A clinical administrator requests a query to include data for a patient’s registries. She’s not sure of the INI and Item number, but she knows the patient is on the Lung Cancer Screening registry. What tool would you use to find the INI and item number given this information?

A

Record Viewer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Select all that apply

In Clarity, which of the following columns COULD contain a NULL value?

A. A foreign key column that would store the patient’s primary care provider
B. A date column that would store the discharge date for an encounter
C. A string column that stores a patient’s email address
D. A numeric column that stores the patient’s age in years
E. A column that is the primary key of a table

A

All but E

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What information is available on the item information window?

A

INI and item number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

IDM 130 is a networked item that is not filled in for this record. What value will be extracted to Clarity for this item, and other Chronicles items that are not filled out?

A

Null

-May 2022, 2.10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What value will be extracted to Caboodle for this item, I IDM 130 is a networked item that is not filled in for this record and other networked items that are not filled out in Chronicles?

A

If the column is a key column, Caboodle will have a ‐1 letting report writers know that this value was not populated in the source, while still enforcing referential integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Why do Null values exist?

A

Not all fields are populated in Chronicles.
ETL data cleansing deletes incorrectly formatted data.
A column may no longer extract data because it is deprecated

-May 2022, 2.10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a category list?

A

A category list is a list of defined values that can be stored in a Chronicles item.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A Chronicles item can store one or more options from a limited list. Which of the following could account for this behavior? Choose all that apply:

A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category

A

B. Multiple Response
C. Networked
F. Category

If a Chronicles item can store one or more options it is a multiple response item. If the options come from a limited list, that item may be a category item, where the category list is the list of options, or networked, where the records or contacts in the destination master file is the list of options

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A Chronicles item stores a single value, but can store a separate value for each contact on a record. Which of the following could account for this behavior? (multi choice)

A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category

A

A. Single Response
D. Overtime

If a Chronicles item can store only one value it is a single response item. If a separate value is stored on each contact the add type is Overtime.

-May 2022, 2.17

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

T/F Multiple clarity tables might extract data from a single record in chronicles.

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How often are incremental tables typically extracted to clarity?

A

Daily

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You open a patient encounter in Record viewer and find item EPT 10115 as pictured. What will be stored for this patient encounter in the Clarity column that extract this item?

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A Chronicles item can store one or more options from a limited list. Which of the following could account for this behavior? Choose all that apply:

A. Single Response
B. Multiple Response
C. Networked
D. Overtime
E. No‐Add
F. Category

A

B. Multiple Response
C. Networked
F. Category

If a Chronicles item can store one or more options it is a multiple response item. If the options come from a limited list, that item may be a category item, where the category list is the list of options, or networked, where the records or contacts in the destination master file is the list of options.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What largely determines the structure of the Clarity database?

A

The structure of Chronicles. (May 2022, 2.3)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are the four steps you will typically perform upon receiving a report request?

A
  1. Identity the data elements you will need for the report.
  2. Find the INI + Item numbers of the data points to use on the report.
  3. Use the INI + Items numbers to find the appropriate Clarity tables and columns.
  4. Join the Clarity tables together using the correct foreign key information.

-May 2022, 2.4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What represents the Chronicles address for a piece of data?

A

The INI + Item number.

-May 2022, 2.4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What allows you to map a data point to the appropriate table and column in Clarity?

A

The Chronicles address (INI + Item number)

-May 2022, 2.4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

When can the Item Information window be accessed?

A

The window can be accessed when a Hyperspace user knows the exact field within a workflow, and can edit the field, that stores the data they want on a report.

-May 2022, 2.6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What activities in Chronicles can you use to look up information about the data in Chronicles?

A

Item Information window (Ctrl + Click)
Record Viewer
Item Editor
Category List Maintenance

-May 2022, 2.6

21
Q

What do you have to know to use the Item Information window?

A

The exact field within a workflow that stores the data you want on a report.(Aug. 2021, 2.6)

22
Q

How do you open the Item Information window?

A

The Item Information widow appears when you ctrl + click on a data entry field in Hyperspace.(Aug. 2021, 2.6)

23
Q

Do the SQL column title and SQL description fields within the Item Information window refer to Clarity or Caboodle columns?

A

Neither. These fields refer to the KB_SQL columns used in the Clarity ETL process.(Aug. 2021, 2.7)

24
Q

Does the Item Information window show Clarity tables and columns?

A

When you are working with the web-based Item Information window the values listed under Table and Column are Clarity tables and columns.(Aug. 2021, 2.7)

25
Q

Does the ctrl + click method work on read-only fields?

A

Not often. If a field is read-only, ctrl + click will often not work(Aug. 2021, 2.8)

26
Q

Does the ctrl + click method work with every read/write field?

A

No. Some read/write fields simply aren’t compatible with the ctrl + click method.(Aug. 2021, 2.8)

27
Q

What does the Record Viewer show?

A

All items set on a particular contact of a particular record.(Aug. 2021, 2.8)

28
Q

What three things does the Record Viewer require to view the data you want to see?

A
  1. Master File2. Record3. Contact(Aug. 2021, 2.8)
29
Q

What identifying information could you use in the Record Viewer to view the values stored?

A

Identifying information would include:

  1. Record ID (.1)
  2. External ID
  3. Contact Serial Number (CSN)

-May 2022, 2.8

30
Q

Define Contact Serial Number (CSN)?

A

A Contact Serial Number (CSN) uniquely identifies a contact within a master file.(Aug. 2021, 2.9)

31
Q

Which column(s) in Clarity can contain NULL values?

A

Any column that is not a primary key can contain NULL values. Even foreign keys may be NULL.(Aug. 2021, 2.11)

32
Q

What are three reasons a NULL might exist in Clarity?

A
  1. Not all fields are populated in Chronicles
  2. ETL data cleansing deletes incorrectly formatted data
  3. A column may no longer extract data because it is deprecated

-May 2022, 2.10

33
Q

What does the Item Editor show?

A

The Item Editor shows the definitions of a Chronicles item.

-May 2022, 2.11

34
Q

What are the three ways to open the Item Editor?

A
  1. Click on an item in the Record Viewer.2. Chart Search (Ctrl + Spacebar)3. The Item Editor symbol (star) in Hyperspace(Aug. 2021, 2.12)
35
Q

Does the Category section of the Item Editor provide a complete category value list?

A

No. The Item Editor is limited to the first 100 category values.(Aug. 2021, 2.12)

36
Q

What does the Release Range in the Item Editor describe?

A

The category values that are released by Epic and cannot be changed.(Aug. 2021, 2.12)

37
Q

What does an Add Type determine?

A

It determines whether an item’s value is stored on each contact, or direct to the record.(Aug. 2021, 2.17)

38
Q

List the Add Types.

A
  1. No-add2. Response Each Time3. Lookback(Aug. 2021, 2.18)
39
Q

Define the Add Type, No-Add.

A

No-Add items store data directly on a record, not a specific contact. The value of a no-add 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.(Aug. 2021, 2.18)

40
Q

What Add Type is considered unknown if an item is blank for a certain contact?

A

If a response each time item is blank for a certain contact, it is considered unknown.(Aug. 2021, 2.18)

41
Q

Define Response Each Time?

A

Response each time items store values separately on each of a record’s contacts.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.(Aug. 2021, 2.18)

42
Q

Define Lookback.

A

Lookback items store values separately on each contact, but assume that the last value entered remains true until a new value is entered.For example, the system automatically enters a patient’s age on each contact, but only if their age is different from the last time the patient was seen.(Aug. 2021, 2.18)

43
Q

What add types may collectively be referred to as overtime add types?

A
  1. Response Each Time2. LookbackBecause both items store data on the contact.(Aug. 2021, 2.18)
44
Q

What does an item’s Response Type determine?

A

An item’s Response Type 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 can have multiple symptoms, or a multi-line address.(Aug. 2021, 2.18)

45
Q

Define the Response Type, Single Response.

A

Only one line of data can be stored per contact.(Aug. 2021, 2.19)

46
Q

Define the Response Type, “Multiple Response”.

A

Multiple lines of data can be stored per contact. These lines might be discrete pieces of data, such as multiple symptoms, or they might be multiple lines of block text, such as an address

-May 2022, 2.18

47
Q

Define the Response Type, Related Group.

A

Multiple lines of data can be stored per contact, and each one of these lines is related to a line in another item.These lines might refer to a list of relatives’ names and their phone numbers.(Aug. 2021, 2.19)

48
Q

What response types may collectively be referred to as multiple response types?

A
  1. Multiple Response2. Related GroupBecause both items store more than one type of data.(Aug. 2021, 2.19)

My CLR110 Clarity Data Model Fundamentals (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions