Brainscape's Knowledge GenomeTM

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


See full index

CLR110 Clarity Data Model Fundamentals > Investigating Chronicles > Flashcards

Investigating Chronicles Flashcards

1
Q

What largely determines the structure of the Clarity database?

A

The structure of Chronicles.

Aug. 2021, 2.3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
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.

(Aug. 2021, 2.4)

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

What represents the Chronicles address for a piece of data?

A

The INI + Item number.

Aug. 2021, 2.4

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

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

A

The Chronicles address (INI + Item number)

Aug. 2021, 2.4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
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 that stores the data they want on a report.

(Aug. 2021, 2.6)

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

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

A
  1. Item Information window (Ctrl + Click)
  2. Record Viewer
  3. Item Editor
  4. Category List Maintenance

(Aug. 2021, 2.6)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
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)

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

What does the Record Viewer show?

A

All items set on a particular contact of a particular record.

(Aug. 2021, 2.8)

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

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

A
  1. Master File
  2. Record
  3. Contact

(Aug. 2021, 2.8)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
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)

(Aug. 2021, 2.9)

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

Define Contact Serial Number (CSN)?

A

A Contact Serial Number (CSN) uniquely identifies a contact within a master file.

(Aug. 2021, 2.9)

17
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)

18
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

(Aug. 2021, 2.11)

19
Q

What does the Item Editor show?

A

The Item Editor shows the definitions of a Chronicles item.

Aug. 2021, 2.11

20
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)

21
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)

22
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)

23
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)

24
Q

List the Add Types.

A
  1. No-add
  2. Response Each Time
  3. Lookback

(Aug. 2021, 2.18)

25
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)

26
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)

27
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)

28
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)

29
Q

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

A
  1. Response Each Time
  2. Lookback
    Because both items store data on the contact.

(Aug. 2021, 2.18)

30
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)

31
Q

Define the Response Type, Single Response.

A

Only one line of data can be stored per contact.

Aug. 2021, 2.19

32
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.

(Aug. 2021, 2.19)

33
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)

34
Q

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

A
  1. Multiple Response
  2. Related Group

Because both items store more than one type of data.

(Aug. 2021, 2.19)

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