COGITO - CLARITY DATA MODEL - CLR
110: CLARITY DATA MODEL
FUNDAMENTALS QUESTIONS AND
ANSWERS
Operational Reporting - ANSWER-Time Sensitive; Relatively Small; Easily Accessible;
Actionable
Operational Reporting Tools - ANSWER-Application Reports; Reporting Workbench;
KB_SQL; Chronicles Ad Hoc; Cache Script
Analytical Reporting in Clarity - ANSWER-Comprehensive; Summarized; Standardized
Clarity Distribution Mechanisms - ANSWER-EPIC-Crystal Integration; Business Objects
Universes; Radar (information center/Portal )
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.)
Point of data in Chronicles can be identified by - ANSWER-Its INI and Item Number
Control Left-Click Method - ANSWER-One method to find where the data lives though
Hyperspace
Raw data in Item Information - ANSWER-System information that is probably different
from what end user sees
Item .1 - ANSWER-Record ID
Item .2 - ANSWER-Record Name
Chronicles Data Type - String - ANSWER-Any combination of characters
Chronicles Data Type - Number - ANSWER-Any number - can be an integer or a
decimal
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
, 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
Chronicles Data Type - Category - ANSWER-A pre-defined list of choices; Some can be
modified by customers, some cannot
Response Types - ANSWER-Determines how many lines of data an Item can hold
Response Types - Single Response - ANSWER-Only one line of data can be stored
Response Types - Multiple Response - ANSWER-Multiple lines of data can be stored
(e.g. addresses)
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
)
Add Types - ANSWER-Identifies whether a data changes on the item for each Contact
or is stored directly on a record
Add Types - No-Add - ANSWER-Stores items directly on a record, not a specific contact
Add Types - Response Each Time - ANSWER-Stores values separately on each of a
record's contact
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.
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.
110: CLARITY DATA MODEL
FUNDAMENTALS QUESTIONS AND
ANSWERS
Operational Reporting - ANSWER-Time Sensitive; Relatively Small; Easily Accessible;
Actionable
Operational Reporting Tools - ANSWER-Application Reports; Reporting Workbench;
KB_SQL; Chronicles Ad Hoc; Cache Script
Analytical Reporting in Clarity - ANSWER-Comprehensive; Summarized; Standardized
Clarity Distribution Mechanisms - ANSWER-EPIC-Crystal Integration; Business Objects
Universes; Radar (information center/Portal )
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.)
Point of data in Chronicles can be identified by - ANSWER-Its INI and Item Number
Control Left-Click Method - ANSWER-One method to find where the data lives though
Hyperspace
Raw data in Item Information - ANSWER-System information that is probably different
from what end user sees
Item .1 - ANSWER-Record ID
Item .2 - ANSWER-Record Name
Chronicles Data Type - String - ANSWER-Any combination of characters
Chronicles Data Type - Number - ANSWER-Any number - can be an integer or a
decimal
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
, 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
Chronicles Data Type - Category - ANSWER-A pre-defined list of choices; Some can be
modified by customers, some cannot
Response Types - ANSWER-Determines how many lines of data an Item can hold
Response Types - Single Response - ANSWER-Only one line of data can be stored
Response Types - Multiple Response - ANSWER-Multiple lines of data can be stored
(e.g. addresses)
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
)
Add Types - ANSWER-Identifies whether a data changes on the item for each Contact
or is stored directly on a record
Add Types - No-Add - ANSWER-Stores items directly on a record, not a specific contact
Add Types - Response Each Time - ANSWER-Stores values separately on each of a
record's contact
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.
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.
