CLR 110/ CLR110 Comprehensive Exam & study guide | Clarity Data Model Fundamentals | 2026/2027 Academic Year – Questions with Correct Answers - WGU

CLR 110 Comprehensive Exam & study guide | Clarity Data Model Fundamentals | 2026/2027 Academic Year – Questions with Correct Answers - WGU 2026 / 2027 Academic Year Q: True or False: Multiple Clarity tables might extract data from a single record in Chronicles. Answer True For example, one patient (EPT) record in Chronicles can have data extracted to PATIENT, PAT_ENC, HSP_ATND_PROV, and OTHER_COMMUNCTN. Q: How often are incremental tables typically extracted to Clarity? Answer Daily Incremental tables are typically extracted to Clarity every night during the ETL process. Answer Q: You open a patient encounter in the Record Viewer and find item EPT 10115. What will be stored for this patient encounter in the Clarity column that extracts this item? Answer 10115-ADT: PATIENT STATUS Discharged [3] 3 When looking at the record viewer, the raw value inside the brackets is typically extracted to Clarity. Q: You want to include item SER 39: Primary Department in a query. Which is the best tool to use to find the Clarity table and column that extracts this item? a) Column Search b) Database Object Search c) Item Editor d) Record Viewer e) Category List Maintenance Answer a When you know the INI and the item number, the best tool to use to find a Clarity table and column will be the Column Search. Q: You find an unfamiliar table CLARITY_ROM in a colleague's report. Which tool could you use to find out more about this table? a) Column Search b) Database Object Search c) Item Editor d) Category List Maintenance Answer b Q: Item HNO 1024: Notes Linked to Document has an Add type of No-Add and a Response type of Multiple. What is the primary key of the table this item is extracted to? Answer NOTE_ID and LINE Q: True or False: Compared to views, derived tables generally take less time to run because the data has been stored on the database. Answer True Since views are saved queries, their use can affect performance. Q: True or False: Epic SQL functions must be used in place of Oracle or Microsoft SQL Server functions in order to return data from Clarity. Answer False Epic SQL functions are not required. You may use Oracle or Microsoft SQL Server functions. Q: Which of the following statements accurately describes Contact Date Real? Choose ALL that apply. a) Only patient records can have a Contact Date Real b) It represents the number of days since 12/31/1840, followed by a two digit decimal c) It is randomly generated d) Different records can have contacts with the same Contact Date Real e) It uniquely identifies a contact within a master file Answer b, d The Contact Date Real is used as a contact identifier (with the record ID). It is the number of days since 12/31/1840 followed by a two digit decimal that identifies multiple contacts on the sam Q: Operational Reporting Answer Time Sensitive; Relatively Small; Easily Accessible; Actionable Q: Operational Reporting Tools Answer Application Reports; Reporting Workbench; KB_SQL; Chronicles Ad Hoc; Cache Script Q: Analytical Reporting in Clarity Answer Comprehensive; Summarized; Standardized Q: Clarity Distribution Mechanisms Answer EPIC-Crystal Integration; Business Objects Universes; Radar (information center/Portal ) Q: The way data is stored in EPIC Answer Chronicles (Storage);Master File/INI (Patient Records); Record (John Accrual); Contact (6/30/2012 Admission); Item (Attending Providers); Line (First Attending, etc.) Q: Point of data in Chronicles can be identified by Answer Its INI and Item Number Q: Control Left-Click Method Answer One method to find where the data lives though Hyperspace Q: Raw data in Item Information Answer System information that is probably different from what end user sees Q: Item .1 Answer Record ID Q: Item .2 Answer Record Name Q: Chronicles Data Type - String Answer Any combination of characters Q: Chronicles Data Type - Number Answer Any number - can be an integer or a decimal Q: Chronicles Data Type - Time Answer A time without a date; stored as the number of seconds since midnight; converted back to normal time for display Q: Chronicles Data Type - Instant Answer Date/Time stored in single item as the number of seconds since midnight on 12/31/1840 and converted back to normal for display Q: Chronicles Data Type - Category Answer A pre-defined list of choices; Some can be modified by customers, some cannot Q: Q: Response Types Answer Determines how many lines of data an Item can hold Q: Response Types - Single Response Answer Only one line of data can be stored Q: Response Types - Multiple Response Answer Multiple lines of data can be stored (e.g. addresses) Q: Response Types - Related Groups Answer Multiple lines of data can be stored and each one of these lines is related to a line in another item (e.g. Different Phone numbers ) Q: Add Types Answer Identifies whether a data changes on the item for each Contact or is stored directly on a record Q: Add Types - No-Add Answer Stores items directly on a record, not a specific contact Q: Add Types - Response Each Time Answer Stores values separately on each of a record's contact Q: Add Types - Lookback Answer Stores values separately on each contact, but assume that last value remains true until new value is entered (not used very often anymore. Networking Answer Very similar to lookups with joins in relational database but specific technique to Chronicles (e.g. End User sees pt name but what is actually stored in item is pt id) Chronicles Record Viewer Answer Scheme of all items with numbers and values for a given record/contact combination in a given master file/INI Item Editor Answer Shows item characteristics including: INI Item #, Description, Data Type, Response Type, Add Type and SQL Table / SQL Column title Clarity Compass Answer Defines what Chronicles/production data will be extracted into which Clarity tables and columns. Defines the structure of your Clarity tables, including primary keys - Hyperspace Clarity Console Answer Schedules the extract of defined tables from Chronicles into Clarity - Web-based Column Search Answer Path: EpicReport ManagementColumn Search: can search your column definitions for a column that extracts a certain Chronicles item, and then jump to that column's compass entry for more information Chronicles to Clarity Data Type Mapping Answer String - VARCHAR; Number - NUMERIC/FLOAT; Date - DATETIME/FLOAT*Contact Date Real; Time - DATETIME; Instant - DATETIME; Category - VARCHAR/INTEGER Deprecated Answer Flag that identifies that disabled/obsolete columns Extracted Answer Almost always set to yes; used by ETL administrators Database Object Search Answer Allows you to search for Clarity Tables by name and then jump into the tables' Compass Table Summary Primary Key Answer A field or combination of fields that uniquely identify a record Contact Date Real (CDR) Answer A contact date real is a date in Epic's internal format, followed by a two decimal places that identify one contact among many on the same date. Contact Serial Number (CSN) Answer A CSN is a number that uniquely identifies a single contact within a master file Load Type - Full Answer Truncates any data already in the Clarity table and re-extracts the entire table from Chronicles Load Type - Incremental (REQ) Answer Finds data that has changed in Chronicles since the last time the table was extracted, extracts the changes, and uses them to update the table in Clarity Load Frequency Answer Default: Full-extract tables are weekly; Incremental tables are daily (incremental) ETL Answer ZC_* tables; Performance Tip - filter or sort on the _C columns Answer The Clarity Extract, Transform, and Load (ETL) process extracts data from your Chronicles database, transforms Chronicles' records, items, and contacts into the tables, rows, and columns of a relational database, and loads it into an Oracle, Microsoft SQL Server, or Teradata database on a dedicated reporting server. Category Tables Data Seeding Answer Data Seeding is useful if the database you are using to validate a report doesn't have the necessary information available to spot check the data. To perform data seeding you, or the report requester, performs workflows in the system that would result in information being added to the report. Should never be performed in production environment. Report Testing Forms Answer On UserWeb and lists measures that should be tested and validated Reporting Implementation Handbook UserWeb document that outlines process for getting reporting ready for your end users My Reports Epic Reports My Reports Creating a Reporting Workbench Report Reports in Reporting Workbench are made from templates. Templates control many things about a report, including what master files the query searches, what criteria are available, and many aspects of the user interface. Historical Instances of Reports in Hyperspace By default, when the system completes a new run for a given report, it deletes and replaces the old results. This method saves space and provides users with only the most up-to-date information; To enable historical instances of report, you must use Web BLOB Service (WBS) to control access. Talk to your Epic representative about setting this up. You can also refer to the Cogito Business Intelligence Setup and Support Guide, which is available for download from the UserWeb. Crystal Hyperspace Integration - Default values ext Most users at your organization will only be interested in report results pertinent to their particular location, department(s), or employees they work with. On the Hyperspace user record, you can set which departments, locations, and other records should be considered relevant to a particular user when they run reports. e.g.EPIC-BI Service Areas No Default: The values used at run time will be the list of service areas on the Cogito form of the User Record. Requesting a report run After you subscribe to an Epic-Crystal report, you must wait until the batch job runs in order to see the results of that report. This can cause problems when the batch jobs are run infrequently. Report priority queues help mitigate this problem. Report priority batch jobs run on a more frequent basis than other batch jobs. If you subscribe to a report that won't be run for a while, you can request a report run. You can do this from the Library by clicking the View option on the report, or from My Reports by right- clicking the report and selecting Request Report. Report types Are used as a filter in the Library. Types make it easier for users to locate templates and their reports in the Library. Each template has one and only one report type assigned to it. What is the difference between operational and analytical reports? Operational reports are real-time reports needed by end users to do their jobs. Analytical reports are over-time reports that show long-term, trending data. Why should you use Clarity for analytical reporting needs? Clarity reports can be run over very large data sets without slowing down your production server. They also can include complex grouping and mathematics, and can be used to do integrated reporting on Epic and non-Epic data. Why should you not use Clarity for operational reporting needs? Most importantly, Clarity data is not real-time, so any operational reports built from Clarity data will be out-of-date from the moment they're generated. They also cannot be used interactively, such as in a workflow where the report jumps a user to a patient's chart. You have a reporting need, and there is no pre-built application report to meet it. Do you need to use Clarity to meet this need? Not necessarily. Reporting Workbench can be used for many non- standard reporting needs. Would the following report be an operational or analytical report? Create a report that counts the number of logs each surgeon has been documented as performing in during the past year. Display the log ID, the name of the surgeon, and the log's primary procedure. This is an analytical report. What is the difference between a record and a contact? A record is a single entity. What kind of thing depends on the master file - a record in the patient master file is a patient, a record in the provider master file is a provider, etc. A contact represents a single moment in time for that record. What is the difference between a multiple response item and a response each time item? These refer to different item characteristics. "Multiple response" refers to a particular Response Type. A multiple response item can hold multiple answers on one contact. "Response each time" refers to a particular Add Type. A response each time item can hold different answers on different contacts. True or False: A patient who has been seen twice at your facility should have two records in the Patient master file. False - The patient should only have one record, but that record will have two contacts. A user shows you a field in Hyperspace that they want to report on. How can you find where in Chronicles that field files to? Control left-click it. If that doesn't work, try using the Chronicles Record Viewer. If you know a Chronicles INI and item, and you want to know the Clarity column it extracts to, how can you find it? Use Column Search, and enter the INI and Item. What happens when a column is marked as Deprecated? No more data will be extracted into the column, although any data already there will not be deleted. What does it mean if a column's name ends with _C? The column holds a category value. You'll need to link it to a ZC_ table to find what that category value means. True or False: A Clarity table with only one column listed as the primary key will always hold no-add, single-response data. False; for example, a table with a CSN listed as the primary key would hold overtime, single-response data. If you need to use two copies of ORDER_PROC, why shouldn't you give the two copies the aliases ORDER_PROC_1 and ORDER_PROC_2? Looking in the Clarity Data Dictionary, there is a table named ORDER_PROC_2. If you were to use ORDER_PROC_2 as an alias it would be difficult to determine if you are using the ORDER_PROC_2 table or if it is an alias you have assigned to the ORDER_PROC table. True or False. The best way to determine whether an inner join or a left outer join should be used is the starting table's primary key. False. The reporting need, load type and frequency will determine whether two tables should be joined using a left outer join or an inner join. A Clarity table's primary key includes a "CSN." What does this mean? A CSN is a Contact Serial Number, which identifies a specific contact within a specific record. A table with a CSN in its primary key extracts overtime data - if it extracted no-add data, you wouldn't need to identify a contact. A Clarity table's primary key includes a line count. What does this mean? Only Chronicles items with a response type of multiple-response or related group have line counts, so you know the table must extract multiple-response or related group items. What are the two types of test cases that should be used? Why are both necessary? As a report is being validated, both inclusive and exclusive cases should be examined. This is to make sure that the correct information is being returned by the report, and that incorrect information is not being returned. True or False. You should use the Production environment to seed data only if the name you give records includes the word "test". False. Only use a test environment to seed data True or False. End users can run Epic-Crystal reports by adding the report to their favorites. False. Adding the report to their favorites subscribes the user to the report. They still need to wait for the batch job to run the report. In the Template Editor, which field contains the default batch job that reports built from the template will use?. The Report frequency field. True or False. In the Template Manager, users can set template-level overrides to determine after how many days a user's Epic-Crystal subscription should be inactivated True. CHAPTER 2-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? Ctrl + Click CHAPTER 2-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 patient is on the Lung Cancer Screening registry. What tool would you use to find the INI and item number given this information? Record Viewer CHAPTER 2-Item Information Window The window shows the INI and item number in which this data is stored, along with other information about the item as a whole. When you are working with the web‐based item information windows the values listed under Table and Column are Clarity tables and columns. When you click the Additional Details you will open the Item Editor activity to find information such as add type and response type. CHAPTER 2-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. 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 for a 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. The Item Editor can also be used to see a list of category values. However, the Item Editor can only show a limited selection of the possible options, and thus using Category List Maintenance provides a more complete look at the category list. Keep in mind that the Record Viewer formatting does not necessarily translate to what is stored in Clarity. CHAPTER 2-Item Editor 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. Because there are many items within a master file that may sound similar, 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 include in your query. CHAPTER 2-Category List A Category List is a list of defined values that can be stored in a Chronicles item. CHAPTER 2-Category List Maintenance A device to look up Category List values CHAPTER 2-Add Type An item's Add Type describes how long a piece of data is valid. It determines whether an item's value is stored on each contact, or directly to the record. CHAPTER 2-Response Type 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 she can have multiple symptoms, or a multi‐line address. Explain the difference in how Chronicles stores and displays values in the Record Viewer. The data in the Record Viewer is formatted for easy viewing. For example, items that are part of a related group are displayed next to each other, category items display both the value and the name of the category they hold, and networked items display both the ID and the name of the record they network to. Keep in mind that the Record Viewer formatting does not necessarily translate to what is stored in Clarity. Observe the screenshot below. 78-COUNTRY United States of America [1] This item, EPT 78, stores the patient's country of residence as part of a category list. When displaying the value for this item, the Record Viewer displays "United States of America [1]". Here we see the category value of 1 in brackets, and the name of the category fully displayed. However, the raw data stored in Chronicles is only what is included inside the brackets. Thus, when the item is extracted to Clarity, only the category value of "1" will carry over. CHAPTER 2-Explain some limitations to the Item Information window as tool for Chronicles research. The Item Information Window (Ctrl + Click) The Ctrl + Click method typically works on read/write fields in Hyperspace. Although this method is the most convenient way to find a piece of data, it does not work for all data points. If a field is read-only, Ctrl + Click will often not work, and some read/write fields simply aren't compatible with the control-left click method. CHAPTER 2 - MRN Medical Record Number CHAPTER 2 - Response Each Time (Overtime Add Type) 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. CHAPTER 2 - No Add 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. 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. 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. CHAPTER 2 - Lookback (Overtime Add Type) 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. 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. CHAPTER 2-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 B, C and F CHAPTER 2-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? (Choose all that apply) A. Single Response B. Multiple Response C. Networked D. Overtime E. No‐Add F. Category A and D CHAPTER 2-No-Add Data vs Overtime Data No‐Add data is stored at the record level, while Overtime data is stored at the contact level. CHAPTER 2-Single Response Only one line of data can be stored per contact. CHAPTER 2-Multiple Response 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. Since both multiple response and related group items store more than one type of data, these response types may collectively be referred to as multiple response types. Single data stores one line of data, while Multiple data stores multiple lines of data. CHAPTER 2-Related Group 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. Since both multiple response and related group items store more than one type of data, these response types may collectively be referred to as multiple response types. Single data stores one line of data, while Multiple data stores multiple lines of data. CHAPTER 2-What value will be extracted to Clarity to Chronicles items that are not filled out? NULL CHAPTER 2-Null Values in Clarity Clarity columns that are not primary keys can contain null values. Even foreign keys may be null. Null values exist for several reasons: *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 The first reason is by far the most common. CHAPTER 2-Patient ID This field stores the internal ID of the patient record, which is not the patient's MRN. CHAPTER 2-Patient Name This field stores the name of the patient, which is the same as the name of the record in EPT. CHAPTER 2-If you are given a sample data point and you are asked to find the INI and item number for that item and possibly other related items, what tool should you use? Record Viewer works great when you are given a sample data point. CHAPTER 3-True or False: The Clarity Console stores definitions for the database objects that can be extracted to and stored in the Clarity database. False. The Clarity Compass stores these definitions. CHAPTER 3-Which tool would you use to find the table and column that extracts EPT 18864: Attending Provider? Column Search, to enter the Clarity Compass CHAPTER 3-What happens when a column is marked as Deprecated? No more data will be extracted into the column. CHAPTER 3-In which of the following scenarios would it be appropriate, and even necessary, to reach out to your Clarity ETL administrator? A. You need to use CLARITY_DEP_CUST_FIELDS in a report. You found the table in the Clarity Compass, but cannot query the table on your database. B. You found a view that looks useful in your reports. You query the view, get data returned, but you want to know how this view fits in with your reports. A: CLARITY_DEP_CUST_FIELDS likely has not been extracted to the Clarity database. Your ETL administrator can enable this for you. CHAPTER 3-Reviewing a colleague's report, you see an unfamiliar table and want to find out more about it. However, you try looking it up, but can't find it in the Clarity Dictionary. Why might this happen, and where should you look instead? The Clarity Dictionary from the UserWeb contains only Epic‐released definitions. Any modifications made by your database administrators will not be reflected. To find all customizations, access the Clarity Compass within Hyperspace. CHAPTER 3-If you find a table in the Clarity Compass, will it necessarily be on your Clarity database? Not always the case. The Clarity Compass will show all of the tables that are possible but at your organization you might not have every table extracted. How can you find out if it is? Query it in SQL, look for C records in the Clarity Compass, check to see there are executions listed on the Summary form CHAPTER 3-Clarity Compass Defines what Chronicles/production data will be extracted into which Clarity tables and columns. Defines the structure of your Clarity tables, including primary keys The Clarity Compass stores a list of all possible database objects that can be extracted to the Clarity database. The Clarity Compass stores table definitions and maps Chronicles items to Clarity tables and columns. Clarity BI developers writing reports and analyzing Clarity data can use the Clarity Compass to learn some basic information about the Clarity ETL process. Clarity ETL administrators may also use this tool for reference and further documentation. CHAPTER 3-Clarity Console Schedules the extract of defined tables from Chronicles into Clarity. Displays information about previously run extracts. The Clarity Console is primarily a tool for Clarity ETL administrators, or Clarity Database Administrator, who uses the Clarity Console to manage and monitor the ETL process as data moves from Chronicles to Clarity. CHAPTER 3-Column Search There are two ways to access the Clarity Compass data. Both utilities are found within Hyperspace and will open different sections of the table workspace. ONE is Column Search: *Search by a Chronicles INI and Item number, or a Clarity column name *Brings you to the Columns tab in the Clarity Compass The Columns tab of the table workspace shows information about a particular column within a table in Clarity. You can enter the Columns tab by using the Column Search activity. CHAPTER 3-Database Object Search (dbo) There are two ways to access the Clarity Compass data. Both utilities are found within Hyperspace and will open different sections of the table workspace. ONE is Database Object Search: *Search by a table name, or the name of another database object *Brings you to the Summary tab in the Clarity Compass CHAPTER 3-ER Diagram Entity Relationship Diagram The Table Summary tab within the Table Workspace shows the Clarity Compass information that is relevant to the entire table. You can enter the Table Summary tab by using the Database Object Search activity, or by clicking the Summary tab when already in the Table Workspace. CHAPTER 3-Report Repository Within the Data Handbook, the Report Repository contains reference information for Epic released and customer‐written reports. It stores reports written using a variety of reporting tools. As a Clarity business intelligence developer, the Report Repository is a useful resource to investigate Clarity tables used in a similar report request. The Report Repository contains information such as tables used in a Crystal report. An ER diagram ﴾Entity Relationship diagram﴿ is a visual tool that show relationships between database objects relevant to a particular reporting area. As a Clarity business intelligence developer, you can use application‐specific ER diagrams to investigate frequently used tables and how they relate together. ER diagrams contain information such as: *Common tables and their links for a particular reporting area *Relationship cardinality of frequent joins Epic publishes and maintains a Clarity ER diagram for each application. To find the one you're looking for, search for "application ER Diagram htm" on Galaxy. Including the "htm" will assure that you access the version of the ER diagram that your web browser will be able to open. Once you download the ZIP file, extract it to your local machine and open "" to view the diagram. CHAPTER 3-Clarity Dictionary The Clarity Dictionary is a key tool providing information about the released Clarity tables. The Clarity Dictionary contains information such as: *Table and column names *Table and column descriptions *Index information *Primary and foreign keys The Clarity Dictionary from the UserWeb contains only Epic‐released definitions. Any modifications made by your database administrators will not be reflected. To find all customizations, access the Clarity Compass within Hyperspace. Find the Clarity Dictionary on the UserWeb through the Data Handbook. You can search by typing in a keyword, or narrow your search with Clarity Table Name or Clarity Column filters. Make sure you have the right version of Epic selected to get the most accurate information. CHAPTER 3 - _C Column The reason the Foreign Key Information section works well to find ZC tables is that joins from _C columns to ZC tables are simple and can be reliably calculated by the data model. CHAPTER 3-ZC_Tables Category items extract to Clarity columns that end in _C and can be used as foreign keys to ZC_ tables in order to look up the name of the category value. CHAPTER 3-ETL Extract, Transform, Load CHAPTER 3-Deprecation When a column is deprecated, data is no longer extracted to it. The replacement column is populated going forward and a backfill process takes care of the previously existing rows in the table. Epic doesn't delete columns or tables once released. However, there are times when an Epic data structure changes so radically that it's no longer possible to populate old tables with it. In these cases, the table or column will be deprecated. While the table or column will still exist in your Clarity database, no new data will be extracted. The Clarity Compass will tell you what column to use as a replacement, or any additional pertinent information. CHAPTER 4-What Chronicles item characteristics allow multiple values to be stored for a single record? Add Type and Response Type Chapter 4-Add Type Characteristics *Indicates if data is stored on a record or on a contact in the record. *Categorized as either No‐Add or Overtime (Response Each Time or Lookback) *No‐Add: stored on the record. Always considered "current". *Overtime: stored on the contact. Chapter 4-Response Type Characteristics *Indicates how many lines of data an item can hold *Categorized as either Single or Multiple (Multiple response, Related group) *Single: holds only one line of data *Multiple: holds multiple lines of data CHAPTER 4-Indentifying Chronicles Contacts There are two possible identifiers for contacts in Epic. *A Contact Serial Number, or CSN, is a serial number that is unique for all contacts within that master file. *A Contact Date Real, or CDR, is a date in Epic's internal format, followed by two decimal places that start at .00 and increment for each additional contact on the same date. CHAPTER 4-All data in a single extracted table in Clarity typically come from the same Chronicles _______________________________ MASTERFILE CHAPTER 4-All data in a single extracted table in Clarity typically come from items with the same _________________ and ___________________ Add Type and Response Type CHAPTER 4-Multiple response Chronicles items typically extract to ___________________ Clarity tables, unless they are part of the same related group. Separate CHAPTER 4-Define the cardinality of a relationship. It describes the numerical relationship between entities in two tables. e.g. 1 to 1 1 to many many to 1, etc. CHAPTER 4-Networked Items Networked items in Chronicles define relationships between an item in one Masterfile and a record or contact. Each networked item will store the ID of a Chronicles record or contact. OVERALL-Access Clarity Compass The Clarity Compass is used to set the definitions for how Chronicles items will translate into Clarity. It is used by ETL administrators at your organization to define the structure of your Clarity tables, and is thus useful for the business intelligence developer in order to view the mapping. The Clarity Compass provides organization‐specific information about your Clarity database. There are two ways to access the Clarity Compass data. Both utilities are found within Hyperspace and will open different sections of the table workspace. 1-Log in to Hyperspace as a Business Intelligence Developer. 2-Use Chart Search to open Column Search. 3-In the INI field enter EPT and press TAB to enter the Item field ( OR, necessary INI) 4-In the item field enter .2 (OR the necessary Item) 5-Click Accept 6-Select the column within the PATIENT table and click Accept. On the search page, you would already see all the Clarity mappings for a given INI and Item number. 7-Click Accept to enter the Columns tab of the Clarity Compass. CHAPTER 4-If an item's add type is overtime, what element will be present in the primary key of the table that extracts the item? A contact identifier such as CSN or CDR CHAPTER 4-What value is stored in a networked item? The .1 of a Chronicles record or the CSN of a contact on a Chronicles record CHAPTER 4-You have a patient query and would like to display the name of the patients' providers. Item EPT 18867: Admitting Provider is a networked item that points to the SER master file. How can you use Column Search help display the name of the admitting provider? Use Column Search on I EPT 18867 to find the foreign key column in the starting table. You can also use Column Search on I SER .2 to find the table that stores provider names. Use the foreign key of the starting table to join to the primary key of the destination table. CHAPTER 4-Would it be possible to have more than one copy of the same table in one report? Why or why not? Yes; Because Chronicles master files can reference each other multiple times, there are multiple ways to link Clarity tables together. CHAPTER 4-If an item's response type is multiple, what element will be present in the primary key of the table that extracts the item? LINE CHAPTER 4-Contact Serial Number CSN-A Contact Serial Number, or CSN, is a serial number that is unique for all contacts within that master file. The unique contact serial number corresponding to this workflow activity event. If this event is associated with a patient encounter, the encounter data should be retrieved by linking this column to PAT_ENC.PAT_ENC_CSN_ID. Note that not all event records will have associated patient encounter data. CHAPTER 4-Contact Date Real CDR-A Contact Date Real is a date in Epic's internal format, followed by two decimal places that start at .00 and increment for each additional contact on the same date. CHAPTER 4-Granularity If a Clarity table storing each of these data points had a granularity of "a patient", then each row would require multiple columns to store each phone number discretely. Defining a table in this fashion would require an upper limit on the number of phone numbers that could be listed for each patient. While this might not be a problem with phone numbers, it would be a problem if you set an upper limit on the number of allergies, medications, or and many other items. CHAPTER 4-Networked Item Networked items in Chronicles define relationships between an item in one Masterfile and a record or contact. Each networked item will store the ID of a Chronicles record or contact. CHAPTER 4-Cardinality It describes the numerical relationship between entities in two tables. his is usually denoted in an "M to N" statement. For example, "one to one" or "zero or one to one or more." 1 to 1 1 to many Many to 1 Many to Many A particular networked item will always reference the same master file. For example, I EPT 470 holds the ID of the user who last changed the patient's address. No matter the patient or user, I EPT 470 can only store the .1 of an EMP record. This relationship is part of the item definition. CHAPTER 5-View A view is a stored query. In Clarity, views meet particular reporting needs, pulling in data from several different tables in Clarity. As a result, views can greatly decrease the amount of work a Clarity report writer needs to do during the query creation process. Views in Clarity typically begin with V_", however this naming convention is not strictly enforced. CHAPTER 5-Derived Table Derived tables, or materialized views, in Clarity are populated from queries that run against data already contained in the database and can take the place of several tables in one report. In Clarity, derived tables follow the dimensional data model: fact tables begin with F_ and dimension tables begin with D_. While Caboodle consists primarily of fact and dimension tables, Clarity has relatively few derived tables and primarily follows a normalized data model. CHAPTER 5-Scripts OVERALL-ER Diagram An ER diagram (Entity Relationship diagram) is a visual tool that show relationships between database objects relevant to a particular reporting area. As a Clarity business intelligence developer, you can use application‐specific ER diagrams to investigate frequently used tables and how they relate together. ER diagrams contain information such as: *Common tables and their links for a particular reporting area *Relationship cardinality of frequent joins OVERALL-Clarity Dictionary Within the Data Handbook, the Clarity Dictionary provides reference information about the Clarity data model. As a Clarity business intelligence developer, the Clarity Dictionary is a key tool providing information about the released Clarity tables. The Clarity Dictionary contains information such as: *Table and column names *Table and column descriptions *Index information *Primary and foreign keys