Investigating Chronicles Flashcards

1
Q

What are the basic steps that you will do upon receiving a report request?

A
  1. Identify the data elements you will need for the report
  2. Find the INI + item number of the data points to use on the report.
  3. Use the INI+ item numbers to find the appropriate clarity tables and columns.
  4. Join the clarity tables together using the correct foreign key information.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Once you are sure what data elements you will need for your report, what are your next steps?

A

Find the INI + item number for the elements.

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

What is the INI + Item number?

A

It is the chronicles address for a piece of data.

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

True or False: The INI + connects to caboodle and it is an address from there?

A

False, The INI + item number is the chronicles address for a piece of data. It is with this chronicles address that you can map the data point the appropriate table and column in clarity.

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

True or False: The Chronicles address helps you map data points and makes connections to table and column in clarity?

A

True, because the INI+ Item number is the chronicles address for a piece of data you are able to map the data point to the appropriate table and column in clarity.

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

True or False: If you do not know where the data is stored, you can use the item information window.?

A

True, if you do not know where the data is stored, once tool that a user can use in hyperspace to find the INI and Item number for data is the item information window.

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

True or False: You cannot use the item information window when you are in a workflow?

A

False, the item information window is used when you are in the workflow and can edit the field where the data is entered as an end user.

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

How would you access the item information window?

A

When you control-left click on a data entry field in hyperspace, the item information window appears.

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

When you control-left click and the item information window appears, what does it provide?

A

This window provides the INI and item number in which this data is stored, a clarity table and column, and the items help text.

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

True or False: When pulling up the Item Editor, would the additional details appear at the bottom?

A

False, only if the user has the correct security, the additional details at the bottom will open the item editor for this item where you can learn more information like the items add type and response type.

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

What is the difference between the two in the picture?

A

If you see the yellow item information window you will see a section labeled SQL column title and SQL description. These are not clarity, they are KB_SQL used for the ETL process.

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

What type of fields does the Ctrl+Click work with?

A

The Ctrl+click method typically works on read/write fields in hyperspace.

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

When will the Ctrl+Click not work?

A

if a field is a read-only, ctrl + click will often not work, and some editable fields will not open the item information window when the control-click workflow is complete.

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

True or False: The record viewer is the item editor?

A

False, The record viewer is an activity in hyperspace that provides a read-only view of raw data in chronicles record.

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

What is the record viewer?

A

The record viewer is an activity in hyperspace that provides a read-only view of raw data in chronicles record. It shows all items set on a particular contact of a particular record.

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

True or False: In order to view data in record viewer, you do not need specify master file, record, nor the contact?

A

False, in order to view data, you must specify the master file, record, and contact for the data you want to see.

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

When the Ctrl+ Click method does not work in hyperspace, what can you do?

A

When the Ctrl+ Click method does not work in hyperspace field, or the report requestor does not know the field where a data point was entered, the record viewer is the most convenient place to find the INI+ item number for a piece of data.

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

True or False: When you know a specific record or contact identifying information, you can use the record viewer to view the values stored.

A

True, Identifying information would include the record ID (.1), an external ID, or a contact serial number (or CSN). Use the record viewer to see what is stored for that contact or to see related data within the master file and how it fits together.

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

True or False, you can use record viewer to see what is stored for that contact?

A

True, use the record viewer to see what is stored for that contact or to see related data within the master file and how it fits together.

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

What is a contact serial number?

A

A contact serial number or CSN will uniquely identify a contact within a master file.

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

What is the purpose of the = key?

A

When you are filling in a field in chronicles that looks up a record you can use the = key to bring in the last record used. In this case if you set up the INI to EPT and insert = into the record, it will automatically bring in your patient.

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

What does CTRL + F do?

A

This will bring up a search bar. The search bar will search through item names as well as values stored.

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

What does “Further Item Filtering > Text Search” mean?

A

This will filter the items shown to only value you searched for.

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

True or False: Here we see the category value of 101 in brackets, and the category value displayed, this format is how it is in clarity?

A

False, raw data stored in chronicles is only the category value. Thus, when the item is extracted to Clarity, only the category value of “101” will carry over.

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

True or False: There are many items that exist in a master file that are not filled out for every record?

A

True, this is common with medical data, since patients undergoing different types od levels of care will have data that is important to document. If the record viewer is able, it will display all possible items. The record viewer, by default will break the items into different pages for master files with many items.

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

What happens when you check the box include blanks in the item filters card?

A

Clicking include blanks will display every possible item that could be populated. There are many possible items that could be populated in the EPT master file.

In chronicles there are varies items that are stored and not everything is going to be applicable. We can include the blank items as well. If the record viewer is able, it will display all possible items. The record viewer, by default, will break the items into different pages for master files with many items.

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

True or False: Clarity columns can contain null values?

A

True, any clarity columns that is not a primary key can contain null values.

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

True or False: In Clarity foreign keys can not be null?

A

False, even foreign keys may be null.

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

What are the reasons for null values in clarity?

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.

30
Q

True or False: Chronicles does not use the data type of category?

A

False, some items in chronicles have a data type of category.

31
Q

True or False: The category items are populated by a list?

A

True, these items are populated by a limited list of options called a category list.

32
Q

What happens when you use a category list value as a filter?

A

When using a category list value as a filter, the query can run more efficiently when filtering on the category value itself rather than the name in the category list table. to find the name to display for a particular value, you need to see the category list.

33
Q

True or False: Multiple items can not reference the same category list?

A

False, it is possible for multiple items in chronicles to reference the same category list.

34
Q

How can you know if an item uses the same category list?

A

In the item editor, there is a link is stored in “where found”. That link would let a report writer know where the category list was stored in chronicles.

35
Q

What are two ways to view a category list?

A

One is through the item editor. The other is through the category list maintenance activity in hyperspace.

36
Q

When viewing the category values through item editor what is a limitation?

A

Category values may be displayed in the item editor in the category section, but the limitation is that it will only display the first 100 category values in a category.

37
Q

How can you see the complete list of categories?

A

You can see the complete list by using the category list maintenance activity in hyperspace.

38
Q

What is Add type?

A

Items add type describes how long a piece of data is valid. It determines whether an items value is stored on each contact, or directly to the record.

39
Q

What is a NO-Add Type?

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 contact on that record.

For example, a patients 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.

40
Q

What is a Response Each Time?

A

Response each time items store values separately on each of a records contacts. If a response each time 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 can not assume that it has not changed since the last time the patient blood pressure was taken.

41
Q

What is Look Back Add type?

A

Look back 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 patients age on each contact, but only if their age is different from the last time the patient was seen.

42
Q

True or False: Both Response each time and Look back are also known as overtime add types?

A

True, since both response each time and lookback items store data on the contact, these add types may collectively be referred to as overtime add types.

43
Q

What is one difference between No-add and overtime data?

A

No add data is stored at the record level, while overtime data is stored at the contact level.

44
Q

True or False: An items response type determines how many lines of data an item can hold?

A

True, an example at any one time, a patient has only one date of birth, multiple symptoms, or a multi-line address. This is where the different response types of single response, multiple response, and related group come into play.

45
Q

What is a single Response type?

A

Only one line of data can be stored per contact.

46
Q

What is multiple response, response type?

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 a block of text, such as an address.

47
Q

What is related group response type?

A

Multiple lines of data can be stored per contact, and each one of these liens is related to a line on another item.

These lines might refer to a list of relatives names and their phone numbers.

48
Q

What is the difference between these?

A

A: Item Editor shows the definitions of a chronicles item. It does not show a particular value stored in the item, instead, it shows information about how the item behaves for all values.

B: Record Viewer is an activity in hyperspace that provides a read only view of raw data in chronicles record. It shows all items set on a particular contact of a particular record.

C: Item Information Window , you control-left click on a data entry field in hyperspace. This window provides the INI and Item number in which this data is stored, a clarity table and column.

D: The yellow Information window is similar to C but they are KB_SQL used for the ETL process.

49
Q

True or False: Line 0 holds the number of registries enrolled in?

A

True, the item is a multiple response type. The typical convention for multiple response items is that line 0 holds the number of responses stored in that item, and the rest of the lines hold the values for different registries the patient is a part of. In this case, because the patient is in 4 registries, line 0 holds the number 4 to indicate that.

50
Q

What is the Item Information Window?

A

One tool that a user can use in hyperspace to find the INI and item number for data is the item information window. The item information window is used when you are in the workflow and can edit the field where the data is entered as an end user.

51
Q

What is Record Viewer?

A

The record viewer is an activity in hyperspace that provides a read-only view of raw data in chronicles record. It shows all items set on a particular contact of a particular record. In order to view data, you must specify the master file, record, and contact for the data you want to see.

When CRTL+ Click method does not work for a hyperspace field, or the report questor does not know the field where a data point was entered, the record viewer is the most convenient place to find the INI+ item number for a piece of data.

52
Q

What is Contact Serial Number?

A

a contact serial number (CSN) will uniquely identify a contact within a master file. When you know a specific record or contact identifying information, you can use the record viewer to view the values stored. Identifying information would include record ID (.1), an external ID, or a contact serial number (CSN).

53
Q

What is an Item Editor?

A

The Item Editor shows the definitions of a chronicles item. Note that it does not show a particular value stored in the item. Instead, it shows information about how the item behaves for all values.

The item editor is useful for investigating the properties on a given item comparing properties can help you decide which item is most appropriate to included in your query.

54
Q

What is a category list?

A

Some items in chronicles have a data type of category. These items are populated by a limited list of options called a category list. when using a category list of values as a filter, the query can run more efficiently when filtering on the category value itself rather than the name in the category list table. To find the name to display for a particular value, you need to see the category list.

It is possible for multiple items in chronicles to reference the same category list. In a situation like that, you may notice in the item editor a link stored in where found-that link would let a report writer know where the category list was stored in chronicles.

55
Q

What is Category List Maintenance?

A

There are many ways to view a category list. Category values may be displayed in the item editor in the category section, but the limitation is that it will only display the first 100. To see the complete list, use the category list maintenance activity in hyperspace.

56
Q

What is an Add Type Response?

A

An items-add type describes how long a piece of data is valid. It determines whether an items value is stored on each contact, or directly to the record.

57
Q

What is No-Add Type response?

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 patients date of b9irth 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.

58
Q

Response Each Time

A

Response each time items store values separately on each of a record’s contacts. If a response each time 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.

59
Q

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.

60
Q

Single Response:

A

Only one line of data can be stored per contact.

61
Q

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 a block of text, such as an address.

62
Q

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 relative’s names and their phone numbers.

63
Q

How can you use epic tools to conduct chronicles research.

A

Two of the main tools that one can conduct chronicles research on is by using the item information window or by using the record viewer. The item information window (Crtl+Click method) gives you the opportunity to find the INI and item number for data. Now, the Crtl+Click method does not work all the time, for example, it does not work with specific data fields. If a field is read-only, Crtl+Click method will often not work, and some editable fields will not open the item information window. Also, some users may not have the security to use the Crtl+Click method.

Record viewer provides a read-only view of raw data in chronicles record and you are able to view the INI and item number for a piece of data. When using the record viewer, you are able to put in the INI and then the record you are viewing. So for example, you want to see a patient you can use the record viewer put in EPT in the INI section and for record you can put in the patient name. Then you can search the contact.

64
Q

Identify the add type and the response type of chronicles item.

A

You are able to find the add type in Item Editor.

65
Q

Open an item in the item editor to find the item characteristics of an item.

A
  1. Open record viewer.
  2. Select the master file you want.
  3. Select the record you want.
    4.You will click on the ept item that you want
  4. This will bring us to a whole new page called the item editor.
66
Q

Use Epic tools to look up category values for items.

A

When looking at an item in the record viewer you are able see the data in more detail you can. For example, if you want to look at a Patient, such as Shehulk, Aubrye and you want to look at the EPT item of .1 patient ID, you can click on it and it will bring the item editor where it tell you more information over that item. For example, it being a string data type. However, if you wanted to look into a category item, you are able to look at the category list. For example, state, Wisconsin.
The First Record Viewer
1. Go to record viewer
2. Put in the INI and the record you want to see
3. Select the contact
4. Go the state and click on it.
5. It will open the item editor.
6. Click on the where founds hyper link.
7. It will then list all the options for state and territories.

The Second, is Category List Activity
1. In the Search Bar put in category List maintenance.
2. For database put in EPT
3. Put in the Item number you want.
4. And you are able to see which id means what.

67
Q

Open a record in the record viewer to begin chronicles research.

A
  1. Look for the search bar with the magnifying glass.
  2. Type in record viewer
  3. Under the INI select the master file that you want to search under.
  4. Select the record.
  5. Select the contact.
  6. Select view record.
68
Q

Differentiate between records and contacts in chronicles.

A

Chronicles is divided into master files and a master file contain information about a broad subject. In this case, the master file is the patients master file. The INI refers to the master file we are looking at. Now within master file contains records and they are information about individual entities within a Masterfile. This further gets broken down into contacts (encounters AKA Visits) this contains information about points in time for a record. The difference between the two is that a record is the individual entities and the contact is the points in time of a record.

69
Q

Explain the difference in how chronicles store and displays values in the record viewer.

A

The record viewer displays read-only data in chronicles record. It shows information of a particular record. The record viewer shows the category and also the value of the category but it later just moves that information over to clarity as a numerical value.

70
Q

Explain some limitations to the item information window as tool for chronicles research.

A

The limitations of the CTRL+Click method is that it does not work with all data points. IF a field is read-only, the CTRL+Click method will not work, and some editable fields will not open the item information window when the control-click workflow is completed.