Cogito - Clarity Data Model - CLR 110: Clarity Data Model Fundamentals
Operational Reporting Time Sensitive; Relatively Small; Easily Accessible; Actionable
Application Reports; Reporting Workbench; KB_SQL; Chronicles Ad Hoc; Cache
Operational Reporting Tools
Script
Analytical Reporting in Clarity Comprehensive; Summarized; Standardized
EPIC-Crystal Integration; Business Objects Universes; Radar (information
Clarity Distribution Mechanisms
center/Portal )
Chronicles (Storage);Master File/INI (Patient Records); Record (John Accrual);
The way data is stored in EPIC
Contact (6/30/2012 Admission); Item (Attending Providers); Line (First Attending, etc.)
Point of data in Chronicles can be Its INI and Item Number
identified by
Control Left-Click Method One method to find where the data lives though Hyperspace
Raw data in Item Information System information that is probably different from what end user sees
Item .1 Record ID
Item .2 Record Name
Chronicles Data Type - String Any combination of characters
Chronicles Data Type - Number Any number - can be an integer or a decimal
A time without a date; stored as the number of seconds since midnight; converted
Chronicles Data Type - Time
back to normal time for display
Date/Time stored in single item as the number of seconds since midnight on
Chronicles Data Type - Instant
12/31/1840 and converted back to normal for display
Chronicles Data Type - Category A pre-defined list of choices; Some can be modified by customers, some cannot
Response Types Determines how many lines of data an Item can hold
Response Types - Single Response Only one line of data can be stored
, Response Types - Multiple Response Multiple lines of data can be stored (e.g. addresses)
Multiple lines of data can be stored and each one of these lines is related to a line in
Response Types - Related Groups
another item (e.g. Different Phone numbers )
Identifies whether a data changes on the item for each Contact or is stored directly
Add Types
on a record
Add Types - No-Add Stores items directly on a record, not a specific contact
Add Types - Response Each Time Stores values separately on each of a record's contact
Stores values separately on each contact, but assume that last value remains true
Add Types - Lookback
until new value is entered (not used very often anymore.
Very similar to lookups with joins in relational database but specific technique to
Networking
Chronicles (e.g. End User sees pt name but what is actually stored in item is pt id)
Scheme of all items with numbers and values for a given record/contact combination
Chronicles Record Viewer
in a given master file/INI
Shows item characteristics including: INI Item #, Description, Data Type, Response
Item Editor
Type, Add Type and SQL Table / SQL Column title
Defines what Chronicles/production data will be extracted into which Clarity tables
Clarity Compass and columns. Defines the structure of your Clarity tables, including primary keys -
Hyperspace
Clarity Console Schedules the extract of defined tables from Chronicles into Clarity - Web-based
Path: Epic>Report Management>Column Search: can search your column definitions
Column Search for a column that extracts a certain Chronicles item, and then jump to that column's
compass entry for more information
String - VARCHAR; Number - NUMERIC/FLOAT; Date - DATETIME/FLOAT*Contact
Chronicles to Clarity Data Type Mapping
Date Real; Time - DATETIME; Instant - DATETIME; Category - VARCHAR/INTEGER
Deprecated Flag that identifies that disabled/obsolete columns
Extracted Almost always set to yes; used by ETL administrators
Allows you to search for Clarity Tables by name and then jump into the tables'
Database Object Search
Compass Table Summary
Primary Key A field or combination of fields that uniquely identify a record
A contact date real is a date in Epic's internal format, followed by a two decimal
Contact Date Real (CDR)
places that identify one contact among many on the same date.
Contact Serial Number (CSN) A CSN is a number that uniquely identifies a single contact within a master file
Truncates any data already in the Clarity table and re-extracts the entire table from
Load Type - Full
Chronicles
Finds data that has changed in Chronicles since the last time the table was extracted,
Load Type - Incremental (REQ)
extracts the changes, and uses them to update the table in Clarity
Load Frequency Default: Full-extract tables are weekly; Incremental tables are daily (incremental)
The Clarity Extract, Transform, and Load (ETL) process extracts data from your
Chronicles database, transforms Chronicles' records, items, and contacts into the
ETL
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 ZC_* tables; Performance Tip - filter or sort on the _C columns
Operational Reporting Time Sensitive; Relatively Small; Easily Accessible; Actionable
Application Reports; Reporting Workbench; KB_SQL; Chronicles Ad Hoc; Cache
Operational Reporting Tools
Script
Analytical Reporting in Clarity Comprehensive; Summarized; Standardized
EPIC-Crystal Integration; Business Objects Universes; Radar (information
Clarity Distribution Mechanisms
center/Portal )
Chronicles (Storage);Master File/INI (Patient Records); Record (John Accrual);
The way data is stored in EPIC
Contact (6/30/2012 Admission); Item (Attending Providers); Line (First Attending, etc.)
Point of data in Chronicles can be Its INI and Item Number
identified by
Control Left-Click Method One method to find where the data lives though Hyperspace
Raw data in Item Information System information that is probably different from what end user sees
Item .1 Record ID
Item .2 Record Name
Chronicles Data Type - String Any combination of characters
Chronicles Data Type - Number Any number - can be an integer or a decimal
A time without a date; stored as the number of seconds since midnight; converted
Chronicles Data Type - Time
back to normal time for display
Date/Time stored in single item as the number of seconds since midnight on
Chronicles Data Type - Instant
12/31/1840 and converted back to normal for display
Chronicles Data Type - Category A pre-defined list of choices; Some can be modified by customers, some cannot
Response Types Determines how many lines of data an Item can hold
Response Types - Single Response Only one line of data can be stored
, Response Types - Multiple Response Multiple lines of data can be stored (e.g. addresses)
Multiple lines of data can be stored and each one of these lines is related to a line in
Response Types - Related Groups
another item (e.g. Different Phone numbers )
Identifies whether a data changes on the item for each Contact or is stored directly
Add Types
on a record
Add Types - No-Add Stores items directly on a record, not a specific contact
Add Types - Response Each Time Stores values separately on each of a record's contact
Stores values separately on each contact, but assume that last value remains true
Add Types - Lookback
until new value is entered (not used very often anymore.
Very similar to lookups with joins in relational database but specific technique to
Networking
Chronicles (e.g. End User sees pt name but what is actually stored in item is pt id)
Scheme of all items with numbers and values for a given record/contact combination
Chronicles Record Viewer
in a given master file/INI
Shows item characteristics including: INI Item #, Description, Data Type, Response
Item Editor
Type, Add Type and SQL Table / SQL Column title
Defines what Chronicles/production data will be extracted into which Clarity tables
Clarity Compass and columns. Defines the structure of your Clarity tables, including primary keys -
Hyperspace
Clarity Console Schedules the extract of defined tables from Chronicles into Clarity - Web-based
Path: Epic>Report Management>Column Search: can search your column definitions
Column Search for a column that extracts a certain Chronicles item, and then jump to that column's
compass entry for more information
String - VARCHAR; Number - NUMERIC/FLOAT; Date - DATETIME/FLOAT*Contact
Chronicles to Clarity Data Type Mapping
Date Real; Time - DATETIME; Instant - DATETIME; Category - VARCHAR/INTEGER
Deprecated Flag that identifies that disabled/obsolete columns
Extracted Almost always set to yes; used by ETL administrators
Allows you to search for Clarity Tables by name and then jump into the tables'
Database Object Search
Compass Table Summary
Primary Key A field or combination of fields that uniquely identify a record
A contact date real is a date in Epic's internal format, followed by a two decimal
Contact Date Real (CDR)
places that identify one contact among many on the same date.
Contact Serial Number (CSN) A CSN is a number that uniquely identifies a single contact within a master file
Truncates any data already in the Clarity table and re-extracts the entire table from
Load Type - Full
Chronicles
Finds data that has changed in Chronicles since the last time the table was extracted,
Load Type - Incremental (REQ)
extracts the changes, and uses them to update the table in Clarity
Load Frequency Default: Full-extract tables are weekly; Incremental tables are daily (incremental)
The Clarity Extract, Transform, and Load (ETL) process extracts data from your
Chronicles database, transforms Chronicles' records, items, and contacts into the
ETL
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 ZC_* tables; Performance Tip - filter or sort on the _C columns
