This table contains general history information for each type of medication warning or advisory. Since each warning could be triggered in different activities at different times, it contains general warning information for each time the warning was triggered. To get patient information, link this table to the table and then link the table to the or table. To get order related information for each medication warning or advisory, link this table to. To get specific medication or condition information for each medication warning type, link this table to specific medication warning related tables, such as the table for drug-allergy warnings; the table for drug-drug, drug-food, and drug-alcohol warnings; the and tables for duplicate therapy warnings; the and tables for IV warnings; and the and tables for pregnancy warnings.

Accounts contain information about billing for services, while coverages contain information about insurance payors, benefits, subscribers, and members. This table contains one row for each account record in your system.

This table contains dispense information for orders.

This table contains pharmacy information. Each ADS (such as Pyxis), satellite pharmacy, or main pharmacy should have a record in the table.

DM_ANESTHESIA is a data mart table that contains metrics for anesthesia encounters. The Anesthesia Record Registry must be activated to populate these metrics. Only patient encounters that meet the inclusion criteria in CER 89004 (DM ) for the registry have information stored in this table.

The table contains basic information about the procedure records in your system. This does include both A/R and clinical procedures.

This table contains hospital account transaction detail from the Hospital Permanent Transactions (HTR) master file.

The table contains high-level information about departments.

The table enables you to report on medications ordered in EpicCare (prescriptions). We have also included patient and contact identification information for each record.

The table contains basic information about your benefit plans.

The table enables you to report on the procedures ordered in the clinical system. We have also included patient and contact identification information for each record.

This table contains a list of table (E0B) records that exist in the Clarity Compass along with pertinent information including the name, how often the table is loaded, how the table is loaded, related master file details, and Oracle®-related settings.

The table contains OR management system procedures.

The table contains basic information about In Basket messages.

This table is the primary table for hospital encounter information. A hospital encounter is a contact in the patient record created through an ADT workflow such as preadmission, admission, ED Arrival, discharge, and hospital outpatient visit (HOV) contacts. These contact types have the ADT flag (I EPT 10101) set to 1. This table excludes all other contacts.

The table is the primary table for referral information stored in system.

This table contains data associated with task (LTK) records.

The table contains one record for each patient in your system. The data contained in each record consists of demographics, PCP and primary location information, registration information, and other information.

This table contains information from pharmacy claims. Each record represents one pharmacy claim in the managed care system's AP Claims module.

The table contains high-level information about your provider records. These records may be caregivers, resources, classes, devices, and modalities.

This table contains high-level information on the episodes recorded in the clinical system for your patients. When a provider sees a patient several times for an ongoing condition, such as prenatal care, these encounters can be linked to a single Episode of Care. It does not contain episodes linked to an inpatient encounter.

This table contains generic information about flowsheet groups/rows.

The table contains result finding information for an order. Result findings include mammography pathology results, cardiovascular palette findings, and other result findings.

This table contains common information from General Use Notes items. This table focuses on time-insensitive, once-per-record data while other HNO tables (e.g., NOTES_ACCT, CODING_CLA_NOTES) contain the data for different note types.

This table summarizes data for AP Claims service lines, with each service line given one row. To link this table’s service line information back to a claim header, join this table to on the column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the column. If you care about neither distinguishing CSR-related service lines nor the ordering of service lines on a claim, you can join back to the claim header on this table's column.

All values associated with a claim are stored in the Claim External Value record. The table holds information about the service lines on the claim.

The table contains OR management system case records.

The table contains one record for each claim in the managed care system's AP Claims module.

The table contains high-level information on both managed care and indemnity coverage records in your system.

This table contains information about your location records. These include revenue locations and patients' primary clinics/locations. The records included in this table are Facility Profile (EAF) records that are designated as facility, service area, and location records. That is, Type of Location (I EAF 27) has a value of 1, 2, or 4.

The table contains information about payer records.

Universal Charge Lines (UCL) information. Each row represents one UCL transaction.

X_DM_WLL_0_17 (Regsitry 100079) is a data mart table that stores information related to general patient health. This table consolidates patient information from many subject areas including lab values, vitals, medications, diagnoses, social history, and risk scores. If the patient is not deceased, then he/she is included in this wellness registry.

X_DM_WLL_18_39 (100068) is a data mart table that stores information related to general patient health. This table consolidates patient information from many subject areas including lab values, vitals, medications, diagnoses, social history, and risk scores. If the patient is not deceased, then he/she is included in this wellness registry.

This table contains information related to patient encounters or appointments.

This table provides information on work list tasks.

DM_WLL_ALL is a data mart table that stores information related to general patient health. This table consolidates patient information from many subject areas including lab values, encounters, vitals, medications, diagnoses, social history, and risk scores. If the patient is not deceased, then he/she is included in this wellness registry.

This table contains information about specimen containers. This includes information about what specimen it belongs to and its current location. This table was originally used to store submitter information. When looking at the SQL for this table you will see some columns still have "submitter" in their name even though this table now holds container information.

Contains the terminology codes for Terminology-type groupers.

This table contains procedure records for blood culture lab orders.

The table contains the system ID numbers for the LLB masterfile. Each record may have multiple IDs; therefore, a line number is used to identify each identification number for each record.

X_DM_ACTIVE_PATIENT is a data mart table that stores information related to Registry 100093 (Active Patient). This table consolidates patient information from many subject areas including lab values, encounters, vitals, medications, diagnoses, procedure and social history. Only patients that meet specific inclusion criteria have their information stored in this table.

The table contains information about activity records used by Hyperspace.

This table contains DRG Types that are used to categorize DRGs by code set and version. A DRG Type (DRG_TYPE_ID) is an Identity ID Type for the DRG master file. The DRG Type is determined by combining the DRG code set (e.g. MS-DRG) and the DRG version or effective date (e.g. Version 28). For example, a DRG Type might be "MS-DRG Version 28." A DRG type will be mapped to either a unique DRG code set and DRG version pair, or a unique DRG code set and effective date range. The actual configuration will depend on whether the third party grouping system specifies an explicit DRG version, or determines a DRG version based on a date associated with the hospital account.

This table holds a list of authorized service areas, business segments and the patient associated with the referral linked to an authorization. This table is used with Organizational Filtering. If the authorization is a Utilization Management authorization, an organization will have access to an authorization if they are authorized for at least one of the linked coverage's associated service areas/business segments. If the authorization is not a Utilization Management authorization, an organization will have access to an authorization if they are authorized for at least one of the linked referral's associated service areas/business segments or if they are authorized for the linked referral's associated patient.

This table contains information about your division records. This includes the division's address as well as other division-specific information. The records in this table are Division (DPG) records.

This table holds users determined to be responsible for work list task instances.

The table contains a list of service areas and business segments used to determine which members are associated with a member group.

This table contains the list of referrals that are used during AP claims adjudication to satisfy authorization requirements for this service.

The table contains information about the members associated with each coverage record. Since one coverage record can have multiple members, each row in the table corresponds to one member and is noted by the coverage ID and the line number.

List of stages attached to a specific problem on a patient's Problem List.

This table is designed to extract information related to tasks.

This table contains details regarding claim codes attached to AP claims.

This table contains the Internet email addresses of patients with web-based chart system accounts. If a patient signs up for Internet Email Alerts, then an alert message will be sent to the address in this table each time the patient receives a new web-based chart system message. The patient can update this address on the Personal Preferences page in web based chart system. Currently, this item is populated for non-patient proxy accounts only. For patients, email information is stored in the and tables, from the Primary Email Address (I EPT 85) and Multiple Email Addresses (I EPT 86) items.

DM_COVID_SUSPECTED is a Data Mart table that stores information related to the -19 Suspected Registry metrics. Only patients that meet the inclusion criteria for the -19 Suspected Registry have information stored in this table. This table stores the data from the latest Clarity extract only.

This table contains Denial/Remark/Correspondence/Variance information from the Denial/Correspondence (BDC) master file. It includes information about the denial/remark code received or correspondence text as applicable. It also includes some general information about the current state of the record. It does not include the change history information and specific denial information from the explanation of benefits (EOB).

This table contains rule information.

Contains a list of column (E0C) records, along with the INI/Item(s) that those columns use to obtain their data, as specified in the Extract Information INI/Item # grid in the column (or linked column) record.

This table contains a list of operational tasks used in ADT.

This table contains basic information about a financial assistance case record.

Extracts the attachments for this NCS (customer service) record.

This table contains information about LGL items that are single-response, and tracked over time.

This table extracts the patient registries associated with a particular organization. This is used in organization filter functionality to make patient-related data for patients on the specified registries available to the associated organizations.

This table stores information about the contacts associated with Transfer Center requests.

This table contains all episode records, regardless of the type and is intended for use with Organization Filter functionality. If used for Organization Filtering, users will be able to see an episode if they have authorization for the owning business segment on the episode or the patient associated with the episode.

This table stores user action log data about how activities were used within workspace actions summarized by hour of the day. Each row represents an activity in which a user took actions on a workstation for an hour of the day, summarized by workspace kind and subkind.

DM_COVID_SUSPECTED_EXT is a Data Mart table that stores external information related to the Suspected Registry metrics. Only patients that meet the inclusion criteria for the -19 Suspected Registry have information stored in this table. This table stores the data from the latest Clarity extract only.

This table contains the currently active medication administration data. This includes all scheduled and acted upon administrations currently showing on the MAR.

The table contains overtime single response orders information.

DM_ACO_EXT is a data mart table that stores external information related to ACOs. This table consolidates patient information from many subject areas including demographics, PCP, patient status, lab values, encounters, vitals, medications, diagnoses, and social history. Only patients that meet specific inclusion criteria have information stored in this table.

This table holds information about payments for AP Claims. Payment information is stored once the claim is sent to AP and subsequently updated with check information once the claim is batched. Therefore, and other columns populated after batching such as AP_BATCH_RUN_CSN_ID, may be . If reporting on amounts paid by checks only, you should filter on whether and amount columns are . When a claim is sent to AP, this table contains one row per responsibility class for the claim without CHECK_IDs. If the claim is batched for a responsibility class, the table is updated to contain one row per claim per responsibility class per check plus the rows for any responsibility classes that remained unbatched. Once a claim is paid in full, all rows will have populated. The other scenario that is important to consider arises because amounts may be if the claim was associated with a check, but no amount was paid. For example, if a reversal claim and its adjustment are batched separately, the reversal claim will have a row with amounts for the adjustment claim's check and vice versa.

This table stores the Medicare health status flags for a member.

The table contains historical, non-primary names for third-party directory (TDD) records. These records represent facilities, groups, or other organizations. There will be one row per contact per secondary name per TDD record.

This table connects the coded CPTs used in coding-only and combined service lines with the line where the CPT was entered in Coding (HAR 1750 related group). CPTs from multiple lines can be included on one service line. Values are only available for coding-only and combined lines. Rows will not be extracted for charge-only lines.

The table enables you to report on the diagnoses associated with medications ordered in clinical system (prescriptions). Since one medication order may be associated with multiple diagnoses, each row in this table is one medication - diagnosis relation. We have also included patient and contact identification information for each record. Note that system settings may or may not require that medications be associated with diagnoses. This table contains only information for those medications and diagnoses that have been explicitly associated. Check with your clinical system Application Administrator to determine how your organization has this set up.

Result audit information for verification and unverification (result correction).

This table contains the authorization decision history for service-level authorizations.

This table contains the implants information for the surgical/invasive procedure log (ORL).

This table contains all of the clinical Outcome and Assessment Information Set () ICD-10 diagnoses entered by a field nurse and edited in Diagnosis Review. The first diagnosis for a given patient encounter is the primary diagnosis. The next 5 are the diagnoses that will go on the submission. Anything after the sixth diagnosis for a given encounter is merely reportable.

This table stores discrete billing diagnosis information received from outside sources.

The Customer Relationship Management record that is referenced by the communication.

This table contains susceptibility results, including antibiotics and interpretations. RES_MICRO_CULTURE can be linked to this table by linking.CULTURE_ID to.RESULT_ID and.UNIQUE_ORGANISM_ID to..

This table contains information about professional billing transactions.

The table contains information about surgical and procedural log (ORL) records.

This table contains eCheck-In information for a specific appointment.

This table extracts the related multiple response item VBP-512.

The table stores metadata (context, linked records, time of entry, etc.) concerning SmartData element values entered by users through SmartForms, SmartTools or other documentation tools that file discrete data to SmartData elements. The actual element values entered by end users are stored in the table.

The table contains the code mapping information (map type, effective dates) for the diagnosis records in the EDG master file. The discrete mapping values can be found in. This table stores information on term-to-code mapping as well as code-to-code mapping.

The table contains information related to working procedures for a Clinical Documentation Improvement (CDI) review.

This table contains one row for each priority that should be considered a high priority.

The table contains one row for each web-based chart system account. The data contained in each row consists of basic account information related to logins and passwords, as well as data that the patient has entered and stored in web-based chart system.

Claim-related info in the refund session.

Table for the linked eye exams to a visit or admission.

In Basket Registries store information to determine the recipients who can display and handle specific types of messages. This table contains the basic information about these Registries. Registries are stored in the HIP master file.

The table contains information on inpatient or outpatient attending providers. This table is based on.

The table contains information about patient transfer requests that have been documented in a customer service communication record. This can be used to report on communication documented by staff who facilitate calls between referring providers and admitting providers for potential transfer patients.

The interventions table contains one record for each intervention recorded in your system. Items included are: status, significance, time spent, value, response, associated patient and CSN, associated order, creating user, associated pharmacy, instant created, and instant closed. Not all of these items will be associated with every intervention. The primary key for the interventions table is.

Contains a list of encounter types considered historical by SlicerDicer. Patients are excluded from SlicerDicer if they have one or more encounters considered historical, and do not have any non-historical encounters other than registration or PCP/clinic change. If a patient does have other encounter types, any information from historical encounters will still be pulled into SlicerDicer. Note that registration and PCP/clinic change encounters are not affected by this setting.

This table contains information on messages sent to and from web-based chart system patients.

Table that holds coverage information for an adjudication. Adjudication records are used by Ambulatory Pharmacy during prescription copay adjudication.

This table stores discrete family history problem information received from outside sources.

DM_CMS_HCC is a data mart table that stores information related to CMS-HCC. This table consolidates data about the applicability of hierarchical conditions categories (HCCs), most recent related diagnosis information, and whether or not the patient requires a calendar year refresh for each applicable HCC. Only patients that meet specific inclusion criteria have information stored in this table.

This table contains information about a single finding.

Hospital Logistics Group Information.

This table stores the mapping of query outcome category values to categories for the response type (agreement, disagreement, no response). The outcome is specified by the user during query completion. Reports can use this mapping table to group queries into outcome types to determine response rates, agreement rates, etc.

The table contains information about your container type records.

This table contains basic information from infection abstractions.

This table contains information about push notification actions. For device alert notifications, actions give users a way to communicate with the external system that sends the alerts to Epic. For example, escalate an alert to the next responsible party in the escalation chain when the recipient is not able to immediately address it. To extract data to: 1. In Clinical Administration, open EMR System Definitions and select Decision Support, Pop Management. 2. Go to the Push Notification Clarity Settings screen. 3. In the Types Excluded from Clarity Extracts field, enter the types of push notification you want to exclude from Clarity extraction.

This table contains information about general characteristics of reports containing print groups. This table includes whether it is an report or time sensitive, the stylesheet used, setup extensions, print class, and content type.

This table contains information related to financial assistance program records.

This table holds flowsheet row identifier information from FLO.

This table contains information about referrals linked to an appointment.

This table contains information about a patient's med dispense history from a third-party interface. This information can be helpful for reviewing whether a patient is getting their prescriptions filled at the correct intervals.

This table contains basic information on device types. Each device type (FDV) record can be a group of devices or even as granular as a specific model, depending on how your organization has set up the system.

The table stores information entered into system's Customer Service module. This can be used to report on communication between medical facility staff and patients.

This table contains information about inventory items in the medication inventory catalog.

This table contains data about a Health Maintenance Plan's record ID and name.

DM_SPECIALTYRX is a data mart table that stores information for patients that are taking Specialty medications. This table consolidates patient level information for Specialty Pharmacy patients. Only patients that meet the specific inclusion criteria defined by the Specialty Pharmacy Registry

The ENROLL_LINKED_CSN2 table identifies encounters, using Contact Serial Numbers (CSN), linked to a patient's enrollment in a research study. Unlike, this table includes any associated protocols, day numbers, treatment plans, and treatment days with the CSN as well. The view should be used instead of directly linking to this table. The actual data used by this view may be split between the or the ENROLL_LINKED_CSN2 tables. The view combines the data from both tables regardless of how the underlying data may be shifting between the two tables.

This table contains the extracted information of the Financial Division.

The table contains the ICD-9 Procedure information on an accounts payable claim.

The table contains information regarding the claim export record.

This table is similar to a typical Data Warehouse "Date Dimension". Link your dates to this table to avoid processing date functions on the reporting server. When you use your reporting tool's date functions to do filtering, all rows will usually be returned to your reporting tool and stored in memory while the tool runs date functions to eliminate rows that don't meet your criteria. This can be very slow. This table helps eliminate that necessity and helps you treat your Clarity database like a data warehouse.

This table contains medications' equivalency information.

DM_ACO is a data mart table that stores information related to ACOs. This table consolidates patient information from many subject areas including demographics, PCP, patient status, lab values, encounters, vitals, medications, diagnoses, and social history. Only patients that meet specific inclusion criteria have information stored in this table.

This table contains the information about the treatment days associated with each protocol or the steps associated with each pathway.

This table contains Care Area specifics.

The table contains the system master person index ID numbers for your patients. Each patient may have multiple master person index IDs; therefore, a line number is used to identify each identification number for a patient.

This table contains order specific questions and their responses.

This table contains information about the procedure modifiers associated with each procedure in. It extracts the related multiple response Procedure Modifiers item. Each row in this table relates to a parent row in. Join to it using the columns and. = GROUP_LINE.

This is the ADT encounter status history. It will track changes to the patient's encounter status (I EPT 10115) and confirmation status (I EPT 18852). The user who made the change, time the change occurred, the new encounter status, and the new confirmation status are recorded. A reason for the change may be provided if the change was triggered through ADT Event Management.

This table contains basic information about imaging data from the performing modality. It also contains cumulative radiation dose information.

DM_ICU_STAY is a data mart table that stores information related to ICU stays. This table consolidates patient information from many subject areas including medications, procedures, LDAs, ventilators, physiological data, and stays. Only patients that had an ICU stay have their information stored in this table.

DM_COVID_CONFIRMED_EXT is a Data Mart table that stores external information from the -19 Confirmed Registry. As released, this registry inherits metrics from the -19 Suspected Registry. You can verify the current configuration by looking at the registry in Hyperspace (via the Registry Editor) or by looking in the table. To access the values of the inherited metrics in reports, join to the tables for those registries on the column.

Registry Data Instance (RDI) record stage history.

This table is designed to extract the information necessary to determine where and how orders are being placed in the system. It can also give an indication of what percentage of orders are being placed in the system where the ordering provider is the same as the ordering user. It also details what type of orders and if the orders were modified and/or reordered. Included orders are parent orders; not pended; not created from an interface; not created by an Instant Order BPA action; not a cabinet override; not a historical order; not a bulk dispense order; not created by referral; not external; and either have a procedure associated or do not have an appointment request system status.

The patient encounter communication management table stores communication details for a patient. It contains recipient, sender, and communication information for communications created and sent using the communication management module.

This table is used to store information from the overtime-related Orders items used for the result read/acknowledgment tracking feature. Namely, this is the Read or Acknowledge by User (I ORD 1910) and Read or Acknowledged On (I ORD 1915) items.

A data mart table that contains metrics for patients who have received a lung cancer screening. The Patients with Lung Cancer Screening Registry must be activated to populate these metrics. Only patient encounters that meet the inclusion criteria for the registry have information stored in this table.

This derived table summarizes the data to show the total of professional and hospital charges made for a given referral.

This table contains a list of generic medications (MDL) that were associated with the Coordinated Care Management episode.

This is a conversion that copies rows from with a context of "" into. Running this conversion will speed up how fast is fully populated in preparation for electronic health information data extracts. This conversion supports running over multiple days, so all of the rows don't have to be copied in a single execution.

This table contains the total matched amounts used for calculating collection ratios, the collection ratios themselves, and associated metrics. These values are only applicable for charge transactions.

This table contains modifiers that, when associated with an order, should denote the order will be excluded from decision support.

This table holds information about Regulatory Group records, which are used to store information about configuration for regulatory reporting and attestation programs.

This table contains clinical information collected on the IRF-PAI.

The table contains information concerning the refund reason and comment for a refund performed at check-in/out. This table will only have data if your site has both Professional Billing and Scheduling applications.

The table contains all historical taxonomy codes and license information associated to those taxonomy codes for third-party directory (TDD) records. These records may represent individuals, facilities, groups, or other organizations. There will be one row per taxonomy code per contact per TDD record.

The table contains all historical addresses and information associated to those addresses for third-party directory (TDD) records. These records may represent individuals, facilities, groups, or other organizations. There will be one row per contact per associated address per TDD record.

This table contains information relating to SmartText records. SmartTexts are blocks of text which may be used in a variety of ways, including documenting on clinical encounters, and for letters sent to patients.

This table contains information from overtime single-response items about General Use Notes (HNO) records. Contact creation logic for clinical notes is as follows: 1. If a note doesn't exist, a new note is created. This represents the first contact on that note. 2. If a revision is filed by the incoming transcription interface, a new contact is created on the note being revised regardless of note status.

The table contains basic data about the various organizations to which you pay checks. These vendors may receive AP claims payments, PCP capitation, or specialty capitation payments.

The table contains one record for each update of a patient's allergy information.

This table contains information about your genomics sequencing pipeline documents.

The table contains historical data for Medicaid and other identifiers for third-party directory (TDD) records. These records may represent individuals, facilities, groups, or other organizations. There will be one row per contact per other identifier per TDD record.

The table contains high-level information about third-party directory (TDD) records. These records may be individuals, facilities, groups, or other organizations. There will be one row per identifier per source from which your organization imports data.

The table contains the system ID numbers for your procedures. Each procedure may have multiple IDs; therefore, a line number is used to identify each identification number for a procedure.

This table contains information related to a financial assistance program tracker record.

The table contains information about the users that have protocolled imaging orders. The table may be useful in both determining the users that have protocolled a particular exam and determining the exams that a given user has protocolled. There should never be more than one row for a given user and order. The key pieces of data stored in this table are the protocolling user (PROTOCOL_USER_ID) and the instant the protocolling action was performed (INSTANT_UTC_DTTM). Since the data stored in the columns relate to related-response items in Chronicles, you will need both the and the to uniquely identify a row of data.

DM_MOUD is a data mart table that stores information related to the topic of Medications for Opioid Use Disorder (). This table consolidates patient information from many subject areas including lab values, encounters, vitals, medications, diagnoses, and social history. Only patients that meet specific inclusion criteria have information stored in this table.

The table contains information about coding records (records in the COD master file). A row in this table contains information about each individual contact for coding records. Coding records store information from Clinical Documentation Improvement (CDI) reviews. A single coding record is created for the hospital account, with each contact (or row) containing information from a separate CDI review of the account.

This table holds the no add single items for the Content Metadata (HCM) master file.

The table enables you to report on the diagnoses associated with procedures ordered in clinical system. Since one procedure order may be associated with multiple diagnoses, each row in this table is one procedure - diagnosis relation. We have also included patient and contact identification information for each record. Note that system settings may or may not require that procedures be associated with diagnoses. This table contains only information for those procedures and diagnoses that have been explicitly associated. Check with your clinical system Application Administrator to determine how your organization has this set up.

This table identifies the valid branches within a research study.

This table contains information about specimen events. This includes information about what the event was, where it occurred, and more. This table was originally used to store submitter information. When looking at the SQL for this table you will see some columns still have "submitter" in their name even though this table now holds container information.

This table stores metric compliance information for alerts from the MAR. Each MAR alert has one row in this table. Only alerts with types of wrong order scanned; inactive order scanned; different dose than the ordered dose; short-term cumulative dose; additional dose on a completed, expired, or discontinued medication; off-schedule; and multiple required scans warnings are included. Various alert attributes are stored here to allow reports to show the metrics grouped by these attributes and gather details about individual alerts.

This table stores the historical payer calculated outcomes for quality measures that are received from payers.

This stored procedure builds the table, which contains one record for every inactive Hospital Billing transaction in the system. A transaction is considered inactive if it has been reversed, has been reposted, or is a reversal. In addition to the transaction ID, this table contains the date on which the transaction became inactive. To report on active transactions, left outer join to this table and select records where.TX_ID is null. To report on active transactions as of a certain date, left outer join to this table and select records where.TX_ID is null or.INACTIVE_DATE is greater than the as of date.

This table extracts organization-specific information such as organization ID and name for use with organization filter functionality.

The table contains information about the different non-Epic applications that use Epic-developed APIs to interact with information in the M database. These client applications are uniquely identified by their. This table includes information about the client that is expected to be stable over time, such as whether your organization allows the application to access the M database, and the type of end-user for which the application is intended.

This table contains the product lines for which to calculate and report outcomes for this measure.

Contains any data warehouse fact table groups required for an external client application. These fact table groups will be used to create a set of views in the data warehouse that the application can access.

Stores the history for AP Claim workqueue items.

This table stores LDA information for a patient. A record is created in LDA for insertion of every line, drain, airway, or wound for a patient, as well as entering a trip into a patient's travel history. The no-add information for this LDA is stored in the table.

This table contains information about the diagnoses associated with transactions. Since one transaction may be associated with multiple diagnoses, each row in this table represents one diagnosis and is identified by the transaction ID and line number. The first six diagnosis IDs associated with a transaction are recorded in the table in the columns DX_ through DX_. This table allows you to easily identify transactions with a specific diagnosis code or range of diagnosis codes. The data for this table is extracted using a query.

This table stores the dates set as holidays for a department. This table also indicates whether a given holiday has been applied as unavailable time to provider and resource scheduling templates. If Cadence is installed and configured to set unavailable time using holidays then the data that populates this table is built automatically during Cadence End of Day processing. Otherwise this data can be generated via a batch job using template 81 - Build Holidays Index.

Contains Home Care facility no-add single items information.

This table stores medications received from outside sources.

The table contains data for immunizations ordered through clinical system. May also contain information on immunizations as reported by patient, but not ordered/administered via clinical system; Fields in this table are noadd- single items in database. If an immunization record is edited/changed, that record will be re-extracted and reflect the updated values.

The table contains the specialties associated with each of your providers. A provider can have multiple specialties; therefore, the primary key for this table is a combination of provider ID and line number of the specialty in the provider's record.

This table displays the status of the pathway (active, completed, or discontinued).

This table contains the SmartSet/Protocol/Pathway settings that do not change per contact for each SmartSet, Protocol, Pathway, or Dental Template.

This table contains the list of results that were followed up during this particular encounter, such as a telephone encounter.

The table lists coded hospice diagnoses.

This table contains general information about questionnaire answer records. For example, the questionnaire the answer record is for, the date it was answered, and whether the answer record is closed.

The table contains information about actions taken by users on a query (coding, Clinical Documentation Improvement, or missing doc).

The Care Everywhere ID Details Table stores details about a Care Everywhere ID record including which patient is linked and the various security and configuration settings associated with the record.

This table contains the questions and answers for questionnaire answer records. It also includes audit information such as when the question was answered and by whom.

This table stores the audit trail information for encounter diagnosis edits. In order to report on diagnosis edits, this table can be linked with. This linking can be done using the and columns in this table along with the and columns in the table.

This table extracts the history of comments associated with deselecting recommended child order items.

Administrable Procedure Items in Orders (ORD).

This table contains the communication mode ID of communications sent to a service through the Continued Care and Services Coordination workflow, along with the patient contact serial number (CSN), patient ID, and contact date of the associated encounter. There is one line per communication sent.

This table extracts information from the PLF master file. PLF records represent the different areas that a patient can be in when using the Patient Location application. They can represent well known areas such as rooms and bed, or any location that the user wants to define. PLF records are also used for direction mapping in the Welcome kiosk.

This table contains data for the Discrete Goals (IGO) masterfile that is over-time data.

This table contains hospital account patient contact serial number (CSN) information from the Hospital Accounts Receivable (HAR) master file.

This table contains the extracted information of the Bill Area masterfile (BIL).

Various no-add single virtual items.

This table contains information about communication traces.

No add single table for Identity history database.

The table contains OR management system log audit trail information.

Contains the list of encounter types considered to be face-to-face encounters. In SlicerDicer, a patient who has had a face-to-face encounter with a clinician is considered a patient of that clinician in the My Patients - Encounter Provider criterion.

This table contains detailed claim print record information for claims associated with the hospital liability bucket.

DM_DCSD_CANCER_PROB is a data mart table that stores information related to the topic of cancer for deceased patients. This table consolidates diagnosis information from many subject areas including diagnoses, cancer staging, treatment plans, treatment summaries, and related encounters. Only problems that meet the specific inclusion criteria defined by the Deceased Cancer Population Registry

This table contains the Surgical Staff information for the Surgical Log (ORL).

Each work request can have any number of fill requests attached signifying the dispenses that should be grouped together. This table includes the patient, order and order dat for each fill request attached to the work request. The primary key for this table is and . The column can be linked to the table in order to include general work request information in the report.

Table that stores series assignment related information as well as information on series answer record status.

This table contains information about the providers (SER records) associated with an infection case.

This table stores lot specific QC material information. It does not include the checking information.

This table contains procedure-level details about authorizations. The associated authorization information for the procedure can be found in the table by joining the tables on the columns. Child table contains multiple rows of additional information related to each row in this table. You may join to this table on the columns and. = GROUP_LINE from that table.

DM_WLL_ALL_EXT is a data mart table that stores external information related to the general wellness registry metrics for all patients. Only patients that meet the inclusion criteria for the general wellness registry for all patients have information stored in this table. This table stores the data from the latest clarity extract only.

The table contains the system ID numbers for your procedure modifiers. Each procedure modifier may have multiple IDs; therefore, a line number is used to identify each identification number for a procedure modifier.

The table contains social history data for each history encounter stored in your system. This table has one row per history encounter.

Contains information about balance, par levels, location, pharmacy and the inventory item to which this balance record is linked.

This table contains information from the Cancer Staging Definitions (FCS) record for each kind of cancer to be staged, such as the type of FCS record, a list of fields that should be available for editing, and which SmartLists to use for restricting entry in those fields.

This table contains the National Drug Code (NDC) information.

The OB_HSB_DEL_RP_DTTM table contains membrane rupture date and time information recorded from the OB Delivery Summary. It uses the list of rupture dates and times stored in the patient's delivery record and combines them to create a list of date/time values. If a rupture time was recorded with no corresponding date, it is considered incomplete documentation and the line is thrown out.

The table contains information about the modifiers associated with patient records that will affect the health maintenance topics appropriate for the patient. These might indicate, for example, that a patient has a history of dysplasia, which would necessitate more frequent pap smears for her than for women of her age group.

This table contains the account status data for each account. Account Status is a multiple response item, that is, an account in your system can have more than one status, such as Returned Mail, Payment Plan, or Collections. Therefore, one row in this table contains one line of account status information for an account. Each row is uniquely identified by the Account ID and line number combination.

Configuration table for encounter types to exclude in quality measure calculations in Caboodle.

This table stores Inventory Location (IVL) records.

The table contains information about your employer groups. An employer group is a unit of a corporation or company made up of employees who share the same benefit plan.

This table contains note types that should function as Anesthesia single-copy notes. These note types will allow a single copy of the note to be created and will not be able to be pended or shared.

This table contains the research enrollment statuses that should be considered accrued.

This table contains the medication related to NDC for each contact.

The table stores information to link to the SmartSet Information (SSI) record and contact that were used to create a patient-level SmartSet Information record.

Contains the look back period used by SlicerDicer (in months).

The table contains information about Interface error logs. This includes the interface that the error was logged on, the invalid value associated with the error, the fatality, as well as the error code. Additional information such as translation table and HL7 field and segment can give you specific information about where errors are occuring.

RFL_DISC_SPEC_AUTH contains discipline-specific authorization information used by Home Health.

Hospital Logistics Request Status Audit.

The table stores the Concept Identifier of the concept or SmartData Identifier (SDI) of the SmartData element referenced by mappings as well as the type of mapping associated with each concept-to-entity link. The mapped entities are given in the table.

The table contains a list of risk panels used to determine which members are associated with a member group.

This table contains information from all category items. Use this table to get the name, title, or abbreviation of any category list value given the corresponding INI and for the category list. Shared category lists will have a row for each category value (VALUE_C) from the source INI and , and those rows will be duplicated for each INI and combination that points to the same category list. For example, the category list for I ORD 30 is shared with I OTP 30. Category 999-Medications will appear once in this table for INI='ORD', =30; and will appear once in this table for INI='OTP', =30.

This table contains a list of appointment cancel reasons which indicate that the cancellation was initiated by the provider. For a full mapping of cancel reasons to cancel initiator, see.

This table stores information about which groupers contain procedures that indicate an admission qualifies as an index admission for certain inpatient readmission metrics.

This table contains the order IDs for medications that are connected through override pull linking.

This table contains medication information for no-add single response items.

ORDER_RAD_AUDIT stores information about imaging audit actions logged on procedure records.

This table contains line-level information for the claim generated from this INV record. This information is common to all claims for the INV; use for invoice-specific information or line-level overrides.

This table stores an audit trail of actions taken within patient facing web applications. This includes MyChart, MyChart Bedside, and audits for web services intended for use by patient facing applications. MyChart Bedside events will populate WPR 535 instead of WPR 530 to indicate the type of audit event. The fields in this table track who took the action (typically the patient), what action was taken and when the action was taken.

This table contains audit trail info for changes made on the list of Health Maintenance Modifiers for a patient.

All values associated with a claim are stored in the Claim External Value record. The table holds the ICD procedures that document surgical procedures on inpatient claims.

DM_DECEASED_CANCER_PAT is a data mart table that stores information related to the topic of cancer for deceased patients. This table consolidates patient level information from many subject areas including demographics, lifetime dosing, family history, and oncology-specific care providers. Only patients that meet the specific inclusion criteria defined by the Deceased Cancer Population Registry

This table stores supplemental required exclusion data sources for measures in a value-based program performance period.

This table contains no add single response data for ambulatory pharmacy work requests. Each work request is associated with a set of fill requests. A fill request is a contact on the order record which contains information about the specific dispense of the attached order. The patient, the order, and the order DAT is stored on the order record of the work request, which also links the work request to its associated fill request. This value lives in table.

Contains a list of column (E0C) records from Views and Derived Tables that link to other columns in the data model. Typically this means that the linking column depends on the linked column in order to obtain its data. The linking column may also rely on the linked column to determine its Data Type, Format INI/Item, Extract INI/Item and Description.

This table contains Infection Control surgical site infection surveillance data that tracks patient procedures from the time of the surgery through the surveillance period. These procedures are based on existing surgical logs.

This table contains information about a patient's sexual orientation.

This table contains information about the Diagnosis Related Group (DRG) data stored as part of a Clinical Documentation Improvement (CDI) review. Each contact in this table corresponds to DRG data from one CDI review.

This table contains hospital liability bucket information from the Hospital Liability Buckets (HLB) master file. This table does not include information for pre-allocated HLB records that are not yet in use.

The table contains basic information about the standard result components that can constitute your procedures. For example, the components of a lab panel are usually the tests performed on a single specimen.

This table stores supplemental optional exclusion data sources for measures in a value-based program performance period.

This table stores contact-specific information for a cancer stage (STG) record. Each row in this table corresponds to a single set of edits that were all saved at the same time.

The table contains the system ID numbers for your devices. Each device may have multiple IDs; therefore, a line number is used to identify each identification number for a device.

DM_IBD is a data mart table that stores information related to the topic of inflammatory bowel disease. This table consolidates patient information from many subject areas including lab values, encounters, vitals, medications, diagnoses, and social history. Only patients that meet specific inclusion criteria have their information stored in this table

This table contains billing indicator information from the HAR master file.

This table contains the reasons why a service declined a patient's request for continued care or services.

The table contains information about your communication tracking records. This includes such information as communication type, the date and time the contact was made, and caller details.

The list value database (FCL) stores information about data as defined by external specifications, for example claim adjudication. This table stores information about those list values.

This table contains basic information about the registry configuration, including information about the import specifications used and the type of registry.

This table stores the properties associated with a metadata record.

The recipients of a Coding or a CDI query for a Hospital Account.

This table stores a listing of users and their associated reporting Authorized Departments. This is the list of departments for which a user is authorized to view in reports.

This table holds blood order reason questions.

History of items linked to episodes edited in the episodes activity. This consists of records at one time linked via HSB 2000/2010 which will be primarily visits linked via the episodes module, but will also include links to INP and could include other masterfiles (like TPL) if applications use standard linking code in HSBUTIL2.

This table contains basic information about your facility record. It only contains information from the newest contact.

The table contains information about your verification records. These records include verification information for patients, guarantors, coverages, coverage members, hospital accounts, and encounters.

This table contains procedure records that are used to document sepsis protocol initiation.

The table contains information about referral sources. Referral sources can be physicians who write medical referrals for patients, or they can be marketing sources by which you acquire new patients.

Links to performables (OPE) and chargeables (UCL) for an order.

This table contains the Surgical Staff Times information for the Surgical Log (ORL).

This table contains information regarding the transplant episode. Only episodes whose Episode Type Class (I HBD 130) is 4 - Transplant will be included.

This table contains the location of bleeding and suppuration findings documented during a patient's periodontal exam.

This table contains the category values which correspond to indications for augmentation. This data comes from the Delivery Summary activity.

This table contains the list of all appointment statuses that are considered to be complete for a facility. A status of "Completed" (category value 2) is always considered complete regardless of its inclusion in this table. To restrict results to completed appointments, include only records whose appointment status category value is either 2, or present in.COMPLETE_STATUS_C.

This table contains basic information about the remittance codes that can accompany electronic payments and claim denials.

Hospital Logistics Assignment Status Modifier Audit.

This table stores general information about the stage of a patient's cancer, including clinical and pathologic staging attributes that were determined using methods defined by the American Joint Committee on Cancer ().

This table contains Home Care overtime single items that are stored in the Patient (EPT) master file.

This table stores information about items that were received in an inventory request invoice.

This table store the PCI device deployment event configuration for the Door-to-Balloon metrics.

This table contains information about the providers who participated in the delivery.

Stores the overall review status of each contact of a metadata record.

This table contains order or order template related information for all alerts. Link to to get patient, vendor, and alert type information for specific alert. Link to to get alert history information. Link to specific alert table to get specific alert information for a given alert type.

This table extracts the related multiple response item LQM-460.

This table holds the event data for the BEV master file.

The table contains employer group information that may change over time, such as the sales representative or dependent cut-off ages.

This table contains the indications for a C-Section.

This table contains data related to the Wait List contact type. Each record is based on patient contact serial number.

This table stores denominator data sources for measures in a value-based program performance period.

This table contains Infection Control surgical site infection surveillance data that tracks patient procedures from the time of the surgery through the surveillance period. These procedures are based on procedure abstractions.

This table contains all hospital account related information for the separate service area billing functionality.

This table contains Infection Control surgical site infection surveillance data that tracks readmissions for a patient from the time of the surgery through the surveillance period.

The table contains the list of ID Types in your system.

The table contains data from patients' problem lists in the clinical system. The data in this table reflects the current status of all problems on the patient's problem list. In the clinical system, each problem is marked as active until it becomes (and is marked) Resolved or Deleted. At that point, by default, it will not be displayed in the application. However, any problem ever entered on this list is stored in the database and will exist in this table. Deleted and resolved problems can be viewed in the application by simply marking a checkbox to show them. Note that deleted and resolved problems can be restored by undeleting them (an option in the application). When a deleted problem is restored, its status is changed to active and the deleted date is returned to null.

Information relating to copays collected using the POS or Registration copay forms (not the AR copay form).

The SYS_RSH_RPT_GRP_OVRIDE table contains the display name overrides for the research category and free-text report groupers.

This table contains information about the related Quickform response group stored in the Quickform responses (I LQL 700) item.

The contains the hospital problems for each hospital encounter.

This table contains information about push notification recipient audit trail. To extract data to: 1. In Clinical Administration, open EMR System Definitions and select Decision Support, Pop Management. 2. Go to the Push Notification Clarity Settings screen. 3. In the Types Excluded from Clarity Extracts field, enter the types of push notification you want to exclude from Clarity extraction.

Table that holds information about the questionnaire series (LQW) that does not change with time like series type, series name..etc.

This table contains the Clinica Data Model types retrieved in the CQL named expression.

Configuration for additional order types that count as radiology orders.

This table contains the category values which correspond to indications for cesarean section. This data comes from the Delivery Summary activity.

This registry stores both current and historical information related to the topic of readmissions. This registry consolidates hospital admission information from many subject areas including lab values, vitals, medications, diagnoses, and social history. Only hospital admissions that meet specific inclusion criteria have information stored in this registry. Note: This table does not contain information on the concept of index admissions and subsequent readmissions. See for details on this definition of readmission.

Contains supplier (WHS) level settings used for purchase requests and shipments.

This table stores discrete diagnosis information received from outside sources.

This table contains the history of service line changes for accounts payable claim records.

this table stores the owners list for content metadata records.

This table contains information about a transplant patient's willingness to accept organs from donors meeting various criteria. Each line represents a change in the documentation about the patient's willingness to accept organs from donors meeting various criteria.

This table contains denial information stored in the Denial/Remark/Correspondence records in the Denial/Correspondence (BDC) master file. There can be multiple lines of data for each record. Each line represents one claim/explanations of benefits (EOB) line that was denied.

This table contains Professional Billing visit information stored in the Hospital Accounts Receivable (HAR) master file. It doesn’t include HAR records created for Hospital Billing and Single Billing Office.

This table extracts the Patient Location (PLC) event tracking information into Clarity. PLC records record information about where a patient was at a certain time. They contain information about where the patient is, when they arrived there, how they got there, and who put them there.

This table contains hospital account CPT(R) codes from the Hospital Accounts Receivable (HAR) master file.

This table stores information on questionnaires that have been attached to web based chart system (WMG) messages.

This table contains employer/plan group information that can change over time, such as the benefit plan associated with the group. Note that this is a small subset of the overtime information, and organizations that use Tapestry should use the table instead whenever possible.

This table stores information on question groups.

The table stores the details about the various levels the patient was in, for the surgical log.

The table contains one record for every alert that was created in Hyperspace. Each record is based on the alert ID and contains key information about the alert such as the patient, patient CSN, alert type, and whether it was seen by a user.

The table contains the note text on I HNO 41 or I HNO 40. The text in HNO 40 or 41 is first converted to plain text. The formatting information in RTF note text or note text is removed. The plain text is then broken up into lines of 1950 characters or less. If Chart Sync is enabled, note records with note type 24-Chart Sync Patient Summary Report, 25-Chart Sync Admission Summary Report are excluded from the table. Note records with a note type of 40-Charge Homing Guarantor Inquiry are not included as they may cause extract issues and serve no reporting purpose.

This is the Clarity Table for Continued Care and Services Coordination and Payor Communication audit data.

The table contains information about interface messages. This includes the contact information, transmission data, and user data.

This table contains the list of errors for a referral when assignment to an appointment fails.

The table contains information about your ED disposition mapping setup in the ED Reporting Settings facility configuration (Record EAF 1). This table includes the list of generic dispositions that are mapped to specific ED dispositions.

The table includes a list of vendors with which providers are associated.

The table contains information about the immunization administered. The rows included in this table are items from DXR (Document) masterfile which include information on type of immunization, administration date, administered dose, administration route, administration site, immunization manufacturer, immunization lot number, administered by, visit date, deferral reason, administration notes, administration location, administration status, administered amount, administered unit, contact serial number of the DXR record that owns the immunization instance and a unique reference identifier to identify a specific instance of an immunization.

This table contains information about an immunization administration's health maintenance sequence number. The records included in this table are Problem List (LPL) records that satisfied a Health Maintenance topic for the patient.

This table contains information about authorization records. This includes links to the patient, referral, and coverage/payer.

A data mart table that contains external metrics for patients who have received a lung cancer screening. The Patients with Lung Cancer Screening Registry must be activated to populate these metrics. Only patient encounters that meet the inclusion criteria for the registry have information stored in this table.

This table contains information about push notification logs. We send multiple pushes for a notification if there are multiple recipients and/or a user has multiple devices. Each line in the table represents an attempt to send a notification to a single user on a single device. For example, there will be three lines with the same when the notification is sent to three recipients. To extract data to: 1. In Clinical Administration, open EMR System Definitions and select Decision Support, Pop Management. 2. Go to the Push Notification Clarity Settings screen. 3. In the Types Excluded from Clarity Extracts field, enter the types of push notification you want to exclude from Clarity extraction.

This table contains details regarding the resolution of claim codes for AP claims.

This table stores discrete information about family members with a noted medical history. The information stored in this table was received from outside sources.

Hospital Logistics Assignment Information Audit.

This table contains coverage information generated and owned by AP Claims adjudication. If your organization uses a separate AP Claims instance in an Interconnect setting, then this table should be extracted from the AP Claims instance instead of the clinical instance.

This table contains information about your bereaved records. These include name, address, phone numbers, and associated patients. The records included in this table are Bereavement Contact (LHB) records.

This table extracts the history of reasons associated with deselecting recommended child order items.

This table holds the quantity of each coded CPT contributing to coding-only and combined service lines. The quantity in this table is associated with the Coding Info line number in CODE_INT_COD_INF_LN. Values are only available for coding-only and combined lines. Rows will not be extracted for charge-only lines.

This table contains a snapshot of information about an individual authorization request as of a point in time.

This table contains information about procedure categories. Procedure categories are used to group together related procedures, such as all GI orderable procedures.

THE tables serves as a link between the CLARITY_EPP and table. It contains the IDs of the benefit plans and the service areas in which those plans are valid.

Extended information about a gene such as its full name and whether it is withdrawn (and if so, when).

This table contains patient addresses on requisitions.

This table contains the users, providers, and messages related to procedure verbal orders and cosign orders.

Configuration table for referral types to exclude in quality measure calculations in Caboodle.

This table stores the default attributed provider, location and provider group records for value-based program configuration. When outcomes are calculated for a value-based program, a provider, location and provider group are attributed to each outcome based on configuration in each value-based program. If no applicable record is found based on that configuration, then the record from this table is used.

This table contains high-level information about user records from the User master file.

This table holds lab components for hemoglobin lab values.

This table stores an order's first and last scheduled date and time, along with the type of review notice for the expire items (i.e. let expire or review).

This table stores the orders associated with a flowsheet row in a multiple-response format for easier reporting.

This table stores information about items in the LGL masterfile that are of no-add type and that are single response.

The table contains the departments in which each of your providers will be scheduled. A provider can be scheduled in multiple departments; therefore, the primary key for this table is a combination of provider ID and line number of the department in the provider's record.

This table contains information about SlicerDicer filters.

This table contains the flowsheet rows and groups used to document pain assessments as defined on the Pain Reassessment screen in Core Measures settings.

The table contains information about your patient genomic indicator records. These include disease-related and drug-related genomic indicators linked to patients.

This table contains the administration routes that are equivalent to intravenous as defined on the Pain Reassessment Reporting screen in System Definitions.

This table contains Medical National Drug Code (NDC) information. Since one transaction may be associated with multiple NDC codes, each row in this table represents one NDC code and is identified by the transaction ID and line number. The data for this table is extracted using a query.

Stores the authorized service areas and business segments for a coverage. Consider using F_COVERAGE_ORG_FILTER_SA instead of this table because it contains all coverages in the systems, whereas this table only contains managed care coverages if business segmentation is on.

This table extracts the related multiple response item VBP-511.

This table contains the enrollment status change of a participant in a research study and the effective date of the status change.

The table contains information about your service areas. The records included in this table are facility profile records that are designated as facility, service area or payor business segment. That is, Type of Location, has a value of 1, 4 or 11.

This table contains information about any episiotomies performed to aid the delivery for this pregnancy.

This table contains Infection Control surgical site infection surveillance data that tracks patient procedures from the time of the surgery through the surveillance period. These procedures are based on billing data.

This table contains information about patient-assigned tasks in the care plan.

The table stores general settings for laboratory test records.

This table contains information about professional billing transactions.

This table stores information pertaining to purchase contract records.

This table contains the lung allocation score information for a transplant episode.

Table for general organ information about transplanted and native organs.

This table contains information about extensible workqueues. Each row represents one workqueue in the WQF masterfile.

This table contains result component comments for orders that are populated by the Incoming Results Interface. These result component comments are not populated through Enter/Edit Results. The data in this table is populated only if the result component comments normally stored in the Component Comment (I ORD 2070) field is too long to be stored in that field.

Stores claim-level diagnosis information sent on Resolute Professional Billing claims. Diagnosis information is coming from the INV 350 related group. The Group 100 column corresponds to claims that were sent.

This table stores tracked recommendation information and Blood result dispense status for orders-related results. This table can also store Dermatology Skin Findings.

This table contains Logistics subtypes associated with the Logistics Region or Logistics Sector.

This table contains linkages between claim service lines and diagnoses for CMS claims.

This table stores reporting specific attributes associated with a department or service location.

The table contains a list of benefit plans used to determine which members are associated with a member group.

This table contains the Delay information for the Surgical Log (ORL).

The table contains information about episodes (pregnancy and delivery record HSB records) linked to a patient's OB history.

Data stored during the process of sending order details to infusion pumps.

This table contains data on the last instant of data being filed to a single column template in Doc Flowsheets.

This table contains the category values which correspond to a delivery method of vaginal forceps delivery.

This table contains the appropriateness score for an imaging procedure if using third party decision support software in conjunction with Epic.

This table contains basic information from surveillance abstractions.

Diagnosis terms can map to multiple codes in a code set. This table discretely lists the mapped codes for term-type diagnoses. Code-type diagnoses will also have a row in this table if the code is in ICD-10-CM.

This table contains the extracted information of the Financial Subdivision.

No-add items for dental orders.

This table contains each coverage subscriber's street address.

The table contains information about your interface table records.

This table stores the antibiotic susceptibility interpretation for a given pathogen on the Pathogen Selection Form in the related multiple response item RDI-40403.

This table stores basic information about metric definitions.

This table contains information on queries sent during coding (including documentation queries) and clinical documentation improvement (CDI) reviews.

The table contains the list of simple or complex variants contained within a complex variant.

This table stores information about imaging addenda.

This table holds the list of checks that the claim was a part of, before the checks were voided. It is possible for a check to appear multiple times in this table for the same claim if it was split across multiple responsibility classes.

The table stores the details about the Pre-op acuity levels documented for a patient in a surgical log.

This table contains the Delay Reasons for the Surgical Log (ORL).

This table contains Home Health/Hospice episode information. It contains the noadd single items for the Episode. These items are entered by a user as part of the Intake encounter.

Table has information for items in related group 20800.

This table contains the previous values from edited flowsheet records.

Compiled roster tracking eligibility periods for each roster ID.

The EXT_SYS_PAT_IDENT_BUNDLE table contains information about external system patient identifier bundles.

This table contains multiple response information for modifiers associated with A/R (ETR) transactions.

This table contains the treatment days in a treatment plan record or the steps in a pathway record.

This table contains all of the contact-specific information for Identity events that have occurred in the system. This includes, among other things, potential duplicate patient identification, patient merges and unmerges, and contact moves.

The table contains high-level information from all the medications for use in your facility.

The table contains aging information for transactions, pulled from ETR 900. It contains one row per balance or coverage change for every transaction. For charges and debit adjustments, this table contains the historical outstanding patient and insurance amounts. For payments and credit adjustments, this table contains the historical undistributed amounts. The and columns indicate the range in which a given snapshot entry for a transaction is valid. The most recent snapshot entry for a transaction will have a default of 12/31/2099. This table can be used to report on transactions at any given point in time by selecting all records where <= report date <= SNAP_END_DATE. The amounts reflected will be positive in the case of charges (debits) and also positive in the case of payments and credit adjustments. For credit transactions, the values in the amount columns will need to be negated.

This table contains the Home Health Contact Type noadd single items. These items do not change when a new contact is created for the Home Health Contact Type record.

This table contains information for prescribing provider identifiers.

This table contains data on discrete frequency (EFQ) records.

This table stores treatment day or pathway step information that is contact-independent, such as the treatment day/pathway step status, the reason for canceling or deferring the day/step, the ID of the treatment plan (TPL) record that contains this treatment day or the ID of the pathway (TPL) record that contains this step, etc.

The table contains the system ID numbers for the LRR masterfile. Each record may have multiple IDs; therefore, a line number is used to identify each identification number for each record.

The table contains information about the carriers who sponsor your networks and benefit plans.

This table contains timeliness information for authorization request milestones.

This table contains most of the information about the lot number records in the Lot Number (LOT) master file.

Transaction Information that is used moderately often.

The table contains information about the compound used in pharmacy preparation of the dispenses of an order.

Stores codes and code sets specified for ICD diagnosis groupers.

This table contains the liver score history for a transplant episode. After 6/28/2022 exceptions will not be included due to changes in the liver allocation policy.

Encounters received from external documents.

This table stores the SQL queries used on Caboodle to evaluate the named expressions contained in the CQL library.

Stores overtime definition for sensitivity records. Currently, only claims analytics workflow records (CL_SENSITIVITY.SENSITIVITY_REC_TYPE_C = 1) support overtime configuration. Records of other types will still appear in this table, but most values will be .

This table contains the category values which indicate that the delivery method was a vaginal vacuum delivery.

The OR_LOG_PANEL_TIME1 table contains OR management system log panel timing information for the first panel.

This table contains Infection Control surgical site infection surveillance data that tracks patient lab results from the time of the surgery through the surveillance period.

All values associated with a claim are stored in the Claim External Value record. The table holds the diagnoses that document any accidents or other external causes for the patient's injury.

Contains a list of column (E0C) records that exist in the Clarity Compass, along with their basic information. This includes name, data type, as well as other pertinent information.

This table contains transactional cost information.

This table contains information about patient eCheck-In sessions, with each row representing a unique session.

This table contains claim line information for claims associated with the hospital account/liability bucket. For uniform medical billing (UB) claims, this table contains pre-processing charge information, which is used in the creation of UB claim lines. Post-processing claim line data for UB claims is stored in the table. For CMS claims, this table contains the post-processing claim line data.

This table contains DRG Types that are used to categorize DRGs by code set and version. A DRG Type (DRG_TYPE_ID) is an Identity ID Type for the DRG master file. The DRG Type is determined by combining the DRG code set (e.g. MS-DRG) and the DRG version or effective date (e.g. Version 28). For example, a DRG Type might be "MS-DRG Version 28." This table can be used by report writers to map a given DRG type with its logical code set and version for a given set of dates.

This table contains a listing of users and the locations for which they are authorized to view reports.

This table stores the related multiple values of the contact-level kickout actions stored in I WEL 218.

The table contains information about the changes made over time to allergies noted in the patients' clinical system records.

The table contains information about prospective patient records. It contains the RQG ID, RQG type, the linked patient ID, and if the link is confirmed.

Table of secondary failure reasons for the native organ.

This table contains information about the current event records.

This table contains information about the completion of each task type associated with a Procedure Pass.

This table contains information about the providers who have been documented as being responsible on an anesthesia record, including their role and begin and end times.

The Care Management configuration table.

This table extracts the comma-delimited list of modifiers that is stored in the Line Modifier (I BDC 291) item for line-level denials. This table will contain one row for each modifier that exists in the list.

Details about the organization. Includes external name, phone/e-mail, hours of operation, HSI, URL.

The table contains each contact for questionnaire questions.

Each row represents the local time a referral audit action took place. Audit actions include: item changes, non-item changes, linked record changes, and entering or exiting specific code paths (bookends).

This table stores discrete specimen information received from outside sources.

Miscellaneous configuration settings for managed care and health plan administration. These settings primarily apply to Tapestry for AP Claims, Enrollment and Eligibility, Premium Billing, and Capitation.

This table stores the emergent PCI procedure configuration information for the Door-to-Balloon metrics.

The table holds the instant that the export status was last changed.

This table contains information about the workflow contexts for attributed provider groups.

This table stores information about Clinical Documentation Improvement (CDI) reviews.

This table condenses heart status history to a start date and expiration date, and a pointer to the line in where the details can be found.

Keeps an audit trail of request status changes for a inventory request.

This is the primary table for Logical Observation Identifiers Names and Codes (®) information.

This table includes links to DCS records where images taken during dispense preparation are stored.

This contains the decisions that were made by potential accepting providers about whether to accept or decline a Transfer Center request.

List of all non-linked metrics applicable to a registry. This includes standard, custom, and inherited.

This table contains information about certain types of planned orders, including orders from treatment days in treatment plans and therapy plans, and orders from clinical pathways steps.

This table contains patient encounter contact serial numbers (CSN) selected in Welcome sessions.

This table contains list of all enrollment statuses considered to be "active".

This table contains information that is useful for linking records (patient, department, etc.) to their appropriate events.

This table contains information related to interface kind records.

All values associated with a claim are stored in the Claim External Value record. The table holds the diagnoses that document the patient's reason for an outpatient visit.

The tables contains Cosmos-specific metadata about how data from external organizations is processed.

The table enables you to report on Medication Problem List information.

Message tasks are discrete activities that can be attached to a message sent from an system user to a patient. The task contains an action item for the patient to complete, such as filling out a questionnaire or scheduling an appointment. This table stores data regarding tasks that have been attached to Patient Access Message (WMG) records, such as what type of a task it was and when the task was completed by a patient.

Table storing information on questionnaire answer ids.

For use with anesthesia, stores all patient encounters (procedure cases, appointments) that are linked to by (fall under the sedation of) the anesthesia episode.

Contains information from the Collection Agencies (KCA) master file.

This table contains codes in external vocabularies that represent an allergen record.

The table contains information for result type records.

The table contains the list of identifiers that are used by external systems to denote patients.

The table contains a list of lines of business used to determine which members are associated with a member group.

This table contains information about the most recent screening program assessment data. This includes the program type, as well as the assessment kind, location, and value. The records in this table are Orders (ORD) records that are exams within a screening program.

The history tracks changes made to the case episode for auditing purposes.

This table contains AP Claim processing milestones and associated dates.

This table contains claim print record information for claims associated with a given hospital account or liability bucket.

This table contains information about a waitlisted transplant patient's lung CAS subscore over time, and the dates on which those scores were recorded.

The extensible report grouper values listed in research studies.

This table contains common names of lactate lab result components.

Contains information related to order blocks for SmartGroup and protocol records.

The table contains MPI ID information for the Reason for Visit (HRV) masterfile. Each record may have multiple IDs; therefore, a line number is used to identify each identification number for each record.

The table contains program information about quality/objective measures that may change over time.

The table contains information about costs and charges associated with the procedural log.

DM_WOUNDS is a data mart that stores information from the Wounds registry. This table consolidates information such as wound outcome, healing percentages, and encounter information. Only patient encounters that meet the inclusion criteria for the registry have information stored in this table. You can verify the current configuration by looking at the registry in Hyperspace (via the Registry Editor).

This table contains NDC price information.

The table records the comments entered via SmartForms.

This table contains information about individual patient insights feedback shared via Payer Platform.

This table stores the element names for a CQL expression within a measure.

This table stores the NDCs associated with inventory item records.

This table contains virtual items for Procedure Pass records.

The table is the master table for risk panel information.

Each row represents a line of auditing information about actions that have occurred on an outreach contact.

The table contains the Primary Location information for your patients over time.

The table is the master table for ADT event history information. This table contains several foreign keys for other ADT tables.

This table stores the concepts and business logic for the pathogens and procedures.

The table contains the Explanation of Benefits information given a transaction ID. It contains data that is not multiple response given a transaction ID.

This table contains the libraries for the dependent expressions for the CQL named expression.

This table contains the single billing office (SBO) balances on the hospital account (HAR). The information is only populated in Enterprise SBO mode. SBO balances are the combined Hospital Billing and Professional Billing transaction balances on each HAR.

This table contains the value sets to filter Clinica Data Model types retrieved in the CQL named expression.

For a given component this holds all the pointers to the table that stores the multi line data.

This table stores the history of professional copay collection.

Stores the mammography recommendations linked to an order.

This table contains basic information about your labs. These are LDF records where the record type (item LDF 27) is set to department (6). It only contains information from the newest contact.

This table contains previous value lists for a Concept Value (HLV) record.

This table stores performance periods for value-based programs.

This table contains information about responsibility classes.

This table stores the link between encounter ID and the associated log or case ID.

This table extracts the service areas that comprise a particular organization. This is used in organization filter functionality.

This table contains the category values which correspond to indications for induction. This data comes from the Delivery Summary activity.

This table stores discrete results received from outside sources.

Contains information on electronically made payments.

This table contains the pharmacological sub class.

This table contains the contact specific settings for each SmartSet or Protocol.

This table contains the list of patient classes that the system considers to mean that the patient is an observation patient.

This table contains basic information about the fee schedules billing system uses to adjudicate the price of a charge and manage care system AP Claims and Referrals used to price procedures based on the composition of the vendor-network contracts.

This table contains the list of teeth associated with a dental procedure.

This table stores information about patient treatment teams such as relationship, specialty, department, and start/end time. Each row represents a member of a patient's treatment team.

The table contains basic information about diagnoses.

Child messages related to a given SMS message.

The table extracts the reporting interpretations for ADT events. This table contains a foreign key to the table for linking to other ADT tables.

This table stores definitions and settings for value-based programs or contracts.

This table contains basic invoice information. Each column in this table is from the INV 100 related group, and each line in the table corresponds to a claim that was sent for this invoice (INV) record.

The table contains the code mapping information (effective dates, map type) for the diagnosis. This table stores the discrete mapped codes. This table stores information on term-to-code mapping as well as code-to-code mapping.

This table stores supplemental numerator data sources for measures in a value-based program performance period.

Stores the level of care values that are allowed for patients being roomed in a particular department.

This table stores required exclusion data sources for measures in a value-based program performance period.

This table contains the history of edits for dental procedure records.

This table stores the initial ED interpretation for a procedure.

This table contains each patient's permanent address (I EPT 50). The primary key for this table is the combination of and . Each different value represents a different patient, and each value represents a different line of that patient's address.

This table stores information on questionnaire answers that have been attached to web based chart system (WMG) messages. When a patient fills out a message with an attached questionnaire, the resulting message back to the provider will have Questionnaire Answer (HQA) records attached. This table shows those HQA records.

This table contains all of the database INI's and Items that exist in the production system and provides some information on each one. Some of this information includes: item data type, reponse type and add type. It also includes KB-SQL information for the item and the release ranges for any category lists.

This table stores the street address for the patient's temporary address.

This table extracts the related multiple response item AIF-2020.

This table lists provider credentials along with their effective dates. The license that this table refers to is for display purposes only. It will be displayed after the provider's name in areas where credentials are shown.

This table holds information about National Healthcare Safety Network () definition records. The records included in this table are Regulatory Group records that are designated as Location or Facility records.

This table stores information on anchor event option(s) a questionnaire series is related to.

The table contains the category values of the reactions associated with a given allergy. There may be multiple reactions associated with a single allergy. In this case, there will be multiple records in this table with the same, but with different values.

This table contains medications' information.

This table stores episode information for Compass Rose episodes.

The table contains information about the pharmacy preparation of the dispenses of an order.

The table contains OR management system pick list supply list.

This table contains information on allergens.

New table for the Hospital Accounts Receivable (HAR) to specify what assessed code and reimbursement amount is versus the charge-based code and reimbursement amount.

The table stores the patient instructions for a prescription as entered by the user. The table should be used in conjunction with the table which contains related medication, patient, and contact identification information you can report on.

This table stores purchase contract specific information.

The table holds information about the cleaning protocols required by cleaning requests.

The table contains information about registration history events stored in RHX records.

Table of the surgical logs for the transplant operation.

Main variant result table.

This table contains the web service ID, score, and medication or procedure ID of the BPA web service.

The table contains implant information.

This table contains the information related to this flowsheet row or group that will clarify its use.

This table contains basic information for charge mapping table.

Contains Home Health noadd single items in the Patient (EPT) master file.

Stores information on CQL Measure Configuration programming point parameter (E3P) records.

This table contains the name and ID of an interface specification (AIP) record. An interface specification is an individual definition of an interface.

This table extracts the Patient Location (PLC) update event information that corresponds to ADT events into Clarity.

This table contains basic information about patient infections.

Cost data for charges.

This table contains the CQL library versions used by Retrieves.

This table contains surgical history information.

This table stores PB Denial/Correspondence (BDC) denial records and the charge transactions that were denied by that denial record.

Stores processing codes (NPD records also known as claim codes or EOB codes) that are designated as system worked, which means the code should be resolved by the system or some other process and not a user.

This table contains the modality data related to the performing imaging order.

This table contains information about the location (department, room, and bed) associated with an Infection Control abstraction.

Prospective Patient Segmentation Information.

This table stores numerator data sources for measures in a value-based program performance period.

This table contains the service areas in a facility to which a user is restricted.

This table contains the first and last date a claim or statement was sent out for a transaction, if any.

This table contains the items for dental teeth records.

For an owning business segment and a service area or business segment () to share claims with, this table defines which claims analytics sensitivities (AP_CLAIM_ANALYTICS_SENS) may be shared with the .

This table contains the calculated Panel Reactive Antibodies (PRA) data for a transplant episode.

This table contains basic information from procedure abstractions.

This table contains data on smartsets and smartgroups that orders originated from.

Hospital Logistics Requests Information.

The table contains information that tracks the current values for the Requisition Grouper (RQG) master file.

The table contains information about log procedure codes.

Diagnosis terms can map to multiple codes in a code set. This table discretely lists the mapped codes for term-type diagnoses. Code-type diagnoses will also have a row in this table if the code is in ICD-9-CM.

This table contains Provider Attribution configuration for Value-Based Programs.

The table is the primary table for storing non-contact specific information related to questionnaire questions.

This table contains information about the how membranes ruptured for this pregnancy.

This table will extract invoice level authorization information.

Information about abnormal resulting instants and associated critical value calls. Only populated for records with status 6-Preliminary, 9-Verified, or 20-Corrected.

This table contains the items for dental procedure records.

This table contains a list of Coordinated Care Management episode case types. Case types refer to case management programs.

This table holds the information for a blood unit associated with an order. The data includes the discrete information for the blood unit (including identifiers) as well as the scanning compliance for the discrete information.

This table contains the base class mappings for the facility hospital profile (HSD 1). Including only the facility profile will prevent duplicate mapping.

Basic information for a refund session.

Clarity table for extracting supported order types for this pharmacy.

This table contains generic information related to a patient's inpatient stay, including data on patient education, notes, and other topics.

This table contains the No-add, single-response items from the Sector (SEC) master file.

This table extracts the related multiple-response Heart Status Reasons (I HSB 30419) item.

Table of payors attached to denial/correspondence records. Each denial/correspondence can be associated with multiple payors.

Contains the related configuration settings for SlicerDicer. Currently this includes a list of SlicerDicer filter records and flowsheet rows used by those filters.

This table stores the history items for status changes of patient tasks within a care plan.

This table holds basic identification and processing information for the claim value record.

This is sub container information for Anatomic Pathology specimens.

Contributory reasons for organ failure, as determined by .

DM_PREGNANCY is a data mart table that stores registry metrics related to pregnancies.

The table is the master table for questionnaire forms.

The table contains one row for each patient-level SmartSet Information contact in the system. These rows contain fields that may be updated for each contact such as contact date, contact owner, and contact type. This table also stores details on care plan goals and interventions and task templates associated with SmartSet Information records.

This table stores information about the reporting contexts for the department.

The table records the changes made to episode summary blocks over time.

The table contains information about compiled results susceptibility.

This table contains information about order template records.

This table contains order set records that are used to document sepsis protocol initiation.

This table includes the basic data for the invoice (INV) record. It contains one row for each used INV record (excluding unused pre-allocated invoices). Note that a row in this table can correspond to multiple claims sent.

Hospital Logistics Assignment Escalation Audit.

The table contains the alternate IDs for your employer groups.

The table contains information pertaining to SmartData elements and concepts. SmartData elements are discrete data elements that can have data stored against them. Concepts are used as reference terminology, but should not be used for data storage. Each concept and element has a unique identifier (CUI), which is used as the primary key for the table.

This table reflects the data in the Hospital Beds (BED) master file.

This table extracts the related multiple response item VBP-425.

Stores the captions of the items that filed the concept.

Interface laboratory general information.

This table contains the Hospital Locations belonging to this Logistics Region or Sector.

This table contains coverage level primary location and PCP information.

This table stores information about which groupers contain procedures that indicate whether an admission qualifies as an index admission for certain inpatient metrics.

Extract table for Identity items in the Payor master file.

This table stores appointments scheduled for a recommendation.

Data sources that define the member group.

This table contains the hospital account types for each hospital account.

All values associated with a claim are stored in the Claim External Value record. The table holds the diagnoses for the claim.

Information regarding the recipient of the In Basket Message.

Contains general transaction information.

This table contains data about providers attributed to patients for My Panel Metrics.

This table holds the no-add, single-response items from the Bed Events (BEV) master file.

The table contains a list of commands that have been run against the message.

Stores summary information about processing codes (also known as claim codes, explanation of benefits codes, or EOB codes).

This table contains growth chart fileset records from your system.

This table contains the Service Areas belonging to this Logistics Region or Sector.

The table contains information from the line of business master file.

Linked communication record for referral audit action.

This table contains information about any methods used to induce delivery for this pregnancy.

The contains coverage auth/cert information for referrals.

This table extracts the related multiple-response Lung Allocation Score (LAS) Exceptions (I HSB 30430) item.

This table maps a link from the table via to the Invoice tables via.

This table contains high-level information on preference lists.

This table contains the noadd single items (name, ID, record state…) for a given event template.

This table cotains the enrollment information for a care plan.

This table contains Welcome session data.

This table holds DRG contract information for each ID type associated with a DRG.

This table contains the basic no-add single items of Care plan template (LCE) records like record name, status, type, display name, etc.

Each row represents the UTC time a referral audit action took place. Audit actions include: item changes, non-item changes, linked record changes, and entering or exiting specific code paths (bookends).

This table contains medications that have been attached to a medication assistance program tracker. Medications attached to a medication program tracker indicate that the medication is covered by the program.

This table contains the category values which correspond to a cesarean section delivery.

This table stores discrete reason for visit information received from outside sources.

Primary table for result component information.

This table stores information about which groupers contain procedures that always exclude admissions as index admissions from certain metrics.

This table contains filing information of the anchor event linked to the task.

This table contains the external provider information.

Stores information about AP Claim workqueue items. Each time an AP Claim enters a workqueue, it will have a row in this table.

This table holds documentation time window configuration for blood transfusion flowsheet documentation.

This table lists the remark codes associated with a Denial/Correspondence (BDC) record.

This table stores information related to the status change history for Transfer Center requests.

This table stores carbapenemases found in an LabID sample.

The table contains the system ID numbers for your departments. Each department may have multiple IDs; therefore, a line number is used to identify each identification number for a department.

Stores the supported measurement period patterns for measures.

This table stores tech complete information for imaging procedures.

This table contains information about edits that occurred on pending event records.

Table for overtime single items.

This table includes Identity ID information for the Episode (HSB) master file.

Generic table that contains every hospital account record regardless of its type. It also contains the patient record that is associated with the hospital account.

This table contains information about feedback shared via Payer Platform.

The cycle information for the treatment plan.

This table contains note types that should function as anesthesia multiple-copy notes. These note types will work like standard Progress notes except they will be stored to the Anesthesia contact.

The table stores information to link to the order group record and contact that were used to create a regimen record.

The table contains information about case timing events associated with a procedural case that has been performed.

The table contains each contact for questionnaire forms.

This table extracts the related multiple response item LSD-45020.

The OR_LOG_PANEL_TIME4 table contains OR management system log panel timing information for the fourth panel.

This table extracts data about hospice benefit periods.

Stores a list of concept values associated with this step of the Care Path. This ties in with the concept stored in I LGL 13194 to represent a complete concept value associated with the step.

Data mart to track patient membership of EGS registry

This table displays the Contact Serial Numbers (CSNs) for linked contacts.

This table contains System Definition settings for Phoenix application.

The table contains the place of service information in the vendor database.

This table contains information about the attributed provider group to which the provider belongs for a given date range.

The table contains information about quality measure search and template records.

This table contains information for service provider identifiers

This table stores carbapenemase tests performed for an LabID sample.

This table contains the RxNorm code for the medications.

The table includes the office addresses for providers.

Protocol records for Anatomic Pathology.

Stores the pathology codes and malignancy types attached to a pathology result on an order.

The OR_LOG_PANEL_TIME3 table contains OR management system log panel timing information for the third panel.

Contains location and classification details for furcation findings.

This table contains the noadd related item information for the event template.

Contains external provider IDs used to link provider information to an event provider.

This table contains information related to Interface error definitions. An error definition is the abstract enumeration of errors that can be logged by your interfaces. This table contains the name and ID of an error. Logged errors are found in.

This table contains master locations which are contained within an aggregate location.

The specimen container ID for specimens with multiple containers.

This table holds the combined service lines created by code integration.

An audit trail for the status changes the In Basket Message has undergone.

This table contains unique IDs of buckets that were replaced by the current bucket.

Contains a list of column (E0C) records that have an associated Registry Metric (CER) and the associated metric ID.

Contains information about Healthy Planet Care Plan templates.

This table contains multiple response information for modifiers associated with Hospital Permanent Transactions (HTR) transactions.

The update information for the treatment plan.

This table contains information about microbiology culture results.

Authorized service areas and business segments for the claim.

Stores performance period tuple list CQL parameters and their values.

The table contains billing cost center information.

Rosters that define the patient base for this program.

This table contains the Departments belonging to this Logistics Region or Sector.

This table contains the list of LDA records representing wounds that are associated with an order.

This table extracts the related multiple-response Intestine Status Reasons History (I HSB 30523) item.

Lab Anatomic Pathology case specimen descriptions.

retransplant diagnosis information.

This table contains information for the HB and PB Guarantor Payment Score Items.

Denial records associated with this payment for evaluating denial rate metrics.

Historical information for Care Path episode.

The table contains the system ID numbers for your facilities. Each facility may have multiple IDs; therefore, a line number is used to identify each identification number for a facility.

The table stores the details about the Phase II acuity levels documented for a patient in a surgical log.

This table stores general information about inventory request invoices.

This table stores the related multiple values of the contact-level kickouts stored in I WEL 215.

Stores the orders linked to a recommendation.

This table holds the hospital areas included in a sector.

Configuration table for medication list statuses that count as medications reviewed in quality measure calculations in Caboodle.

This table includes status items that indicate if a transaction is active and if is the most recent active transaction.

This table stores claim level coverage related information.

The table contains information on UB revenue codes.

Matching History Transaction Related Items. A line is added to this related group whenever two transactions are matched together.

Hospital Logistics Request Status Modifier Audit.

NOADD_SINGLE Clarity table for LVV.

This table contains screening program information from your procedure category records.

Externally received insurance information.

This table contains the simple generic name.

The list of surfaces associated with this dental order.

The table contains historical, non-primary names for third-party directory (TDD) records. These records represent individuals only. There will be one row per contact per secondary name per TDD record.

The table contains data from medical history contacts entered in clinical system patient encounters. Since one patient encounter may contain multiple medical history contacts, each contact is uniquely identified by a combination of the patient encounter serial number and a line number.

Contains flags needed to identify orders that meet specific criteria for genomics usage.

This table contains payment classification category, weight, and price information.

Table for transplant protocols for classifying the patient.

The table contains information about your applications like application ID, name, etc. The records in this table are from the E2G masterfile.

This table contains information about any lacerations occurring during the labor and delivery for this pregnancy.

Contains the compiled list of records for a grouper.

This table contains the history of coding status changes for each account coded.

This table contains rows for tracking surgical log complication elements.

The table contains OR management system OR information.

This table is used to extract ingredient medication information for mixture orders.

Actions which the user has taken upon alerts.

The table contains responses for questionnaire questions.

This table contains information about the physician who finalized a study and when it was finalized.

The table contains information about your ED disposition mapping setup in the ED Reporting Settings facility configuration (Record EAF 1). This table stores the multi-related list of ED dispositions that map to a single generic disposition.

This table contains one row for each line of the billing address of a guarantor account.

This table stores reading physician information for imaging procedures.

This table displays data for I LQM 374, which stores the required data sources in a measure definition.

This table lists the contact serial numbers (CSNs) of the encounters where a given episode task was completed.

This table displays high-level information for device (DEV) records.

This table contains the linked child transport request records (TNP) associated with multiple transporter assignment.

Contains a list of column IDs for each table that have been identified as the primary key columns for those tables.

Contains the scheduled times for procedure orders.

This table contains data about groupers of category values.

The table contains overtime information from the benefit plan master file.

This table extracts data from the user history of a MyChart user record as it relates to scheduling through MyChart. The values stored in a delimited format in Chronicles are expanded into discrete values for easier reporting.

The table contains information about workspace records used by Hyperspace.

This table contains the SQL code found in the footer of each Clarity table's query.

This table stores the flowsheet rows that are used to record date of death as defined on the General Reporting Definitions screen in system settings.

The table contains information associated with dental visit records.

The table contains OR management system log procedures.

Stores codes and code sets specified for ICD procedure groupers.

Balance update audit trail. Stores balance updates.

The table enables you to report on attributes for each order. Currently, you could use value 1 to get all order that pyxis override.

This table contains information about the Home Health credentials mapping items, EAF 27880 and 27881. They map the networked category list SER-6001 to the list of standard reporting disciplines.

This table displays general information about the Task Templates (LTT) record.

Stores general system settings.

This table contains the post-op diagnosis codes for the surgical log (ORL) record.

The table contains the system ID numbers for your diagnoses. Each diagnosis may have multiple IDs; therefore, a line number is used to identify each identification number for a diagnosis.

Keeps an audit trail of shipment status changes for a inventory request.

This table contains data related to concepts. The data in this table is populated by the import.

This table contains the line IDs (ORM) for the Delay Information of the Surgical Log (ORL).

This table stores the patient-facing areas of research for a research study.

Table to store the audit log information for questionnaire series answer records. The audit log contains data such as the last update instant, date, action, questionnaire ID, User (EMP) ID, Patient Access Account (WPR) ID and reason why tickler notification was not queued.

The SmartData element's description.

The table contains OR management system log diagnosis codes.

Basic method information.

This table stores information about items that were sent in an inventory request invoice.

The table contains OR management system surgical services.

This table contains the pre-op diagnosis codes for the surgical log (ORL) record.

This table contains cost information for PB visits.

This table holds the history of escalation reasons for the BEV master file.

Stores CQL parameters and their values on CQL measure records.

This table contains hospital account transaction diagnoses from the Hospital Permanent Transactions (HTR) master file.

This table contains the SmartGroup settings that do not change per contact for each SmartGroup.

Tracking info for orders coming from a preference list or order template. For Beacon, the column is used, which is the unique ID of the order template in the patient's treatment plan used to create the order.

The table contains inventory item records.

The table allows you to report on department services information from system's ADT application.

This table returns the authorized business segment associated with a payor record.

This contains a list of languages and their properties, both spoken and written.

Table for contact level additional information such as barcode scans.

Settings for steps in a Care Path.

This table maps discharge dispositions used for reporting to base ADT discharge dispositions.

This table stores referral history columns that are shared between audit actions that happened during the same workflow.

This table stores information about items ordered in an inventory request.

Requisition grouper patient race information.

Configuration table for referral statuses to include in quality measure calculations in Caboodle.

This table holds information from the Procedure Group (EPG) master file.

This table contains the coverages used for prescription fills. A given fill can have multiple coverages associated with it. Other clinical information about the fill is in table.

This table contains a list of all of the variant records associated with the result for this order.

This table contains the users, providers, and messages related to medication verbal orders and cosign orders.

Stores a list of flags placed on a task.

This table stores links between appointment requests and appointments scheduled from them.

This table contains basic no-add information about medical conditions.

This table contains basic information for records in the Reason for Visit (HRV) master file.

This table contains information on master person index information for an allergen.

The table identifies study coordinators for a patient's enrollment in a research study.

This table contains information regarding Continued Care and Services Coordination, where each row represents a service considered for the patient's care. All services populated in a Continued Care and Services Coordination navigator section will be included in the table. The services can be provider (SER), facility (EAF), or department (DEP) records.

This table contains all the historical entries (dates/times/users/related contacts) for when the patient's problem list was marked as reviewed.

This is the clarity table for Infection Control Abstraction Workqueue functionality. It contains the review information for an abstraction.

This table contains information from system settings in the Point of Service System Definitions (POS).

Stores requisition grouper contact information.

This table stores prelimming physician information for imaging procedures.

This table stores data about wound therapy treatments that have been applied to a wound.

This table contains the hospital account alternate ICD procedures from the hospital account (HAR) master file. Alternate ICD procedures will be specified if hospital accounts are coded with two sets of ICD codes.

Contains the sequence of events for the transport request.

This table holds related patient contacts for the In Basket message record. This table is intended to replace IB_MESSAGES_2__EPT_CSN_ID because this table can store multiple encounters per message. Typically, this table will only have one line per message because most In Basket message records only have a singular contact associated, if any.

The table contains OR management system case surgeons.

This table contains linking information associated with flowsheet records.

The table contains the detailed pricing information for all DRG codes in your fee schedules.

This table contains BestPractice Advisory records that alert users when a patient is determined to be septic.

Users that were either requested to cosign the data or did cosign the data.

This table contains links to the alert data (ALT) displayed during medication administrations.

Stores CQL library parameters and their default values.

This table stores the antibiotics associated with a pathogen on the Pathogen Selection Form from related multiple response item RDI-40402.

This table contains information about the providers specific to this episode of care.

This table stores the medications that are associated with an inventory item.

This table traces medication orders in the pharmacy verify queue.

This table contains hospital account external injury codes information from the Hospital Accounts Receivable (HAR) master file.

The table contains a list of member groups, which are used to identify member populations under different circumstances.

The table contains information about infections linked to isolations. This includes the UTC instant at which the infections and isolations were linked. If the link was removed, the UTC instant at which the unlink occurred is also included.

Table containing the Identity IDs for a given ROM record.

This table extracts the related multiple response item AIF-2010.

Attributes and values for Willow Inventory GL credit strings.

This table displays the contact information that is related to the report generated for the ACC Registry.

This table contains nurses listed in research studies.

This table contains pharmacy over time information.

Stores patient communication information.

The table contains information about the allergies noted in your patients' clinical system records. You would use this table if you wanted to report on the number of patients who are allergic to sulfa drugs, for example. To determine the allergic reaction, link to the table.

This table contains hospital account final diagnosis list information from the Hospital Accounts Receivable (HAR) master file.

Customer Install Mnemonics.

This table stores information about actions performed on the study in imaging departments.

This table extracts the list of the medications that are linked to simple generic medications.

The table lists pending admission, transfer, and discharge actions to be taken.

The OR_LOG_PANEL_TIME2 table contains OR management system log panel timing information for the second panel.

This table stores the authorized service areas for payers.

This table contains links to flowsheet data (FSD) saved as part of medication administrations.

This table contains information about the program that a pharmacy claim is associated with.

Contains the possible outcomes for a quality measure.

This table contains the direct reference codes used in a CQL retrieve.

The records in this table contain child order IDs of standing orders released in an HOV encounter.

This table stores data for Identity Event Records (IER) associated with the source patient in a merge event.

Contains discrete data about the named expressions in a CQL library.

This table summarizes diagnoses associated with AP claim service lines. To link this table’s service line information back to a claim header, join this table to on the column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the column.

This table contains task information for Microbiology specimens and Anatomic Pathology cases.

The table contains overtime information on the episodes recorded in clinical system for your patients.

This is a Clarity table for EMP 17700 (Service Areas Authorized).

This table holds result edit information for Lab.

This table contains the heart status information for a transplant episode.

The Benefits that are used by the measure.

Table holding a single shift instance's basic information.

This table stores the dictation radiologist & dictating date information for orders performed in radiology.

This table contains hospital account claims information extracted from hospital account records.

This table lists out the guarantor account types that are considered research for the facility.

The table contains OR management system case procedures.

Filter locators (LGLs) for SmartGroup.

The table contains the change history of an accounts payable claim.

This table contains transplant classifications (types of organs being transplanted).

This table stores discrete vitals information received from outside sources.

This table contains noadd single items for SSI.

This table contains flowsheet row (FLO) data for an encounter. This table is a key table in tying LDA assessment row lines in flowsheet data records to the LDAs, and the necessary joins are: IP_FLOWSHEET_ROWS.IP_LDA_ID with.IP_LDA_ID.INPATIENT_DATA_ID with.INPATIENT_DATA_ID. with.

Quality measure program information including program, measure ID, and measure group.

General table level default values.

Organizational cost information stored on the hospital account.

CLARITY_EMP_DEMO table contains the demographic information of the users.

This table holds the Order ID for orders which EpicCare fills when dropping this referral.

Contains QM mnemonic IDs and values.

This table contains data relating to the history of problems from patients' problem lists in the clinical system.

The table contains the benefit plan history for your employer groups.

This table contains data on discrete goals (IGO) records associated with a patient.

The names of tuple elements for CQL library parameters.

This table stores the narrative information resulting from a procedure.

An audit trail for the recipient status changes the In Basket Message has undergone.

This table stores general inventory request information.

Contains the structure to support multiple Lab specimen for an order.

This table stores information about which groupers contain "always planned" procedures that always exclude readmissions from certain inpatient readmission metrics.

This table stores the measure period patterns for a specific measure and program.

This table contains hospital account and PB visit coverage list information from the Hospital Accounts Receivable (HAR) master file.

The previous value for a referral item audit action.

The table contains over time information from the procedure master file.

Authorized Service Areas and Business Segments for the referral.

This table contains medications' therapeutic classes.

This table contains patient isolation data.

This table returns the authorized business segment associated with a benefit plan record.

Adjudication attempts on prescription fill requests.

This table contains message text associated with a referral.

This table stores the multiple response data relating to which EMPs verified the waste contact on a given order.

The line for a referral item audit action

This table extracts alternate payer routing information for PB transactions.

Stores DRG codes and code sets considered sensitive for a sensitivity record and contact.

This table stores impression information for a procedure.

The table contains diagnosis information stored with referrals.

The data types of tuple elements in CQL library parameters.

The product lines to use for this benefit plan in reporting.

The table contains information about your patient genomic indicator records.

Address of the requisition grouper.

This table contains the care area types for the care area records.

Contains the expressions configured for a quality measure.

This table contains the line IDs (ORM) for the Surgical Staff Information of the Surgical Log (ORL).

Attributes and values for Willow Inventory GL debit strings.

This table contains the dependent expressions of a CQL named expression.

The research study statuses to be bucketed into Active - Not Recruiting.

This table contains information on variance types (IGT records).

This table contains the Benchmarking peer groups associated with an encounter.

The item being audited for the referral.

The anatomical regions of which the procedure is related.

Organ crossmatch types and results.

This table contains research contacts listed in research studies.

Denial records associated with this payment for evaluating denial rate metrics.

The table contains the system ID numbers for the HLX masterfile. Each record may have multiple IDs; therefore, a line number is used to identify each identification number for each record.

This table contains the IDs of the orders which were used to create a case.

List of metrics applicable to the registry. Every record in this registry will have these metrics tracked.

This table contains the intestine status information for a transplant episode.

The providers for an external event.

This table contains the referrals linked to AP claims.

Clarity extract table for Identity items in the Benefit Plan master file.

This table stores order performable information.

This table contains information for a single NDC code on a pharmacy claim.

Table for the tooth surfaces on which a given dental procedure is performed.

This table stores allergy reactions received from outside sources.

Frequency override times

List of departments that should be able to access information about this specimen.

Stores the items invoiced for an inventory request.

Contains the reasons for each referral.

This table stores the indications of use selected for a medication record.

Extracted table for scoring system-related data from scoring system data filed to RDI.

This table contains order-level information associated with genomics sequencing documents.

This table contains other providers listed in research studies.

Stores ophthalmology exam information documented in the visit.

Address of each submitter.

Profile variable values for an interface looking at the interface profile, system definition interface profile, interface kind, and variable defaults.

This table contains device capture information for the given Inpatient Data (INP) record.

This table contains the appointment serial number of the appointments scheduled for an order.

This table contains information for the DRG (Diagnosis Related Groups) master file.

This table contains contact specific data for the IGO (Discrete Goals) master file.

The table contains virtual items for the OR management system case records.

This table displays times that cosigners cosigned the flowsheet data.

Table contains items that represents anatomy of body (vessel related items).

Lab Anatomic Pathology case responsible person.

Information of other payors who paid the claim.

The table contains OR management system log surgeons.

This table contains care plan goal records that have goal outcome documentation for a particular encounter.

This table contains the line IDs (ORM) for the implant information of the surgical/invasive procedure log (ORL).

Complications from biopsy.

This table extracts the column names that were part of an entire table backfill when an action took place. This table replaced CLARITY_TBL_BKFL_EVNT_COL.

This table stores expression return element types if defined in a data model.

This table extracts the used codes for a CQL library.

The table contains information from the extension master file.

The list of analytics contexts assigned to the groupers.

This table contains information on the source goal templates for a patient goal or outcome.

Clarity table to hold the refund reason on the transactions (HTR). Only one refund reason is set for the transaction.

Synoptic result record table.

This table is a list of orders that have been linked to a Pharmacy intervention.

This table contains pharmacy addresses.

This table contains information about the various steps involved in turning over a bed. Each row corresponds to one bed clean and includes information about the previous patient who left the bed before the clean and the new patient who occupied the bed after the clean. This table can be joined to many other tables to retrieve additional information relating to the bed turnover process. Common joins may include, TXPORT_REQ_INFO, PEND_ACTION, CLARITY_ADT, PAT_ENC, or.

This table contains data on variance (IVR) records associated with a patient.

Lab Anatomic Pathology case information.

This table contains the organs recovered from a donor.

This table contains medications' pharmaceutical classes.

This table contains service lines for pharmacy claims.

The table contains social alcohol history data entered in clinical system patient encounters. Note: Typically, only the most recent social history data for a patient is extracted. However, you may elect to extract all social history contacts if you wish. In this case, since one patient encounter may contain multiple social history contacts, each contact is uniquely identified by a combination of the patient encounter serial number and a line number.

This table contains the category values which correspond to a cephalic delivery presentation. It can also indicate which cephalic presentations are vertex.

The table contains information about offers that were made to patients for their wait list entries via MyChart using the auto wait list batch job.

This table holds values for the suspected reaction row (EMR_SYSTEM_DEFS.SUSP_REACT_FLO_MEAS_ID) that indicate no reason is suspected.

The table records information about completed and manually overridden clinical system health maintenance topics that apply to each patient. This information is found in your system by the following path: clinical system Supervisor Menu > Supervisor's menu > Patient Health Maint option, or by clicking the clinical system client Health Maintenance button.

This table contains one row for each lab redraw reason where the collecting user is considered not at fault.

This table contains information about appointments, with one row per appointment. It is derived from the table and contains columns simplifying common reporting needs.

This table stores user action log data about login events. Each row represents a login event.

This table contains information on discrete pertinent negative exam findings in the physician exam for the left eye.

This table contains information about lab orders. One row in the table represents an order. Orders are only included in this table if they have an order type listed in the install mnemonic and do not have a future standing status.

The table contains data recorded in the family history contacts entered in the patient's chart during a clinical system encounter. Note: This table is designed to hold a patient's history over time; however, it is most typically implemented to only extract the latest patient history contact.

This table contains information from no-add, single-response items in EMR System Definitions.

The table contains information on inpatient discharge diagnoses. Each record in this table is based on

This table contains information about the attributed provider groups to which the location belongs for a given date range.

This table stores configured generic external procedure IDs that are assigned to external lab and imaging results autoreconciled through Happy Together when a true procedure mapping cannot be found.

This table contains the values which correspond to either third or fourth degree perineal lacerations.

This table holds data of whether the patient's allergies were marked as containing no drug allergies.

Stores the service areas and business segments () claims owned by a business segment (in) may be shared with. Claims may be filtered based on the information in other* tables.

This table indicates which order modes are considered per protocol. These orders will automatically be considered to be for the purposes of reporting.

The table contains the system master person index ID History for your patients. Each patient may have multiple master person index IDs; therefore, a line number is used to identify each identification number for a patient.

This table can be used to convert a medication quantity between two units. Joining to this table on and and multiplying the quantity by will calculate the quantity in the unit in the column.

This table contains a list of the diagnosis groupers. Any patient being treated with a diagnosis in these groupers should be excluded from most outpatient opioid reporting.

Contains information relevant to the patient's screening program history.

This table contains a list of different pain management-related medication concepts and medication groupers that contain the medication records belonging to each one.

The table contains basic information about the appointment records in your system. Since one patient encounter can be an appointment with multiple providers and resources (joint appointment), the primary key of this table comprises, and in which is used to identify each provider within the appointment.

Table to store the general questionnaire attached to upcoming appointment.

This table contains information about the Home Health disciplines mapping items, EAF 27875 and 27876. They map the networked category list SER 27001 to the list of standard reporting disciplines.

This table holds custom MAR actions that are mapped to blood waste and blood returned actions.

This table holds information for the right eye ophthalmology forms index.

Category values from I EPT 19472-"OB Hx Is Living" that indicate neonatal demise, as specified in I LSD 15527-"Neonatal Demise Category Values".

The patient encounter diagnosis table contains one record for each diagnosis associated with each encounter level of service. This table will contain all diagnoses specified on the Order Summary screen.

The table contains the audit history for manual registry overrides for a given patient. Each row represents one change to a registry override.

This table contains configuration data to help interpret results for metrics.

This table contains information about the problem list of a patient. It is based off the table, and its function is to list the Problem List (LPL) IDs of each patient.

The table contains information about surgical, radiology, and invasive lab locations.

This table extracts the values of the MyChart audit trail that should be considered patient-initiated actions, for the purpose of reporting on feature usage.

This table is used as a bridge table representing unique combinations of MyChart patient (WPR) records accessed during a given MyChart session.

System defined report grouper types for research studies. The line numbers in this table are used to reference from RSH-3021.

This table stores mappings from the Epic-defined race values to the Office of Management and Budget (OMB) defined race values as specified in the OMB Race Mapping Configuration of system definitions.

This table extracts the registries on which each patient appears.

This table contains information about which additional encounter types are considered while processing visit volume metric data.

This table stores the street address for the patient's correspondence address.

This table contains the video visit related data for a patient that is stored at the patient contact level.

Intervention types configured as balloon-equivalent interventions for the purpose of the Door-to-Balloon metrics.

This table lists out the guarantor account types that are considered institutional for each service area.

This table contains information for the cert period to which a Home Health contact belongs.

This table contains one row for each order priority that should be considered a timed priority.

This table saves the estimated wait times patients might see when they schedule appointments or during their visits.

The table contains one row for each patient in your system and indicates whether the patient is considered valid for reporting purposes.

The PAT_ENC_ES_AUD_ACT table contains scheduling system's auditing of actions taken on appointment contacts.

Extracts balance update reason category configuration useful for reporting.

The patient encounter letters table contains information about letters associated with encounters.

This table holds configuration information for blood grouper records.

This table contains the values which correspond to a delivery not being a live birth.

This table stores the case classification configuration options for the Door-to-Balloon metrics.

This item holds information on (Prescription Drug Monitoring Program) review.

This table contains information on the due status of health maintenance topics.

This table holds lab components for hematocrit lab values.

This table contains the hierarchy. The data in this table is populated from the the ^HSNOMEDRel global.

This table contains continued care services provided by facilities.

Groupers for obstetrics reporting.

Table contains list of enrollment statuses considered to be "pre-enrolled".

Health Maintenance Plans used during patient's last health maintenance update.

This table extracts street addresses recorded in each patient's historical addresses.

The contains authorized service area information for the patient.

The procedures available for a deceased organ donor.

This derived table extracts end of day items for Hospital Accounts.

This table extracts each patient's historical addresses.

This table contains one record for each patient type for each patient.

This table contains information on a patient's race.

History Audit Trail Items