Explorer
MedicationAdvisoryHistory
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.
AccountBillingInformation
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.
MedicationDispenseInformation
This table contains dispense information for orders.
PharmacyLocationAndConfiguration
This table contains pharmacy information. Each ADS (such as Pyxis), satellite pharmacy, or main pharmacy should have a record in the table.
AnesthesiaEncounterMetrics
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.
ClinicalBillingProcedu
The table contains basic information about the procedure records in your system. This does include both A/R and clinical procedures.
HospitalAccountTransactionDetai
This table contains hospital account transaction detail from the Hospital Permanent Transactions (HTR) master file.
DepartmentProfi
The table contains high-level information about departments.
MedicationPrescriptionOrd
The table enables you to report on medications ordered in EpicCare (prescriptions). We have also included patient and contact identification information for each record.
BenefitPlans
The table contains basic information about your benefit plans.
ClinicalProcedureOrd
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.
ClarityTableMetad
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.
SurgicalProcedureDefinition
The table contains OR management system procedures.
InBasketMessageCommunication
The table contains basic information about In Basket messages.
HospitalEncoun
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.
ReferralManagementRecord
The table is the primary table for referral information stored in system.
ClinicalTaskManagemen
This table contains data associated with task (LTK) records.
PatientDemographics
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.
PharmacyClaimDetai
This table contains information from pharmacy claims. Each record represents one pharmacy claim in the managed care system's AP Claims module.
ProviderMasterfi
The table contains high-level information about your provider records. These records may be caregivers, resources, classes, devices, and modalities.
ObstetricsEpisodeOfC
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.
FlowsheetGroupRowDefinition
This table contains generic information about flowsheet groups/rows.
OrderResultFinding
The table contains result finding information for an order. Result findings include mammography pathology results, cardiovascular palette findings, and other result findings.
NoteGeneralInformation
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.
AccountsPayableClaimServiceLin
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.
ClaimServiceLineDetai
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.
SurgicalCaseManagementRecord
The table contains OR management system case records.
ClaimAdjudication
The table contains one record for each claim in the managed care system's AP Claims module.
InsurancePlanCoverag
The table contains high-level information on both managed care and indemnity coverage records in your system.
LocationProfi
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.
PayerMasterfi
The table contains information about payer records.
ChargeTransactionLineI
Universal Charge Lines (UCL) information. Each row represents one UCL transaction.
WellnessRegistryPatientD
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.
PatientWellnessRegistryX
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.
PatientEncounters
This table contains information related to patient encounters or appointments.
WorklistTaskCompletionDetai
This table provides information on work list tasks.
PatientWellnessRegistry
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.
SpecimenContainerTracking
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.
GrouperTerminologySystemCodes
Contains the terminology codes for Terminology-type groupers.
RegistryBloodCultureProcedures
This table contains procedure records for blood culture lab orders.
LabLocationIden
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.
RegistryActivePatientMetrics
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.
HyperspaceActivityConfiguration
The table contains information about activity records used by Hyperspace.
DiagnosisRelatedGroupSystemDefinition
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.
AuthorizationServiceAreaFi
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.
CorporateDivisionAddress
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.
WorklistResponsibleUserAssignmen
This table holds users determined to be responsible for work list task instances.
MemberGroupServiceAreaAssignmen
The table contains a list of service areas and business segments used to determine which members are associated with a member group.
ClaimProcedureReferralUsag
This table contains the list of referrals that are used during AP claims adjudication to satisfy authorization requirements for this service.
InsuranceCoverageMemberDetails
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.
ProblemListStageHistory
List of stages attached to a specific problem on a patient's Problem List.
ClinicalTaskDefinition
This table is designed to extract information related to tasks.
ClaimExplanationOfBenefitCodes
This table contains details regarding claim codes attached to AP claims.
MyChartPatientAccountEmailAddress
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.
CovidSuspectedRegistryMetrics
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.
BillingDenialCorrespondenc
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).
ChargeEditRuleDefinition
This table contains rule information.
ClarityColumnSourceMapping
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.
RegistrationTaskConfiguration
This table contains a list of operational tasks used in ADT.
FinancialAssistanceCas
This table contains basic information about a financial assistance case record.
CustomerServiceRecordAttachmen
Extracts the attachments for this NCS (customer service) record.
QuicksetSingleResponseOverT
This table contains information about LGL items that are single-response, and tracked over time.
OrganizationRegistrySettings
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.
TransferCenterRequestContactLog
This table stores information about the contacts associated with Transfer Center requests.
PatientCareEpisodeSummary
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.
UserActivityWorkspaceHourlySummary
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.
CoronavirusSuspectedPatientRegistryMetrics
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.
MedicationAdministrationRecordAction
This table contains the currently active medication administration data. This includes all scheduled and acted upon administrations currently showing on the MAR.
OrderStatusLegacy
The table contains overtime single response orders information.
AccountableCareOrganizationRegistryExt
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.
ClaimPaymentDetai
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.
PatientMedicareHealthStatus
This table stores the Medicare health status flags for a member.
ThirdPartyDirectoryOrganizationNameHistory
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.
HospitalAccountProcedureCodeLin
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.
MedicationOrderDiagnosisAssociation
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.
ResultVerificationAuditTrai
Result audit information for verification and unverification (result correction).
AuthorizationServiceDecisionHistory
This table contains the authorization decision history for service-level authorizations.
SurgicalProcedureLogImplantDetails
This table contains the implants information for the surgical/invasive procedure log (ORL).
HomeHealthOasisDiagnoses
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.
ExternalBillingDiagnosisDocumen
This table stores discrete billing diagnosis information received from outside sources.
CommunicationCustomerRelationshipReferenc
The Customer Relationship Management record that is referenced by the communication.
MicrobiologyAntibioticSusceptibility
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..
ProfessionalBillingTransactionDetails
This table contains information about professional billing transactions.
SurgicalCaseRecord
The table contains information about surgical and procedural log (ORL) records.
AppointmentEcheckinStep
This table contains eCheck-In information for a specific appointment.
ProgramMeasurementExpressionSecondarySourc
This table extracts the related multiple response item VBP-512.
SmartDataElementMetad
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.
DiagnosisCodeMappingRecords
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.
ClinicalDocumentationWorkingProcedu
The table contains information related to working procedures for a Clinical Documentation Improvement (CDI) review.
HighPrioritySystemDefinitions
This table contains one row for each priority that should be considered a high priority.
MyChartAccountInformation
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.
RefundSessionClaimDetails
Claim-related info in the refund session.
OphthalmologyLinkedEncounters
Table for the linked eye exams to a visit or admission.
InbasketRegistryConfiguration
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.
HospitalAttendingProvid
The table contains information on inpatient or outpatient attending providers. This table is based on.
CustomerServiceTransferReques
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.
PharmacyInterventionDetai
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.
SlicerDicerHistoricalEncounterTyp
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.
MyChartPatientMessag
This table contains information on messages sent to and from web-based chart system patients.
PrescriptionAdjudicationCoverag
Table that holds coverage information for an adjudication. Adjudication records are used by Ambulatory Pharmacy during prescription copay adjudication.
ReceivedFamilyHistoryPro
This table stores discrete family history problem information received from outside sources.
PatientHierarchicalConditionCategoryRegistry
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.
ResultCardiovascularFinding
This table contains information about a single finding.
HospitalLogisticsGroupAssignmen
Hospital Logistics Group Information.
QueryOutcomeResponseMapping
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.
SpecimenContainerTyp
The table contains information about your container type records.
InfectionSurveillanceAbstraction
This table contains basic information from infection abstractions.
PushNotificationActionDetai
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.
ReportConfigurationDetails
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.
FinancialAssistanceProg
This table contains information related to financial assistance program records.
FlowsheetRowIden
This table holds flowsheet row identifier information from FLO.
AppointmentReferralLink
This table contains information about referrals linked to an appointment.
ExternalMedicationDispenseHistory
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.
DeviceTypeConfiguration
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.
PatientServiceCommunication
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.
MedicationInventoryProductCatalog
This table contains information about inventory items in the medication inventory catalog.
HealthMaintenancePlanDefinition
This table contains data about a Health Maintenance Plan's record ID and name.
SpecialtyMedicationRegistryPatien
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
ResearchStudyEncounterLinkag
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.
BillingAreaFinancialDivision
This table contains the extracted information of the Financial Division.
ClaimProcedureCodes
The table contains the ICD-9 Procedure information on an accounts payable claim.
ClaimExportBatchMetad
The table contains information regarding the claim export record.
CalendarDateDimension
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.
MedicationEquivalencyDetai
This table contains medications' equivalency information.
AccountableCareOrganizationRegistry
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.
ProtocolTreatmentDay
This table contains the information about the treatment days associated with each protocol or the steps associated with each pathway.
EmergencyDepartmentCareAreaConfiguration
This table contains Care Area specifics.
PatientMasterIndexIdentifierHistory
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.
OrderSpecificQuestionRespons
This table contains order specific questions and their responses.
AuthorizationProcedureModifiers
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.
EncounterStatusHistory
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.
ImagingRadiationDoseStructuredRepor
This table contains basic information about imaging data from the performing modality. It also contains cumulative radiation dose information.
IntensiveCareUnitStayMetrics
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.
CovidConfirmedRegistryExternalD
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.
UnitedNetworkForOrganSharingRegistryStageHistory
Registry Data Instance (RDI) record stage history.
OrderPlacementMetric
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.
PatientEncounterCommunicationManagemen
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.
OrderResultReadAcknowledgmentTracking
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.
LungCancerScreeningRegistryMetrics
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.
ReferralChargeSummary
This derived table summarizes the data to show the total of professional and hospital charges made for a given referral.
CareEpisodeAssociatedMedication
This table contains a list of generic medications (MDL) that were associated with the Coordinated Care Management episode.
SynopticSmartDataConversionBatch
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.
TransactionCollectionRatioMetrics
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.
ClinicalDecisionSupportModifierExclusion
This table contains modifiers that, when associated with an order, should denote the order will be excluded from decision support.
RegulatoryReportingGroup
This table holds information about Regulatory Group records, which are used to store information about configuration for regulatory reporting and attestation programs.
InpatientRehabilitationFacilityPatientAssessmentInstrumentClinicalD
This table contains clinical information collected on the IRF-PAI.
CheckInRefundReason
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.
ThirdPartyDirectoryTaxonomyHistory
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.
ThirdPartyDirectoryAddressHistory
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.
ClinicalTextTemp
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.
ClinicalNoteEncounterInformation
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.
VendorPaymentOrganization
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.
PatientAllergyUpdateHistory
The table contains one record for each update of a patient's allergy information.
GenomicSequencingDocumentCloudLifecyc
This table contains information about your genomics sequencing pipeline documents.
ThirdPartyDirectoryIdentifierHistory
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.
ExternalProviderDirectory
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.
ProcedureIden
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.
FinancialAssistanceApplicationStatus
This table contains information related to a financial assistance program tracker record.
ImagingOrderProtocolEven
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.
OpioidUseDisorderRegistry
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.
ClinicalDocumentationReviewContac
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.
ContentMetadataI
This table holds the no add single items for the Content Metadata (HCM) master file.
OrderedProcedureDiagnosisAssociation
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.
ResearchStudyA
This table identifies the valid branches within a research study.
SpecimenContainerEventLog
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.
MedicationAdministrationRecordAlertComplianc
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.
PayerQualityMeasureHistoricalOutcomes
This table stores the historical payer calculated outcomes for quality measures that are received from payers.
InactiveHospitalBillingTransaction
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.
ReportingConfigurationOrganizationFi
This table extracts organization-specific information such as organization ID and name for use with organization filter functionality.
ApplicationProgrammingInterfaceClientConfiguration
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.
QualityMeasureNcqaProductLines
This table contains the product lines for which to calculate and report outcomes for this measure.
ExternalClientFactTableGroups
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.
ClaimWorkqueueItemHistory
Stores the history for AP Claim workqueue items.
PatientLineDrainAirwayTripHistory
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.
TransactionDiagnosisLink
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.
DepartmentHolidayScheduling
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.
HomeHealthAgencyFacilityConfiguration
Contains Home Care facility no-add single items information.
ExternallySourcedMedicationRecord
This table stores medications received from outside sources.
ImmunizationRecord
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.
ProviderSpecialty
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.
OncologyTreatmentPlanStatus
This table displays the status of the pathway (active, completed, or discontinued).
SmartSetProtocolPathwayConfiguration
This table contains the SmartSet/Protocol/Pathway settings that do not change per contact for each SmartSet, Protocol, Pathway, or Dental Template.
EncounterResultFollowUp
This table contains the list of results that were followed up during this particular encounter, such as a telephone encounter.
HospiceDiagnosisCodes
The table lists coded hospice diagnoses.
QuestionnaireAnswerHistory
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.
CodingClarificationActionHistory
The table contains information about actions taken by users on a query (coding, Clinical Documentation Improvement, or missing doc).
CareEverywhereDocumentReleaseAuthorization
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.
QuestionnaireAnswerDetai
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.
EncounterDiagnosisEditAuditTrai
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.
ChildOrderDeselectionCommentHistory
This table extracts the history of comments associated with deselecting recommended child order items.
BloodTransfusionAdministration
Administrable Procedure Items in Orders (ORD).
PatientServiceCommunicationMod
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.
PatientLocationStructu
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.
PatientGoalUpdatesOverT
This table contains data for the Discrete Goals (IGO) masterfile that is over-time data.
HospitalAccountPatientContac
This table contains hospital account patient contact serial number (CSN) information from the Hospital Accounts Receivable (HAR) master file.
BillAreaRevenueGroup
This table contains the extracted information of the Bill Area masterfile (BIL).
LaboratoryResultAuditTrai
Various no-add single virtual items.
PatientOutreachCommunicationTrac
This table contains information about communication traces.
PatientIdentityHistoryLog
No add single table for Identity history database.
SurgicalCaseAuditTrai
The table contains OR management system log audit trail information.
SlicerDicerFaceToFaceEncounterTyp
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.
HospitalBillingClaimDetai
This table contains detailed claim print record information for claims associated with the hospital liability bucket.
DeceasedCancerPatientRegistryD
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
OperatingRoomSurgicalS
This table contains the Surgical Staff information for the Surgical Log (ORL).
PharmacyWorkRequestOrderFi
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.
QuestionnaireSeriesAssignmen
Table that stores series assignment related information as well as information on series answer record status.
InfectionCaseAssociatedProvid
This table contains information about the providers (SER records) associated with an infection case.
QualityControlLotInformation
This table stores lot specific QC material information. It does not include the checking information.
AuthorizationProcedureDetai
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.
GeneralWellnessRegistryMetrics
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.
ProcedureModifierSystemIden
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.
LifestyleSocialHistory
The table contains social history data for each history encounter stored in your system. This table has one row per history encounter.
InventoryItemBalanc
Contains information about balance, par levels, location, pharmacy and the inventory item to which this balance record is linked.
CancerStagingMethodologyDefinition
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.
NationalDrugCodeMedicationDetai
This table contains the National Drug Code (NDC) information.
ObstetricsDeliveryMembraneRuptureDateT
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.
HealthMaintenanceMod
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.
AccountStatusHistory
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.
ValueBasedCareEncounterTypeExclusion
Configuration table for encounter types to exclude in quality measure calculations in Caboodle.
PharmacyInventoryLocation
This table stores Inventory Location (IVL) records.
EmployerBenefitPlanGroup
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.
AnesthesiaSingleCopyNoteTypeConfiguration
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.
ResearchEnrollmentAccrualStatus
This table contains the research enrollment statuses that should be considered accrued.
NationalDrugCodeContactStatus
This table contains the medication related to NDC for each contact.
PatientSmartSetSourceInformation
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.
SlicerDicerLookbackConfiguration
Contains the look back period used by SlicerDicer (in months).
InterfaceErrorLogDetai
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.
ReferralDisciplineSpecificAuthorization
RFL_DISC_SPEC_AUTH contains discipline-specific authorization information used by Home Health.
HospitalLogisticsRequestStatusHistory
Hospital Logistics Request Status Audit.
ExternalConceptMapping
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.
MemberGroupRiskPanelAssociation
The table contains a list of risk panels used to determine which members are associated with a member group.
SystemCategoryDefinition
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.
ProviderInitiatedAppointmentCancellationReason
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.
ReadmissionIndexProcedureDefinition
This table stores information about which groupers contain procedures that indicate an admission qualifies as an index admission for certain inpatient readmission metrics.
MedicationAdministrationRecordOverrideLink
This table contains the order IDs for medications that are connected through override pull linking.
MedicationConfigurationDetails
This table contains medication information for no-add single response items.
RadiologyImagingProcedureAuditTrai
ORDER_RAD_AUDIT stores information about imaging audit actions logged on procedure records.
InvoiceClaimLineDetai
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.
PatientApplicationUserAudi
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.
PatientHealthMaintenanceModifierAudi
This table contains audit trail info for changes made on the list of Health Maintenance Modifiers for a patient.
ClaimIcdProcedu
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.
DeceasedCancerPatientRegistry
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
ValueBasedProgramMeasureExclusionDataSourc
This table stores supplemental required exclusion data sources for measures in a value-based program performance period.
AmbulatoryPharmacyWorkReques
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.
ColumnLinkageDefinition
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.
SurgicalSiteInfectionProcedureSurveillanc
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.
PatientSexualOrientationIdentity
This table contains information about a patient's sexual orientation.
ClinicalDocumentationWorkingDiagnosisRelatedGroup
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.
HospitalLiabilityBuck
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.
LabResultComponentDefinition
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.
ProgramMeasureOptionalExclusionSourc
This table stores supplemental optional exclusion data sources for measures in a value-based program performance period.
CancerStagingContactHistory
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.
DeviceIdentificationHistory
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.
InflammatoryBowelDiseaseRegistryDataMar
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
HospitalAccountBillingIndicato
This table contains billing indicator information from the HAR master file.
ServiceDeclinationReason
This table contains the reasons why a service declined a patient's request for continued care or services.
CommunicationTrackingLog
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.
ExternalCodeListValu
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.
RegistryConfiguration
This table contains basic information about the registry configuration, including information about the import specifications used and the type of registry.
MetadataRecordProperties
This table stores the properties associated with a metadata record.
HospitalCodingQueryRecipien
The recipients of a Coding or a CDI query for a Hospital Account.
UserAuthorizedReportingDepartments
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.
BloodOrderReasonForUseQuestionn
This table holds blood order reason questions.
EpisodeCarePlanLinkHistory
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.
LaboratoryFacilityConfiguration
This table contains basic information about your facility record. It only contains information from the newest contact.
PatientInformationVerification
The table contains information about your verification records. These records include verification information for patients, guarantors, coverages, coverage members, hospital accounts, and encounters.
SepsisProtocolInitiationProcedu
This table contains procedure records that are used to document sepsis protocol initiation.
ReferringProviderSourc
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.
OrderPerformableChargeableLink
Links to performables (OPE) and chargeables (UCL) for an order.
SurgicalLogStaffT
This table contains the Surgical Staff Times information for the Surgical Log (ORL).
TransplantEpisodeDetails
This table contains information regarding the transplant episode. Only episodes whose Episode Type Class (I HBD 130) is 4 - Transplant will be included.
PeriodontalExamBleedingSuppurationLocation
This table contains the location of bleeding and suppuration findings documented during a patient's periodontal exam.
ObstetricDeliveryAugmentationReason
This table contains the category values which correspond to indications for augmentation. This data comes from the Delivery Summary activity.
AppointmentCompletionStatusConfiguration
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.
ElectronicRemittanceCodeDefinition
This table contains basic information about the remittance codes that can accompany electronic payments and claim denials.
HospitalLogisticsAssignmentStatusModifierAudi
Hospital Logistics Assignment Status Modifier Audit.
CancerStagingInformation
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 ().
HomeHealthPatientEncoun
This table contains Home Care overtime single items that are stored in the Patient (EPT) master file.
PurchaseOrderReceivedItems
This table stores information about items that were received in an inventory request invoice.
CardiovascularPercutaneousCoronaryInterventionDeviceEven
This table store the PCI device deployment event configuration for the Door-to-Balloon metrics.
ObstetricsDeliveryProvid
This table contains information about the providers who participated in the delivery.
MetadataRecordReviewStatus
Stores the overall review status of each contact of a metadata record.
AlertOrderInformation
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.
QualityMeasureExpressionRequiredDataSourc
This table extracts the related multiple response item LQM-460.
BedActionRequestEven
This table holds the event data for the BEV master file.
PayorPlanGroupTemporalAttributes
The table contains employer group information that may change over time, such as the sales representative or dependent cut-off ages.
CesareanSectionIndicationLog
This table contains the indications for a C-Section.
PatientEncounterWaitLis
This table contains data related to the Wait List contact type. Each record is based on patient contact serial number.
ValueBasedProgramMeasureDenominatorDataSourc
This table stores denominator data sources for measures in a value-based program performance period.
SurgicalSiteInfectionProcedureAbstraction
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.
HospitalAccountSeparateServiceAreaBilling
This table contains all hospital account related information for the separate service area billing functionality.
SurgicalSiteInfectionReadmissionSurveillanc
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.
PatientIdentifierTypeDefinition
The table contains the list of ID Types in your system.
PatientProblemHistoryCurrent
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.
PatientEncounterCopayCollection
Information relating to copays collected using the POS or Registration copay forms (not the AR copay form).
ResearchGrouperOverrid
The SYS_RSH_RPT_GRP_OVRIDE table contains the display name overrides for the research category and free-text report groupers.
QuickformQuestionRespons
This table contains information about the related Quickform response group stored in the Quickform responses (I LQL 700) item.
HospitalEncounterProblemLis
The contains the hospital problems for each hospital encounter.
PushNotificationRecipientAuditTrai
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.
QuestionnaireSeriesDefinition
Table that holds information about the questionnaire series (LQW) that does not change with time like series type, series name..etc.
ClinicalQualityMeasureCqlExpressionDataTyp
This table contains the Clinica Data Model types retrieved in the CQL named expression.
RadiologyOrderTypeConfiguration
Configuration for additional order types that count as radiology orders.
CesareanSectionIndication
This table contains the category values which correspond to indications for cesarean section. This data comes from the Delivery Summary activity.
InpatientReadmissionRegistry
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.
SupplierPurchaseRequestAndShipmentSettings
Contains supplier (WHS) level settings used for purchase requests and shipments.
ReceivedExternalDiagnosis
This table stores discrete diagnosis information received from outside sources.
ClaimTransactionHistory
This table contains the history of service line changes for accounts payable claim records.
ContentMetadataRecordOwners
this table stores the owners list for content metadata records.
TransplantOrganAcceptanceCri
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.
HospitalBillingDenialLineDetai
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.
ProfessionalBillingVisits
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.
PatientLocationEventTracking
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.
HospitalAccountCptProcedures
This table contains hospital account CPT(R) codes from the Hospital Accounts Receivable (HAR) master file.
MyChartMessageQuestionnaireAttachmen
This table stores information on questionnaires that have been attached to web based chart system (WMG) messages.
PlanGroupOvertimeHistory
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.
ClinicalQuestionGroup
This table stores information on question groups.
SurgicalLogPacuLevelTimestamps
The table stores the details about the various levels the patient was in, for the surgical log.
ClinicalAlertInteraction
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.
NoteTextConten
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.
ContinuedCarePayorCommunicationAudi
This is the Clarity Table for Continued Care and Services Coordination and Payor Communication audit data.
InterfaceMessageLog
The table contains information about interface messages. This includes the contact information, transmission data, and user data.
ReferralAppointmentAssignmentErro
This table contains the list of errors for a referral when assignment to an appointment fails.
FacilityEmergencyDepartmentDispositionMapping
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.
ProviderVendorAssociation
The table includes a list of vendors with which providers are associated.
ImmunizationAdministrationRecord
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.
ImmunizationHealthMaintenanceSequenceNum
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.
PayorServiceAuthorization
This table contains information about authorization records. This includes links to the patient, referral, and coverage/payer.
LungCancerScreeningRegistryMetricsExt
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.
PushNotificationDeliveryLog
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.
ClaimCodeResolutionDetai
This table contains details regarding the resolution of claim codes for AP claims.
ReceivedFamilyHistoryMem
This table stores discrete information about family members with a noted medical history. The information stored in this table was received from outside sources.
TechnicianAssignmentAuditLog
Hospital Logistics Assignment Information Audit.
InsuranceCoverageAccountsPayableClaims
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.
HospiceBereavementContac
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.
ChildOrderRecommendationDeselectReasonHistory
This table extracts the history of reasons associated with deselecting recommended child order items.
CodingProcedureServiceLineQuantity
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.
AuthorizationRequestHistory
This table contains a snapshot of information about an individual authorization request as of a point in time.
ProcedureCategoryDefinition
This table contains information about procedure categories. Procedure categories are used to group together related procedures, such as all GI orderable procedures.
BenefitPlanServiceAreaLink
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.
GeneVersionDetails
Extended information about a gene such as its full name and whether it is withdrawn (and if so, when).
RequisitionPatientAddress
This table contains patient addresses on requisitions.
ProcedureOrderSignatu
This table contains the users, providers, and messages related to procedure verbal orders and cosign orders.
ValueBasedCareReferralExclusionTyp
Configuration table for referral types to exclude in quality measure calculations in Caboodle.
ValueBasedProgramDefaultAttribution
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.
UserRecordInformation
This table contains high-level information about user records from the User master file.
HemoglobinLabComponentDefinition
This table holds lab components for hemoglobin lab values.
OrderFirstAndLastScheduledDateT
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).
FlowsheetRowOrderLink
This table stores the orders associated with a flowsheet row in a multiple-response format for easier reporting.
QuickSetLocatorNoAddSingleRespons
This table stores information about items in the LGL masterfile that are of no-add type and that are single response.
ProviderSchedulingDepartmen
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.
SlicerDicerFilterDefinition
This table contains information about SlicerDicer filters.
InpatientFlowsheetPainAssessmentConfiguration
This table contains the flowsheet rows and groups used to document pain assessments as defined on the Pain Reassessment screen in Core Measures settings.
PatientGenomicIndicatorDiseaseDrug
The table contains information about your patient genomic indicator records. These include disease-related and drug-related genomic indicators linked to patients.
PainReassessmentIntravenousRoutes
This table contains the administration routes that are equivalent to intravenous as defined on the Pain Reassessment Reporting screen in System Definitions.
TransactionNationalDrugCod
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.
CoverageAuthorizedServiceAreaBusinessSegmen
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.
ValueBasedProgramMeasurePrimarySourc
This table extracts the related multiple response item VBP-511.
ResearchStudyEnrollmentStatusHistory
This table contains the enrollment status change of a participant in a research study and the effective date of the status change.
ServiceAreaProfi
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.
ObstetricDeliveryEpisiotomy
This table contains information about any episiotomies performed to aid the delivery for this pregnancy.
SurgicalSiteInfectionBilledProcedu
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.
CarePlanPatientTaskStatus
This table contains information about patient-assigned tasks in the care plan.
LaboratoryVirologyTestMas
The table stores general settings for laboratory test records.
ProfessionalBillingTransactionDetai
This table contains information about professional billing transactions.
PurchaseContractRecord
This table stores information pertaining to purchase contract records.
TransplantLungAllocationScoreHistory
This table contains the lung allocation score information for a transplant episode.
OrganTransplantDetails
Table for general organ information about transplanted and native organs.
WorkqueueDefinition
This table contains information about extensible workqueues. Each row represents one workqueue in the WQF masterfile.
OrderResultComponentCommentOverflow
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.
InvoiceDiagnosisInformation
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.
ResultRecommendationFinding
This table stores tracked recommendation information and Blood result dispense status for orders-related results. This table can also store Dermatology Skin Findings.
LogisticsSectorSubtypes
This table contains Logistics subtypes associated with the Logistics Region or Logistics Sector.
ClaimServiceLineDiagnosisLinkag
This table contains linkages between claim service lines and diagnoses for CMS claims.
NationalHealthcareSafetyNetworkServiceLocation
This table stores reporting specific attributes associated with a department or service location.
MemberGroupBenefitPlanLink
The table contains a list of benefit plans used to determine which members are associated with a member group.
SurgicalCaseDelayInformation
This table contains the Delay information for the Surgical Log (ORL).
ObstetricsHistoryPregnancyEpisodeLink
The table contains information about episodes (pregnancy and delivery record HSB records) linked to a patient's OB history.
InfusionPumpOrderAlertDetails
Data stored during the process of sending order details to infusion pumps.
FlowsheetSingleColumnLastFiledD
This table contains data on the last instant of data being filed to a single column template in Doc Flowsheets.
DeliveryMethodForcepsCategory
This table contains the category values which correspond to a delivery method of vaginal forceps delivery.
ImagingDecisionSupportAppropriateness
This table contains the appropriateness score for an imaging procedure if using third party decision support software in conjunction with Epic.
RegistrySurveillanceAbstraction
This table contains basic information from surveillance abstractions.
DiagnosisCodeMappingIcdTen
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.
BillAreaFinancialSubdivision
This table contains the extracted information of the Financial Subdivision.
DentalOrderNoAddItems
No-add items for dental orders.
CoverageSubscriberAddress
This table contains each coverage subscriber's street address.
InterfaceTranslationTableConfiguration
The table contains information about your interface table records.
NationalHealthcareSafetyNetworkPathogenSusceptibilityInterpretation
This table stores the antibiotic susceptibility interpretation for a given pathogen on the Pathogen Selection Form in the related multiple response item RDI-40403.
BenchmarkDefinition
This table stores basic information about metric definitions.
CodingAndClinicalDocumentationQueries
This table contains information on queries sent during coding (including documentation queries) and clinical documentation improvement (CDI) reviews.
ComplexVariantComponen
The table contains the list of simple or complex variants contained within a complex variant.
RadiologyOrderAddendu
This table stores information about imaging addenda.
VoidedClaimChecks
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.
SurgicalLogPreoperativeAcuityLev
The table stores the details about the Pre-op acuity levels documented for a patient in a surgical log.
SurgicalLogDelayReasons
This table contains the Delay Reasons for the Surgical Log (ORL).
HomeHealthHospiceEpisodeIntakeInformation
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.
PatientEncounterFormAnsw
Table has information for items in related group 20800.
FlowsheetMeasurementEditHistory
This table contains the previous values from edited flowsheet records.
RosterEligibilityPeriod
Compiled roster tracking eligibility periods for each roster ID.
ExternalSystemPatientIdentifierGroup
The EXT_SYS_PAT_IDENT_BUNDLE table contains information about external system patient identifier bundles.
TransactionClaimModifiers
This table contains multiple response information for modifiers associated with A/R (ETR) transactions.
OncologyTreatmentPlanPathwaySteps
This table contains the treatment days in a treatment plan record or the steps in a pathway record.
PatientIdentityEventHistory
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.
MedicationFormulary
The table contains high-level information from all the medications for use in your facility.
TransactionAgingHistory
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.
HomeHealthContactTypeMetad
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.
ClaimPrescribingProviderIden
This table contains information for prescribing provider identifiers.
FrequencyParameters
This table contains data on discrete frequency (EFQ) records.
TreatmentPlanDayStatus
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.
LaboratoryTestComponentIden
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.
InsuranceCarrierSponso
The table contains information about the carriers who sponsor your networks and benefit plans.
AuthorizationRequestMilestoneTimeliness
This table contains timeliness information for authorization request milestones.
PharmaceuticalLotInformation
This table contains most of the information about the lot number records in the Lot Number (LOT) master file.
TransactionDetai
Transaction Information that is used moderately often.
OrderPharmacyPreparationCompound
The table contains information about the compound used in pharmacy preparation of the dispenses of an order.
DiagnosisGrouperICDCodes
Stores codes and code sets specified for ICD diagnosis groupers.
TransplantLiverScoreHistory
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.
ExternalDocumentEncoun
Encounters received from external documents.
QualityMeasureClinicalQueryLanguageQuery
This table stores the SQL queries used on Caboodle to evaluate the named expressions contained in the CQL library.
SensitivityOvertimeDefinition
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 .
DeliveryMethodVacuumCategory
This table contains the category values which indicate that the delivery method was a vaginal vacuum delivery.
OperatingRoomPanelTiming
The OR_LOG_PANEL_TIME1 table contains OR management system log panel timing information for the first panel.
SurgicalSiteInfectionSurveillanceLabResu
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.
ClaimInjuryExternalCauseDiagnosis
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.
ClarityColumnMetad
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.
TransactionCostDetai
This table contains transactional cost information.
PatientEcheckinSession
This table contains information about patient eCheck-In sessions, with each row representing a unique session.
ClaimLineDetai
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.
DiagnosisRelatedGroupReportingConfiguration
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.
UserReportAuthorizationLocations
This table contains a listing of users and the locations for which they are authorized to view reports.
WelcomeSessionKickoutAction
This table stores the related multiple values of the contact-level kickout actions stored in I WEL 218.
PatientAllergyHistoryLog
The table contains information about the changes made over time to allergies noted in the patients' clinical system records.
RequisitionGroupPatientLink
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.
NativeOrganSecondaryFailureReason
Table of secondary failure reasons for the native organ.
EmergencyDepartmentEventLog
This table contains information about the current event records.
ProcedurePassTaskCompletion
This table contains information about the completion of each task type associated with a Procedure Pass.
AnesthesiaRecordProviderAssignmen
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.
CareManagementConfiguration
The Care Management configuration table.
ClaimDenialLineMod
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.
OrganizationDataExchangeConfiguration
Details about the organization. Includes external name, phone/e-mail, hours of operation, HSI, URL.
QuestionnaireQuestionResponseHistory
The table contains each contact for questionnaire questions.
ReferralHistoryAction
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).
ReceivedDocumentSpecimenInformation
This table stores discrete specimen information received from outside sources.
ManagedCareSystemConfiguration
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.
EmergentPercutaneousCoronaryInterventionConfiguration
This table stores the emergent PCI procedure configuration information for the Door-to-Balloon metrics.
ClaimExportStatusHistory
The table holds the instant that the export status was last changed.
AttributedProviderGroupWorkflowContexts
This table contains information about the workflow contexts for attributed provider groups.
ClinicalDocumentationReview
This table stores information about Clinical Documentation Improvement (CDI) reviews.
HeartTransplantStatusHistorySummary
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.
InventoryRequestStatusAuditTrai
Keeps an audit trail of request status changes for a inventory request.
LogicalObservationIdentifierNamesAndCodes
This is the primary table for Logical Observation Identifiers Names and Codes (®) information.
DispensePreparationImageDocumentation
This table includes links to DCS records where images taken during dispense preparation are stored.
TransferCenterProviderDecision
This contains the decisions that were made by potential accepting providers about whether to accept or decline a Transfer Center request.
RegistryApplicableMetrics
List of all non-linked metrics applicable to a registry. This includes standard, custom, and inherited.
TreatmentPlanBlockInformation
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.
WelcomeSessionEncounterSelection
This table contains patient encounter contact serial numbers (CSN) selected in Welcome sessions.
ActiveEnrollmentStatus
This table contains list of all enrollment statuses considered to be "active".
PatientEventLinkag
This table contains information that is useful for linking records (patient, department, etc.) to their appropriate events.
InterfaceKindConfiguration
This table contains information related to interface kind records.
OutpatientVisitReasonDiagnosis
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.
DataExchangeOrganizationConfiguration
The tables contains Cosmos-specific metadata about how data from external organizations is processed.
MedicationProblemListAssociation
The table enables you to report on Medication Problem List information.
PatientMessageTask
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.
QuestionnaireSeriesAnsw
Table storing information on questionnaire answer ids.
AnesthesiaEpisodeLinkedProcedures
For use with anesthesia, stores all patient encounters (procedure cases, appointments) that are linked to by (fall under the sedation of) the anesthesia episode.
CollectionAgencyProfi
Contains information from the Collection Agencies (KCA) master file.
AllergenExternalVocabularyCodes
This table contains codes in external vocabularies that represent an allergen record.
LabResultTypeConfiguration
The table contains information for result type records.
ExternalSystemPatientIdentifierBund
The table contains the list of identifiers that are used by external systems to denote patients.
MemberGroupLineOfBusiness
The table contains a list of lines of business used to determine which members are associated with a member group.
ScreeningProgramMostRecentAssessmen
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.
CaseManagementEpisodeHistory
The history tracks changes made to the case episode for auditing purposes.
ClaimProcessingMilestoneHistory
This table contains AP Claim processing milestones and associated dates.
HospitalClaimPrintRecord
This table contains claim print record information for claims associated with a given hospital account or liability bucket.
TransplantLungCompositeAllocationScoreHistory
This table contains information about a waitlisted transplant patient's lung CAS subscore over time, and the dates on which those scores were recorded.
ResearchStudyReportGroupers
The extensible report grouper values listed in research studies.
LactateRegistryComponentNames
This table contains common names of lactate lab result components.
OrderSetBlockConfiguration
Contains information related to order blocks for SmartGroup and protocol records.
ReasonForVisitMpiIden
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.
QualityMeasureVersionSpecification
The table contains program information about quality/objective measures that may change over time.
SurgicalCaseCostAndCharg
The table contains information about costs and charges associated with the procedural log.
WoundRegistryMetrics
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).
NationalDrugCodePricingHistory
This table contains NDC price information.
SmartFormConceptCommen
The table records the comments entered via SmartForms.
PayerPlatformPatientInsightFeedback
This table contains information about individual patient insights feedback shared via Payer Platform.
QualityMeasureClinicalQualityLanguageElementNames
This table stores the element names for a CQL expression within a measure.
ProductNationalDrugCodes
This table stores the NDCs associated with inventory item records.
SurgicalProcedureTimeoutSafetyChecklis
This table contains virtual items for Procedure Pass records.
RiskPanelMasterfi
The table is the master table for risk panel information.
OutreachContactActionAudi
Each row represents a line of auditing information about actions that have occurred on an outreach contact.
PatientPrimaryLocationHistory
The table contains the Primary Location information for your patients over time.
PatientEncounterHistory
The table is the master table for ADT event history information. This table contains several foreign keys for other ADT tables.
NhsnPathogenProcedureConcep
This table stores the concepts and business logic for the pathogens and procedures.
TransactionExplanationOfBenefits
The table contains the Explanation of Benefits information given a transaction ID. It contains data that is not multiple response given a transaction ID.
QualityMeasureClinicalQueryLanguageDependentLibrary
This table contains the libraries for the dependent expressions for the CQL named expression.
HospitalAccountSingleBillingOfficeBalanc
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.
QualityMeasureClinicalQueryLanguageValueSetFi
This table contains the value sets to filter Clinica Data Model types retrieved in the CQL named expression.
ResultComponentMultilineValuePoin
For a given component this holds all the pointers to the table that stores the multi line data.
ProfessionalBillingCopayCollectionHistory
This table stores the history of professional copay collection.
MammographyOrderRecommendation
Stores the mammography recommendations linked to an order.
LaboratoryDepartmentProfi
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.
ConceptValuePreviousValu
This table contains previous value lists for a Concept Value (HLV) record.
ValueBasedProgramPerformancePeriod
This table stores performance periods for value-based programs.
FinancialResponsibilityClass
This table contains information about responsibility classes.
PatientOperatingRoomAdmissionLink
This table stores the link between encounter ID and the associated log or case ID.
OrganizationServiceAreaSettings
This table extracts the service areas that comprise a particular organization. This is used in organization filter functionality.
ObstetricDeliveryIndicationReason
This table contains the category values which correspond to indications for induction. This data comes from the Delivery Summary activity.
ExternalResultD
This table stores discrete results received from outside sources.
ElectronicPaymentTransactionDetails
Contains information on electronically made payments.
MedicationPharmacologicalSubclass
This table contains the pharmacological sub class.
ProtocolContactSettings
This table contains the contact specific settings for each SmartSet or Protocol.
ObservationPatientClassDefinition
This table contains the list of patient classes that the system considers to mean that the patient is an observation patient.
FeeScheduleContractPricing
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.
DentalProcedureToothFinding
This table contains the list of teeth associated with a dental procedure.
PatientTreatmentTeamMembership
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.
DiagnosisInformation
The table contains basic information about diagnoses.
SmsMessageChildren
Child messages related to a given SMS message.
AdmissionDischargeTransferEventInterpretation
The table extracts the reporting interpretations for ADT events. This table contains a foreign key to the table for linking to other ADT tables.
ValueBasedProgramDefinition
This table stores definitions and settings for value-based programs or contracts.
InvoiceClaimInformation
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.
DiagnosisCodeMapping
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.
ValueBasedProgramMeasureNumeratorSourc
This table stores supplemental numerator data sources for measures in a value-based program performance period.
DepartmentAllowedLevelOfC
Stores the level of care values that are allowed for patients being roomed in a particular department.
ValueBasedProgramMeasureExclusionSourc
This table stores required exclusion data sources for measures in a value-based program performance period.
DentalProcedureEditHistory
This table contains the history of edits for dental procedure records.
EmergencyDepartmentProcedureInterpretation
This table stores the initial ED interpretation for a procedure.
PatientAddressHistory
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.
MyChartMessageQuestionnaireAnsw
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.
ChroniclesItemDefinition
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.
PatientTemporaryAddress
This table stores the street address for the patient's temporary address.
InterfaceTranslationTableD
This table extracts the related multiple response item AIF-2020.
ProviderLicenseCredenti
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.
NationalHealthcareSafetyNetworkFacilityDefinition
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.
QuestionnaireSeriesAnchorEven
This table stores information on anchor event option(s) a questionnaire series is related to.
AllergyReactionDetai
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.
MedicationLegacyD
This table contains medications' information.
SocialCareCompassRoseEpisod
This table stores episode information for Compass Rose episodes.
OrderDispensePharmacyPreparation
The table contains information about the pharmacy preparation of the dispenses of an order.
OperatingRoomPickListSupply
The table contains OR management system pick list supply list.
AllergenVocabulary
This table contains information on allergens.
ProspectivePaymentSystemReimbursemen
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.
MedicationOrderPatientInstructions
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.
PurchaseContractDetails
This table stores purchase contract specific information.
BedCleaningProtocolRequiremen
The table holds information about the cleaning protocols required by cleaning requests.
RegistrationHistoryEven
The table contains information about registration history events stored in RHX records.
TransplantSurgicalLog
Table of the surgical logs for the transplant operation.
GeneticVariantDetai
Main variant result table.
BestPracticeAlertWebServiceSco
This table contains the web service ID, score, and medication or procedure ID of the BPA web service.
SurgicalImplantRecord
The table contains implant information.
FlowsheetRowGroupDescription
This table contains the information related to this flowsheet row or group that will clarify its use.
MedicationChargeMapping
This table contains basic information for charge mapping table.
HomeHealthPatientCaregiverInformation
Contains Home Health noadd single items in the Patient (EPT) master file.
QualityMeasureClinicalQueryLanguageParam
Stores information on CQL Measure Configuration programming point parameter (E3P) records.
InterfaceSpecificationProfi
This table contains the name and ID of an interface specification (AIP) record. An interface specification is an individual definition of an interface.
PatientLocationEventInformation
This table extracts the Patient Location (PLC) update event information that corresponds to ADT events into Clarity.
PatientInfectionContro
This table contains basic information about patient infections.
HospitalTransactionCostDetails
Cost data for charges.
QualityMeasureRetrievalCqlLibraryVersion
This table contains the CQL library versions used by Retrieves.
ReceivedDocumentSurgicalHistory
This table contains surgical history information.
DenialChargeTransactionLinks
This table stores PB Denial/Correspondence (BDC) denial records and the charge transactions that were denied by that denial record.
ManagedCareSystemExplanationOfBenefitsCodeConfiguration
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.
ImagingOrderModalityD
This table contains the modality data related to the performing imaging order.
RegistryInfectionControlLocation
This table contains information about the location (department, room, and bed) associated with an Infection Control abstraction.
ProspectivePatientAttribu
Prospective Patient Segmentation Information.
ProgramMeasureNumeratorDataSourc
This table stores numerator data sources for measures in a value-based program performance period.
UserRestrictedServiceA
This table contains the service areas in a facility to which a user is restricted.
TransactionClaimStatementDateHistory
This table contains the first and last date a claim or statement was sent out for a transaction, if any.
DentalToothFinding
This table contains the items for dental teeth records.
ClaimSharingSensitivityConfiguration
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 .
TransplantCalculatedPanelReactiveAntibodyHistory
This table contains the calculated Panel Reactive Antibodies (PRA) data for a transplant episode.
SurgicalProcedureAbstractionRegistry
This table contains basic information from procedure abstractions.
OrderSmartSetAssociation
This table contains data on smartsets and smartgroups that orders originated from.
HospitalLogisticsReques
Hospital Logistics Requests Information.
RequisitionGrouperMasterPatientIndexHistory
The table contains information that tracks the current values for the Requisition Grouper (RQG) master file.
SurgicalCaseProcedureCod
The table contains information about log procedure codes.
DiagnosisIcdNineMapping
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.
ValueBasedProgramProviderAttribution
This table contains Provider Attribution configuration for Value-Based Programs.
QuestionnaireQuestionDefinition
The table is the primary table for storing non-contact specific information related to questionnaire questions.
ObstetricDeliveryRuptureOfMembranesTyp
This table contains information about the how membranes ruptured for this pregnancy.
InvoiceAuthorizationInformation
This table will extract invoice level authorization information.
CriticalResultCommunication
Information about abnormal resulting instants and associated critical value calls. Only populated for records with status 6-Preliminary, 9-Verified, or 20-Corrected.
DentalProcedureFinding
This table contains the items for dental procedure records.
CaseManagementEpisodeTyp
This table contains a list of Coordinated Care Management episode case types. Case types refer to case management programs.
BloodUnitAdministrationDetails
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.
HospitalBillingProfileBaseClassMap
This table contains the base class mappings for the facility hospital profile (HSD 1). Including only the facility profile will prevent duplicate mapping.
RefundSessionAudi
Basic information for a refund session.
PharmacySupportedOrderTyp
Clarity table for extracting supported order types for this pharmacy.
InpatientStayEducationNo
This table contains generic information related to a patient's inpatient stay, including data on patient education, notes, and other topics.
HospitalSectorConfiguration
This table contains the No-add, single-response items from the Sector (SEC) master file.
TransplantHeartStatusReasonHistory
This table extracts the related multiple-response Heart Status Reasons (I HSB 30419) item.
BillingDenialCorrespondencePayo
Table of payors attached to denial/correspondence records. Each denial/correspondence can be associated with multiple payors.
SlicerDicerFilterFlowsheetRowConfiguration
Contains the related configuration settings for SlicerDicer. Currently this includes a list of SlicerDicer filter records and flowsheet rows used by those filters.
CarePlanPatientTaskStatusHistory
This table stores the history items for status changes of patient tasks within a care plan.
ClaimSubmissionValueRecord
This table holds basic identification and processing information for the claim value record.
SpecimenSubContainerInformation
This is sub container information for Anatomic Pathology specimens.
OrganUnitedNetworkForOrganSharingFailureReason
Contributory reasons for organ failure, as determined by .
PregnancyRegistryMetrics
DM_PREGNANCY is a data mart table that stores registry metrics related to pregnancies.
ClinicalDocumentationFormBlueprin
The table is the master table for questionnaire forms.
SmartSetContactInformation
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.
DepartmentReportingContex
This table stores information about the reporting contexts for the department.
EpisodeSummaryBlockAuditTrai
The table records the changes made to episode summary blocks over time.
ReceivedDocumentResultSusceptibility
The table contains information about compiled results susceptibility.
OrderTemplateRecord
This table contains information about order template records.
SepsisProtocolRegistryOrders
This table contains order set records that are used to document sepsis protocol initiation.
ClaimInvoiceDetails
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.
TransportEscalationAuditTrai
Hospital Logistics Assignment Escalation Audit.
EmployerGroupAlternateIden
The table contains the alternate IDs for your employer groups.
SmartDataElementConceptLexicon
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.
HospitalBedManagemen
This table reflects the data in the Hospital Beds (BED) master file.
ProgramMeasurePublicationCalculationMethod
This table extracts the related multiple response item VBP-425.
ConceptItemCaption
Stores the captions of the items that filed the concept.
LaboratoryGeneralInformation
Interface laboratory general information.
HospitalSectorLocations
This table contains the Hospital Locations belonging to this Logistics Region or Sector.
CoveragePrimaryCarePhysicianLocationHistory
This table contains coverage level primary location and PCP information.
InpatientMetricIndexProcedureGroup
This table stores information about which groupers contain procedures that indicate whether an admission qualifies as an index admission for certain inpatient metrics.
PayorMasterfileIdentity
Extract table for Identity items in the Payor master file.
OrderResultRecommendationAppointmen
This table stores appointments scheduled for a recommendation.
MemberGroupDataSourceConfiguration
Data sources that define the member group.
HospitalAccountTyp
This table contains the hospital account types for each hospital account.
ClaimDiagnosis
All values associated with a claim are stored in the Claim External Value record. The table holds the diagnoses for the claim.
InBasketMessageRecipien
Information regarding the recipient of the In Basket Message.
WillowInventoryTransaction
Contains general transaction information.
MyPanelMetricsAttributedProvid
This table contains data about providers attributed to patients for My Panel Metrics.
BedEventRequestSummary
This table holds the no-add, single-response items from the Bed Events (BEV) master file.
InterfaceMessageCommandAuditLog
The table contains a list of commands that have been run against the message.
ClaimAdjudicationPendCod
Stores summary information about processing codes (also known as claim codes, explanation of benefits codes, or EOB codes).
GrowthChartFilesetReferenc
This table contains growth chart fileset records from your system.
HospitalSectorServiceA
This table contains the Service Areas belonging to this Logistics Region or Sector.
LineOfBusinessMetad
The table contains information from the line of business master file.
ReferralCommunicationAuditHistory
Linked communication record for referral audit action.
PregnancyDeliveryInductionMethod
This table contains information about any methods used to induce delivery for this pregnancy.
ReferralCoverageAuthorization
The contains coverage auth/cert information for referrals.
LungAllocationScoreExceptionHistory
This table extracts the related multiple-response Lung Allocation Score (LAS) Exceptions (I HSB 30430) item.
TransactionInvoiceLink
This table maps a link from the table via to the Invoice tables via.
ClinicalPreferenceListConfiguration
This table contains high-level information on preference lists.
EventTemplateConfiguration
This table contains the noadd single items (name, ID, record state…) for a given event template.
CarePlanEnrollmentDetails
This table cotains the enrollment information for a care plan.
PatientWelcomeSessionAudi
This table contains Welcome session data.
DiagnosisRelatedGroupReimbursementContrac
This table holds DRG contract information for each ID type associated with a DRG.
CarePlanTemplateConfiguration
This table contains the basic no-add single items of Care plan template (LCE) records like record name, status, type, display name, etc.
ReferralHistoryActionTimestamp
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).
FinancialAssistanceMedicationProgramTrack
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.
DeliveryCesareanSectionReason
This table contains the category values which correspond to a cesarean section delivery.
ReceivedExternalReasonForVisi
This table stores discrete reason for visit information received from outside sources.
LaboratoryResultComponentDetai
Primary table for result component information.
MetricIndexProcedureExclusionGroup
This table stores information about which groupers contain procedures that always exclude admissions as index admissions from certain metrics.
TaskAnchorEventFilingInformation
This table contains filing information of the anchor event linked to the task.
ReceivedDocumentExternalProvid
This table contains the external provider information.
ApClaimWorkqueueHistory
Stores information about AP Claim workqueue items. Each time an AP Claim enters a workqueue, it will have a row in this table.
BloodTransfusionDocumentationWindowConfiguration
This table holds documentation time window configuration for blood transfusion flowsheet documentation.
DenialCorrespondenceRemarkCod
This table lists the remark codes associated with a Denial/Correspondence (BDC) record.
TransferCenterRequestStatusHistory
This table stores information related to the status change history for Transfer Center requests.
RegistryPositiveCarbapenemaseResu
This table stores carbapenemases found in an LabID sample.
DepartmentIden
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.
QualityMeasureSupportedPeriodPattern
Stores the supported measurement period patterns for measures.
ImagingProcedureTechnicianCompletion
This table stores tech complete information for imaging procedures.
BedPlacementPendingEventHistory
This table contains information about edits that occurred on pending event records.
TreatmentRegimenUpdateInformation
Table for overtime single items.
EpisodeMasterPatientIden
This table includes Identity ID information for the Episode (HSB) master file.
HospitalAccountDetai
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.
PayerPlatformIntegrationFeedback
This table contains information about feedback shared via Payer Platform.
TreatmentPlanCyc
The cycle information for the treatment plan.
AnesthesiaMultiCopyNoteTypes
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.
RegimenSourceOrderGroupLink
The table stores information to link to the order group record and contact that were used to create a regimen record.
SurgicalCaseTimingEvents
The table contains information about case timing events associated with a procedural case that has been performed.
QuestionnaireFormContac
The table contains each contact for questionnaire forms.
RiskAdjustmentDxHccHierarchy
This table extracts the related multiple response item LSD-45020.
SurgicalCasePanelFourTimingEvents
The OR_LOG_PANEL_TIME4 table contains OR management system log panel timing information for the fourth panel.
HospiceBenefitPeriod
This table extracts data about hospice benefit periods.
CarePathStepConceptValu
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.
EmergencyGeneralSurgeryRegistryMembership
Data mart to track patient membership of EGS registry
InpatientLinkedContactSerialNum
This table displays the Contact Serial Numbers (CSNs) for linked contacts.
PhoenixSystemDefinitionSettings
This table contains System Definition settings for Phoenix application.
VendorPlaceOfServic
The table contains the place of service information in the vendor database.
ProviderAttributionGroupHistory
This table contains information about the attributed provider group to which the provider belongs for a given date range.
QualityMeasureSearchTemp
The table contains information about quality measure search and template records.
ClaimServiceProvidersIden
This table contains information for service provider identifiers
RegistryCarbapenemaseTests
This table stores carbapenemase tests performed for an LabID sample.
MedicationRxNormCodes
This table contains the RxNorm code for the medications.
ProviderAddressLocation
The table includes the office addresses for providers.
AnatomicPathologyProtoco
Protocol records for Anatomic Pathology.
OrderPathologyResultFinding
Stores the pathology codes and malignancy types attached to a pathology result on an order.
OperatingRoomPanelThreeTiming
The OR_LOG_PANEL_TIME3 table contains OR management system log panel timing information for the third panel.
DentalFurcationFindingDetails
Contains location and classification details for furcation findings.
EventTemplateNoAddRelatedI
This table contains the noadd related item information for the event template.
ExternalEventProviderLinkag
Contains external provider IDs used to link provider information to an event provider.
InterfaceErrorDefinition
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.
InventoryLocationHierarchy
This table contains master locations which are contained within an aggregate location.
SpecimenContainerIden
The specimen container ID for specimens with multiple containers.
CombinedServiceLineByCodeIntegration
This table holds the combined service lines created by code integration.
InBasketMessageStatusAuditTrai
An audit trail for the status changes the In Basket Message has undergone.
HospitalBillingLiabilityBucketReplacementHistory
This table contains unique IDs of buckets that were replaced by the current bucket.
RegistryMetricColumnMapping
Contains a list of column (E0C) records that have an associated Registry Metric (CER) and the associated metric ID.
HealthyPlanetCarePlanTemp
Contains information about Healthy Planet Care Plan templates.
HospitalTransactionModifiers
This table contains multiple response information for modifiers associated with Hospital Permanent Transactions (HTR) transactions.
TreatmentPlanUpdateHistory
The update information for the treatment plan.
MicrobiologyCultureResu
This table contains information about microbiology culture results.
ClaimAuthorizedServiceA
Authorized service areas and business segments for the claim.
ValueBasedProgramClinicalQualityLanguageTupleParam
Stores performance period tuple list CQL parameters and their values.
BillingCostCen
The table contains billing cost center information.
ValueBasedProgramPatientRos
Rosters that define the patient base for this program.
SectorDepartmentLink
This table contains the Departments belonging to this Logistics Region or Sector.
OrderWoundAssociation
This table contains the list of LDA records representing wounds that are associated with an order.
TransplantIntestineStatusReasonHistory
This table extracts the related multiple-response Intestine Status Reasons History (I HSB 30523) item.
AnatomicPathologySpecimenDescription
Lab Anatomic Pathology case specimen descriptions.
TransplantRetransplantDiagnosis
retransplant diagnosis information.
GuarantorPaymentScoreHistory
This table contains information for the HB and PB Guarantor Payment Score Items.
PaymentRelatedDenials
Denial records associated with this payment for evaluating denial rate metrics.
CarePathEpisodeHistory
Historical information for Care Path episode.
FacilityIdentification
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.
SurgicalLogPhaseTwoAcuityLevels
The table stores the details about the Phase II acuity levels documented for a patient in a surgical log.
PurchaseOrderInvoiceDetails
This table stores general information about inventory request invoices.
WelcomeSessionKickoutReason
This table stores the related multiple values of the contact-level kickouts stored in I WEL 215.
RecommendationResultOrderLink
Stores the orders linked to a recommendation.
SectorHospitalAreaInclusion
This table holds the hospital areas included in a sector.
ValueBasedMedicationReviewStatusConfiguration
Configuration table for medication list statuses that count as medications reviewed in quality measure calculations in Caboodle.
TransactionStatusHistory
This table includes status items that indicate if a transaction is active and if is the most recent active transaction.
ClaimCoverageInformation
This table stores claim level coverage related information.
UniformBillingRevenueCod
The table contains information on UB revenue codes.
TransactionMatchHistory
Matching History Transaction Related Items. A line is added to this related group whenever two transactions are matched together.
HospitalLogisticsRequestStatusModifierAudi
Hospital Logistics Request Status Modifier Audit.
TelehealthVisitMetad
NOADD_SINGLE Clarity table for LVV.
ProcedureCategoryScreeningProg
This table contains screening program information from your procedure category records.
ReceivedDocumentInsuranceInformation
Externally received insurance information.
SimpleGenericMedicationN
This table contains the simple generic name.
DentalOrderSurfaces
The list of surfaces associated with this dental order.
ThirdPartyDirectoryIndividualNameHistory
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.
SurgicalHistoryProcedu
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.
GenomicOrderIndicato
Contains flags needed to identify orders that meet specific criteria for genomics usage.
PaymentClassificationCategory
This table contains payment classification category, weight, and price information.
TransplantProtocolEpisod
Table for transplant protocols for classifying the patient.
ApplicationConfiguration
The table contains information about your applications like application ID, name, etc. The records in this table are from the E2G masterfile.
ObstetricDeliveryLaceration
This table contains information about any lacerations occurring during the labor and delivery for this pregnancy.
GrouperCompiledRecordLis
Contains the compiled list of records for a grouper.
HospitalAccountCodingStatusHistory
This table contains the history of coding status changes for each account coded.
SurgicalCaseComplication
This table contains rows for tracking surgical log complication elements.
OperatingRoomResourceLocation
The table contains OR management system OR information.
MedicationMixtureIngredientInformation
This table is used to extract ingredient medication information for mixture orders.
AlertInteractionHistory
Actions which the user has taken upon alerts.
QuestionnaireQuestionRespons
The table contains responses for questionnaire questions.
OrderFinalizingProvid
This table contains information about the physician who finalized a study and when it was finalized.
EmergencyDepartmentDispositionMapping
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.
GuarantorBillingAddressLin
This table contains one row for each line of the billing address of a guarantor account.
ImagingOrderInterpretationPhysician
This table stores reading physician information for imaging procedures.
QualityMeasureRequiredDataSourc
This table displays data for I LQM 374, which stores the required data sources in a measure definition.
EpisodeTaskCompletionEncoun
This table lists the contact serial numbers (CSNs) of the encounters where a given episode task was completed.
HospitalDeviceRegistry
This table displays high-level information for device (DEV) records.
TransportMultipleAssignments
This table contains the linked child transport request records (TNP) associated with multiple transporter assignment.
TablePrimaryKeyColumns
Contains a list of column IDs for each table that have been identified as the primary key columns for those tables.
ProcedureOrderScheduledT
Contains the scheduled times for procedure orders.
GrouperCategoryConcep
This table contains data about groupers of category values.
BenefitPlanOver
The table contains overtime information from the benefit plan master file.
MyChartSchedulingHistory
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.
HyperspaceWorkspaceConfiguration
The table contains information about workspace records used by Hyperspace.
ClarityTableQueryFooterSq
This table contains the SQL code found in the footer of each Clarity table's query.
DateOfDeathFlowsheetRowDefinition
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.
DentalTreatmentRegimenVisi
The table contains information associated with dental visit records.
SurgicalCaseProcedureLog
The table contains OR management system log procedures.
ProcedureGrouperCodes
Stores codes and code sets specified for ICD procedure groupers.
InventoryBalanceUpdateAuditTrai
Balance update audit trail. Stores balance updates.
OrderAttributeLegacy
The table enables you to report on attributes for each order. Currently, you could use value 1 to get all order that pyxis override.
HomeHealthCredentialDisciplineMapping
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.
TaskTemplateConfiguration
This table displays general information about the Task Templates (LTT) record.
SystemConfigurationSettings
Stores general system settings.
SurgicalCasePostoperativeDiagnosis
This table contains the post-op diagnosis codes for the surgical log (ORL) record.
DiagnosisIdentifierHistory
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.
PurchaseOrderStatusAuditTrai
Keeps an audit trail of shipment status changes for a inventory request.
LexiconSnomedConceptMap
This table contains data related to concepts. The data in this table is populated by the import.
SurgicalCaseDelayInformationLineID
This table contains the line IDs (ORM) for the Delay Information of the Surgical Log (ORL).
ResearchStudyPatientFacingA
This table stores the patient-facing areas of research for a research study.
QuestionnaireSeriesAuditLog
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.
LexiconElementDescription
The SmartData element's description.
OperatingRoomCaseDiagnosisCodes
The table contains OR management system log diagnosis codes.
LaboratoryInstrumentMethodConfiguration
Basic method information.
InvoiceRequestSentItems
This table stores information about items that were sent in an inventory request invoice.
OperatingRoomProviderSurgicalServic
The table contains OR management system surgical services.
SurgicalCasePreoperativeDiagnosis
This table contains the pre-op diagnosis codes for the surgical log (ORL) record.
ProfessionalBillingVisitCos
This table contains cost information for PB visits.
BedEscalationReasonHistory
This table holds the history of escalation reasons for the BEV master file.
ClinicalQualityMeasureParam
Stores CQL parameters and their values on CQL measure records.
HospitalTransactionDiagnoses
This table contains hospital account transaction diagnoses from the Hospital Permanent Transactions (HTR) master file.
OrderSetSmartGroupSettings
This table contains the SmartGroup settings that do not change per contact for each SmartGroup.
OrderTemplateTracking
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.
SurgicalSupplyInventory
The table contains inventory item records.
DepartmentServiceInformation
The table allows you to report on department services information from system's ADT application.
PayorAuthorizedBusinessSegmen
This table returns the authorized business segment associated with a payor record.
HumanLanguagesMasterfi
This contains a list of languages and their properties, both spoken and written.
MedicationAdministrationRecordBarcodeScan
Table for contact level additional information such as barcode scans.
CarePathStepConfiguration
Settings for steps in a Care Path.
DischargeDispositionReportingMap
This table maps discharge dispositions used for reporting to base ADT discharge dispositions.
ReferralWorkflowHistory
This table stores referral history columns that are shared between audit actions that happened during the same workflow.
InventoryRequestItemDetails
This table stores information about items ordered in an inventory request.
RequisitionGrouperPatientRac
Requisition grouper patient race information.
ValueBasedReferralStatusInclusion
Configuration table for referral statuses to include in quality measure calculations in Caboodle.
ProcedureGroupDefinition
This table holds information from the Procedure Group (EPG) master file.
PrescriptionFillCoverages
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.
OrderResultVarian
This table contains a list of all of the variant records associated with the result for this order.
MedicationOrderSignatu
This table contains the users, providers, and messages related to medication verbal orders and cosign orders.
LaboratoryTaskFlags
Stores a list of flags placed on a task.
AppointmentRequestScheduledAppointmentLink
This table stores links between appointment requests and appointments scheduled from them.
MedicalConditionMasterfi
This table contains basic no-add information about medical conditions.
EncounterReasonForVisi
This table contains basic information for records in the Reason for Visit (HRV) master file.
AllergenMasterPersonIndexLink
This table contains information on master person index information for an allergen.
ResearchStudyEnrollmentCoordinato
The table identifies study coordinators for a patient's enrollment in a research study.
ContinuedCareServiceCoordination
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.
ProblemListReviewHistory
This table contains all the historical entries (dates/times/users/related contacts) for when the patient's problem list was marked as reviewed.
InfectionControlAbstractionReview
This is the clarity table for Infection Control Abstraction Workqueue functionality. It contains the review information for an abstraction.
PointOfServiceSystemDefinition
This table contains information from system settings in the Point of Service System Definitions (POS).
RequisitionGroupContactInformation
Stores requisition grouper contact information.
ImagingOrderPreliminaryFinding
This table stores prelimming physician information for imaging procedures.
WoundTreatmentApplication
This table stores data about wound therapy treatments that have been applied to a wound.
HospitalAccountAlternateProcedureCodes
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.
TransportEventSequenc
Contains the sequence of events for the transport request.
InbasketMessagePatientEncoun
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.
OperatingRoomCaseSurgeon
The table contains OR management system case surgeons.
FlowsheetRecordLinking
This table contains linking information associated with flowsheet records.
FeeScheduleDiagnosisRelatedGroupPricing
The table contains the detailed pricing information for all DRG codes in your fee schedules.
SepsisBestPracticeAdvisoryAlerts
This table contains BestPractice Advisory records that alert users when a patient is determined to be septic.
FlowsheetUserCosignatu
Users that were either requested to cosign the data or did cosign the data.
MedicationAdministrationAlertLink
This table contains links to the alert data (ALT) displayed during medication administrations.
QualityMeasureLibraryParameterDefau
Stores CQL library parameters and their default values.
NationalHealthcareSafetyNetworkPathogenSusceptibilityAntibiotic
This table stores the antibiotics associated with a pathogen on the Pathogen Selection Form from related multiple response item RDI-40402.
EpisodeOfCareProvid
This table contains information about the providers specific to this episode of care.
ProductMedicationLink
This table stores the medications that are associated with an inventory item.
MedicationOrderPharmacyVerificationTrac
This table traces medication orders in the pharmacy verify queue.
HospitalAccountExternalInjuryCod
This table contains hospital account external injury codes information from the Hospital Accounts Receivable (HAR) master file.
MemberGroupPopulation
The table contains a list of member groups, which are used to identify member populations under different circumstances.
InfectionToIsolationLinkag
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.
RoomIdentityHistory
Table containing the Identity IDs for a given ROM record.
InterfaceTranslationTableKeys
This table extracts the related multiple response item AIF-2010.
WillowInventoryGeneralLedgerCreditStringAttributes
Attributes and values for Willow Inventory GL credit strings.
RegistryContactSerialNumberForACCRepor
This table displays the contact information that is related to the report generated for the ACC Registry.
ResearchStudyNurses
This table contains nurses listed in research studies.
PharmacyOverTimeDetails
This table contains pharmacy over time information.
RequisitionPatientCommunication
Stores patient communication information.
PatientAllergyHistory
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.
HospitalAccountFinalDiagnosis
This table contains hospital account final diagnosis list information from the Hospital Accounts Receivable (HAR) master file.
CustomerInstallationMnemonicConfiguration
Customer Install Mnemonics.
RadiologyImagingStudyActions
This table stores information about actions performed on the study in imaging departments.
SimpleGenericMedicationLinkag
This table extracts the list of the medications that are linked to simple generic medications.
PatientPlacementReques
The table lists pending admission, transfer, and discharge actions to be taken.
OperatingRoomPanelTwoTimestamps
The OR_LOG_PANEL_TIME2 table contains OR management system log panel timing information for the second panel.
PayerServiceAreaAuthorization
This table stores the authorized service areas for payers.
MedicationAdministrationFlowsheetDataLink
This table contains links to flowsheet data (FSD) saved as part of medication administrations.
PharmacyClaimProgramAssociation
This table contains information about the program that a pharmacy claim is associated with.
QualityMeasureOutcomes
Contains the possible outcomes for a quality measure.
ClinicalQualityMeasureCqlRetrieveCod
This table contains the direct reference codes used in a CQL retrieve.
StandingHospitalOrderReleasedChildOrd
The records in this table contain child order IDs of standing orders released in an HOV encounter.
HistoricPatientIdentityEventMergeLog
This table stores data for Identity Event Records (IER) associated with the source patient in a merge event.
QualityMeasureClinicalQualityLanguageDefinitions
Contains discrete data about the named expressions in a CQL library.
ClaimProcedureAssociatedDiagnosis
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.
SpecimenMicrobiologyAndPathologyTaskLog
This table contains task information for Microbiology specimens and Anatomic Pathology cases.
EpisodeOvertimeRecord
The table contains overtime information on the episodes recorded in clinical system for your patients.
AuthorizedUserLocation
This is a Clarity table for EMP 17700 (Service Areas Authorized).
LaboratoryResultEditHistory
This table holds result edit information for Lab.
TransplantHeartStatusHistory
This table contains the heart status information for a transplant episode.
QualityMeasureRelevantNcqaBenefits
The Benefits that are used by the measure.
LogisticsTechnicianShiftInstanc
Table holding a single shift instance's basic information.
RadiologyOrderDictationResu
This table stores the dictation radiologist & dictating date information for orders performed in radiology.
HospitalAccountClaimDetails
This table contains hospital account claims information extracted from hospital account records.
FacilityResearchGuarantorTypes
This table lists out the guarantor account types that are considered research for the facility.
OperatingRoomCaseProcedureDetai
The table contains OR management system case procedures.
OrderSetSmartGroupFilterLocato
Filter locators (LGLs) for SmartGroup.
AccountsPayableClaimChangeHistory
The table contains the change history of an accounts payable claim.
TransplantClassification
This table contains transplant classifications (types of organs being transplanted).
ReceivedVitalsFromExternalDocumen
This table stores discrete vitals information received from outside sources.
SmartSetSingleItemNoAddon
This table contains noadd single items for SSI.
FlowsheetRowEncounterD
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.
QualityMeasureProgramInformation
Quality measure program information including program, measure ID, and measure group.
InterfaceTableDefaultValues
General table level default values.
HospitalAccountCostBreakdown
Organizational cost information stored on the hospital account.
UserDemographics
CLARITY_EMP_DEMO table contains the demographic information of the users.
ReferralOrderIden
This table holds the Order ID for orders which EpicCare fills when dropping this referral.
QualityMeasurementMnemonicConfiguration
Contains QM mnemonic IDs and values.
PatientProblemHistory
This table contains data relating to the history of problems from patients' problem lists in the clinical system.
EmployerGroupBenefitPlanHistory
The table contains the benefit plan history for your employer groups.
PatientCarePlanGo
This table contains data on discrete goals (IGO) records associated with a patient.
QualityMeasureLibraryParameterElementN
The names of tuple elements for CQL library parameters.
ProcedureResultNarrativ
This table stores the narrative information resulting from a procedure.
InBasketMessageRecipientStatusAudi
An audit trail for the recipient status changes the In Basket Message has undergone.
InventoryTransferAndPurchaseOrderReques
This table stores general inventory request information.
OrderLabSpecimenPerformanc
Contains the structure to support multiple Lab specimen for an order.
InpatientReadmissionAlwaysPlannedProcedureExclusion
This table stores information about which groupers contain "always planned" procedures that always exclude readmissions from certain inpatient readmission metrics.
ValueBasedProgramMeasurePeriodPattern
This table stores the measure period patterns for a specific measure and program.
HospitalAccountCoverageLis
This table contains hospital account and PB visit coverage list information from the Hospital Accounts Receivable (HAR) master file.
ReferralHistoryPreviousValu
The previous value for a referral item audit action.
ProcedureHistory
The table contains over time information from the procedure master file.
ReferralAuthorizedServiceAreaBusinessSegmen
Authorized Service Areas and Business Segments for the referral.
MedicationTherapeuticClass
This table contains medications' therapeutic classes.
PatientIsolationRecord
This table contains patient isolation data.
BenefitPlanAuthorizedBusinessSegmen
This table returns the authorized business segment associated with a benefit plan record.
PrescriptionAdjudicationAttemp
Adjudication attempts on prescription fill requests.
ReferralCommunicationTex
This table contains message text associated with a referral.
MedicationWasteVerificationEmploy
This table stores the multiple response data relating to which EMPs verified the waste contact on a given order.
ReferralItemHistoryChangeLin
The line for a referral item audit action
TransactionAlternatePayerRouting
This table extracts alternate payer routing information for PB transactions.
SensitiveDiagnosisRelatedGroupDefinitions
Stores DRG codes and code sets considered sensitive for a sensitivity record and contact.
OrderProcedureImpression
This table stores impression information for a procedure.
ReferralDiagnosis
The table contains diagnosis information stored with referrals.
QualityMeasureLibraryParameterElementTyp
The data types of tuple elements in CQL library parameters.
BenefitPlanHedisProductLin
The product lines to use for this benefit plan in reporting.
PatientGenomicIndicato
The table contains information about your patient genomic indicator records.
RequisitionGrouperAddress
Address of the requisition grouper.
CareAreaTypeDefinitions
This table contains the care area types for the care area records.
QualityMeasureExpressions
Contains the expressions configured for a quality measure.
SurgicalLogStaffAssignmen
This table contains the line IDs (ORM) for the Surgical Staff Information of the Surgical Log (ORL).
InventoryGeneralLedgerDebitStringAttributes
Attributes and values for Willow Inventory GL debit strings.
QualityMeasureCqlDependentExpressions
This table contains the dependent expressions of a CQL named expression.
ResearchStudyStatusNotRecruiting
The research study statuses to be bucketed into Active - Not Recruiting.
ClinicalExceptionTyp
This table contains information on variance types (IGT records).
EncounterBenchmarkingPeerGroup
This table contains the Benchmarking peer groups associated with an encounter.
ReferralAuditTrailItemChang
The item being audited for the referral.
ProcedureAnatomicalRegion
The anatomical regions of which the procedure is related.
OrganCrossmatchResu
Organ crossmatch types and results.
ResearchStudyContac
This table contains research contacts listed in research studies.
HospitalTransactionRelatedDenials
Denial records associated with this payment for evaluating denial rate metrics.
LexiconConceptIden
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.
SurgicalCaseOrderLink
This table contains the IDs of the orders which were used to create a case.
RegistryMetricDefinition
List of metrics applicable to the registry. Every record in this registry will have these metrics tracked.
TransplantIntestineStatusHistory
This table contains the intestine status information for a transplant episode.
ReceivedDocumentEventProvid
The providers for an external event.
ClaimReferralLinkag
This table contains the referrals linked to AP claims.
BenefitPlanIden
Clarity extract table for Identity items in the Benefit Plan master file.
OperativeProcedurePerform
This table stores order performable information.
PharmacyClaimMedicationDetai
This table contains information for a single NDC code on a pharmacy claim.
DentalProcedureToothSurfaces
Table for the tooth surfaces on which a given dental procedure is performed.
ReceivedAllergyReaction
This table stores allergy reactions received from outside sources.
PatientOrderTemplateFrequencyOverrideT
Frequency override times
SpecimenAccessDepartmentLis
List of departments that should be able to access information about this specimen.
PurchaseOrderInvoicedItems
Stores the items invoiced for an inventory request.
ReferralReasonForVisi
Contains the reasons for each referral.
MedicationOrderIndication
This table stores the indications of use selected for a medication record.
RegistryAcuityScoreD
Extracted table for scoring system-related data from scoring system data filed to RDI.
GenomicSequencingDocumentOrd
This table contains order-level information associated with genomics sequencing documents.
ResearchStudyOtherProviders
This table contains other providers listed in research studies.
OphthalmologyVisitExamD
Stores ophthalmology exam information documented in the visit.
LabSubmitterAddress
Address of each submitter.
InterfaceProfileVariableValu
Profile variable values for an interface looking at the interface profile, system definition interface profile, interface kind, and variable defaults.
InpatientDeviceDataCaptu
This table contains device capture information for the given Inpatient Data (INP) record.
OrderAppointmentSerialNum
This table contains the appointment serial number of the appointments scheduled for an order.
DiagnosisRelatedGroupReferenc
This table contains information for the DRG (Diagnosis Related Groups) master file.
GoalContactHistory
This table contains contact specific data for the IGO (Discrete Goals) master file.
OperatingRoomCaseVirtualItems
The table contains virtual items for the OR management system case records.
FlowsheetDataCosignTimestamp
This table displays times that cosigners cosigned the flowsheet data.
VascularAnatomySystemDefinition
Table contains items that represents anatomy of body (vessel related items).
LabAnatomicPathologyCaseResponsiblePerson
Lab Anatomic Pathology case responsible person.
ClaimOtherPayorInformation
Information of other payors who paid the claim.
OperatingRoomSurgicalProcedureLog
The table contains OR management system log surgeons.
EncounterGoalOutcomeDocumentation
This table contains care plan goal records that have goal outcome documentation for a particular encounter.
SurgicalCaseImplantLink
This table contains the line IDs (ORM) for the implant information of the surgical/invasive procedure log (ORL).
BiopsyComplicationsResu
Complications from biopsy.
TableBackfillEventColumn
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.
QualityMeasureDataModelReturnElements
This table stores expression return element types if defined in a data model.
QualityMeasureCqlLibraryCodes
This table extracts the used codes for a CQL library.
LegacyParameterProfi
The table contains information from the extension master file.
GrouperAnalyticsContextAssignmen
The list of analytics contexts assigned to the groupers.
PatientGoalSourceTemp
This table contains information on the source goal templates for a patient goal or outcome.
TransactionRefundReason
Clarity table to hold the refund reason on the transactions (HTR). Only one refund reason is set for the transaction.
OrderSynopticResu
Synoptic result record table.
PharmacyInterventionOrderLink
This table is a list of orders that have been linked to a Pharmacy intervention.
PharmacyAddress
This table contains pharmacy addresses.
BedTurnaroundActivity
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.
ClinicalVarianceRecord
This table contains data on variance (IVR) records associated with a patient.
LabPathologyRequisitionCas
Lab Anatomic Pathology case information.
TransplantDonorRecoveredOrgan
This table contains the organs recovered from a donor.
MedicationPharmaceuticalClass
This table contains medications' pharmaceutical classes.
PharmacyClaimServiceLineDetai
This table contains service lines for pharmacy claims.
PatientAlcoholUseHistory
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.
ObstetricVertexCephalicPresentationTyp
This table contains the category values which correspond to a cephalic delivery presentation. It can also indicate which cephalic presentations are vertex.
AutomatedWaitListO
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.
BloodSuspectedReactionNegativeValu
This table holds values for the suspected reaction row (EMR_SYSTEM_DEFS.SUSP_REACT_FLO_MEAS_ID) that indicate no reason is suspected.
PatientHealthMaintenanceHistory
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.
LabRedrawNoFaultReason
This table contains one row for each lab redraw reason where the collecting user is considered not at fault.
ScheduledAppointmentInformation
This table contains information about appointments, with one row per appointment. It is derived from the table and contains columns simplifying common reporting needs.
UserActionLogLoginEven
This table stores user action log data about login events. Each row represents a login event.
OphthalmologyLeftEyeNegativeExamFinding
This table contains information on discrete pertinent negative exam findings in the physician exam for the left eye.
LaboratoryOrderInformation
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.
PatientFamilyMedicalHistory
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.
SystemDefinitionSettings
This table contains information from no-add, single-response items in EMR System Definitions.
InpatientDischargeDiagnosis
The table contains information on inpatient discharge diagnoses. Each record in this table is based on
LocationAttributedProviderGroup
This table contains information about the attributed provider groups to which the location belongs for a given date range.
AutoreconciledExternalProcedureMapping
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.
ObstetricPerinealLacerationDeg
This table contains the values which correspond to either third or fourth degree perineal lacerations.
PatientNoDrugAllergyStatus
This table holds data of whether the patient's allergies were marked as containing no drug allergies.
ClaimSharingServiceAreaBusinessSegmentConfiguration
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.
ComputerizedPhysicianOrderEntryPerProtocolOrderMod
This table indicates which order modes are considered per protocol. These orders will automatically be considered to be for the purposes of reporting.
PatientMasterPersonIndexHistory
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.
MedicationUnitConversionFacto
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.
OpioidExclusionDiagnosisGroup
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.
PatientScreeningProgramHistory
Contains information relevant to the patient's screening program history.
PainManagementMedicationConcepts
This table contains a list of different pain management-related medication concepts and medication groupers that contain the medication records belonging to each one.
AppointmentProviderLink
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.
UpcomingAppointmentQuestionn
Table to store the general questionnaire attached to upcoming appointment.
HomeHealthDisciplineMapping
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.
BloodWasteReturnedMedicationAdministrationRecordActionMapping
This table holds custom MAR actions that are mapped to blood waste and blood returned actions.
OphthalmologyRightEyeFormsIndex
This table holds information for the right eye ophthalmology forms index.
ObHistoryNeonatalDemiseCategories
Category values from I EPT 19472-"OB Hx Is Living" that indicate neonatal demise, as specified in I LSD 15527-"Neonatal Demise Category Values".
EncounterDiagnosis
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.
RegistryOverrideAuditHistory
The table contains the audit history for manual registry overrides for a given patient. Each row represents one change to a registry override.
ComputerizedPhysicianOrderEntryMetricConfiguration
This table contains configuration data to help interpret results for metrics.
PatientProblemListLink
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.
SurgicalLocationInformation
The table contains information about surgical, radiology, and invasive lab locations.
MyChartPatientActionTypeMapping
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.
MyChartSessionPatientAccessBridg
This table is used as a bridge table representing unique combinations of MyChart patient (WPR) records accessed during a given MyChart session.
ResearchStudyReportGrouperTyp
System defined report grouper types for research studies. The line numbers in this table are used to reference from RSH-3021.
OfficeOfManagementAndBudgetRaceMapping
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.
PatientRegistryMembership
This table extracts the registries on which each patient appears.
AdditionalVisitVolumeEncounterTypes
This table contains information about which additional encounter types are considered while processing visit volume metric data.
PatientCorrespondenceStreetAddress
This table stores the street address for the patient's correspondence address.
PatientEncounterVideoVisitContac
This table contains the video visit related data for a patient that is stored at the patient contact level.
PercutaneousCoronaryInterventionBalloonEquivalen
Intervention types configured as balloon-equivalent interventions for the purpose of the Door-to-Balloon metrics.
InstitutionalGuarantorAccountTypesByServiceA
This table lists out the guarantor account types that are considered institutional for each service area.
HomeHealthPatientCertificationPeriod
This table contains information for the cert period to which a Home Health contact belongs.
OrderTimedPriorityDefinition
This table contains one row for each order priority that should be considered a timed priority.
AppointmentWaitTimeEstim
This table saves the estimated wait times patients might see when they schedule appointments or during their visits.
PatientReportingValidity
The table contains one row for each patient in your system and indicates whether the patient is considered valid for reporting purposes.
AppointmentContactAuditActions
The PAT_ENC_ES_AUD_ACT table contains scheduling system's auditing of actions taken on appointment contacts.
PharmacyInventoryUpdateReasonConfiguration
Extracts balance update reason category configuration useful for reporting.
EncounterCorrespondenceLetters
The patient encounter letters table contains information about letters associated with encounters.
BloodProductConfiguration
This table holds configuration information for blood grouper records.
StillbirthReason
This table contains the values which correspond to a delivery not being a live birth.
CardiovascularPciCaseClassification
This table stores the case classification configuration options for the Door-to-Balloon metrics.
PrescriptionDrugMonitoringProgramReview
This item holds information on (Prescription Drug Monitoring Program) review.
HealthMaintenanceTopicStatus
This table contains information on the due status of health maintenance topics.
HematocritLabCommonN
This table holds lab components for hematocrit lab values.
SnomedConceptRelationship
This table contains the hierarchy. The data in this table is populated from the the ^HSNOMEDRel global.
FacilityContinuedCareServic
This table contains continued care services provided by facilities.
ObstetricsReportingElementGrouperMapping
Groupers for obstetrics reporting.
EnrollmentStatusPreEnrolledLis
Table contains list of enrollment statuses considered to be "pre-enrolled".
PatientHealthMaintenanceCurrentGuid
Health Maintenance Plans used during patient's last health maintenance update.
PatientHistoricalStreetAddress
This table extracts street addresses recorded in each patient's historical addresses.
PatientAuthorizedServiceA
The contains authorized service area information for the patient.
DeceasedDonorProcedures
The procedures available for a deceased organ donor.
HospitalAccountEndOfDayBalanc
This derived table extracts end of day items for Hospital Accounts.
PatientHistoricalAddress
This table extracts each patient's historical addresses.
MasterFileDictionary
This table contains dictionary information regarding every master file.
PatientTypeHistory
This table contains one record for each patient type for each patient.
PatientRacialIdentity
This table contains information on a patient's race.
HistoryAuditTrailI
History Audit Trail Items

AnesthesiaEncounterMetrics

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.

Column NameTypeDescription
AnesthesiaDurationMinutesNUMERICThis column contains the time in minutes between anesthesia start and anesthesia end for the primary surgical log. Rule: DM AN ANESTHESIA TIME (MINUTES) (89201)
IsCentralLineInInternalJugularVARCHARThis column contains Y if a central line was placed in the internal jugular, N if none of the central lines were placed in the internal jugular, or null if there were no central lines placed. Rule: DM AN CVC INSERTED IN INTERNAL JUGULAR (89251)
WasTransferredToIntensiveCareUnitNUMERICThis column contains 1 if there was a documented ICU admission on the anesthesia encounter after the patient left the operating room, or 0 if there was not. Rule: DM AN TRANSFER TO ICU (89043)
MultimodalAnesthesiaEvaluationStatusINTEGERThis column contains 1 (Pass) if the multimodal anesthesia was used, 2 (Exclude) if the patient was allergic to multiple classes of analgesic medications, or 0 (Fail) if neither of those is true. It may contain null if insufficient documentation exists to make a determination, such as if the patient's In Room time has not yet been documented. Rule: DM AN Multimodal Analgesia Evaluation (89243)
AnesthesiaRegistryRecordIdentifierNUMERICThis column contains the unique identifier (.1 item) for the registry data record.
PneumothoraxRequiringThoracostomyNUMERICThis column contains 1 if pneumothorax requiring thoracostomy was documented, or null if it was not. Rule: DM AN PNEUMOTHORAX REQUIRING THORACOSTOMY PLACEMENT (89160)
HasPediatricAccidentalPunctureOrLacerationVARCHARThis column contains Y if a patient has a secondary diagnosis code for accidental puncture or laceration during a procedure or N if they do not. The column also contains null for the following condition: The patient has surgical or medical discharges defined by AHRQ; obstetric discharges, spinal surgery discharges, discharges with accidental puncture or laceration as a principal diagnosis, discharges with accidental puncture or laceration as a secondary diagnosis that is present on admission, normal newborns, and neonates with birth weight less than 500 grams. Rule: DM AN AHRQ PEDS ACCIDENTAL PUNCTURE OR LACERATION (89557)
IsMonitoredAnesthesiaCareVARCHARThis column contains Y if monitored anesthesia care was performed or N if not. Rule: DM AN ANESTHESIA TYPE - MONITORED ANESTHESIA CARE (89163)
TotalSevofluraneVolumeNUMERICThis column displays the total estimated volume in liters of sevoflurane gas administered during anesthesia. Rule: DM AN TOTAL SEVOFLURANE VOLUME (L) (89245)
AnesthesiaCaseDelayReasonINTEGERThis column contains the reason for which the case was delayed. Rule: DM AN CASE DELAY REASON (89559)
HasCatheterAssociatedBloodstreamInfectionIndicatorVARCHARThis column displays Y if a patient has a secondary diagnosis of vascular catheter-associated infection or N if they do not. Rule: DM AN CMS HAC CENTRAL VENOUS CATHETER-RELATED BLOOD STREAM INFECTION (89582)
HasOtherHospitalAcquiredComplicationIndicatorVARCHARThis column contains Y if the patient has another complication other than the ones PSH is specifically tracking and null otherwise. Rule: DM AN OTHER COMPLICATION (89675)
FirstPostAnesthesiaCareUnitPainScoreNUMERICThis column contains the first pain score recorded in the PACU. If the value is outside the 0-10 range, the column will contain null. Rule: DM AN FIRST PACU PAIN SCORE (89028)
IntraprocedureMorphineEquivalentDoseMilligramsNUMERICThis column contains the total calculated morphine equivalent dose for the intraprocedure time period. Rule: DM AN MORPHINE EQUIVALENT DOSE IN MG - INTRAPROCEDURE (89216)
AnesthesiaCptIICode4554FIndicatorNUMERICThis column contains 1 if the given anesthesia encounter can be coded for CPT Code 4554F, or null if it cannot. Rule: DM AN CPT II CODE 4554F (89078)
WasCardiacBypassDocumentedNUMERICThis column contains 1 if cardiac bypass was documented, or null if it was not. Rule: DM AN CARDIAC BYPASS (89034)
WasInhalationalAnestheticUsedForInductionOnlyIndicatorVARCHARThis column contains Y if the patient was given an inhalational anesthetic for induction only or null if they were not. Rule: DM AN INHALATIONAL ANESTHETIC USED ONLY FOR INDUCTION (89340)
CaseRecordContainsSupersededAdHocNUMERICThis column contains 1 if the case record contains a superceded ad hoc, or 0 if it does not. Rule: DM AN CASE CONTAINS SUPERCEDED AD HOC (89204)
DiagnosisListIcd9VARCHARThis column contains a semicolon-delimited list of patient diagnoses in the ICD-9 term set with ranks appended after a hyphen. Rule: DM AN DIAGNOSIS LIST ICD-9 (89057)
TotalMorphineEquivalentDose48HourPostprocedureNUMERICThis column contains the total calculated morphine equivalent dose from the end of anesthesia up to 48 hours postprocedure. Rule: DM AN MORPHINE EQUIVALENT DOSE IN MG - 48 HOURS POSTPROCEDURE (89239)
AnesthesiaQualityMeasureAsa20ACodeApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA20A Code, or null if it cannot. Rule: DM AN ASA CODE ASA20A (89109)
AdministrationOfNk1ReceptorAntagonistNUMERICThis column contains 1 if the patient received an administration of NK1 receptor antagonists during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC NK1 RECEPTOR ANTAGONIST (89260)
TotalAnesthesiaIsofluraneVolumeInLitersNUMERICThis column displays the total estimated volume in liters of isoflurane gas administered during anesthesia. Rule: DM AN TOTAL ISOFLURANE VOLUME (L) (89246)
IsAnesthesiaCodeableAsa15bNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA15B Code, or null if it cannot. Rule: DM AN ASA CODE ASA15B (89103)
PreviousIntubationIndicatorNUMERICThis column contains 1 if the patient was previously intubated (not specifically for the procedure), or 0 if they were not. Rule: DM AN PREVIOUS INTUBATION (89048)
ChecklistUsedPriorToInductionNUMERICThis column contains 1 if a WHO checklist or similar safety checklist was used prior to induction, or null if there was not. Rule: DM AN CHECKLIST USED PRIOR TO INDUCTION (89263)
AnesthesiaMetricRegistryIdentifierNUMERICThis column contains the unique identifier (.1 item) for the registry data record.
AnesthesiaBillingPatientClassVARCHARThis column contains the ADT patient class on the billing encounter associated with the anesthesia episode. Rule: DM AN PATIENT CLASS (89214)
DocumentedAnesthesiologistsListVARCHARThis column contains all anesthesiologists with time documented on the anesthesia record in a semicolon-delimited list, or null if there are none documented. Rule: DM AN ALL ANESTHESIOLOGISTS (89164)
PostAnesthesiaCareUnitDepartureDateTimeDATETIMEThis column contains the documented instant at which the patient left the PACU. Rule: DM AN OUT OF PACU INSTANT (89021)
PatientOnClinicalPathwayIndicatorVARCHARThis column contains Y if the patient is on or has completed a clinical pathway or null if the patient has not. Rule: DM AN PSH PROTOCOL STATUS (89326)
HasPoorGlycemicControlDuringHospitalStayIndicatorVARCHARThis column contains Y if a patient has a secondary diagnosis of poor glycemic control during hospital stay or N if they do not. Rule: DM AN CMS HAC MANIFESTATIONS OF POOR GLYCEMIC CONTROL (89669)
IsNonDepolarizingNeuromuscularBlockerAdministeredDuringAnesthesiaVARCHARThis column contains a Y if it was documented that the patient received a non-depolarizing neuromuscular blocking agent between Anesthesia Start and Stop, or null if they did not. Rule: DM AN NON-DEPOLARIZING NEUROMUSCULAR BLOCKER ADMINISTERED (89196)
HasPediatricWoundDehiscenceHospitalAcquiredConditionVARCHARThis column contains Y if a patient has a diagnosis code of disruption of internal surgical wound with a reclosure procedure or N if they do not. This column contains null for the following conditions: The patient does not have an abdominopelvic procedure; cases with a principal or secondary diagnosis code present on admission for disruption of internal operation wound, cases with any procedure codes for gastroschisis or umbilical hernia repair in newborns performed before abdominal wall reclosure, cases with any-listed diagnosis codes and any-listed procedure codes for a high-risk immunocompromised state, including transplant, with any-listed diagnosis codes for an intermediate-risk immunocompromised state, cirrhosis and hepatic failure, cases with stays less than two days, neonates with birth weight less than 500 grams, and obstetric cases. Rule: DM AN AHRQ PEDS WOUND DEHISCENCE (POSTOPERATIVE) (89627)
IsHospitalAcquiredHemorrhageOrHematomaVARCHARThis column contains Y if a patient has perioperative hemorrhage, hematoma with control of perioperative hemorrhage, drainage of hematoma, or miscellaneous hemorrhage- or hematoma-related procedure following surgery documented in their hospital accounts or N if they do not. This column contains null for the following conditions: The patient has surgical discharges defined by AHRQ with any operating room procedure; cases with a diagnosis of coagulation disorder and cases with a diagnosis of perioperative hemorrhage or hematoma, and cases where the only procedure was one of the above-mentioned cases. Rule: DM AN AHRQ HEMORRHAGE OR HEMATOMA (PERIOPERATIVE) (89606)
HospitalDischargeCodeVARCHARThis column contains the hospital discharge code. Rule: DM AN HOSPITAL DISCHARGE CODE (89438)
PatientReceivedNeuromuscularBlockerAntagonistBenchmarkNumeratorNUMERICThis column displays 1 if the patient falls into the numerator of the neuromuscular blocker antagonist benchmark, or 0 if they do not. Rule: DM AN PATIENT RECEIVED NEUROMUSCULAR BLOCKER ANTAGONIST BENCHMARK NUMERATOR (89311)
WasGlucoseManagementEducationOfferedIndicatorVARCHARThis column contains Y if documentation exists indicating the patient was offered blood glucose management education. Rule: DM AN POSTOPERATIVE GLUCOSE MANAGEMENT EDUCATION PROVIDED (89600)
IsAsaCode12BApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA12B Code, or null if it cannot. Rule: DM AN ASA CODE ASA12B (89128)
AnesthesiaCptCode0581FEligibleFlagNUMERICThis column contains 1 if the given anesthesia encounter can be coded for CPT Code 0581F, or null if it cannot. Rule: DM AN CPT II CODE 0581F(89009)
AnesthesiaProfessionalBillingChargesListVARCHARThis column contains a semicolon-delimited list of professional billing charges for the anesthesia encounter. This includes non-billed codes, supply charges, HCPCS codes, and modifiers. Rule: DM AN PROFESSIONAL BILLING CHARGES (89039)
ReasonMedicationListNotReviewedNUMERICThis column contains 1 if there is documentation stating the current medication list was not reviewed due to an exclusion, or null if there is not. Rule: DM AN REASON MEDICATION LIST NOT REVIEWED (89117)
AnesthesiaEpisodeIdentificationNUMERICThis column contains the anesthesia episode ID. Rule: DM AN EPISODE ID (89006)
SurgicalRecoveryDurationMinutesNUMERICThis column contains the time in minutes between in recovery and out of recovery for the primary surgical log. Rule: DM AN RECOVERY TIME (MINUTES) (89208)
IsAsaCode14HApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA14H Code, or null if it cannot. Rule: DM AN ASA CODE ASA14H (89099)
BilledProcedureEmergentStatusNUMERICThis column contains 1 if the procedure was documented as emergent in anesthesia professional billing information, or 0 if it was marked as non-emergent. Rule: DM AN BILLED EMERGENT STATUS (89119)
IsCentralLinePlacedNUMERICThis column contains 1 if the patient had a central line placed, or 0 if they did not. Rule: DM AN CENTRAL LINE PLACED (89031)
PediatricHospitalAcquiredPostoperativeSepsisIndicatorVARCHARThis column contains Y if a patient has any secondary diagnosis codes for sepsis or N if they do not. This column contains null for the following conditions: The patient has a medical discharge defined by AHRQ with an elective admission and an operating room procedure; cases with a principal diagnosis of sepsis, cases with a secondary diagnosis of sepsis present on admission, cases with a principal diagnosis of infection, cases in which the procedure belongs to surgical class 4, neonates and obstetric cases. Rule: DM AN AHRQ PEDS SEPSIS (POSTOPERATIVE) (89617)
TotalPostoperativeNauseaVomitingRiskFactorsNUMERICThis column contains the patient's total number of risk factors for PONV. The column will contain 0 if no risk factors are documented.The risk factors include patient sex, history of motion sickness, history of PONV, smoking status, and intended opioid administration during intra-procedure or post-procedure care. Rule: DM AN TOTAL NUMBER OF RISK FACTORS FOR PONV (89080)
IsAnesthesiaEncounterCodedForCpt4556fFlagNUMERICThis column contains 1 if the given anesthesia encounter can be coded for CPT Code 4556F, or null if it cannot. Rule: DM AN CPT II CODE 4556F (89084)
ObstructiveSleepApneaRiskIndicatorVARCHARThis column displays Y if the patient had a positive screen for obstructive sleep apnea or N if the screen was negative. The column will contain null if the patient was not screened. Rule: DM AN HAS RISK OF OBSTRUCTIVE SLEEP APNEA (89465)
DeprecatedAnesthesiaBillingUnitsNUMERICThis column is being deprecated in a future version and should not be used. It is being replaced by column BILLING_UNITS (RDT/230) in table DM_ANESTHESIA.
IsAsa10BCodeApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA10B Code, or null if it cannot. Rule: DM AN ASA CODE ASA10B (89133)
BetaBlockerNotGivenMedicalReasonNUMERICThis column contains 1 if there was a medical reason for not giving a beta blocker 24 hours prior to incision, or null if there was not. Rule: DM AN BETA BLOCKER NOT GIVEN FOR MEDICAL REASONS (89112)
PostProcedureDeliriumIndicatorNUMERICThis column contains 1 if the patient had postprocedure delirium documented, or 0 if they did not. Rule: DM AN POSTPROCEDURE DELIRIUM (89135)
AnesthesiaRegistryStatusINTEGERThis column contains 1 if the status of the registry data is active, or 2 if it is inactive.
HospitalRecoveryStayDurationInDaysNUMERICThis column contains the number of days between the anesthesia stop date and discharge date (inclusive of both dates). If the anesthesia stop and discharge dates are the same day this column contains 1. If either the anesthesia stop date or discharge date does not exist this column contains 0. Rule: DM AN DURATION OF HOSPITAL RECOVERY STAY (89671)
AntiemeticGlucocorticoidAdministrationFlagNUMERICThis column contains 1 if the patient received an administration of antiemetic glucocorticoids during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC GLUCOCORTICOIDS (89162)
HasSurgicalWoundDehiscenceVARCHARThis column contains Y if a patient has a diagnosis code of disruption of internal surgical wound with a reclosure procedure or N if they do not. This column contains null for the following conditions: The patient does not have an adominopelvic procedure for wound dehiscence; cases with an immunocompromised state, cases with stays less than two days, and obstetric cases. Rule: DM AN AHRQ WOUND DEHISCENCE (POSTOPERATIVE) (89652)
AnesthesiaEmergenceDateTimeDATETIMEThis column contains the documented instant of emergence. Rule: DM AN EMERGENCE INSTANT (89017)
PatientBirthDateDATETIMEThis column contains the patient's date of birth. Rule: DM GENERAL BIRTH DATE (82013)
PatientSexVARCHARThis column contains the sex of the patient. Rule: DM IP PATIENT SEX (84046)
AnesthesiaComplicationsIndicatorNUMERICThis column contains 1 if there were any anesthesia complications documented, 0 if there were not, or null if no complication documentation was found. Rule: DM AN ANESTHESIA COMPLICATIONS (89037)
WasNeuromuscularBlockerAdministeredNUMERICThis column displays 1 if it was documented that the patient received a neuromuscular blocker between Anesthesia Start and Stop, or 0 if they did not. Rule: DM AN NEUROMUSCULAR BLOCKER ADMINISTERED NON-DEFASCICULATING DOSES (89289)
PatientHeightInchesFLOATThis column contains the patient's height in inches. Rule: DM AN PATIENT HEIGHT (89545)
IsEligibleForHcpcsG9658NUMERICThis column contains 1 if the given anesthesia encounter can be coded for HCPCS Code G9658, or null if it cannot. Rule: DM AN HCPCS CODE G9658 (89169)
AnesthesiaTypesVARCHARThis column contains the anesthesia types documented on the anesthesia record, delimited by semicolons. Rule: DM AN ANESTHESIA TYPE (89072)
PatientInstructedNotToSmokeByAnesthesiaPriorToSurgeryIndicatorVARCHARThis column displays Y if patient was seen prior to the day of surgery by anesthesia or proxy and instructed not to smoke or null if the patient was not. Rule: DM AN PATIENT HAD PRE-ANESTHESIA VISIT WITH SMOKING INSTRUCTION (89234)
IsBenzodiazepineAdministeredDuringAnesthesiaNUMERICThis column displays 1 if it was documented that the patient received benzodiazepine between Anesthesia Start and Stop, or 0 if they did not. Rule: DM AN BENZODIAZEPINE ADMINISTERED (89304)
HistoryOfDiabetesNUMERICThis column contains 1 if the patient has diabetes documented in their medical history, problem list, or anesthesia preevaluation note. Otherwise, this column contains null. Rule: DM AN HX OF DIABETES (89206)
NeuraxialOrPeripheralNerveBlockEvaluationStatusINTEGERThis column contains 1 if the patient received a neuraxial or peripheral nerve block, 2 if there was a patient reason for not doing so, or 0 otherwise. Rule: DM AN NEURAXIAL ANESTHESIA OR PERIPHERAL NERVE BLOCK EVALUATION (89470)
TotalAnesthesiaFreshGasFlowDurationMinutesNUMERICThis column displays the total estimated time in minutes that fresh gas flow was on during anesthesia. Rule: DM AN TOTAL FRESH GAS FLOW TIME (89368)
IntraoperativeVasodilatorAdministrationIndicatorNUMERICThis column contains 1 if the patient received an administration of vasodilators during intraprocedure care, or null if they did not. Rule: DM AN INTRAPROCEDURE ADMINISTRATION OF VASODILATORS (89142)
AllStudentRegisteredNurseAnesthetistsVARCHARThis column contains all SRNAs with time documented on the anesthesia record in a semicolon-delimited list, or null if there are none documented. Rule: DM AN ALL SRNAS (89167)
PrimaryProcedureOperatingRoomProviderIdentifierVARCHARThis column contains the SER ID of the operating room in which the primary procedure was performed. Rule: DM AN OPERATING ROOM (89075)
PrimaryProcedureHcupGrouperIdentificationVARCHARThis column contains the grouper (VCG) ID that the primary procedure (ORP) on the primary log is associated with or null if the procedure is not associated with any grouper. Rule: DM AN HCUP PROCEDURE GROUP FOR PRIMARY PROCEDURE (89325)
AnesthesiaCodingLagDaysNUMERICThe column contains the number of days from the date of service of the anesthesia record to the date when the professional charges were posted to the guarantor account. Rule: DM AN CODING LAG DAYS (89154)
FirstPostProcedureCoreTemperatureNUMERICThis column contains the core temperature upon entry to PACU (In Recovery) or after Out of Room for patients transferred directly to ICU, or null if it is not documented. Rule: DM AN POSTPROCEDURE CORE TEMPERATURE UPON ENTRY TO ICU/PACU (89136)
IsOnAnticoagulantOrAntiplateletMedicationFlagVARCHARThis column contains Y if the patient is on anticoagulant or antiplatelet medications or N if not. Rule: DM AN PATIENT ON ANTICOAGULANTS OR ANTIPLATELET MEDICATIONS (89259)
AnesthesiaInductionToEmergenceDurationMinutesNUMERICThis column contains the length of time that occurred between the induction and emergence events in minutes. Rule: DM AN TIME FROM INDUCTION TO EMERGENCE (89262)
AnesthesiaCaseLocationsVARCHARThis column contains the locations of the cases associated with the anesthesia record in a semicolon-delimited string. Rule: DM AN CASE LOCATIONS (89122)
HadCentralLinePlacementInjuryVARCHARThis column contains Y if the patient had a central line placement injury that results from an attempted or completed insertion of a central venous catheter or null if the patient did not. A central line placement Injury includes a pneumothorax, hemothorax or thoracic duct, cardiac or vascular injury that results from an attempted or completed insertion of a central venous catheter. Rule: DM AN CENTRAL LINE PLACEMENT INJURY (89338)
AntiemeticPhenothiazineAdministeredFlagNUMERICThis column contains 1 if the patient received an administration of antiemetic phenothiazines during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC PHENOTHIAZINES (89065)
DataExtractionDateDATETIMEThis column contains the date the current row's values were extracted.
PrimaryPayerFinancialClassVARCHARThis column contains the financial class of the patient's primary payer for the encounter. Rule: DM AN PRIMARY PAYER FINANCIAL CLASS (89102)
PatientPostalCodeVARCHARThis column contains the patient's postal code. Rule: DM IP PATIENT ZIP CODE (84041)
TotalPostoperativeVisionLossRiskFactorsNUMERICThis column contains the patient's total number of risk factors for POV. The column will contain 0 if no risk factors are documented. The risk factor is calculated based on procedure length, patient age, professional billing charges, and family history of POV. Rule: DM AN TOTAL NUMBER OF RISK FACTORS FOR POV (89108)
EncounterDifficultIntubationFlagNUMERICThis column contains 1 if the patient had a difficult intubation documented in the current anesthesia encounter, or null if they did not. Rule: DM AN DIFFICULT INTUBATION (THIS ENCOUNTER) (89211)
PharmacologicProphylaxisMedicalExclusionReasonNUMERICThis column contains 1 if there was a medical reason for not administering pharmocologic prophylaxis, or null if there was not. Rule: DM AN MEDICAL REASON FOR NOT ADMINISTERING PHARMACOLOGIC PROPHYLAXIS (89061)
AnesthesiaStartInstantDATETIMEThis column contains the instant at which anesthesia start was documented. Rule: DM AN ANESTHESIA START INSTANT (89013)
PreprocedureMorphineEquivalentDoseMilligramNUMERICThis column contains the total calculated morphine equivalent dose for the preprocedure time period. Rule: DM AN MORPHINE EQUIVALENT DOSE IN MG - PREPROCEDURE (89215)
DeprecatedPeripheralNerveBlockPerformedIndicatorNUMERICThis column contains 1 if a peripheral nerve block was performed on the patient or 0 if not. It is suggested to use DM_ANESTHESIA_2.PERIPHERAL_NERVE_BLOCK_YN instead of this column. Rule: DM AN ANESTHESIA TYPE - PERIPHERAL NERVE BLOCK (89114)
ProcedureStartInstantDATETIMEThis column contains the documented instant of procedure start. Rule: DM AN PROCEDURE START INSTANT (89073)
HospitalAcquiredAccidentalPunctureLacerationIndicatorVARCHARThis column contains Y if a patient requires a second abdominopelvic procedure one or more days after the index procedure or N if they do not. This column contains null for the following conditions: The patient has a medical or surgical discharge defined by AHRQ with an abdominopelvic procedure; cases with accidental puncture or laceration as a principal diagnosis or a secondary diagnosis that is present on admission, and obstetric cases. Rule: DM AN AHRQ ACCIDENTAL PUNCTURE OR LACERATION (89662)
IsTrainOfFourBenchmarkDenominatorVARCHARThis column displays Y if the patient falls into the denominator of the train of four benchmark, or N if they do not. Rule: DM AN TRAIN OF FOUR BENCHMARK DENOMINATOR (89197)
TotalIsofluraneAdministrationDurationNUMERICThis column displays the total estimated time in minutes that isoflurane gas was on during anesthesia. Rule: DM AN TOTAL ISOFLURANE TIME (89361)
HospitalAcquiredHipFractureSecondaryDiagnosisIndicatorVARCHARThis column contains Y if a patient has a secondary diagnosis of hip fracture that is not present on admission or N if they do not. This column contains null for the following conditions: The patient has a surgical or medical discharge defined by AHRQ with any operating room procedure; cases that are susceptible to falling (seizure disorder, syncope, stroke, occlusion of arteries, coma, cardiac arrest, poisoning, trauma, delirium or other psychoses, anoxic brain injury, metastatic cancer, lymphoid malignancy, bone malignancy, disorders of the musculoskeletal system, and disorders of connective tissue), cases with self- inflicted injury, cases with a principal diagnosis of hip fracture, cases with a secondary diagnosis of hip fracture present on admission, and obstetric cases. Rule: DM AN AHRQ HIP FRACTURE (POSTOPERATIVE) (89592)
PatientIsSmokerFlagNUMERICThis column contains 1 if the patient is a smoker (e.g. cigarette, cigar, pipe, e-cigarette, or marijuana). Rule: DM AN PATIENT SMOKING STATUS (89062)
HandoffChecklistNotUsedForMedicalReasonIndicatorNUMERICThis column contains 1 if there was a medical reason for not using a handoff checklist to PACU or ICU, or null if there was not. Rule: DM AN CHECKLIST AT HANDOFF NOT USED FOR MEDICAL REASON (89261)
IntraoperativeAntithrombinIIIAdministrationIndicatorNUMERICThis column displays 1 if the patient received an administration of antithrombin III during intraprocedure care, or null if they did not. Rule: DM AN INTRAPROCEDURE ADMINISTRATION OF ANTITHROMBIN III (89147)
WasPostProcedureHandoffChecklistUsedNUMERICThis column contains 1 if a checklist was used to facilitate care handoff following a procedure, or null if it was not. Rule: DM AN CHECKLIST USED (89005)
IsEligibleForAnesthesiaCodeASA13JNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA13J Code, or null if it cannot. Rule: DM AN ASA CODE ASA13J (89172)
CaseClassificationINTEGERThis column contains the case classification of the primary procedure, or null if it is not documented. Rule: DM AN CASE CLASSIFICATION (89041)
ProcedureEndInstantDATETIMEThis column contains the documented instant of procedure end. Rule: DM AN PROCEDURE END INSTANT (89074)
IsAnesthesiaEncounterInMortalityBenchmarkDenominatorNUMERICThis column contains 1 if the anesthetic record qualifies for the denominator of the all-cause mortality benchmark or 0 if it does not. Rule: DM AN ALL-CAUSE MORTALITY IN 48 HOURS DENOMINATOR (89321)
PatientIdentificationVARCHARThis column contains the unique ID of the patient record for this row. It is frequently used to link to the PATIENT table. This column holds the ID as of when the row was extracted. If the patient was merged or unmerged after this record was deleted from Chronicles, this PAT_ID may not reflect the current ID of the patient. To reference the current ID of the patient, use the PAT_ID column in the PAT_ENC table. Join to the PAT_ENC table on the CSN columns in each table.
CoronaryArteryBypassGraftPostProcedureStrokeIndicatorNUMERICThis column contains 1 if the patient had a stroke following the procedure, or null if they did not. Rule: DM AN CABG STROKE (89266)
NumberOfRescueAntiemeticDosesInPostAnesthesiaCareUnitNUMERICThis column displays the number of documented doses of rescue antiemetic medications given to the patient in PACU, or null if the patient was never documented as going to the PACU. Rule: DM AN NUMBER OF RESCUE ANTIEMETIC DOSES IN PACU (89313)
TotalIntraprocedureBloodLossVolumeNUMERICThis column returns the total blood loss in mL administered during anesthesia intraprocedure. Rule: DM AN TOTAL BLOOD LOSS (mL) (89248)
AmbulatoryHyperglycemiaControlEvaluationINTEGERThis column contains an evaluation of hyperglycemia control during ambulatory procedures. If the patient became hyperglycemic (blood glucose > 180 mg/dL) during the procedure and insulin was given, the value will be 1. If there was a medical reason insulin was not given in this scenario, the value will be 2. If insulin was not given to a hyperglycemic patient and no reason was given, the value will be 0. Rule: DM AN HYPERGLYCEMIA CONTROL EVALUATION (89596)
IatrogenicPneumothoraxWithVenousCatheterizationIndicatorVARCHARThis column displays Y if a patient has a secondary diagnosis of postoperative pneumothorax or an iatrogenic pneumothorax procedure or N if they do not. Rule: DM AN CMS HAC IATROGENIC PNEUMOTHORAX WITH VENOUS CATHETERIZATION (89572)
LastSugammadexAdministrationInstantDATETIMEThis column displays the instant of the last administration of sugammadex from a grouper of medication records or null if it was not administered. Rule: DM AN INSTANT OF LAST SUGAMMADEX ADMIN (89713)
IsFiveHydroxytryptamineAdministeredNUMERICThis column contains 1 if the patient received an administration of 5-hydroxytryptamine during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN DOCUMENTED PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC 5-HYDROXYTRYPTAMINE (89063)
DataExtractionDateDATETIMEThis column contains the date the current row's values were extracted.
PatientAdmissionDateTimeDATETIMEThis column displays the date and time of admission for the patient, or null if it is not documented. Rule: DM AN PATIENT ADMISSION DATE AND TIME (89149)
HasHistoryOfPostoperativeNauseaAndVomitingNUMERICThis column contains 1 if the patient has a history of postoperative nausea and vomiting, or null if they do not. Rule: DM AN HISTORY OF PONV (89059)
FirstPerioperativeInsulinAdministrationInstantDATETIMEThis column contains the date and time of the first insulin dose during the perioperative period. Rule: DM AN FIRST PERIOPERATIVE INSULIN ADMINISTRATION INSTANT (89563)
AnesthesiaEpisodeIdentificationNUMERICThis column contains the anesthesia episode ID. Rule: DM AN EPISODE ID (89006)
PatientMedicationListReviewedStatusNUMERICThis column contains 1 if the PTA medications were marked as reviewed, or null if they were not. Rule: DM AN MEDICATION LIST REVIEWED (89116)
HighestBloodGlucoseBeforeAnesthesiaStopNUMERICThis column contains the highest blood glucose lab result taken before the Anesthesia Stop time. Rule: DM AN HIGHEST SERUM GLUCOSE PRIOR TO ANESTHESIA STOP (mg/dL) (89599)
IsAsaCodeFifteenAApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA15A Code, or null if it cannot. Rule: DM AN ASA CODE ASA15A (89101)
WasAntiemeticAntihistamineAdministeredNUMERICThis column contains 1 if the patient received an administration of antiemetic antihistamines during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC ANTIHISTAMINE (89068)
AntiemeticSteroidAdministrationFlagNUMERICThis column contains 1 if the patient received an administration of antiemetic steroids during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN DOCUMENTED PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC STEROIDS (89064)
ArterialInjuryDocumentedFlagNUMERICThis column contains 1 if an arterial injury was documented, or null if one was not. Rule: DM AN ARTERIAL INJURY (89026)
PatientSmokedOnDayOfServiceIndicatorVARCHARThis column contains Y if the patient smoked on the day of service or null if the patient did not. Rule: DM AN PATIENT SMOKED ON DAY OF SERVICE (89235)
WasGeneralAnesthesiaAdministeredIndicatorVARCHARThis column contains Y if general anesthesia was performed or N if not. Rule: DM AN ANESTHESIA TYPE - GENERAL ANESTHESIA (89176)
IsCatheterAssociatedUrinaryTractInfectionHospitalAcquiredConditionVARCHARThis column contains Y if a patient has a secondary diagnosis of catheter-associated urinary tract infection or N if they do not. Rule: DM AN CMS HAC CATHETER-ASSOCIATED URINARY TRACT INFECTION (89673)
WasPacuOpioidReversalAdministeredNUMERICThis column displays 1 if it was documented that the patient received an administration of opioid reversals in PACU, or 0 if they did not. Rule: DM AN OPIOID REVERSAL ADMINISTERED IN PACU (89301)
AnesthesiaCodeAsa11bIndicatorNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA11B Code, or null if it cannot. Rule: DM AN ASA CODE ASA11B (89127)
PostAnesthesiaCareUnitHoldDurationMinutesNUMERICThis column contains the time in minutes between Ready for Discharge From Recovery and Out of Recovery for the primary surgical log, or null if there are not two documented times. Rule: DM AN PACU HOLD TIME (MINUTES) (89228)
WasExposureKeratitisDocumentedNUMERICThis column contains 1 if exposure keratitis was documented following the procedure, or null if it was not. Rule: DM AN EXPOSURE KERATITIS (89159)
SupplementalProfessionalChargeTotalNUMERICThis column contains the total of supplemental professional charges for the anesthesia record. Rule: DM AN PROFESSIONAL CHARGE TOTAL (89156)
AveragePostAnesthesiaCareUnitAntiemeticBenchmarkNumeratorNUMERICThis column displays the number of rescue antiemetic doses the patient received in PACU if the patient falls in the numerator of the PACU rescue antiemetic benchmark, or 0 if they do not. Rule: DM AN AVERAGE NUMBER OF RESCUE ANTIEMETIC DOSES IN PACU BENCHMARK NUMERATOR (89314)
BilledProcedureAnesthesiaCrosswalkCodeVARCHARThis column contains the ASA crosswalk CPT codes for the anesthesia procedure that was billed, delimited by semicolons. Rule: DM AN BILLED PROCEDURE ASA CODE (89045)
PatientCountryOfResidenceVARCHARThis column contains the patient's country. Rule: DM AN PATIENT COUNTRY (89547)
PreliminaryCauseOfDeathDiagnosisIdentifierNUMERICThis column contains the preliminary cause of death. Rule: DM AN CAUSE OF DEATH (89753)
HospitalizationDurationDaysNUMERICThis column contains the number of days between admission date and discharge date (inclusive of both dates). If the admit and discharge dates are the same day, this column contains 1. If either the admission date or discharge date does not exist, this column contains 0. Rule: DM AN DURATION OF HOSPITAL STAY (89670)
TotalBilledAnesthesiaUnitsNUMERICThis column contains the total number of billed anesthesia units for the anesthesia record. Rule: DM AN PROFESSIONAL BILLING UNITS (89152)
PhaseTwoEntryInstantDATETIMEThis column contains the documented instant at which the patient entered Phase II. Rule: DM AN PATIENT IN PHASE II INSTANT (89077)
IsAnesthesiaEncounterCptCode4255FNUMERICThis column contains 1 if the given anesthesia encounter can be coded for CPT Code 4255F, or null if it cannot. Rule: DM AN CPT II CODE 4255F (89087)
BenzodiazepineReversalInPacuBenchmarkDenominatorIndicatorNUMERICThis column displays 1 if the patient falls into the denominator of the Benzodiazepine reversal given in PACU benchmark, or 0 if they do not. Rule: DM AN BENZODIAZEPINE REVERSAL IN PACU BENCHMARK DENOMINATOR (89307)
AnesthesiaProfessionalChargeTotalNUMERICThis column contains the total of professional charges for the anesthesia record. Rule: DM AN PROFESSIONAL CHARGE TOTAL (89155)
AdministeredAntiemeticAnticholinergicIndicatorNUMERICThis column contains 1 if the patient received an administration of antiemetic anticholinergics during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC ANTICHOLINERGIC (89069)
TotalNitrousOxideVolumeNUMERICThis column returns the total estimated N2O volume in liters documented in anesthesia intraprocedure. Rule: DM AN TOTAL N2O GAS VOLUME (L) (89371)
PatientStopBangScoreINTEGERThis column contains the patient's STOP-Bang score as assessed for this encounter. Rule: DM AN STOP-BANG SCORE (89463)
PatientEnteredOperatingRoomDateTimeDATETIMEThis column contains the documented instant at which the patient entered the operating room. Rule: DM AN IN ROOM INSTANT (89018)
AnesthesiaBilledAsaScoreVARCHARThis column contains the ASA score (aka physical status) of the patient as entered in anesthesia professional billing information and mapped in LSD 89240 as a category value of HCT 50005, or null if it was not documented. Rule: DM AN BILLED ASA SCORE (89118)
WasSpinalBlockPerformedVARCHARThis column contains Y if a spinal block was performed or N if not. Rule: DM AN ANESTHESIA TYPE - SPINAL BLOCK (89224)
PreexistingEyeTraumaIndicatorNUMERICThis column contains 1 if the patient had pre-existing eye trauma prior to the procedure, or null if they did not. Rule: DM AN PRE-EXISTING EYE TRAUMA (89265)
LastNonDepolarizingNeuromuscularBlockerAdministrationInstantDATETIMEThis column displays the instant of the last non-depolarizing neuromuscular blocker administration or null if it was not administered. Rule: DM AN INSTANT OF LAST NEUROMUSCULAR BLOCKER ADMIN (89712)
AnesthesiaProcedureRevenueLocationIdentifierNUMERICThis column contains the revenue location in which the anesthesia procedure was performed. Rule: DM AN REVENUE LOCATION (89011)
IsPediatricHospitalAcquiredOtherComplicationVARCHARThis column contains Y if the patient has another complication other than the ones PSH is specifically tracking and null otherwise. Rule: DM AN PEDS OTHER COMPLICATION (89677)
AnesthesiaPropofolInfusionAdministeredNUMERICThis column contains 1 if the patient received an infusion of propofol during anesthesia care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC PROPOFOL (89389)
WasNeuraxialBlockPerformedVARCHARThis column contains Y if a neuraxial block was performed or N if not. Rule: DM AN ANESTHESIA TYPE - NEURAXIAL BLOCK (89227)
PatientAgeAtAnesthesiaEncounterStartNUMERICThis column contains the patient's age in years at the start of the anesthesia encounter. Rule: DM AN PATIENT AGE AT ENCOUNTER (89052)
FortyEightHoursAfterAnesthesiaStopDateTimeDATETIMEThis column contains the date and time that's 48 hours after the instant Anesthesia Stop was filed or null if it is not documented. Rule: DM AN 48 HRS AFTER ANESTHESIA STOP INSTANT (89323)
IsAnesthesiaEncounterEligibleForHCPCSG9656NUMERICThis column contains 1 if the given anesthesia encounter can be coded for HCPCS G9656 Code, or null if it cannot. Rule: DM AN HCPCS CODE G9656 (89131)
ObstructiveSleepApneaEducationStatusINTEGERThis column displays 1 if the patient was educated about risks of obstructive sleep apnea, and 0 if not. The column will contain 2 if there was a medical reason for not educating the patient. Rule: DM AN OBSTRUCTIVE SLEEP APNEA EDUCATION EVALUATION (89467)
FirstPostInsulinPerioperativeBloodGlucoseNUMERICThis column contains the first blood glucose lab result taken after insulin was given in the perioperative time period. Rule: DM AN FIRST SERUM GLUCOSE POST-INSULIN ADMINISTRATION (mg/dL) (89598)
AnesthesiaMaskDifficultyAssessmentVARCHARThis column contains the mask difficulty assessment documented in an anesthesia procedure note. Rule: DM AN MASK DIFFICULTY ASSESSMENT (89207)
IsNonOpioidMultimodalAnalgesiaUsedVARCHARThis column contains Y if non-opioid multimodal analgesia is documented or No if not. Rule: DM AN Non-Opioid Multimodal Analgesia Used (CER 89241)
MeanArterialPressureAreaUnderCurveBaseline70NUMERICThis column displays the area under the curve (AUC) for a mean arterial pressure (MAP) baseline of 70. Rule: DM AN AREA UNDER CURVE MEAN ARTERIAL PRESSURE UNDER 70 (89510)
AnesthesiaReadyDurationMinutesNUMERICThis column contains the time in minutes between Anesthesia Start and Anesthesia Ready or between Epidural-to-C-Section and Anesthesia Ready Rule: DM AN READY MINUTES (89271)
IsAsaCode10AApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA10A Code, or null if it cannot. Rule: DM AN ASA CODE ASA10A (89132)
TotalDesfluraneTimeInMinutesNUMERICThis column displays the total estimated time in minutes that desflurane gas was on during anesthesia. Rule: DM AN TOTAL DESFLURANE TIME (89362)
HasPerioperativePulmonaryEmbolismOrDeepVeinThrombosisVARCHARThis column contains Y if a patient has a secondary ICD-10-CM diagnosis code for deep vein thrombosis or a secondary ICD-10-CM diagnosis code for pulmonary embolism or N if they do not. This column contains null for the following conditions: The patient has a surgical discharge defined by AHRQ with a operating room procedure; patients with a principal ICD-10-CM diagnosis code (or secondary diagnosis present on admission) for proximal deep vein thrombosis, pulmonary embolism, patients with any-listed ICD-10-PCS procedure code for extracorporeal membrane oxygenation (ECMO), and patients with any-listed ICD-10-CM diagnosis code for acute brain or spinal injury present on admission, or MDC 14. Rule: DM AN AHRQ PULMONARY EMBOLISM OR DEEP VEIN THROMBOSIS (PERIOPERATIVE) (89632)
AnesthesiaProcedureDepartmentIdentifierNUMERICThis column contains the department in which the anesthesia procedure was performed. Rule: DM AN DEPARTMENT (89010)
MeanArterialPressureAreaUnderCurveUnder60NUMERICThis column displays the area under the curve (AUC) for a mean arterial pressure (MAP) baseline of 60. Rule: DM AN AREA UNDER CURVE MEAN ARTERIAL PRESSURE UNDER 60 (89508)
AnesthesiaRegistryStatusINTEGERThis column contains 1 if the status of the registry data is active, or 2 if it is inactive.
AnesthesiaPatientIdentifierVARCHARThis column contains the unique ID of the patient record for this row. It is frequently used to link to the PATIENT table. This column holds the ID as of when the row was extracted. If the patient was merged or unmerged after this record was deleted from Chronicles, this PAT_ID may not reflect the current ID of the patient. To reference the current ID of the patient, use the PAT_ID column in the PAT_ENC table. Join to the PAT_ENC table on the CSN columns in each table.
MeanArterialPressureAreaUnderCurveUnder65NUMERICThis column displays the area under the curve (AUC) for a mean arterial pressure (MAP) baseline of 65. Rule: DM AN AREA UNDER CURVE MEAN ARTERIAL PRESSURE UNDER 65 (89509)
PatientDeathDateTimeDATETIMEThis column displays documented date and time of death for the patient, or null if no time is specified. Rule: DM AN PATIENT DEATH DATE AND TIME (89139)
HasTransfusionReactionDiagnosisVARCHARThis column contains Y if a patient has a secondary diagnosis of transfusion reactions or N if they do not. Rule: DM CMS HAC AN TRANSFUSION REACTION (89666)
AnesthesiaRecordDateDATETIMEThis column contains the anesthesia record date. Rule: DM AN RECORD DATE (89007)
OpioidReversalInPacuBenchmarkNumeratorNUMERICThis column displays 1 if the patient falls into the numerator of the Opioid Reversal in PACU benchmark, or 0 if they do not. Rule: DM AN OPIOID REVERSAL IN PACU BENCHMARK NUMERATOR (89302)
ExtubationDateTimeDATETIMEThis column displays the instant the patient was extubated, or null if the extubation event was not filed or an airway LDA was not documented as removed after procedure completion. Rule: DM AN EXTUBATION INSTANT (89308)
HasPediatricPerioperativeHemorrhageOrHematomaVARCHARThis column contains Y if a patient has any secondary diagnosis code for perioperative hemorrhage or hematoma and any-listed procedures for control of perioperative hemorrhage or evacuation of hematoma, or N if they do not. This column contains null for the following conditions: The patient has a medical discharge defined by AHRQ with elective admission and any operating room procedure; cases with a diagnosis of coagulation disorder and cases with perioperative hemorrhage or hematoma as a principal diagnosis or a secondary diagnosis that is present on admission, cases where the only operating room procedure is one of the above-mentioned procedures, obstetric cases, and neonates with birth weight less than 500 grams. Rule: DM AN AHRQ PEDS HEMORRHAGE OR HEMATOMA (PERIOPERATIVE) (89597)
EncounterContactSerialNumberNUMERICThis column contains the unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
AnesthesiaPerioperativeEncounterContactTypeVARCHARThis column contains the contact type for the perioperative encounter associated with the anesthesia encounter being evaluated. Rule: DM AN PERIOPERATIVE ENCOUNTER TYPE (89093)
IsUltrasoundGuidedInternalJugularCentralVenousCatheterINTEGERThis column contains 1 if all central lines placed in the internal jugular used ultrasound guidance, 0 if at least one central line placed in the internal jugular did not use ultrasound guidance, or null if no central lines were placed in the internal jugular. Rule: DM AN CVC INSERTED IN INTERNAL JUGULAR WITH ULTRASOUND GUIDANCE (89254)
FamilyHistoryPostoperativeNauseaVomitingInParentOrSiblingNUMERICThis column contains 1 if the patient has a family history of postoperative nausea and vomiting, or null if they don't. Rule: DM AN FAMILY HISTORY OF PONV IN PARENTS OR SIBLINGS (89071)
LastPreprocedureBloodGlucoseValueNUMERICThis column contains the last blood glucose lab result taken in the preprocedure area before the Anesthesia Start time. Rule: DM AN LAST SERUM GLUCOSE PRIOR TO ANESTHESIA START (mg/dL) (89558)
PatientHistoryOfDifficultIntubationNUMERICThis column contains 1 if the patient has a history of difficult intubation noted in their medical history, problem list, a procedure note, or the postprocedure note. Rule: DM AN HX OF DIFFICULT INTUBATION (89212)
IsPediatricPostoperativeRespiratoryFailurePresentVARCHARThis column contains Y if a patient has one of the following diagnoses or N if they do not. No configuration is required: - Postoperative respiratory failure (secondary diagnosis) - Secondary ICD 10 procedure codes for a mechanical ventilation for 96 consecutive hours or more occurring 0 or more days after the first major operating room procedure - Secondary ICD 10 procedure codes for a mechanical ventilation for less than 96 consecutive hours occurring 2 or more days after the first major operating room procedure - Secondary ICD 10 procedure codes for a reintubation occuring 1 or more days after the first major operating room procedure
PatientSpokenLanguageVARCHARThis column contains the patient's spoken language. Rule: DM AN PATIENT LANGUAGE (89019)
TotalNitrousOxideTimeInMinutesNUMERICThis column displays the total estimated time in minutes that N2O was on during anesthesia. Rule: DM AN TOTAL N2O FLOW TIME (89373)
AnesthesiaPhysicalStatusScoreVARCHARThis column contains the patient's ASA score (aka physical status). Rule: DM AN ASA SCORE (89055)
FirstInsulinAdministrationInstantDATETIMEThis column contains the date and time of the first insulin dose before the Anesthesia Stop time. Rule: DM AN FIRST INSULIN ADMINISTRATION INSTANT PRIOR TO ANESTHESIA STOP (89561)
IsAnesthesiaEncounterAsa14BCodeApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA14B Code, or null if it cannot. Rule: DM AN ASA CODE ASA14B (89091)
TotalDesfluraneVolumeNUMERICThis column displays the total estimated volume in liters of desflurane gas administered during anesthesia. Rule: DM AN TOTAL DESFLURANE VOLUME (L) (89247)
TotalIntraprocedureMedicationCostNUMERICThis column contains the total med cost for administered intraprocedure medications. Rule: DM AN TOTAL MED COST (89765)
OwningInstanceCommunityIdentifierVARCHARThis column contains the Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
RecordOwningInstanceCommunityIdentifierVARCHARThis column contains the Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
BilledAnesthesiaTypeVARCHARThis column contains the billed anesthesia types as mapped in LSD 89230, delimited by semicolons. Rule: DM AN BILLED ANESTHESIA TYPE (89094)
ExtractedInstanceCommunityIdentifierVARCHARThis column contains the Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
IsEligibleForHealthcareProcedureCodeG9654NUMERICThis column contains 1 if the given anesthesia encounter can be coded for HCPCS Code G9654, or 0 if it cannot. Rule: DM AN HCPCS CODE G9654 (89230)
RecoveryCareDurationInMinutesNUMERICThis column contains the time in minutes between In Recovery and Ready for Discharge from Recovery for the primary surgical log, or null if there are not two documented times. Rule: DM AN RECOVERY CARE COMPLETE TIME (MINUTES) (89229)
WasPencilPointNeedleUsedSpinalBlockINTEGERThis column contains 1 (Pass) if a pencil point needle was used in all spinal blocks performed for this procedure or 0 (Fail) if any of them did not. Rule: DM AN Pencil Point Used in Spinal Procedure (89249)
IsPatientDeceasedInRecoveryNUMERICThis column contains 1 if the patient's documented time of death is between the In Recovery and Out of Recovery event times, or 0 if it is not. The column contains null if the In Recovery or Out of Recovery events are not documented. Rule: DM AN PATIENT DEATH IN RECOVERY (89141)
NumberOfProphylacticAntiemeticsAdministeredNUMERICThis column contains the number of prophylactic pharmacologic antiemetic agents of different classes given preoperatively and intraoperatively. Rule: DM AN NUMBER OF PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC AGENTS OF DIFFERENT CLASSES (89134)
PostAnesthesiaCareUnitAntiemeticBenchmarkDenominatorFlagNUMERICThis column displays 1 if the patient falls into the denominator of the PACU rescue antiemetic benchmark, or 0 if they do not. Rule: DM AN AVERAGE NUMBER OF RESCUE ANTIEMETIC DOSES IN PACU BENCHMARK DENOMINATOR (89315)
PreAnesthesiaLastBodyMassIndexNUMERICThis column contains the patient's most recently calculated body mass index (BMI) prior to anesthesia. Rule: DM AN PATIENT BMI (89554)
WasIntubatedForProcedureNUMERICThis column contains 1 if the patient was intubated between Anesthesia Start and Anesthesia End, or 0 if they were not. Rule: DM AN INTUBATED FOR PROCEDURE (89044)
IsAnticoagulantAndAntiplateletMedicationLastDoseReviewedVARCHARThis column contains Y if the the patient's anticoagulant and antiplatelet medications were reviewed and last dose information was documented or N if not. Rule: DM AN FULLY DOCUMENTED ANTICOAGULANT AND ANTIPLATELET MEDICATIONS (89269)
WasInhalationalAnestheticGasUsedNUMERICThis column contains 1 if an inhalational anesthetic gas was used, or null if one was not. Rule: DM AN INHALATION OF GENERAL ANESTHETICS (89058)
WasPeripheralNerveBlockPerformedVARCHARThis column contains Y if a peripheral nerve block was performed or N if not. Rule: DM AN ANESTHESIA TYPE - PERIPHERAL NERVE BLOCK (89114)
SurgicalDurationInMinutesNUMERICThis column contains the time in minutes between in room and out of room for the primary surgical log. Rule: DM AN OPERATING ROOM TIME (MINUTES) (89200)
HighestTemperatureNearAnesthesiaEndNUMERICThis column contains the highest temperature that occurred between 30 minutes before and 15 minutes after anesthesia end. Rule: DM AN HIGHEST TEMPERATURE NEAR ANESTHESIA END (89113)
HighestCoreTemperatureDuringProcedureNUMERICThis column contains the highest core temperature during the procedure, or null if no core temperature recording exists. Rule: DM AN HIGHEST CORE TEMPERATURE DURING PROCEDURE (89137)
HasHospitalAcquiredPressureUlcerStageThreeOrFourVARCHARThis column returns Y if a patient has a secondary diagnosis of developing stage III or stage IV pressure ulcer or N if they do not. Rule: DM AN CMS HAC STAGE III AND IV PRESSURE ULCER (89552)
IsTrainOfFourBenchmarkNumeratorVARCHARThis column contains a Y if the record is included in the numerator of the Train of Four benchmark or null if it is not. Rule: DM AN TRAIN OF FOUR BENCHMARK NUMERATOR (89195)
AllAnesthesiaResidentsListVARCHARThis column contains all anesthesia residents with time documented on the anesthesia record in a semicolon-delimited list, or null if there are none documented. Rule: DM AN ALL RESIDENTS (89165)
BilledProcedureCptCodeVARCHARThis column contains the CPT codes of the anesthesia procedure that was billed, delimited by semicolons. Rule: DM AN BILLED PROCEDURE CPT CODE (89040)
PostoperativeNauseaVomitingRiskInterventionBenchmarkDenominatorFlagNUMERICThis column contains 1 if the patient encounter should be in the denominator of the PONV Risk Factors Versus Interventions benchmark, or null if not. If the patient had 2 or more risk factors for PONV and received inhalational general anesthesia, the encounter is included in the denominator. The encounter is excluded if the patient's ASA score was 5 or 6, or the encounter was emergent. Rule: DM AN PONV RISK FACTORS VERSUS INTERVENTIONS BENCHMARK DENOMINATOR (89319)
ResponsibleProviderNationalProviderIdentifierNUMERICThis column displays the responsible provider's NPI ID for the anesthesia record. Rule: DM AN RESPONSIBLE ANESTHESIOLOGIST NPI (89145)
HospitalAcquiredRespiratoryFailureIndicatorVARCHARThis column contains Y if a patient has one of the following or N if they do not. No configuration is required: - Postoperative respiratory failure (secondary diagnosis) - Secondary ICD 10 procedure codes for a mechanical ventilation for 96 consecutive hours or more occurring 0 or more days after the first major operating room procedure - Secondary ICD 10 procedure codes for a mechanical ventilation for less than 96 consecutive hours occurring 2 or more days after the first major operating room procedure - Secondary ICD 10 procedure codes for a reintubation occuring 1 or more days after the first major operating room procedure
HasMajorPsychiatricDisorderNUMERICThis column contains 1 if the patient has a major psychiatric disorder, 0 if they do not, or null if neither was documented on the anesthesia record. Rule: DM AN PSYCHIATRIC DISORDER (89027)
WasNeuromuscularBlockerAntagonistAdministeredNUMERICThis column displays 1 if it was documented that the patient received a neuromuscular blocker antagonist medication between Anesthesia Start and Extubation, or 0 if they did not. Rule: DM AN NEUROMUSCULAR BLOCKER ANTAGONIST ADMINISTERED (89310)
IsAnesthesiaEncounterEligibleForHcpcsCodeG9655NUMERICThis column contains 1 if the given anesthesia encounter can be coded for HCPCS Code G9655, or null if it cannot. Rule: DM AN HCPCS CODE G9655 (89168)
WasCardiacArrestDocumentedNUMERICThis column contains 1 if cardiac arrest was documented, or null if it was not. Rule: DM AN CARDIAC ARREST (89032)
CentralVenousCatheterMaximalSterileBarrierFlagNUMERICThis column contains 1 if all central lines placed during anesthesia care used maximal sterile barrier precautions or 0 otherwise. Rule: DM AN CENTRAL LINE PLACED WITH MAXIMUM STERILE BARRIER PRECAUTIONS (89503)
SurgicalProcedureDurationMinutesNUMERICThis column contains the time in minutes between procedure start and procedure complete for the primary surgical log. Rule: DM AN PRIMARY LOG PROCEDURE LENGTH (89060)
LaborEpiduralToCSectionTransitionDateTimeDATETIMEThis column contains the date and time that a labor epidural transitions to a C-section. Rule: DM AN EPIDURAL TO C-SECTION INSTANT (89272)
TakingNarcoticsPriorToProcedureNUMERICThis column contains 1 if the patient was taking narcotics prior to the procedure, or 0 if they were not. Rule: DM AN PATIENT TAKING NARCOTICS (89023)
PatientLeftPhaseTwoInstantDATETIMEThis column contains the documented instant at which the patient left Phase II. Rule: DM AN OUT OF PHASE II INSTANT (89022)
TotalMorphineEquivalentDoseSixHourPostProcedureNUMERICThis column contains the total calculated morphine equivalent dose from the end of anesthesia up to 6 hours postprocedure. Rule: DM AN MORPHINE EQUIVALENT DOSE IN MG - 6 HOURS POSTPROCEDURE (89218)
HighestPreproceduralPainScoreNUMERICThis column contains the highest pain score recorded in preprocedure on a 0-10 pain scale. If the value is outside the 0-10 range, the column will contain null. Rule: DM AN HIGHEST PREPROCEDURAL PAIN SCORE (89146)
AnesthesiaResponsibleProviderIdentifierVARCHARThis column contains the responsible provider for the anesthesia record. Rule: DM AN RESPONSIBLE PROVIDER (89008)
PrincipalDiagnosisRelatedGroupCodeVARCHARThis column contains the external ID of the final coded DRG. Rule: DM AN PRINCIPAL DRG CODE (89665)
AnesthesiaCptTwoCode0583FIndicatorNUMERICThis column contains 1 if the given anesthesia encounter can be coded for CPT Code 0583F, or null if it cannot. Rule: DM AN CPT II CODE 0583F (89049)
NeuromuscularBlockerAntagonistBenchmarkDenominatorNUMERICThis column displays 1 if the patient falls into the denominator of the neuromuscular blocker antagonist benchmark, or 0 if they do not. Rule: DM AN PATIENT RECEIVED NEUROMUSCULAR BLOCKER ANTAGONIST BENCHMARK DENOMINATOR (89312)
DiagnosisListIcd10VARCHARThis column contains a semicolon-delimited list of patient diagnoses in the ICD-10 term set with ranks appended after a hyphen. Rule: DM AN DIAGNOSIS LIST ICD-10 (89047)
PatientRaceINTEGERThis column contains the patient's race. Rule: DM AN PATIENT RACE (89546)
PostAnesthesiaCareUnitMorphineEquivalentDoseMilligramsNUMERICThis column contains the total calculated morphine equivalent dose in the PACU. Rule: DM AN MORPHINE EQUIVALENT DOSE IN MG - PACU (89217)
AnesthesiaCasePaymentMethodVARCHARThis column contains the primary payment method used by the patient for this anesthesia case, or null if it is not available. Rule: DM AN PAYMENT METHOD (89082)
IntendedOpioidAdministrationIndicatorNUMERICThis column contains 1 if there was an intended administration of opioids during intraprocedure or postprocedure care, or null if there was not. Rule: DM AN INTENDED OPIOID ADMINISTRATION DURING INTRAPROCEDURE OR POST PROCEDURE CARE (89070)
AnesthesiaStopDocumentedInstantDATETIMEThis column contains the instant at which anesthesia stop was documented. Rule: DM AN ANESTHESIA STOP INSTANT (89014)
ResponsibleProviderAtExtubationIdentifierVARCHARThis column displays the responsible provider at the time of extubation event or the last responsible provider if the event does not exist. Rule: DM AN RESPONSIBLE PROVIDER AT EXTUBATION (89198)
WasSecondAirwayPlacedOnPatientNUMERICThis column contains 1 if multiple airways were used on the patient between Procedure Start and Out of Recovery, 0 if there were not, or null if out of PACU is not documented. Rule: DM AN SECOND AIRWAY PLACED ON PATIENT (89042)
WasDeepHypothermiaDocumentedNUMERICThis column contains 1 if deep hypothermia was documented, or null if it was not. Rule: DM AN DEEP HYPOTHERMIA (89033)
TotalSevofluraneAdministrationDurationNUMERICThis column displays the total estimated time in minutes that sevoflurane gas was on during anesthesia. Rule: DM AN TOTAL SEVOFLURANE TIME (89360)
AnesthesiaRecordTypeVARCHARThis column contains the type of anesthesia record: case, appointment, or ad hoc. Rule: DM AN ANESTHESIA RECORD TYPE (89210)
SourceInstanceCommunityIdentifierVARCHARThis column contains the Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
ReintubationBeforeRecoveryDischargeNUMERICThis column displays 1 if the patient was reintubated after an extubation and before out of recovery, or null if they were not. Rule: DM AN REINTUBATION (89268)
AverageCodingLagTimeBenchmarkDenominatorNUMERICThis column displays 1 if the patient falls into the denominator for this metric, or 0 if they do not. Rule: DM AN AVERAGE TIME FROM RECORD DATE TO PB CODING COMPLETE BENCHMARK DENOMINATOR (89317)
HighestPainScoreInPostAnesthesiaCareUnitNUMERICThis column contains the highest pain score recorded in the PACU. If the value is outside the 0-10 range, the column will contain null. Rule: DM AN HIGHEST PACU PAIN SCORE (89029)
IsAnesthesiaCodeAsa20BApplicableNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA20B Code, or null if it cannot. Rule: DM AN ASA CODE ASA20B (89110)
LimitedCommunicationAtPostAnesthesiaCareUnitDischargeIndicatorVARCHARThis column contains Y if the patient has a co-occurring condition that limits the ability to communicate at PACU discharge or null if the patient does not. Examples include severe dementia, developmental delay, or mechanical ventilation. Rule: DM AN LIMITED COMMUNICATION AT PACU DISCHARGE (89342)
CanBeCodedForAnesthesiaQualityMeasure11ANUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA11A Code, or null if it cannot. Rule: DM AN ASA CODE ASA11A (89104)
CentralLineNoMaxSterileBarrierMedicalReasonIndicatorNUMERICThis column contains 1 if any central line placed during anesthesia care had a medical reason for not using maximal sterile barrier precautions. It will return 0 if all central lines used maximal sterile barrier precautions or if any central line did not and no medical reason was supplied. Rule: DM AN CENTRAL LINE PLACED WITH MEDICAL REASON FOR NOT USING MAXIMUM STERILE BARRIER PRECAUTION (89236)
TotalFreshGasFlowVolumeInLitersNUMERICThis column returns the total fresh gas flow in liters documented in anesthesia intraprocedure. Rule: DM AN TOTAL FRESH GAS FLOW VOLUME (L) (89359)
IntraoperativeNitricOxideAdministrationNUMERICThis column contains 1 if nitric oxide was used between In Room and Out of Room, or null if it was not. Rule: DM AN INTRAPROCEDURE USE OF NITRIC OXIDE (89143)
IsAnesthesiaEncounterInAllCauseMortalityFortyEightHourNumeratorNUMERICThis column contains 1 if the anesthetic record qualifies for the numerator of the all-cause mortality benchmark or 0 if it does not. Rule: DM AN ALL-CAUSE MORTALITY IN 48 HOURS NUMERATOR (89322)
HospitalDischargeDispositionVARCHARThis column contains the hospital discharge disposition. Rule: DM AN HOSPITAL DISCHARGE DISPOSITION (89437)
WasEpiduralBlockPerformedVARCHARThis column contains Y if an epidural block was performed or N if not. Rule: DM AN ANESTHESIA TYPE - EPIDURAL BLOCK (89225)
OperatingRoomDepartureInstantDATETIMEThis column contains the documented instant at which the patient left the operating room. Rule: DM AN OUT OF ROOM INSTANT (89020)
AnesthesiaInductionDateTimeDATETIMEThis column contains the documented instant of induction. Rule: DM AN INDUCTION INSTANT (89016)
IsCodeableForAsa14aNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA14A Code, or null if it cannot. Rule: DM AN ASA CODE ASA14A (89090)
WasCornealInjuryOrExposureKeratitisDiagnosedVARCHARThis column displays Y if the patient was diagnosed with a corneal injury or exposure keratitis prior to discharge or N if not. Rule: DM AN CORNEAL INJURY OR EXPOSURE KERATITIS (89158)
AnesthesiaSurgicalServiceVARCHARThis column contains the surgical service for the case linked to the anesthesia record. Rule: DM AN SURGICAL SERVICE (89153)
AllAnesthesiaStaffListVARCHARThis column contains a semicolon-delimited list of all anesthesia staff documented on the anesthesia record. Rule: DM AN ALL ANESTHESIA STAFF (89046)
IsAnesthesiaCodeableAsa13HNUMERICThis column contains 1 if the given anesthesia encounter can be coded for ASA13H Code, or null if it cannot. Rule: DM AN ASA CODE ASA13H (89171)
ObstructiveSleepApneaMitigationUsedIndicatorVARCHARThis column contains Y if two or more mitigation factors were used to deal with obstructive sleep apnea or N if not. The column will be null for patients with a negative obstructive sleep apnea screening or if the patient was not screened. Rule: DM AN OBSTRUCTIVE SLEEP APNEA TWO OR MORE MITIGATION STRATEGIES USED (89466)
TotalCaseDelayInMinutesNUMERICThis column contains the total case delay time in minutes. Rule: DM AN DELAY TIME IN MINUTES (89549)
AntiemeticButyrophenonesAdministeredFlagNUMERICThis column contains 1 if the patient received an administration of antiemetic butyrophenones during preprocedure or intraprocedure care, or null if they did not. Rule: DM AN PROPHYLACTIC PHARMACOLOGIC ANTIEMETIC BUTYROPHENONES (89067)
PostProcedureCornealInjuryNUMERICThis column contains 1 if the patient had a corneal injury following the procedure, or null if they did not. Rule: DM AN CORNEAL INJURY (89264)
PatientBloodTypeRhFactorVARCHARThis column contains the patient's blood type and Rh factor. Rule: DM AN BLOOD TYPE/Rh FACTOR (89205)
PatientStateOfResidenceVARCHARThis column contains the patient's state of residence. Rule: DM AN PATIENT STATE OF RESIDENCE (89213)
AnesthesiaOpioidAdministrationFlagNUMERICThis column displays 1 if it was documented that the patient received an administration of opioids between Anesthesia Start and Anesthesia Stop, or 0 if they did not. Rule: DM AN OPIOID ADMINISTERED (89300)
PatientDischargeDateTimeDATETIMEThis column displays the date and time of discharge for the patient, or null if it is not documented. Rule: DM AN PATIENT DISCHARGE DATE AND TIME (89151)
HasSepsisSecondaryDiagnosisVARCHARThis column contains Y if a patient has a secondary diagnosis codes for sepsis or N if they do not. This column contains null for the following conditions: The patient has a surgical discharge defined by AHRQ with an elective admission and any operating room procedure; cases with a principal diagnosis or secondary diagnosis present on admission for sepsis, or infection, and MCD 14. Rule: DM AN AHRQ SEPSIS (POSTOPERATIVE) (89642)