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

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.

Column NameTypeDescription
AssociatedPatientIdentifierVARCHARStores a link to the EPT record used as a source for this requester.
AccountAddressDistrictCategoryNumberINTEGERThe district category number for the account's address.
PaymentPlanTotalAmountNUMERICThe payment plan total amount.
ShouldExtractGuarantorFlagVARCHARThis column indicates whether the guarantor should be extracted. If the guarantor is homed it will be extracted, otherwise not: 1-extract, 0-do not extract.
HospitalAccountBadDebtUndistributedBalanceNUMERICThis column stores the total of all undistributed buckets for this guarantor's hospital accounts that are in bad debt when using account-based bad debt.
GuarantorPaymentLikelihoodCategoryINTEGERCategory describing the likelihood for this guarantor to pay.
GuarantorMilitaryBranchOfServiceINTEGERThis column stores the military branch of service to which the guarantor belongs.
CoverageLastVerificationDateDATETIMEContains the date that the corresponding coverage was last verified.
GuarantorStateVARCHARThe category value of the state in which the guarantor lives.
RequestorIsDisplayedInQuickDisclosureIndicatorVARCHARIndicates whether a requester can appear in the quick disclosure activity. Y indicates that the requester will appear in the activity.
AccountNUMERICThe amount of the insurance balance on the guarantor as of the time of the extract.
GuarantorCityVARCHARThe city in which the guarantor lives.
AccountUndistributedInsuranceCreditBalanceNUMERICAccount undistributed credit balance - insurance credits only.
GuarantorSynchronizationOwnerAccountIdentifierNUMERICWhen using guarantor account syncing, this item is the record pointer to the owning guarantor account, if one exists.
LastProfessionalBillingSelfPayBalanceUpdateDateDATETIMEThis is updated based on changes to patient balance.
GuarantorEmployerStateCategoryVARCHARThe category number for the state of the guarantor's employer.
ProfessionalBillingExternalBadDebtInsuranceBalanceNUMERICThis value is the Professional Billing external AR bad debt insurance balance.
GuarantorEmployerCountyCategoryVARCHARThe category value corresponding to the county in which the guarantor's employer is located.
HospitalAccountLastDemandStatementDateDATETIMEThis column contains the date of the last demand statement to be sent to the guarantor.
AccountOverdueNoticeCycleIdentifierNUMERICThis column stores the unique identifier for the follow-up cycle record used to determine at what point overdue notices for bills are sent to this guarantor.
LastPatientPaymentAmountNUMERICThe amount of the most recent patient payment received for this account before the enterprise reporting extract.
LastStatementInsuranceBalanceNUMERICLast statement's insurance amount
PaymentPlanCurrentMissedCountINTEGERThis item will store the number of payments that are currently late on the payment plan
AccountHospitalBillingExternalAccountsReceivableSelfPayBalanceNUMERICThis item stores the Hospital Billing (HB) external Accounts Receivable (AR) self-pay balance for the account.
GuarantorGuestPayLockUtcInstantDATETIMEThe UTC instant when Pay as Guest is locked for the guarantor account.
ReleaseOfInformationBillingHouseNumberVARCHARHouse number for ROI billing address
LastEnterpriseInformationalStatementDateDATETIMEThis column stores the date the last enterprise non-demand informational statement was generated. Informational statements are those with no self-pay balance for the guarantor.
PaymentPlanDelinquentAmountNUMERICThis is the sum of delinquent payment plan payments.
FollowUpLastLetterSentDateDATETIMEDate the last follow-up letter was sent.
AccountEmployerIdentifierVARCHARThis is the unique ID of the employer record (EEP .1) associated with this account if EAF 6410 is set to 1. This is free text if EAF 6410 is set to 2.
DefaultReleaseOfInformationTypeIdentificationNUMERICDefines the default release type to be used when the requester is selected within the Release of Information activity.
GuarantorBillingAddressCountyCategoryVARCHARThe category number for the county of the guarantor's billing address.
GuarantorRecordIdentifierNUMERICThis column stores the unique identifier for the guarantor record. This field will be hidden in a public view of the ACCOUNT table.
GuarantorMilitaryRankCodeINTEGERThis column stores the military rank to which the patient's guarantor belongs.
GuarantorStatementFrequencyINTEGERSpecifies the statement frequency for this guarantor. Available options are weekly, monthly, bi-weekly, or weekly and end-of-month.
BillingStatusExpirationDateTimeDATETIMEBilling status expiration date
HospitalBillingUndistributedBalanceNUMERICThis value is the Hospital Billing undistributed balance on the account, but excludes hospital accounts in external AR or bad debt.
GuarantorEmployeeIdentificationNumberVARCHAREmployee ID number of the guarantor.
AccountExternalHospitalBillingInsuranceBalanceAmountNUMERICThis item stores the Hospital Billing (HB) external Accounts Receivable (AR) insurance balance for the account.
HospitalBadDebtInsuranceBalanceNUMERICThis column stores the total of all insurance buckets for this guarantor's hospital accounts that are in bad debt when using account-based bad debt.
StatementInterventionRuleIdentifierVARCHARThe statement intervention rule that caused the guarantor account to be held in PB statement processing.
GuarantorVerificationNextReviewDateDATETIMENext date this guarantor's verification should be reviewed.
LastLetterFollowUpLevelINTEGERThis retains the value of the current follow up level (I EAR 3007) when a letter was last generated.
ReleaseOfInformationTaxExemptIndicatorVARCHARIndicates whether releases of information for this requester are tax-exempt. Y indicates that the requester's releases are tax-exempt. N or a null value indicates that the requester's releases are taxed.
CommunityPhysicianOwnerIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
HospitalAccountPaymentPlanCurrentAmountDueVARCHARCurrent amount due on a hospital account for a payment plan.
RequisitionGrouperGuarantorRelationshipIdentifierINTEGERThis column stores the unique identifier for the guarantor's relationship to the requisition grouper patient record.
GuarantorNextStatementDateDATETIMEThis column contains the date of the next statement to be sent to the guarantor.
HospitalBillingBalanceNUMERICThis value is the Hospital Billing balance on the guarantor.
AccountLastFollowUpTaskCycleNUMERICFollow up cycle of last task on an account.
PaymentPlanEffectiveDateDATETIMEThis column stores the date when the payment plan becomes effective. This column will only be populated if the guarantor is on a payment plan.
AssociatedAccountIdentifierNUMERICStores a link to the EAR record used as a source for this requester.
AccountTypeCategoryINTEGERCategory value associated with the type of account, such as Personal/Family, Worker’s Comp, etc.
AccountEmployerPhoneNumberVARCHARThe phone number for the employer associated with this account (may contain dashes).
GuarantorWorkPhoneNumberVARCHARThe guarantor’s work phone number (may contain dashes).
GuarantorLastViewedHospitalBillDetailInMyChartDateTimeDATETIMEThe date and time when a Hospital Billing detail bill was last viewed in MyChart by this guarantor. The date and time for this column is stored in Universal Coordinated Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
GuarantorVerificationStatusVARCHARThe category number of the guarantor verification status.
HospitalAccountPaymentPlanMonthlyAmountDueVARCHARThis column contains the monthly payment due on a hospital account for a payment plan.
LastHospitalBillingBalanceNotificationDateDATETIMEThe date on which the last balance notification was sent to the guarantor for their Hospital Billing (HB) / Single Billing Office (SBO) balances.
GuarantorPreferredLanguageVARCHARThe category value for the preferred language of the guarantor.
PaymentPlanCurrentBalanceNUMERICThe Hospital Billing Payment Plan current balance.
IsRequisitionGrouperAccountVARCHARIndicates whether this is a requisition grouper account.
GuarantorMobilePhoneNumberVARCHARMobile phone for guarantor accounts.
GuarantorHospitalBillingNoteExpirationDateDATETIMEThis column contains the expiration date of the billing note on this guarantor.
AssociatedPatientConfidentialNameVARCHARThis item contains the confidential name of the associated patient, if it exists. This name is used to determine the confidential nature of the guarantor.
GuarantorEmploymentDateDATETIMEThe date the guarantor was employed.
ExternalProfessionalBillingBadDebtSelfPayBalanceNUMERICThis value is the Professional Billing external AR bad debt self-pay balance.
CollectorUserIdentifierVARCHARThis column stores the unique identifier for the system user who is the collector assigned to this guarantor. This ID may be encrypted if you have elected to use enterprise reporting’s security utility.
AssociatedPlaceOfServiceIdentifierNUMERICStores a link to the EAF record used as a source for this requester.
IsGuarantorIsolatedForDataRestrictionVARCHARThis flag is set if the guarantor is considered "isolated" for patient data restrictions. Isolated guarantors are guarantors created from isolated patients.
GuarantorStatementBillingStatusINTEGERThe category value for the billing status used for handling statements for this guarantor, such as Age and Hold Statements, Age and Send Statements, Don’t Age and Hold Statements, and so on.
PaymentPlanTotalMissedCountINTEGERThis item will store the total number of missed payments on the account's payment plan.
PatientSelfPayBalanceAmountNUMERICThe amount of the self-pay balance on the account as of the time of the extract.
AlternateBillingZipCodeVARCHARThis is the zip code on the Alternate Billing Address.
LastHospitalBillingInsurancePaymentDateDATETIMEThis column stores the last hospital billing insurance payment date.
LastEnterpriseDemandInformationalStatementDateDATETIMEThis column stores the date the last enterprise demand informational statement was generated. Informational statements are those with no self-pay balance for the guarantor.
GuarantorMilitaryComponentINTEGERThis column stores the guarantor's military component, which is used to distinguish between guarantors who are on regular active duty and those who are members of one of the augmenting support groups.
PaymentPlanCycleAmountOverrideNUMERICIf Guarantor is on autopayment plan using Scheduled Payment architecture, this item stores the monthly amount to be used for this payment plan cycle if the value is different than the updated payment plan monthly amount in payment plan amount.
LogicalOwnerCommunityIdentifierVARCHARThe Community ID (CID) of the instance that is the logical owner of this record or line. This is only populated if you use IntraConnect.
GuarantorNameVARCHARThis column stores the name for the guarantor record. The name could be hidden if you have elected to use enterprise reporting’s security utility.
GuarantorEmploymentStatusCategoryINTEGERThe category number for the guarantor's employment status.
GuarantorSocialSecurityNumberVARCHARThe guarantor's social security number (may contain dashes). This item could be hidden.
PaymentPlanFrequencyCodeINTEGERPayment plan frequency
AlternateBillingAddressStateVARCHARThe category value of the state on the Alternate Billing Address.
PaymentPlanCurrentAmountDueNUMERICThe Hospital Billing Payment Plan current amount due.
IsGuarantorActive</tbody>VARCHARThis column indicates whether the guarantor was active at the time of the extract.
AssociatedRequesterCoverageIdentifierNUMERICStores a link to CVG record
GuarantDATETIMEThis column contains the date of the last verification of the associated guarantor.
HospitalSelfPayLastAgingDateDATETIMEOldest Self-pay aging date.
DeprecatedPaymentPlanAutoPayCreditCardIdentificationNUMERICCredit card associated with the payment plan. This credit card will be charged automatically when an installment is due for the payment plan. This column will be deprecated in the future release as the payment plan is being transitioned to use the scheduled payment framework. Once the transition is complete, reference the scheduled payment record for the current credit card.
HospitalBillingSelfPayBalanceLastUpdateDateDATETIMEThis is updated based on changes to Hospital Billing (HB) self-pay balance (I EAR 20003).
AccountIncomeSourceVARCHARIncome source.
LastStatementHoldDateDATETIMEThe most recent date on which the account was held from the Professional Billing (PB) statement processing.
PaymentPlanIsOnTimeIndicatorVARCHARWhether payment plan is on time, "Y" for on time, "N" for not on time.
AddressChangeInitiatingUserIdentifierVARCHARThe user who initiated the linked address changes.
AccountBillingCycleCategoryINTEGERThe category value associated with the billing cycle to which the guarantor belongs.
IsPaymentPlanEffectiveUntilBalancePaidVARCHARThis column indicates whether the payment plan will be effective until the balance is paid off that is, the payment plan remains effective if new charges occur. This column will only be populated if there is a payment plan.
LastGuarantorBillingVerificationStatusINTEGERThis item indicates the most recent patient-selected status of whether the self-guarantor billing information is correct in Welcome.
LastPatientPaymentReceivedDateDATETIMEThe date the most recent patient payment was received for this account before the enterprise reporting extract.
GuarantorLastViewedHospitalBillingStatementMyChartDateTimeDATETIMEThe date and time when a Hospital Billing statement was last viewed in MyChart by this guarantor. This field will be updated when either a guarantor-level or hospital account-level statement is viewed in MyChart for this guarantor. The date and time for this column is stored in Universal Coordinated Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
HospitalBillingInsuranceAgingDateDATETIMEThis column stores the hospital billing insurance aging date.
UserCoverageLastVerificationIdentifierVARCHARContains the date that the corresponding coverage was last verified.
IsRequestOfInformationPatientAccountVARCHARIndicates whether this account is an ROI patient account. Y indicates that the account is an ROI patient account. N indicates the account is a non-patient ROI account. Null indicates the account is not an ROI account.
GuarantorCreditBalanceIndicatorVARCHARIndicates whether the guarantor has credit balance. Y indicates the guarantor has credit balance. A null value indicates the guarantor has no credit balance. An N will not be populated for this column.
GuarantorEmployerHouseNumberVARCHARThe house number of the guarantor's employer.
WasGuarantorRehomedVARCHARIndicates whether a new guarantor was created as a result of running the rehoming report and performing the rehome account action. Y indicates a new guarantor was created as a result of running the rehoming report and performing the rehome account action. An N will not be populated for this column. This item will only be populated if the guarantor is rehomed.
AssociatedProviderIdentificationVARCHARStores a link to the SER record used as a source for this requester.
LastStatementSentDateDATETIMEThe date the most recent patient statement was sent for the account.
LastHospitalAutoPayDateDATETIMEThe most recent Auto Pay date for guarantor set up with a payment plan on Auto Pay.
LastInsurancePaymentDateDATETIMEThe date the most recent insurance payment was received for this account before the enterprise reporting extract.
AlternateGuarantorBillingAddressDistrictCategoryINTEGERThe category number for the alternate district of the guarantor's billing address.
AccountBadDebtBalanceNUMERICThis value is the balance of bad debt on the account.
HospitalBillingPrebilledBalanceAmountNUMERICThis value is the Hospital Billing prebilled balance on the account.
ProfessionalBillingStatementHoldReasonCodeINTEGERThe reason why the account was held in Professional Billing statement processing.
BillingNoteExpirationDateDATETIMEBilling note expiration date.
DefaultReleaseOfInformationFormatCodeINTEGERDefines the default requested format to be used when the requester is selected within the Release of Information activity.
DefaultReleaseOfInformationAttentionToAddressVARCHARThe Default Attention To field for ROI Releases.
HospitalAccountPaymentPlanInitialBalanceVARCHARThe initial balance on the hospital account when the payment plan starts.
TopLinkedRequesterAccountIdNUMERICReturns the top linked requester account id, this should be used for grouping purposes.
IsClientAccountGuarantorVARCHARIndicates whether or not this is a client guarantor.
OldGuarantorIdentifierNUMERICHolds a pointer from the new guarantor to the old guarantor
IsRequesterUncommonIndicatorVARCHARIs this requester a common requester? Set to Y if the requester is an uncommon requester, N or null if the requester is common.
PaymentPlanAutomaticPaymentScheduleIdentifierNUMERICThe scheduled payment record (BSP) associated with the guarantor's payment plan. Scheduled payment record is used to define the auto pay payment plan terms, including the payment method, day to trigger payment, and monthly amount.
GuarantorEmployerCityVARCHARThe city of the guarantor's employer.
HospitalBillingSelfPayBalanceNUMERICThis value is the Hospital Billing self-pay balance on the account, but excludes hospital accounts in external AR, bad debt or that have not yet been billed to self-pay.
IsGenericRequesterFlagVARCHARFlag indicating whether this is a generic requester in which it requires additional documentation to determine who is the actual requester.
GuarantorLastViewedHospitalBillingLetterDateTimeDATETIMEThe date and time when a Hospital Billing letter was last viewed in MyChart by this guarantor. This field will be updated when either a guarantor-level or hospital account-level letter is viewed in MyChart for this guarantor. The date and time for this column is stored in Universal Coordinated Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
ContractExpirationDateDATETIMEThe date on which the contract attached to this guarantor expires.
GuarantorEmployerZipCodeVARCHARThe ZIP code of the guarantor's employer.
AccountServiceAreaIdentifierNUMERICThe ID of the service area (EAF .1) to which this account belongs.
AddressChangeInitiatorSourceVARCHARThe source record that initiated the linked address changes.
AlternateBillingAddressCityVARCHARThis is the city on the Alternate Billing Address.
AccountHasVipStatusIndicatorVARCHARIndicates whether there is VIP status for this account. Y indicates the account has VIP status. N indicates the account does not have VIP status.
PaymentPlanINTEGERThe day of the month when the payment plan amount is due if the account is on a payment plan.
AssociatedRequesterDepartmentIdentifierNUMERICStores a link to the DEP record used as a source for this requester.
AccountUndistributedSelfPayCreditBalanceNUMERICAccount undistributed credit balance - self-pay credits only.
GuarantVARCHARThe category value of the primary financial class of the guarantor (i.e. commercial, Medicare, self-pay, etc.)
LastClaimProductionDateDATETIMELast date the claim was produced
LastStatementFormIdentifierVARCHARThe unique ID of the last statement form.
HospitalBadDebtSelfPayBalanceNUMERICSelf-pay balance of accounts in bad debt that have been billed to self-pay.
AccountReleaseOfInformationBillingCountyCategoryNumberVARCHARThe county category number for the account's ROI Billing Address.
GuarantorOccupationVARCHARThe occupation of the guarantor.
LastGuarantorVerificationUserIdentifierVARCHARThis column stores the unique identifier of the last user to verify the guarantor.
AssociatedRequesterOrganizationIdentifierNUMERICStores a link to the DXO record used as a source for this requester.
MyChartAccountIdentifierVARCHARThe unique ID of the MyChart account that is linked to this guarantor record. This is used when the guarantor is not a patient in the system but needs to have access to the billing information in MyChart.
LastWelcomeGuarantorAccountVerificationDateDATETIMEThis item indicates the most recent date the patient verified the self-guarantor billing information is correct in Welcome.
GuarantorAlternateBillingCountryVARCHARThe category number for the alternate country of the guarantor's billing address.
LastHospitalBillingSelfPayPaymentDateDATETIMEThis column stores the last hospital billing self-pay payment date.
GuarantorReferralSourceIdentifierVARCHARThis column stores the unique identifier for the referral source for this guarantor.
GuarantorHomePhoneNumberVARCHARThe guarantor’s home phone number (may contain dashes).
PatientRecordOfGuarantorIdentificationVARCHARIf the guarantor is the same person as a patient, this item contains the patient ID.
GuarantorAlternateBillingHouseNumberVARCHARThe alternate billing house number for the guarantor.
AssociatedRequesterPayerRecordIdentifierNUMERICStores a link to the EPM record used as a source for this requester of information.
GuarantorEmployerFaxNumberVARCHARThe guarantor's employer's fax number.
RequesterPrepaymentRequiredIndicatorVARCHARIndicates whether this requester is designated as a pre-pay-only requester. Y indicates that the requester is pre-pay-only. N or a null value indicates that the requester does not have to pre-pay.
GuarantorZipCodeVARCHARThe ZIP Code area in which the guarantor lives.
EmployerOtherCommentVARCHARA free text comment that can be entered when the value that is considered to be "Other" is selected as the employer. This option is available only if your organization has chosen to link the account employer to the Employer (EEP) master file in the Facility Profile.
CurrentFollowUpLevelINTEGERCurrent follow up level.
GuarantorEmailAddressVARCHAREmail address documented on the guarantor. Any clarity report looking for the guarantor's email address must search in the following sequence, and use the first found one: - The primary email address from the associated patient of the guarantor. - The email address from the MyChart account associated with the guarantor.
ClientBillGenerationDayOfWeekINTEGERSpecifies the day of the week to generate the client bill on provided that CLNT_BILL_FRQNCY_C is set to weekly or biweekly.
DefaultGuarantorHospitalAccountIdentifierNUMERICThis column stores the unique identifier for the default hospital account of the guarantor. The item is only used in single billing office mode.
LastHospitalStatementDateDATETIMEThis column contains the date of the last statement sent to the guarantor.
AccountIdentifierNUMERICThe unique identifier for the account record.
GuarantorContactPersonNameVARCHARThe name of the person to contact for questions regarding the guarantor. This item could be hidden.
GuarantorSexVARCHARThe sex of the guarantor. This is extracted as the category abbreviation.
HasActiveHospitalAccountReceivableStatusVARCHARFlag to be used for looping over outstanding Guarantor Accounts 'Y' Means that EAR has Active(Open) HARS. Null Means that EAR don't have any open HARS.
GuarantorAccountIdentifierNUMERICThis column stores the unique identifier for the guarantor record. This ID number may be encrypted if you have elected to use enterprise reporting’s security utility.
LastStatementBilledAmountNUMERICLast statement's billed amount
GuarantorCreditScoreINTEGERThe guarantor's credit score.
AccountINTEGERThe district category number for the account's ROI Billing Address.
ReleaseRequesterTypeClassificationINTEGERStores the type of requester record this is.
GuarantorMilitaryPayGradeINTEGERThis column stores the military pay grade to which the patient's guarantor belongs.