"internal layout" - ANS-number of days since 12/31/1840 or number of seconds considering
the fact that midnight three-nine
2 Tools Used in Clarity ETL Process - ANS-Clarity Compass, Clarity Console 3-17
A manager desires to recognize who has made modifications to affected person
demographics within the final six months.
Will Caboodle probably be able to meet this record request? - ANS-No. Image trade
monitoring does now not track who made a change. 6-14
ACCESS_LOG and ACCESS_WRKF - ANS-Tables used to peer what a selected consumer
is doing within the gadget, or has accessed certain patient's facts. 6-12
Add Type - ANS-An item's Add Type describes how long a chunk of data is valid. It
determines whether an object's cost is
stored on each contact, or directly to the report. 2-17
Add Type - ANS-Indicates if information is saved on a document or
on a touch within the report. Categorized as either No‐Add or
Overtime ﴾Response Each Time or
Lookback﴿
No‐Add: stored on the document.
Always taken into consideration "modern-day".
Overtime: saved on the touch. 4-6
Add Type: No-Add, Response Type: Multiple/Related - ANS-RECORD_ID, LINE 4-12
Add Type: No-Add, Response Type: Single - ANS-RECORD_ID four-12
Add Type: Overtime, Response Type: Multiple/Related - ANS-CSN, LINE or RECORD_ID,
CDR, LINE 4-12
Add Type: Overtime, Response Type: Single - ANS-CSN or RECORD_ID, CDR 4-12
All records in a unmarried extracted desk in Clarity commonly come from gadgets with the
equal _________ and ___________ - ANS-Add type, Response type 4-12
All facts in a unmarried extracted table in Clarity generally come from the identical
Chronicles: ______________ - ANS-Master report four-12
Audit Item Tables - ANS-The set of tables that begin with AUDIT_ITM, that are designed to
audit any object in chronicles for which auditing is grew to become on. 6-11
, Caboodle Packages - ANS-Clarity is the source of Epic information for Caboodle, and you
are able to
see the SQL query that populates the burden bundle for Epic information going into
Caboodle. Five-8
Categories are extracted as an ______________________ or ________________________
- ANS-INTEGER, VARCHAR three-9
Category List - ANS-When the use of a class list cost as a filter out, the query can run more
successfully whilst filtering on the
class value itself in preference to the name in the category listing table. To locate call to
show for a
precise price, you want to see the category list. 2-12
Chronicles Info dating among gadgets: - ANS-The courting among gadgets and columns
isn't always one‐to‐one: a unmarried Chronicles item can extract to
a couple of columns in Clarity. 3-7
Clarity Compass - ANS-Defines what Chronicles/manufacturing facts may be extracted
into which Clarity tables and columns. Defines the structure
of your Clarity tables, inclusive of number one keys. 3-17
Clarity Compass - ANS-The Clarity Compass shops a list of all feasible database objects
that may be extracted to the Clarity
database. 3-21
Clarity Console - ANS-Schedules the extract of defined tables from Chronicles into
Clarity. Displays statistics approximately previously run extracts. Three-17
Clarity Dictionary - ANS-For a Clarity business intelligence developer, the Clarity Dictionary
is a tool
supplying records about the released Clarity tables without requiring business intelligence
developers
to have access to Hyperspace. Three-15
Cogito Dictionary - ANS-The Cogito Dictionary lives in the Analytics Catalog. 3-23
Cogito SQL Reporting Workbench Templates - ANS-Reporting workbench use the Ad Hoc
search engine to search Chronicles, or it's far feasible to use the
Cogito SQL seek engine to run a query in opposition to Clarity or Caboodle as part of the
hunt. 5-9
Column Search - ANS-Search by means of a Chronicles INI and Item
range, or a Clarity column name.
Brings you to the Columns. Three-6
Columns Section - ANS-The columns section lists out some key