Investigating Chronicles Flashcards
What are the basic steps that you will do upon receiving a report request?
- Identify the data elements you will need for the report
- Find the INI + item number of the data points to use on the report.
- Use the INI+ item numbers to find the appropriate clarity tables and columns.
- Join the clarity tables together using the correct foreign key information.
Once you are sure what data elements you will need for your report, what are your next steps?
Find the INI + item number for the elements.
What is the INI + Item number?
It is the chronicles address for a piece of data.
True or False: The INI + connects to caboodle and it is an address from there?
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.
True or False: The Chronicles address helps you map data points and makes connections to table and column in clarity?
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.
True or False: If you do not know where the data is stored, you can use the item information window.?
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.
True or False: You cannot use the item information window when you are in a workflow?
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 would you access the item information window?
When you control-left click on a data entry field in hyperspace, the item information window appears.
When you control-left click and the item information window appears, what does it provide?
This window provides the INI and item number in which this data is stored, a clarity table and column, and the items help text.
True or False: When pulling up the Item Editor, would the additional details appear at the bottom?
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.
What is the difference between the two in the picture?
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.
What type of fields does the Ctrl+Click work with?
The Ctrl+click method typically works on read/write fields in hyperspace.
When will the Ctrl+Click not work?
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.
True or False: The record viewer is the item editor?
False, The record viewer is an activity in hyperspace that provides a read-only view of raw data in chronicles record.
What is the record viewer?
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.
True or False: In order to view data in record viewer, you do not need specify master file, record, nor the contact?
False, in order to view data, you must specify the master file, record, and contact for the data you want to see.
When the Ctrl+ Click method does not work in hyperspace, what can you do?
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.
True or False: When you know a specific record or contact identifying information, you can use the record viewer to view the values stored.
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.
True or False, you can use record viewer to see what is stored for that contact?
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.
What is a contact serial number?
A contact serial number or CSN will uniquely identify a contact within a master file.
What is the purpose of the = key?
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.
What does CTRL + F do?
This will bring up a search bar. The search bar will search through item names as well as values stored.
What does “Further Item Filtering > Text Search” mean?
This will filter the items shown to only value you searched for.
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?
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.
True or False: There are many items that exist in a master file that are not filled out for every record?
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.
What happens when you check the box include blanks in the item filters card?
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.
True or False: Clarity columns can contain null values?
True, any clarity columns that is not a primary key can contain null values.
True or False: In Clarity foreign keys can not be null?
False, even foreign keys may be null.