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

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.

Column NameTypeDescription
FutureRelativeExpectedDateCategoryINTEGERHolds a category value for the expected completion date. This may be subtly different from the expected date (ORDER_PROC.FUT_EXPECT_COMP_DT) for things like "in 3 months", which could be Start Date+90 days (S+90), Start date+91 days (S+91), or Start date + 92 days (S+92) depending on the current date.
PreferredAppointmentWindowStartTimeDATETIMEThis is the start of the appointment window for the preferred appointment window.
ReferenceLabBillingTypeVARCHARThe reference lab bill type category ID for the order record, indicating how reference labs should bill for services performed.
RecurringProcedureExpirationDateDATETIMEThe date when a recurring procedure order expires.
LastResultEditDateTimeDATETIMEThe instant the result was last edited.
IsIncludedInMetricDenominatorIndicatorVARCHARThis item returns true if the result can be included in denominator of the result release metrics, other factors can still prevent this result from being included. The item will not return true if the order 1) is cancelled 2) has source in 19, 44, or 100 3) is blood admin
PrioritizedResultUniversalTimeDATETIMEStores the prioritized instant for the result in UTC
OrderSigningSessionKeyVARCHARThe unique key associated with the order at the time of signing. Other orders will share this key if they were signed at the same time.
OrderPerformByDatetimeDATETIMEUnbuffered perform-by date used in automatic order cancellation batch job.
ScheduleRemovalReasonCodeINTEGERThis item stores a reason why the order was removed from scheduling reports.
OrderCreationUserIdentifierVARCHARThe unique identifier of the user who signed the order, or the last person who performed a sign and hold or release action for a signed and held order.
IsNoChargeExternalResultIndicatorVARCHARThis column returns whether the order is an external result that should not drop charges. A value of 1 returns Y. A value of 0 returns N. A null value will return null but is treated the same as 0 when dropping charges.
PanelOrderReleaseDateTimeDATETIMEIf this order is a performable order on a test panel, this item stores the local date and time when the associated orderable was released. This column will only be populated for performable orders on test panels. It will not be populated for the orderable order on test panels.
ProcedureOrderCostEstimateIdentifierNUMERICA link to a patient estimate record that contains patient cost estimate information for procedure orders.
ExcusedLeaveEndDateDATETIMEEnd date of the excuse period.
DeliveryRequestUnitCategoryINTEGERThe unit category of the blood component order record being requested.
LastMammogramProcedureDateDATETIMEThe date when the last breast procedure was performed.
ProcedureOrderReferralClassCategoryVARCHARThe referral class category number for the procedure order.
IsPictureArchivingCommunicationSystemImageAvailableIndicatorVARCHARStores whether images are available via PACS (picture archiving and communication system) for a radiology order. 'Y' indicates that the images are available, 'N' and NULL indicate that the images are not available.
ProcedureServiceINTEGERThis item contains a procedure service type (surgery, imaging, dental, etc.) that overrides the service type from a referral or coverage source.
ResultTransmittalQueueEntryIdentifierVARCHARThe unique ID used for the result transmittal queue entry associated with the order.
ExternalServiceProviderCanArchiveDocumentsIndicatorVARCHARDetermines whether the external service provider is allowed to archive documents.
LastMammogramExternalIndicatorVARCHARWhether the last breast procedure was done externally.
IsOrderByHospitalistIndicatorVARCHARIndicates whether or not this order was placed by a hospitalist. ‘Y’ indicates that this order was placed by a hospitalist. ‘N’ or NULL indicate that this order was not placed by a hospitalist.
ProcedureInterventionVARCHARIntervention for this procedure.
OrderExclusionFromClinicalDecisionSupportReasonINTEGERThe Exclude From Decision Support reason for the order. It will be either 1 - Unsuccessful Attempt represents an order that was not successfully completed. or 2 - Documented on Wrong Patient represents the order's result information was documented on the incorrect patient.
ReferredToProviderIdentifierVARCHARThe unique ID of the provider referred to for a referral order. Other columns in the same logical group are: SER_ADDRESSID (ORD 3001), REFG_FACILITY_ID (ORD 3010) and REFERRAL_ID (ORD 3300)
ScheduledDurationInMinutesINTEGERThe amount of time (in minutes) the order will contribute to an appointment
OrderResultContactSerialNumberNUMERICThe unique contact serial number for the contact that was created from this order. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
NetPayableAmountNUMERICThe net payable of the service.
UpdateAssessmentRecommendationDurationSecondsINTEGERStores the total number of seconds spent by clinicians updating discrete data in the Update Assessment/Recommendations activity.
OrderProcedureRecordIdentifierNUMERICThe unique identifier for the order record.
BloodComponentDeliveryRequestOrderIdNUMERICThe order ID of the blood component order this order record is requesting a delivery from.
ExternalOrderIdentificationVARCHARStores the external order ID for the order.
WasImagingExamPerformedVARCHARStores whether the imaging exam was performed in isolation.
ParentCrossEncounterOrderIdNUMERICWhen a cross-encounter order is released, this item stores the ID of the parent order.
PrioritizedInstantTimeDATETIMEThe time and date that is used as the prioritized date.
OrderNUMERICThe unique ID of the order record for this row.
StandingStatusInBasketMessageIdentifierVARCHARHolds the ID number of the Standing Status In Basket message associated with this Order. The In Basket message informs the user that a standing order exists.
InterestingStudyReasonCategoryINTEGERThe category ID for denoting the reason a study is worth being marked for later review, as in for an educational case or for group reading physician review.
FirstFinalResultChartedInstantDATETIMEThe instant final results were first made available on the chart. This is the result contact instant (ORD-1970) from the first contact where the procedure result status (ORD-115) is 3-Final result.
SpecimenCollectionTimeDATETIMEThe time the specimen was taken.
OriginalOrderIdentifierNUMERICWhen an order record is created as the result of a procedure change workflow, it stores a pointer to the previous order. To reliably find the original order record, refer to ORDER_PROC_5.ORIGINATING_ORD_ID
OrderPhaseOfCareCategoryINTEGERThis item will store the phase of care for which this order was created. Example: Pre-Op, Intra-Op, PACU.
ModalityProcedureStartDateTimeDATETIMEFor procedures performed on modalities using Digital Imaging and Communications in Medicine (DICOM), this stores the start date & time of the performed procedure sent from the modality to system.
OrderReviewGranularityIndicatorVARCHARDetermines if an order is reviewed by day or by instant.
AntNUMERICWeekly maximum dose of anticoagulant for a patient on anticoagulation therapy.
IsPendingResultTransmittalVARCHARIndicates if the order was placed on the result transmittal queue but not yet processed by it.
PrioritizedOrderInstantDateTimeDATETIMEThis item stores the prioritized instant (date and time) for an order in local time zone. It represents the most relevant date and time an action was taken on an order.
ReferredPrimaryConditionGrouperIdentifierNUMERICPrimary condition for which the patient is being referred as a Search Condition MAG record.
IsOrderSelfReferredIndicatorVARCHARIndicates whether an order is self-referred. 'Y' indicates that an order is self-referred. 'N' indicates that an order was manually marked as not self-referred. NULL indicates that an order was not automatically marked as self-referred and not manually marked as being either self-referred or not self-referred.
ContactDateTimeDecimalFLOATA unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
RadiologyExamHardStopOverrideLastDateTimeDATETIMEStores the most recent time a hard stop was overridden at begin or end exam in radiology
OrderResultStatusCategoryINTEGERThe category number for the status of results for an order, as of the date and time the record was extracted.
ResultReportRoutingOverrideIndicatorINTEGERStores whether result report routing settings are overriden by test level settings or not.
BatchResultsReportPrintedInstantDATETIMEThis column holds the instant the results report was printed through batch printing routine RISBSREP or through results routing.
OrderableOrderSetQuestionnaireIdentifierNUMERICThe unique ID of the Orderable OSQ that this order was created from.
ProcedurePerformingTechnologistIdentifierVARCHARThe unique ID of the employee record of the technologist who performed this procedure.
IncompleteSubOrderCountINTEGERStore the number of child orders which have not yet reached completed/canceled status. meaning they are either not yet released or are currently active.
OrderLetterPrintDateDATETIMEThe date a letter will be created and printed for this order. This is cleared after the letter has been created and printed.
LastProcedureResultDateTimeDATETIMEThe most recent date and time when the procedure order was resulted.
ReferredToProviderAddressIdentifierVARCHARAddress selected for the referred-to provider. Format: {External provider ID}-{Address Line #}
ClinicalDecisionSupportUnsignedOrderIdentifierVARCHARThe GUID assigned to an unsigned order during the CDS Hooks CRD workflow. This will be used for tracking the ORD record associated with an unsigned order.
OrderProviderStatusCategoryINTEGERThe provider status category number for the order at the time of the extract. This item reflects the providers' viewed status of the order result message. The amount, frequency and type of data stored in this item depends on the programming point records entered into the results message type definition in use at each facility. This column is used to link to the ZC_PROV_STATUS table.
IsLastResultAbnormalNoAddVARCHARIndicates whether the most recent result is abnormal. 'Y' indicates that the most recent update of the result was marked abnormal. 'N' indicates that the abnormal flag is not set, or marked as normal. This is set to 'N' when a result is in progress, and will be updated as result updates are filed.
ExcusedLeaveStartDateDATETIMEStart date of the excused activities period.
IsPatientHormoneHistoryNotApplicableForMammogramVARCHARWhether the patient has no mammography-relevant hormone history, documented by the tech in the visit navigator.
OrderProcedureCancellationReasonCategoryVARCHARThe reason for cancellation category number for the procedure order.
OrderResultPrimaryRecipientDepartmentIdentifierNUMERICThis item stores the primary recipient if it is a DEP record. This is used to store the primary recipient for a result that has been received on the incoming interface. Results Routing does not consider this item as it is only used for audit trail purposes.
ConditionalOrderInitiatedInstantDATETIMEStores the instant when an inpatient conditional order was initiated.
WasReadingPoolManuallyAssignedVARCHARIndicates whether or not this study's reading pools or assigned providers were manually assigned.
AnticoagulationNextInternationalNormalizedRatioDateTimeDATETIMEThe date of the next International Normalized Ratio (INR) check for a patient on anticoagulation therapy.
OrderLastContactDateTimeRealFLOATThe latest contact date for the order in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
OrderProcedureAuthorizedQuantityINTEGERThe number of procedures authorized for this order.
OrderAccountsReceivableInterfaceStatusCategoryINTEGERThis column contains the AR Interface Status category value for this order.
FutureOrderExpectedCompletionDateDATETIMEThe date by which each future procedure order should be completed. Displayed in calendar format.
ReferredToDepartmentProviderIdentifierNUMERICThe unique ID of the department to which this order is referred.
OrderResultTrackingStatusINTEGERThis stores whether follow-up with recipients is required, in progress, or completed. This status is the per-order, see RESULT_TRACK_RECIP for individual recipient result tracking statuses.
PanelOrderReleaseUniversalTimeDATETIMEIf this order is a performable order on a test panel, this item contains the UTC date and time when the associated orderable was released. This column will only be populated for performable orders on test panels. It will not be populated for the orderable order on test panels.
UniqueOrderRecordIdentifierNUMERICThe unique identifier for the order record.
OrderProcedureNameVARCHARThe name of the order as it appears in the patient's record.
OrderReceivedDateTimeDATETIMEThe date and time the order was received.
SpecimenBarcodeScannedDataVARCHARStores the barcode data scanned during specimen collection.
OrderUserContextCategoryVARCHARAssigns an order a category ID with a user's context. The order can be used for or created for procedure orders.
LastProtocolSourceOrderIdentifierNUMERICThis item stores a pointer to the last order record that had its protocol edited by a user. When a protocol is edited this item should be populated on the order record that was edited. When a protocol is copied forward to another order record, this item should be populated on the destination order.
PatientHadLungCancerHistoryIndicatorVARCHARReturns whether the patient had a history of lung cancer at the time of the order.
SelfReferredReasonIdentifierVARCHARThe ID of the record that caused the self-referred item to be populated.
SpecimenReceivedDateDATETIMEThis item stores the date that the specimen was received. It is in the same logical group as the SPECIMEN_RECV_TIME column.
OrderCopiedStatusCategoryIdINTEGERThe order copy status category ID, indicating whether the order was copied to another visit.
ResultLastUpdateInstantUniversalTimeDATETIMEStores the last update instant for a result in UTC
ReflexSourceOrderIdentifierNUMERICThe order ID from which this reflex order was created.
OrderDestinationAncillaryCategoryIdINTEGERThe ancillary category ID for the destination ancillary that is responsible for this order.
PreviousImagingStudyStatusCategoryIdINTEGERThis stores the category ID for the imaging study status (e.g. technician ended the exam, reading physician finalized the exam) before the order was canceled. This will only be populated for canceled imaging orders. This column is used to link to the ZC_RADIOLOGY_STS table.
FirstChartingUserIdentificationVARCHARThe unique ID of the user who first made results available on the chart.
AuthorizationRequirementFlagVARCHARThis column stores whether or not authorization is required for the service.
FirstUserWithFinalResultIdentificationVARCHARThe unique ID of the user who first made final results available on the chart.
DigitalImagingCommunicationInMedicineLastUpdateInstantDATETIMEThe instant of the last time the UIDs were updated.
OrderIdentifierBeforeTransmittalVARCHARThis column contains the Before Order ID for an order before Order Transmittal.
ProcedureOrderTypeCategoryNumberINTEGERThe order type category number for the procedure order.
ReferredToProviderSpecialtyVARCHARThe medical specialty category number of the provider to which the patient was referred for the procedure order.
RequestedUnitsPerPeriodINTEGERRequested units/visits per period. This along with the Requested periods (REQ_PERIODS) determines the total 'requested units'.
IntraConnectRecordOwnerCommunityIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
DietOrderCommentsVARCHARThis column contains the Diet Comments entered for an order.
OrderFinancialClearanceUtcInstantDATETIMERecords the UTC instant an order was financially cleared
OrderGroupSessionUniversalTimeCoordinatedDATETIMEThe date and time that identifies this order group, in UTC.
OrderFastingDecisionINTEGERThis column will determine how to treat fasting requirements for the appointment when the order should be performed shortly after signing. It holds the answer to an order-specific question presented to the ordering user.
LastOrderReviewDateTimeDATETIMEThe most recent date and time when the procedure order was reviewed.
ExcludeFromMammographyQualityStandardsActReportVARCHARIf set to Y, this order should never be included in any MQSA (Mammography Quality Standards Act) summary. This indicates this particular order is an outlier that should not be considered in mammography reporting. If set to N or is null, it can be included in mammgraphy reporting.
ReferredToPrimarySpecialtyGrouperIdentificationNUMERICPrimary specialty to which the patient is being referred as a Search Specialty MAG record.
IsLeaveIncludingLightDutyVARCHARWhether the medical leave also has a light duty period.
MedicalLeaveStartDateDATETIMEStart date of the medical leave.
RemainingStandingOccurrencesINTEGERThe number of individual occurrences remaining for this procedure order.
MammographyOutcomeCodeINTEGERThis column stores the outcome (e.g. FP/FN/TP/FN/etc) for a mammography study. This column is used to link to the ZC_MAMMO_OUTCOME table.
SnomedCodeSourceCategoryINTEGERsource of the SNOMED code (reported vs inferred)
ProtocolStatusDateDATETIMEThe date an unscheduled order was placed, or the appointment date for a scheduled order which requires a protocol.
OrderModifiedVsReorderedFlagVARCHARFlag used to denote if the order was modified or reordered.
AuthorizingProviderIdentifierVARCHARThe unique ID of the provider prescribing or authorizing the order.
OrderTypeFutureOrStandingVARCHARThis column indicates whether an order is a future (F) or standing (S) order.
ScheduleToleranceAfterINTEGERHow long after the expected date for the order the appointment can still be safely made.
OrderPhysicalCommunityOwnerIdentificationVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
LungImagingOutcomeINTEGERThe positive/negative outcome for a lung imaging study.
ReferredToProviderCareTeamIdentifierNUMERICThis item tracks the IP provider team associated with a consult/referral order.
PatientWeightChangeOuncesNUMERICThe patient's weight change (oz.).
DeprecatedCcRecipientDepartmentIdentifierNUMERICThis item stores the CC recipient if it is a DEP record. This is used to store the CC recipient for a result that has been received on the incoming interface. Results Routing does not consider this item as it is only used for audit trail purposes.
LeaveLightDutyStartDateDATETIMEStart date of the light duty period.
ProcedureThirdModifierIdentificationVARCHARThe unique ID of the modifier record. This is the third modifier entered for the procedure and affects how the procedure is billed.
OrderSubmitterIdentifierNUMERICThe unique ID of the external site (submitter) associated that originally placed the order.
CaseLogPreferenceCardIdentificationVARCHARThe preference card in the case (ORC) or log (ORL) that this order is associated with.
OrderNoChargeReasonCodeINTEGERThe reason that a charge was not triggered for an order record. This item being populated does not imply any issues with system integrity or system build; it will be set both for legitimate reasons that a charge was not triggered as well as non-legitimate reasons.
ProcedurePerformingDepartmentIdentifierNUMERICThe unique ID of the department where the procedure will take place.
StandingOrderOriginalOccurrenceCountINTEGERThe total number of occurrences that a recurring order was authorized for.
EpicCareLinkEConsultEncounterContactSerialNumberNUMERICStores the contact serial number for the encounter associated with this e-consult order. This item is only used when the e-consult order is placed from EpicCare Link or EpicWeb.
ScheduledOrderReleaseQueueIdentificationVARCHARStores the queue ID when an order release is scheduled for a later instant. This ID corresponds to the ^HGEN("QITEM",###) node.
ProcedurePatientClassCategoryNumberVARCHARThe patient class category number for the patient at the time the procedure will be performed.
LastSequencingDocumentUpdateUtcDatetimeDATETIMEThe instant when the linked sequencing documents were last updated, represented in UTC.
DeprecatedPathologyResultNarrativeNoteIdentifierVARCHARThis column contains the pathology result narrative ID and only supports historical data.
OrderStatusCategoryNumberINTEGERThe order status category number of the procedure order.
ProcedureOrderArchivedIndicatorVARCHARIndicates whether the Procedure Order record is archived at the record level.
OrderFinancialClearanceStatusINTEGERRecords the financial clearance status of an order
OrderMedicalLeaveTypeINTEGERThe type of medical leave being ordered.
BreastImagingExamIndicationCodeINTEGERIndication for mammography exam specific to NMD version 2. Category values that can be mapped to BI-RADS indication for exam.
LastStandingOrderPerformanceDateDATETIMEThe date on which a standing order was last performed.
SpecimenTakenDateTimeDATETIMEThe date the specimen was taken.
OrderAccountOverrideIdentifierNUMERICThe unique ID of the order level account record override associated with this order.
RequestedDepartmentVARCHARThis column contains the requested department. The item is populated by the Cadence Orders Interface.
OverreadSourceOrderIdentifierNUMERICStores the order record ID that is marked for imaging overread.
ReferralChildWelfareServiceRoleINTEGERIndicates the child welfare service role in connection with child psychology services for the psychology referral order.
RequestedVisitFrequencyCategoryINTEGERThe category ID for the frequency of visits/units requested for the procedure (e.g. day, week, month, year).
HasLabSpecimenIndicatorVARCHARIndicates whether the order or any of the linked performable orders have a lab specimen. 'Y' indicates that the order or one of the linked performable orders has a lab specimen. 'N' indicates that the order does not have a linked lab specimen and no linked performable order has a lab specimen.
OrderCancellationCommentVARCHARComment entered while cancelling an order.
PatientBreastSelfExaminationCategoryINTEGERThe category ID that indicates whether or not a patient performs breast self-exams, which map to Yes, No, or N/A.
OrderRemovedByUserIdentifierVARCHARThe unique ID of the user who removed the order from the order scheduling worklist or workqueue.
StandingOrderIntervalVARCHARThe time interval set for a recurring order, indicating the time between one instance of the order and the next instance.
OriginatingOrganizationIdentifierNUMERICThis item holds the originating organization ID for this order. Most frequently this will be the organization that the order exists on, but it is possible to receive external orders, created elsewhere.
OrderBillingProviderIdentificationVARCHARThe unique ID of the provider under whose name this order should be billed. This might be the same ID as the AUTHRZING_PROV_ID.
LastMammogramProcedureNameVARCHARThe last breast procedure that was performed. This field allows you to freely specify a procedure name in case it was performed outside the organization.
ExcusedLeaveDurationInDaysINTEGERDuration of the excuse period in days.
FirstFinalResultUniversalTimeCoordinateDateTimeDATETIMEThe date and time final results were first made available on the chart.
OrderingProviderResultRoutingAddressVARCHARThe address of the ordering provider which will be used to receive the results of this order.
ReferralIdentifierNUMERICStores the associated referral ID for referral orders. Other columns in the same logical group are: SER_ADDRESSID (ORD 3001), REFG_FACILITY_ID (ORD 3010) and REFD_TO_PROV_ID(ORD 3100)
OrderCreatedContextIdentifierNUMERICStores the context (ODC) ID that was created by the order.
OrderReferralFormalityINTEGERStores the Referral Formality of an order.
OrderDomainCategoryINTEGERUsed to semantically group types of procedure orders
OrderResultCarbonCopyProviderRecipientIdentifierVARCHARStores SER of CC recipient. This is used to store the cc recipient for a result that has been received on the incoming interface. This item stores the recipient if it is an SER record. Also see items 2134 and 2135. Results Routing does not consider this item as it is only used for audit trail purposes.
ReferralProviderRoutingMethodCategoryINTEGERThe 'Encounter Communication Sent - Method' category ID for the routing method that will be used for automated results routing. The method is determined when placing an order in Ancillary Order Entry.
ObservationEndDateTimeDATETIMEThis is the end date for an observation. This typically equates to the end date of a specimen collection or the end date of a procedure.
OrderProcedureIdentifierNUMERICThe unique ID of the procedure order record.
ProtocolOrderSourceINTEGERStores the source of the protocol-based order.
SpecifiedFirstOccurrenceTimeDATETIMEThe first occurrence time specified by a user, if the order was signed with a frequency record containing a schedule of specified dates and times.
AnticoagulationTherapyTargetEndDateDATETIMETargeted end date for the patient's anticoagulation therapy.
ReferralPsychologyConsentToINTEGERIndicates the status of obtaining the patient's consent in connection with the referral's transfer of medical record information for the psychology referral order.
AdmissionDischargeTransferOrderTypeCategoryINTEGERThe ADT (admission, discharge, transfer) order type category ID for the order, indicating what type of patient movement this order is intended for.
ReferralLivingSituationINTEGERDescribes who the patient or child lives with for this psychology referral order.
FinancialCommitmentServiceProviderAddressVARCHARThe service provider address for the financial commitment.
PreferredAppointmentWindowEndTimeDATETIMEThis is the end of the appointment window for the preferred appointment window.
OrderTransmissionMethodINTEGERThis item holds the method of transmission for a given order. It should only be set from a property within an order transmittal rule.
ImagingExamLastPatientWeightGramsNUMERICMost recent patient weight (grams) preceding the end exam instant, within the system's age-based weight lookback range. Exams missing an end exam instant, as well as exams taking place too long after the last recorded patient weight, will not populate this item.
OrderLabelPrinterIdentifierNUMERICThe item will hold the label printer filled in the multi-step or multi-step collection form and will be used by the interface.
ProcedureOrderEndTimeDATETIMEThe date and time when the procedure order is to end.
InteractionOverrideCommentVARCHARInteraction override comment.
ScheduleDurationBufferMinutesINTEGERThe amount of time (in minutes) that should be added to system calculated scheduling duration as a buffer.
PrimaryRecipientFreeTextVARCHARStores free text of primary recipient. This is used to store the primary recipient for a result that has been received on the incoming interface. This item stores the recipient if it is not an SER or EAF record. Also see items 2130 and 2131. Results Routing does not consider this item as it is only used for audit trail purposes.
ReferredToPrimarySubspecialtyGrouperIdentifierNUMERICPrimary subspecialty to which the patient is being referred as a Search Subspecialty MAG record.
OrderTotalServicePriceNUMERICThe total price of the service.
BreastImagingPreliminaryOutcomeINTEGERStores preliminary FP/FN/TP/FN/etc info for a breast imaging study. May not contain the most current data until the MQSA report has been run.
ReferredToLocationIdentifierNUMERICThe unique ID of the location record to which this patient was referred.
AnticoagulationInternationalNormalizedRatioGoalCategoryIdentifierINTEGERThe International Normalized Ratio (INR) goal category ID for a patient on anticoagulation therapy.
AllowReferralWithoutProviderTeamIndicatorVARCHARThis item stores whether the "No Group" checkbox to allow placing a referral without an associated provider team has been checked.
ExpiringOrderInBasketMessageIdentificationVARCHARHolds the ID number of the Expiring Order In Basket message (EOW) associated with this Order. The In Basket message informs the user that a future order is about to expire.
ReferringProviderIdentificationVARCHARThe unique ID of the provider who has referred this order, i.e. the referring provider.
OrderLastOverallMammographyAssessmentVARCHARThe most recent overall mammography assessment for the order. This should be the same as the most recent value for ORDER_RAD_ASMT.ASSESSMENT_C. This column is used to link to the ZC_ASSESSMENT table.
PendingDiscontinueStatusINTEGERStatus of an order if the order is pending discontinue.
IsAnticoagulationIndefiniteVARCHARIndicates whether a patient is indefinitely on anticoagulation. 'Y' indicates anticoagulation is indefinite (no end date set for anticoagulation).
ResultLetterNotNeededIndicatorVARCHARIndicates whether a study is marked as not needing a mammography result letter. 'Y' indicates a study has been marked as not needing a result letter.
ReferredPrimaryTreatmentGrouperIdentifierNUMERICPrimary treatment for which the patient is being referred as a Search Treatment MAG record.
ProtocolAssignedProviderIdentificationVARCHARIf an order's protocol has been assigned to a provider, this item contains the provider ID of the assigned provider.
ProcedurePerformedDateDATETIMEThe date when the procedure will be performed.
LastMammogramLocationIdentifierNUMERICWhere the last breast procedure was performed. If it was performed by the current organization, this field will be empty
IsOrderAutoGeneratedVARCHARStores whether an order was auto-generated or not.
OrderCoverageIdentifierNUMERICThe unique ID of the order level coverage record associated with this order.
LastResultingLaboratoryIdentifierNUMERICThe unique ID of the resulting lab from the last contact where the procedure result status is not null.
LastFinalResultUserIdentifierVARCHARThe unique ID of the user who last made final results available on the chart.
OrderReadingPriorityCategoryNumberINTEGERThe reading priority category number of a study.
LogicalDeploymentOwnerIdentifierVARCHARID of the logical deployment owner for this record. Logical owners show the deployment where the record was created but doesn't represent if the record is a part of version skew.
OrderGroupRuleIdentifierVARCHARThe unique identifier (.1 item) for the rule that identifies this order group
IntraConnectOwningInstanceCommunityIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
OrderContextIdentifierNUMERICPointer to the order context record.
ProcedureFourthModifierIdentifierVARCHARThe unique ID of the modifier record. This is the fourth modifier entered for the procedure and affects how the procedure is billed.
ReferralFirstAppointmentByDateDATETIMEThe date that the first appointment for the referral should occur by.
ImageAvailabilityReceivedDateTimeDATETIMEThe date and time when we receive an image availability message from the interface.
MovedOrderSourceLinkIdentifierNUMERICThis object tracks order record links created when using the inpatient or ambulatory order mover utilities to move an order record. This item is populated on the source order record and points to the target order record(s) created.
PrimaryRecipientProviderIdentifierVARCHARStores SER of primary recipient. This is used to store the primary recipient for a result that has been received on the incoming interface. This item stores the recipient if it is an SER record. Also see items 2131 and 2132. Results Routing does not consider this item as it is only used for audit trail purposes.
OrderQuestionRecordListVARCHARThe list of question records associated with this order.
OrderScreeningFormIdentifierNUMERICThe unique ID of the screening form linked to the order.
PatientSignedMedicareDenialWaiverIndicatorVARCHARIndicates whether an Advanced Beneficiary Notice waiver form was signed by the patient in the event that the service to be performed was denied by Medicare.
MyChartBatchReleaseDateTimeDATETIMEServer time instant after which a result will be released to MyChart by the batch job
ImagingExamLastPatientHeightInCentimetersNUMERICMost recent patient height (centimeters) preceding the end exam instant, within the system's age-based height lookback range. Exams missing an end exam instant, as well as exams taking place too long after the last recorded patient height, will not populate this item.
LastHormoneReviewUserIdentificationVARCHARThe last user to review the hormone history.
ExtractedInstanceCommunityIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
PreviousOrderContextIdentifierNUMERICThis item stores the context the order was linked to prior to being released.
RadiologyExamEndUniversalTimeDATETIMEThe date and time an order's exam is ended in the Universal Time Coordinated (UTC) format.
OrderGroupPrimaryOrderIdentifierNUMERICThe unique identifier (.1 item) for the primary order for this order group.
OvarianFollicleAverageRoundingMethodINTEGERThe measurement rounding method for ovarian follicle averages. This indicates whether follicle measurement averages are rounded to the nearest whole-millimeter or half-millimeter. This is only set for studies that contain ovarian follicle measurements. Also only used for averages, not follicle diameters which always round to the nearest tenth.
IntendedSmokingCessationDateDATETIMEThe date a patient plans to quit smoking. This value is populated by filing an order-specific question.
MaternalUltrasoundResultIdentifierNUMERICThis column contains a link to the RES record where findings specific to the mother were filed for this ultrasound order.
OrderLookupIndexIdentifierNUMERICContains an ID from Order Lookup Index. This may be populated if an order originates from an Order Panel.
SendingOrganizationServiceAreaIdentifierVARCHARThis item stores the identifier of the service area from the external organization that sent this order. This will often be from the organization that created the order, but that will not always be the case in the event the order has been passed along to multiple organizations.
LastBreastProcedureWeightInOuncesNUMERICThe patient's weight (oz.) at the last breast procedure.
OrderServiceProviderIdentificationVARCHARThe provider on the service.
RequestedProcedureDateTimeDATETIMEThe requested date and time. The items extracted to this column are populated by the Cadence Orders Interface.
LastSequencingDATETIMEThe instant when the linked sequencing documents were last updated, represented in the local time of the system that made the change.
IsImportantResultMessageFlagVARCHARFlag IB Result Message as Important.
SchedulingFlagRemovalMethodCodeINTEGERStores the method used to remove the "Needs Scheduling" flag on the schedulable order. Currently this is set for orders that had the flag manually cleared and for orders where the flag was automatically cleared because the order was expired.
PictureArchivingCommunicationSystemImageLocationIdentifierINTEGERStores the category ID of the PACS (picture archiving and communication) system has the images for a radiology order.
OrderSourceCategoryIdentifierINTEGERThe order source category ID of the order, indicating where in the EHR the order was entered.
LastExcludedFromClinicalDecisionSupportDateTimeDATETIMEThe instance when the "Exclude From Decision Support" was updated on the order record.
PatientExcusedFromLeaveActivitiesIndicatorVARCHARWhether the patient should be excused from doing specific activities during the leave.
InpatientStandingOrderReleaseIntervalVARCHARThis item stores the interval at which a standing order should be released for inpatient orders.
OrderExcludeFromClinicalDecisionSupportUtcLastUpdatedDateTimeDATETIMEThe instance in UTC when the "Exclude From Decision Support" was updated on the order record.
DefaultBundleCodesUsedForChargesIndicatorVARCHARIndicates historical data about whether the default bundle codes are used for charges. 'Y' indicates that default bundle codes were used for charges, 'N' or NULL indicate that default bundle codes were not used.
OutsideServiceViewAuthorizationEndDateDATETIMEThe authorized end date to view service events if the service provider is authorized to view documents for a specific date range.
InitialOrderIdentifierNUMERICThis column contains the originating order ID. It is related conceptually to ORDER_PROC_2.ORIGINAL_ORDER_ID, but rather than pointing back to the previous order ID at the same level in the order tree hierarchy, this column will point back to the initial order created by the ordering end user. Use this column to find out information about the initial order, or to determine if an order went through a change procedure workflow which generated new order records.
OrderStatusReversionCommentVARCHARStores the comment given for reverting an order to a previous radiology status.
ReadingProviderIdentifierVARCHARThe unique ID of the reading physician of the exam.
ReceivedExternalAuthorizingProviderNameVARCHARThis item holds the free-text for the received authorizing provider's name. It is free text and not linked to a provider record because we do not want to generate provider records for all received external result orders.
IsRulesBasedOrderTransmittalUsedVARCHARStores a Yes if rules based order transmittal was used on this order.
ObservationEndTimeDATETIMEThis is the end time for an observation. This typically equates to the end time of a specimen collection or the end time of a procedure.
ServiceNotCoveredIndicatorVARCHARThis item indicates whether or not the service is covered.
FutureExpectedDateDetailsTextVARCHARThis item holds the free-text details entered if the future expected date comment (FUTURE_EXPECTED_DATE_COMMENT_C) is "Other (Specify)".
ProcedureOrderReferralTypeCategoryVARCHARThe referral type category number for the procedure order.
ActiveProcedureOrderCategoryTypeINTEGERThis item holds the category type of the active procedure order. Only active procedure type orders will be contained in this item. Medications are excluded. The categories separate order type in parent/child/normal and IP/OP order type.
OrderResultedViaInterfaceIndicatorVARCHARIndicates whether this order was resulted through an interface or not. Y indicates that the result came through an interface, N indicates it was not resulted through an interface but rather some other result mechanism or not resulted at all.
OrderStatusCompletedByUserIdentifierVARCHARThe ID of the user who marked an inpatient procedure as 'Complete'
CollectedSpecimenAmountVARCHARThe amount of specimen that was collected. The identifier for the units for this amount are in COLL_AMT_UNIT_ID.
ReferredToSpecialtyCategoryVARCHARThe category value for the medical specialty of the provider to which the patient is referred. This field does not contain data for referral orders created within Epic.
PendedOrderSignActionINTEGERSign action for pended order.
OrderStatusCategoryIdentifierINTEGERThe active order category ID, which indicates information about the order status.
ProcedureOrderChargeGeneratedDateTimeDATETIMEThe date and time when the charge was generated for the procedure order.
ReferenceLabClientIdentifierVARCHARThe client ID or account ID assigned by the reference lab.
LastBreastHistoryReviewedInstantDATETIMEThe instant the last breast procedure information was reviewed.
OrderTransmittalNextPassNumberINTEGERHolds the next pass number that Order Transmittal needs to take on this Order.
ShouldGeneratePatientEstimateFlagVARCHARA flag used for pended orders that indicates that the order should generate a patient estimate record when it is fully signed.
IsLabChargeTriggeredIndicatorVARCHARIndicates whether a charge was triggered in lab.
LastChartedDateTimeUtcDATETIMEThe date and time results were last made available on the chart.
PhysicalDeploymentOwnerIdentifierVARCHARID of the physical deployment owner for this record. Physical owners will be where the data is hosted, either on the cross-over server or the owner deployment.
LastResultUpdateDateTimeDATETIMEThe date and time of the last result date. This item is set based on a time stamp received in the interface. It is also set when results are manually entered or when an order is cancelled.
NoChargeReasonCodeINTEGERContains the reason that no charges were linked to the order.
FirstCorrectingUserIdentifierVARCHARThe unique ID of the user who first authorized a correction to the result on this order.
IsReferralForDifferentProblemVARCHARThis column returns "Y" if the referral order is for a problem different from the problem being treated in the encounter where this order was placed. If the referral order is for the same problem then this column will be "N" or nothing is returned. This column can only be populated if an organization has the PAS license.
InstantiatingUserIdentifierVARCHARThe unique ID of the user who instantiated the order.
LaboratorySpecialResultTypeINTEGERIndicates the type of data the laboratory result is.
LastImagingStudyReadDateTimeDATETIMEStores the last time an imaging order had a status change of "SAVED" or higher.
ProcedureInstructionsSavedVARCHARFlag for an order that was created after item ORD-10650 PROCESS INSTRUCTIONS AT SIGNING was created.
LeaveLightDutyEndDateDATETIMEEnd date of the light duty period.
OrderPriorityCodeINTEGERStores the radiology result priority.
OrderPotentialAddonIndicatorVARCHARIndicates whether an add-on was possible for this order at the time of ordering.
ParentOrderCreationInstantDATETIMEThe instant when the parent order was created, local to this order's time zone.
MammographyQualityStandardsActExclusionReasonNoteIdentifierVARCHARFree text explanation of why this order is excluded from MQSA statistics. Use this column to join to the HNO_NOTE_TEXT table on the NOTE_ID column to obtain the reason text.
PrintLocalCopyIndicatorVARCHARWhether to print a copy of this order.
OrderGroupSessionDateTimeDATETIMEThe date and time that identifies this order group.
SpecimenCollectionDepartmentIdentifierNUMERICThe unique identifier of the department where the specimen was collected.
ApprovedUnitsPerPeriodINTEGERApproved units/visits per period. This along with the approved periods (APPR_PERIODS) determines the total 'approved units'.
FirstCorrectedResultTimestampDATETIMEThe date and time the results of this order were first corrected.
ReferralExpirationDateDATETIMEThe expiration date for this referral order.
OrderExpirationBeforeEndTimeDATETIMEThe date and time an order will be labeled as expiring, based on a defined period of time before the order's end time.
ProcedureIdentifierNUMERICThe unique ID of the procedure record corresponding to this order. This can be used to link to CLARITY_EAP.
OrderSigningPatientLocationDepartmentIdentifierNUMERICThe unique identifier of the department where the patient is located at the time this order was signed,
ProcedureLoincSourceCategoryINTEGERSource of the procedure LOINC ID.
PerformedProtocolCodeVARCHARPerformed Protocol Code Sequence: Meant to indicate the protocol that was actually performed on the ordered procedure (can differ from protocol that was ordered). Sequence specified DICOM documentation for MPPS messages. See IHE EYECARE transaction
IsSchedulingToleranceBeforeUnrestrictedVARCHARIndicates if the No restriction checkbox is checked for scheduling tolerance before the expected treatment date for a schedulable procedure. 'Y' indicates there are no restrictions.
MyChartMetricsIsResultFinalVARCHARThis item returns true if the result has a status of Final, the result is not canceled, and the result contact source is not 8-Procedure Notes. It is used only by MyChart results release metrics.
ProcedureIsPossibleIndicatorVARCHARIndicates whether or not the procedure is a possible procedure.
OrderProcedureGenericCategoryCodeINTEGERA generic category item that associated with each procedure of a referral solely for documentation purposes (purely customer defined)
ResultingAgencyNetworkIdentifierNUMERICThe resulting agency (LLB) record used when ordering this test over the Aura network.
IsBalanceAdjustedIndicatorVARCHARStores whether the balance for supplies/drugs is already adjusted.
OrderPerformedDateTimeDATETIMEThe date and time the order was performed.
ImagingAddendumUpdatedInEpicDateTimeDATETIMEThis column stores when the addendum is updated in Epic (addendum sign date if using an Epic workflow, otherwise whenever received over the interface)
TransmitOrderFlagVARCHARIndicates to Order Transmittal whether order transmittal should be done on this Order.
LastRedrawReasonCategoryIdentifierINTEGERThe last redraw reason category ID for the order.
ReflexOrderSchedulingEventINTEGERThe event a scheduled reflex used to determine the scheduling time.
CommunityIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
LastFinalResultChartedUtcDatetimeDATETIMEThe date and time final results were last made available on the chart.
FutureExpectedDateCommentCategoryINTEGERHolds a category value for the comment part of expected date. This will include categories based on scheduling comments like "Before Surgery", "After Consult", etc.
LightDutyLeaveDurationInDaysINTEGERDuration of the light duty period in days.
LastResultUpdateUtcInstantDATETIMEStores the last update instant for a result in UTC
TranscriptionistUserIdentifierVARCHARThe unique ID of the user record of the transcriptionist for this order.
OrderPrioritizedInstantUtcTimestampDATETIMEThis item stores the prioritized instant (date and time) for an order in UTC time zone. It represents the most relevant date and time an action was taken on an order.
OwningInstanceCommunityIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
ReferralRequestINTEGERStores Referral Requesting Authority of an order.
AssociatedProblemListIdentifierNUMERICThe unique ID of the problem list record that is associated with this order. This column is mainly used for immunization orders.
ScheduleOrderExternalIdentificationVARCHARSchedule orders external id used for CS and EDI
LastBreastProcedureOrderIdNUMERICThe last breast procedure that was performed on this patient prior to this order.
ProtocolScheduleState</blockquote>INTEGERThe scheduling status for an order which requires a protocol. This column links to the ZC_PROTCL_STATE table.
OrderHasPendingStatusIndicatorVARCHARIndicates whether or not the order has a pending status. 'Y' indicates that the order has a pending status. 'N' or NULL indicates that the order does not have a pending status.
SnomedCodeSourceTypeINTEGERsource of the SNOMED code (reported vs inferred)
SendBackToSignerForReviewIndicatorVARCHARIndicates whether multi-discipline studies will be sent back to previous signers for review if the result text has been changed for this order. Yes indicates that studies will be sent back. No or Null will indicate that studies will not be sent back. The data is automatically populated when an imaging study reaches Exam Ended or Exam Begun from the value in field "Sign Again if Result Text Changed" in the Radiology/Cardiology Options 3 screen of the linked procedure. If that is null then we look at the same field in the procedure category or the Study review node of the Imaging System Definitions. Users can change the original value by changing the same field in the advanced mode of the Assign Activity.
ProcedureDurationINTEGERDuration for this procedure.
OutsourcedServiceAuthorizedAmountNUMERICThe amount for which the financial commitment is authorized.
MyChartMetricEntryInstantDATETIMEThis item returns the Instant of Entry if the result has a status of Final, the result is not canceled, and the result contact source is not 8-Procedure Notes. It is used only by MyChart results release metrics.
OrderAppointmentStatusCategoryINTEGERThe appointment scheduling status category number for the order. This column will be null if the order is not schedulable.
UnscheduledFrequencyFlagINTEGERIf the frequency is unscheduled, this column will store a 1. If the frequency is not unscheduled, this column will be blank.
LastOrderResultCorrectionAuthorizedByUserIdVARCHARThe unique ID of the user who last authorized a correction to the results of this order.
OrderWorkqueueRemovalReasonCommentVARCHARFree text comments entered by the user who removed an order from the scheduling workqueue or worklist explaining why the order was removed.
AfterTransmittalOrderIdVARCHARThis column contains the After Order ID for an order after Order Transmittal.
OrderChartCorrectionIdentifierNUMERICThe unique identifier of the chart correction audit record for the order.
MyChartMetricResultContactUtcDatetimeDATETIMEThis item returns the Contact Instant if the result has a status of Final, the result is not canceled, and the result contact source is not 8-Procedure Notes. It is used only by MyChart results release metrics.
OutsourcedServiceProviderNameVARCHARThe service provider name for the financial commitment.
ImagingStudyStatusCategoryINTEGERThe category ID for the imaging study status (e.g. technician ended the exam, reading physician finalized the exam) of the procedure order.
ApprovedServiceUnitQuantityINTEGERThe number of units approved for the service.
MyChartPatientStatusAtResultFinalizationINTEGERThis item returns the MyChart status of the patient at the time the result was finalized. It is used only by MyChart results release metrics.
CopiedCarbonRecipientFacilityIdentifierNUMERICStores EAF of CC recipient. This is used to store the CC recipient for a result that has been received on the incoming interface. This item stores the recipient if it is an EAF record. Also see items 2133 and 2135. Results Routing does not consider this item as it is only used for audit trail purposes.
RequiredSignatureCountINTEGERThe number of physician signatures required to move the study status to final within the procedural applications.
ModalityProcedureEndDateTimeDATETIMEFor procedures performed on modalities using Digital Imaging and Communications in Medicine (DICOM), this stores the end date & time of the performed procedure sent from the modality to system.
WasAddonRequestedForOrderFlagVARCHARIndicates whether an add-on was requested for this order at the time of ordering.
OrderSpecimenDrawTypeCategoryIdentifierINTEGERThe specimen draw type category ID for the order.
TotalImagesPerformedInExamINTEGERThe number of images performed by a tech during the imaging exam linked to this order. This number is a total for the exam and includes images done on other procedures linked to the same appointment.
OrderableQuestionnaireVersionDateVARCHARThe date corresponding to the version of the parent Orderable OSQ used to place this order.
OrderProtocolStatusINTEGERContains the current status of the order's protocols. Will be used to determine how to populate the protocol work list.
OrderPatientClassRemovalReasonINTEGERThis holds a reason that the patient class was stripped from the order. If this value is blank, it can mean either that the procedure didn't have a patient class or that the reason the patient class was stripped isn't a reason that's audited.
CommunityLogOwnerIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
OrderQuestionnaireSeriesIdentifierNUMERICThis item stores the questionnaire series that the patient is being assigned to using this order.
IsMultipassOrderTransmittalCompletedVARCHARIs multipass order transmittal completed?
OrderSummaryGenerationInstantDATETIMEInstant that the summary sentence was generated for a signed order.
InpatientConditionalOrderCategoryIdentifierINTEGERThe inpatient conditional order category ID for the order, indicating whether this order should be conditionally initiated.
ReplacedProcedureOrderIdNUMERICThe unique ID of the changed or reordered procedure order that this procedure replaced. This column is frequently used to link back to ORDER_PROC table.
OrderScheduleWorkqueueRemovalInstantDATETIMEThe date and time when the order was removed from the schedule orders workqueue or worklist. The information is only populated for orders that are currently removed and were removed manually by a user.
AuthorizingProviderRoutingMethodINTEGERthis item stores the routing method for the authorizing provider
ReferralOrderParentalResponsibilityINTEGERIndicates which entity has parental responsibility for the patient for the psychology referral order.
OverrideTaskTemplateIdentificationVARCHARContains the override task template ID for overriddem anchored orders, orders attached to a time (for example, a pregnant woman's delivery date).
AuthorizingProviderUserIdVARCHARThe unique identifier for the authorizing provider of the order record.
LastScheduledInstantDateTimeDATETIMEThis item stores the inpatient order's last scheduled instant.
ProcedureOrderExtractionDateTimeDATETIMEThe date and time the procedure order was extracted from the database.
PatientAgeAtExaminationINTEGERThe age of the patient (in years) as of the date of the exam. If the exam has ended, this will be the age as of end exam. If not, this will be the age as of the scheduled appointment date. If an appointment has not been scheduled for this exam, this value will be null.
OrderInstantiationTimestampDATETIMEThe date and time of instantiation when a child order is generated from a standing or future order.
IsExternalImagingStudyReadVARCHARThis item indicates whether this order is for an external read of an imaging study. A null value should be assumed to be No.
ResultingAgencyIdentifierNUMERICThe unique ID of the lab or other resulting agency, such as radiology, that provided the order results.
IncludeFindingsAvatarInReportIndicatorVARCHARDetermines whether or not the findings avatar should be included in the report
OrderProtocolStatusUtcDatetimeDATETIMEThis is the instant of the schedule state of the protocol for the order was set.
OrderEncounterTypeINTEGERThis indicates whether an order is an inpatient or outpatient order. Note that Outpatient orders can be placed from an Inpatient encounter as discharge orders. This column might be blank for Outpatient orders placed prior to the creation of the IP module. This column is used to link to the ZC_ORDERING_MODE table.
PatientPayableAmountNUMERICThe amount or portion the patient will have to pay for the service they are being referred for.
ProcedureStartDateTimeDATETIMEThe date and time when the procedure order is to start.
ChargeTriggerResultIdentifierINTEGERThe result of a charge trigger
IsProcedureChangedInWorkflowVARCHARThis column determines whether the orderable procedure was changed as part of a change procedure workflow that generated new order records. The column will be set to 1 - Yes if a new procedure was selected during the change procedure workflow step. If the procedure was kept and other details were changed, this column will be populated with 0 - No. If the order did not go through a change procedure workflow which generated new order records, this column will be null.
PanelProcedureIdentifierNUMERICThe unique ID of the panel procedure record associated with this order.
AddOnSpecimenIdentifierVARCHARThe unique ID of the specimen that the order was added onto.
PerformedProtocolNameVARCHARName/description for the protocol that was actually performed on the ordered procedure (can differ from protocol that was ordered). Correlates with Protocol Performed Code. See IHE EYECARE transaction
NonParticipatingReferralIdentifierNUMERICThe unique ID of patient and coverage information for non-participatory lab referrals attached to this order. If this is filled in, then PAT_ID and related columns in the ORDER_PROC table will not be filled in for this order. This column is frequently used to link to the RQG_DB_MAIN table.
IsSavedOrderIndicatorVARCHARIndicates whether an order has a status of saved. A "Yes" value indicates that the order is in a status of saved. A null value indicates that the order is not in a status of saved. A "No" value will not be populated for this column.
OrderProcedureFirstModifierIdentificationVARCHARThe unique ID of the modifier record. This is the first modifier entered for the procedure and affects how the procedure is billed.
OrderBillAreaIdentifierNUMERICThe bill area this order is associated with.
ImagingResultLastUpdatedInEpicDateDATETIMEThis column stores when the result is updated in Epic (sign date if using an Epic workflow, otherwise whenever received over the interface)
ProcedureConditionGroupCategoryINTEGERStores the patient condition group. It is used to default the procedure date based on the selected condition group.
SpecimenSourceCommentVARCHARThis free text item is used to store comments about the specimen source.
ReferralPriorityCategoryVARCHARThe priority level category number of a referral order, which is used to specify whether a referral order is routine, urgent, emergency or elective. This column is used to link to the ZC_RFL_PRIORITY table.
OrderOriginatingOrganizationIdentifierVARCHARThe unique ID generated by the organization that originally created this order.
DiscontinuedOrderLocalInstantDATETIMEThe instant the order was discontinued or canceled in the local timezone.
CrossEncounterAvailabilityStatusINTEGERThis item is a yes/no/complete item which will indicate whether this order is available to other encounters. If this item is set as 'complete', then the order has been released and is no longer available.
IsFutureDateApproximateIndicatorVARCHARIndicates whether there is an approximate future expected date for this order. 'Y' indicates there is an approximate future expected date. 'N' or NULL indicates that there is not an approximate future expected date.
MammographyQualityStandardsActExcludingUserIdentifierVARCHARUser that excluded this order from mammography MQSA reports.
IsSignedAndHeldOrderINTEGERThis item stores 1 if the order is signed and held and active
PatientEncounterContactSerialNumberNUMERICThe unique contact serial number for this contact. This number is unique across patients and encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
ReferredToDepartmentSpecialtyVARCHARThe category value for the requested medical specialty of the department to which the patient is referred.
ReferringProviderAddressIdentifierVARCHARStores the referring provider address ID for referral orders. The format is provider external ID - Address line number. For example, if provider external ID = 123 and Address line = 4, the value would be 123-4. If the referring provider has no address, this will store the provider external ID only. Other columns in the same logical group are: REFG_FACILITY_ID (ORD 3010), REFD_TO_PROV_ID(ORD 3100) and REFERRAL_ID (ORD 3300)
CommunityLogOwnerIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
IsOrderResultAbnormalVARCHARIndicates whether or not this order contains abnormal results. This column will contain a Y if there are abnormal results and an N or null if it does not. For orders with lab component results, if any one component of this order has an abnormal result value then this will hold a Y.
ExternalOrderResultTranscriptionistVARCHARThe transcriptionist of an external order result coming through the transcription interface.
ImagingStudyInstanceIdentifierVARCHARThis column stores the unique identifier for an instance of a DICOM imaging study.
MammogramWeightChangeRecordedDateNUMERICThe date the patient's weight change was recorded.
IsInpatientOrderAutoReleaseVARCHARThis item indicates whether child instances of a standing order should be automatically released for inpatient orders.
ApprovedPeriodsINTEGERApproved periods. Also known as duration. Approved units per period (APPR_PER_PERIOD) along with the approved periods determines the total 'approved units'.
AuthorizingProviderResultRoutingAddressIdentifierVARCHARThe authorizing provider's address ID-LINE that will be used to receive the final result report. In order to pull the actual address, link ORDER_PROC_2.AUTH_PRV_ROUT_ADDR to CLARITY_SER_ADDR.ADDR_UNIQUE_ID.
ProcedureLogicalObservationIdentifierNumberCodeIdentifierNUMERICLOINC ID associated with the procedure.
IsExpirationMeasuredInDaysIndicatorVARCHARIndicates whether the amount of time determining when an order will expire is in measured in days or instants. '0' indicates that the expiration time is in a number of hours. '1' indicates the expiration time is in a number of days or weeks.
OrderCheckoutCommentVARCHARThe check-out comments entered on the order.
ImagingExamLastPatientClassVARCHARStores the calculated patient class as of the time the exam was begun by retrieving the ADT record most recently preceding the begin exam time (or end exam time if begin exam doesn't exist). If no relevant ADT record is found, then the current patient class on the first appointment contact scheduled to a modality will be used.
OrderCreationInstantDATETIMEThe instant when the order was created.
ProcedureOrderDescriptionVARCHARA brief summary of the procedure order.
MedicalLeaveEndDateDATETIMEEnd date of the medical leave.
OrderingProviderRoutingMethodINTEGERThis item stores the routing method for the ordering provider
HomeCareEpisodeTypeINTEGERThis item stores the type of home care episode the order should create if it is a home care referral order.
OrderDiscreteIntervalVARCHARThe discrete interval for the order. This is extracted as the category title.
PrincipalResultsInterpreterNameVARCHARThe name of the principal results interpreter, the person who reviewed and interpreted the results.
FirstChartedDateTimeUtcDATETIMEThe date and time results were first made available on the chart.
OrderReflexSourceCategoryIdentifierINTEGERThe reflex source category ID for the order.
ScheduledChildOrderInstantDATETIMEStores the scheduled instant of the child order.
MedicalLeaveDurationInDaysINTEGERDuration of the medical leave in days.
OrderProtocolAssignedPoolIdentifierVARCHARIf an order's protocol has been assigned to a pool, this item contains the pool ID of the assigned pool.
LastImagingProcedureStatusInstantDATETIMEThe instant of the last Imaging and Procedure (IProc) status update of an order.
LastCorrectedOrderResultDateTimeDATETIMEThe date and time the results of this order were last corrected.
ProcedureOrderClassVARCHARThe order class category number of the procedure order.
EncounterContactSerialNumberNUMERICThe 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).
BreastImagingTypeCodeINTEGERThe imaging type category ID used to indicate whether standard imaging only, or standard plus additional imaging, was performed. Category values used for the NMD 3.0 extract.
SpecimenCollectionPatientScanRequirementSourceINTEGERIndicates the source of a required patient scan when collecting specimens.
OrderSigningDepartmentIdentifierNUMERICThe unique identifier for the login department used by the user signing the order.
ImagingProtocolSourceOrderIdNUMERICFor an order that was placed from an imaging protocol, this item contains the protocolled imaging procedure order from which the order was placed. This item can be used to help associate contrast, medication, and point-of-care lab test orders with the protocolled procedure orders for which they were placed.
InpatientConditionalOrderMetDateTimeDATETIMEStores the instant when the condition was marked as "met/satisfied" (ORD-1401) for an inpatient conditional order.
SendingOrganizationIdentifierNUMERICThis item stores the ID of the organization (DXO) that sent this order. This will often be the organization that created the order, but that will not always be the case in the event the order has been passed along to multiple organizations.
BreastImagingMammographyIndicationVersion3INTEGERIndication for mammography exam specific to NMD version 3. Category values that can be mapped to BI-RADS indication for exam. .
SelfReferredReasonCategoryINTEGERThe reason why the self-referred item is set to its current value.
ReferralPsychologyCaseWorkerNameVARCHARThe case manager of the child psychology case for this psychology referral order.
OrderResultRemarkNoteIdentifierVARCHARStores the link to the general notes record containing the result remarks. It is networked to General Use Notes record.
OrderPlacementDatetimeDATETIMEThe date and time when the procedure order was placed.
ProcedureOrderInterfaceStatusCategoryINTEGERThe interface status category number of the procedure order as it relates to the orders interface.
OrderDATETIMEInstant on which this order was excluded from MQSA reports.
IsOrderExchangedOnNetworkVARCHARIndicates whether this order is exchanged on the orders and results network.
OrderReferralReasonCategoryVARCHARThe reason for referral category number for the procedure order.
ExamWeightRecordedDateDATETIMEThe date when patient's current weight was recorded.
LastStudyEditTimeDATETIMEThe column contains the time the study was last opened in edit mode.
InBasketMessageThreadNUMERICStores In Basket message thread created when signing an order (Ex: During E-Consult workflow)
OrderIndicationCommentVARCHARThe comment entered for the indications of use for this order.
FindingsAvatarImageDocumentIdentificationVARCHARStores the Document ID of the image for the findings avatar
ProcedureStatusCategoryIdINTEGERThe imaging and procedure status category ID of an order.
ReferralAuthorizedVisitCountINTEGERThe number of visits this referral order is authorized for.
ProcedureSecondModifierIdentifierVARCHARThe unique ID of the modifier record. This is the second modifier entered for the procedure and affects how the procedure is billed.
OrderIdentifierNUMERICThe unique identifier for the order record.