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

DepartmentProfi

The table contains high-level information about departments.

Column NameTypeDescription
IntraConnectPhysicalOwnerCommunityIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
WaitlistDefaultStartDateMethodINTEGERThe method by which the system will default the wait list start date when creating a new wait list entry. When scheduling from a linked record, data from that record may be used instead. For example, when scheduling an appointment request, the requested appointment date (APPT_REQUEST.REQUESTED_APPT_DATE) can be used instead of this setting. This setting overrides a similar setting in system definitions. If neither setting is populated, the value 1 –Current Date While Scheduling is used.
DepartmentClaimAlternateAddressZipCodeVARCHARThe department level claim alternate address zip that you want to be printed on claims.
DepartmentOrderPreferenceListIdentificationNUMERICThe unique ID of the Preference List (EPD) used by this department, including both medication and procedure orders.
DepartmentEmergencyDepartmentTeamAssignmentModeINTEGERThe mode of emergency department team assignment for the department.
DepartmentReportGroupSevenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DeprecatedUseRefillRequestProviderPoolIndicatorVARCHARStarting in May 21, this item is no longer used. In February 21 and earlier, this item will be used to determine whether a refill request should be routed to provider's e-prescribing pool by default.
EarliestPatientArrivalTimeDATETIMEThis time is used when calculating the earliest possible arrival time a patient should be given. Note that only the time component of the column value is meaningful.
DepartmentEventRecordIdentifierVARCHARThis item holds the IEV record containing the events for this department.
MedicationAdministrationRecordINTEGERThis column stores how long the MAR shows discontinued meds for patients in this department.
AutoLinkUnlinkAuditTrailUserVARCHARThe user record to be used to record in the audit trail when a contact is auto-linked to (or unlinked from) an episode.
DepartmentAddressCountyValueVARCHARThe category number of the county of the address for the department.
MedicationAdministrationRecordFutureTimeLimitINTEGERThis column stores how long in the future it is possible to consume due times on the MAR for patients in this DEP department.
ParentHospitalIdentifierNUMERICThis item stores the parent hospital (location type - hospital,2) for the department. If the ADT PARENT (item 7010) of the department is not of type hospital, the programming point for this virtual item will drill down the facility structure to find appropriate hospital.
GeneralLedgerReportDepartmentSortCodeVARCHARThe code that the General Ledger report uses to sort the departments if you use Department as a sorting category in your facility.
ShowAppointmentReviewSnapboardFlagVARCHARIndicates whether or not the appointment review form is shown after scheduling from the Snapboard. If set to 'Y' then the form is shown. If set to 'N' then the form is not shown. If set to null then the system definition is used.
DepartmentLearningAssessmentTemplateIdentifierNUMERICThe unique ID of the learning assessment template (ILA) record used by this department.
SendUnverifiedMedicationNotificationToAttendingProviderIndicatorVARCHARIndicates whether a notification message will be sent to a patient's attending provider when an unverified medication is administered in the MAR.
ReportGrouperThreeVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
IncompleteChartingMessageDelayDaysINTEGERThe number of days since an encounter is opened before an overdue incomplete charting message is sent. The message will be sent to the provider supervisor stored in the PROV_SUP_ID column.
ReportingGroupTwentySixVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
IsConsultantLedClinicIndicatorVARCHARDefines whether this is a consultant led clinic or not.
IsHospitalInHomeDepartmentIndicatorVARCHARSet to 1-Yes to indicate that this department is a virtual 'home' department used for Hospital in Home programs. It is appropriate to set this to yes regardless if the department is covered by the Hospital in Home CMS waiver or not, as long as it represents a department that patients are admitted or transferred to in order to represent an inpatient home stay. When this item is 0-No or blank, the department is not considered a Hospital in Home department.
HospitalAccountVerificationConfirmationDepartmentOverrideIdentifierVARCHARThe unique ID of the department override for the hospital account verification confirmation record.
TreatmentTeamRemovalEventIdentificationVARCHARThe unique ID for the event that will be recorded in the patient events log when a staff member is removed from a patient's treatment team.
StaffDepartureEventIdentifierVARCHARThe unique ID of the event that is recorded in a patient's events log when a staff member leaves the patient's room. This uses the real time location system (RTLS) to track the staff member.
ProfessionalBillingINTEGERThis column contains the category item determining if we only expect PB charges in this department or not.
OutpatientDuplicateIntervalStringVARCHARIndicate the lookback time for duplicate checking. This item stores the string value of the duplicate interval (in days). This value is converted into hours and populated into item-17210 Outpatient Duplicate Interval. To specify an interval in DAYS, you can enter a positive number. To specify an interval in HOURS, you can enter it in terms of days. (e.g., to specify 6 hours, enter .25) To specify the interval in weeks, you can enter a number/fraction followed by the letter W. (e.g., to specify 3 weeks, type 3W or 3.0W). The value is converted to equivalent days and displayed to the user. Note: Large interval values may cause the system to slow down considerably. Please consult your system Technical Services Representative before setting large values in this field.
IsNumberOfDaysSupplyEnabledForDispensingDepartmentVARCHARDetermines whether this unit can dispense a number of days supply for some medications. A medication order will dispense a number of days supply if the medication, pharmacy, and patient location are all set to dispense a number of days supply.
ParentHospitalBillingLocationIdentifierNUMERICThe unique identifier of the location that is the HB parent location that contains this department.
DepartmentMedicationPreferenceListIdentifierNUMERICThe unique ID of the medication Preference List (EPD) for the department.
ReportGrouperOneVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentFormularyOverrideIdentifierVARCHARDefine a formulary at the department level.
EmergencyDischargeEventIdentifierVARCHARThe unique ID of the event that fires when a patient is discharged from this ED.
DepartmentClaimAlternateAddressNameVARCHARThe department level claim alternate address name that you want to be printed on claims. This name could appear in Box 33 on paper CMS, FL1 on UB, BA0-18 on NSF and 2010AB-NM1-03 on ANSI claim forms.
DepartmentReportingGroupFiveVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentServiceAreaIdentifierNUMERICThe unique ID of the service area in which this department is located. This is the service area for the department, calculated by the function EPIC_DEPTOSA; this function is needed because the service area is linked to the location record and not to the department record directly.
ClinicDispensePharmacyIdentifierNUMERICThe ID of the pharmacy used in the Swiss clinic dispense workflow. Only used for organizations with the Swiss package ordering feature.
AutomatedSmsDefaultReplySmartTextIdentifierVARCHARThe unique ID of the SmartText that specifies the default reply to a recipient when a 2-way SMS reply is received and processed.
CanCopyPatientEducationAssessmentForwardIndicatorVARCHARIndicates whether Patient Education Assessments can be copied forward in this department.
CriticalCareUnitFunctionCategoryINTEGERThis item is used for collection of the Critical Care Unit Function CDS data element.
AttendingProviderAssignmentEventRuleIdentifierVARCHARThe unique ID of the rule to determine the event triggered when assigning attending provider.
ConfidentialEmployerScreeningResultPoolIdentifierNUMERICThe unique ID of the In Basket pool which will receive Results Routing messages for confidential employer screening orders from this department.
DepartmentLogoFilenameVARCHARThe filename of the department's logo stored in a shared directory.
DepartmentTranscriptionistEmployeeIdentificationVARCHARThe unique employee ID for the department transcriptionist.
ProcedureSchedulingDelayMinutesINTEGERDefault number of minutes to delay scheduling for proceedure orders from the present. If an order is include now, or starts between now and the number of minutes after the delay, the order will actually schedule starting at the specified number of minutes after now. Note: if the user specifies scheduling starting at a time, the delay will not be used. If nothing is entered here, the delay specified in System Definitions will be used instead.
DepartmentMaximumNurseWorkloadNUMERICRepresents the maximum safe workload per nurse in this department.
DepartmentRecordStatusINTEGERThe record status category number for the department record. Note that for department records that are active this column will have a null value.
DepartmentNationalLocationClassNumberINTEGERThe location class category number for this department.
DepartmentServiceTypeIndicatorINTEGERDescribes whether the unit is providing psychiatric or somatic services.
IsTableBasedOrderTransmittalForcedVARCHARIndicates whether to force order transmittal to be table-based.
DefaultClinicianOrderEntryModeINTEGERSpecify a default ordering mode here if this department supports orders in both outpatient and inpatient mode in clinician order entry.
DepartmentFacilityCategoryIdentifierVARCHARThe facility category number for the department. This identifies the facility in which the department is located.
ShowVisitCoverageOnHospitalAccountReportVARCHARControls whether or not Visit Coverage field is shown on Hospital Account forms.
EnableAppointmentProjectionOnSnapboardIndicatorVARCHARIndicates whether real time appointment projection is enabled on the Snapboard at the department level.
DepartmentIdentifierNUMERICThe unique ID number assigned to the department record.
AutoAddAppointmentToWaitlistIndicatorVARCHARIndicates whether an appointment will be automatically added to the Wait List upon scheduling based on the associated visit type listed in the department overrides table. 'Y' indicates that the visit type will be auto-added when scheduled. 'N' or NULL indicate that the visit type will not be auto-added.
DepartmentDefaultResumeMedicationCategoryINTEGERThe category number for the default resume medication action to be used by Inpatient in this department record.
AllServicesAreSecondaryIndicatorVARCHARIndicates that any services not listed in the allowed service list are considered secondary.
DepartmentMailingAddressDistrictNumberINTEGERThe category number of the district in the department mailing address, if the mailng address is not the same as the department's physical address. If the mailing address (all MAILING_* columns and CLARITY_DEP_ADDR_MAILING table) is empty, the physical address (ADDRESS_* columns and CLARITY_DEP_ADDR table) can be assumed to represent both addresses.
MedicationAdministrationRecordLookaheadHoursINTEGERThe number of hours the MAR activity will look ahead and display future medications.
DepartmentMedicationAdministrationRecordShiftProgrammingPointIdentifierNUMERICThe unique ID of the programming point record (LPP) used to configure the times that appear in the MAR activity for users logged into this department.
DepartmentExpressSchedulingReleaseDataOffsetOverrideNumberNUMERICThe release data offset override for express scheduling for the department.
DepartmentParentClinicIdentifierINTEGERThis item stores the parent clinic for the given department.
DefaultMedicationINTEGERIf a medication order is dispensing number of days supply, this item stores the number of days that should be supplied by default.
BedPlanningAlternateAbbreviationVARCHARThis is a name that can be used in place of the department abbreviation for bed planning users. This is an alternate abbreviation to what is found in CLARITY_DEP__DEPT_ABBREVIATION.
AdmissionDischargeTransferParentLocationIdentifierNUMERICThe unique ID of the location that serves as the parent in your facility’s ADT organizational structure.
DepartmentReportGrouperTwentyFiveVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentExternalProviderDirectoryIdentifierVARCHARCE external department ID for DEP record in provider directory.
AppointmentGoalDefaultMinimumSchedulingDaysINTEGERStores the default minimum number of days allowed between appointment scheduling and the appointment date for the goal.
DepartmentMailingStateCategoryVARCHARThe category number of the state in the department mailing address, if the mailng address is not the same as the department's physical address. If the mailing address (all MAILING_* columns and CLARITY_DEP_ADDR_MAILING table) is empty, the physical address (ADDRESS_* columns and CLARITY_DEP_ADDR table) can be assumed to represent both addresses.
DepartmentReportGroupThirteenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentReportGroupSixteenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
MedicationAdministrationRecordBarcodeMatchExpirationHoursINTEGERNumber of hours past the end time that the MAR will allow barcode matches on expired medication orders.
IsInpatientDepartmentFlagVARCHARA flag that indicates whether or not this department is considered an inpatient department. This field will be empty for non-inpatient departments.
EmergencyDepartmentContactWarningTimeframeHoursINTEGERThe time frame to check against when showing an ED contact creation warning message.
DepartmentReportGroupTenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
AuthorizationDecisionEntityNameVARCHAREnter the name of the First Tier, Downstream or Related Entity (FDR) which is responsible for making authorization decisions within this login department. This will be reported on the ODAG. If the authorization decision was made during Auto Status Assignment, the login department will not be used.
IsMedicationAdministrationRecordPharmacyIntegrationAvailable</blockquote>VARCHARIndicates whether the pharmacy module or pharmacy interface is available.
DepartmentClinicalContextOverrideCategoryINTEGERThe category value of the department-level override of the location's or service area's clinical context. For reporting on the clinical context of this department with respect to facility settings and overrides, use CLINICAL_CONTEXT_C instead."
DepartmentTravelTimeGrouperINTEGERContains the travel time grouper for a department. The travel time grouper is set for departments that are considered to have roughly the same travel time to them from any other external location.
IsManualReleaseFreeTextIntervalsVARCHARIf using auto release, indicates whether manual release uses free text intervals.
DepartmentReportGrouperThirtyTwoCategoryVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
PromptCenterSelectionForAppointmentAutomaticallyIndicatorVARCHARIndicates whether or not to automatically trigger center selection popup during appointment entry.
EmergencyManagerThirdWaitingAreaIdentifierNUMERICThe care area that is the third waiting area in the ED Manager. This area is displayed on the right side, bottom panel of the ED Manager.
DepartmentReportGroupSixVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentUsesAutomaticInterpreterSchedulingIndicatorVARCHARIndicates whether to use automatic scheduling of interpreters during appointment entry in the department. This setting overrides what is set at the system level.
DepartmentOperatingRoomUnitTypeCategoryNumberINTEGERThe OR unit type category number for the department.
ShowLanguageControlsInDischargeInstructionsIndicatorVARCHARIndicates whether language controls are shown in the Visit Navigator Discharge Instructions section for this department. Y indicates that the department shows language controls in the Visit Navigator Discharge Instructions section. A null value or an N indicate that the department does not show the language controls.
DepartmentPrescriptionTimeAdjustmentMessagePoolIdentifierNUMERICThe unique ID of the In Basket pool (HIP) which is set to receive Rx Adjust Times Notification messages in the department record.
MedicationAdministrationRecordDisplayShiftHoursINTEGERThe number of hours to shift the display in the MAR activity.
DepartmentFlashCardPrintCountINTEGERThe number of flash cards to print in this department.
DepartmentReportGroupThirtySixVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentInstancePhysicalOwnerIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
UseArrivalTimeFunctionalityIndicatorVARCHARIndicates whether the department is using arrival time functionality. Y indicates that the department is using arrival time functionality. N or null indicate that the department is not using it.
DepartmentDefaultAccountClassINTEGERThe account class indicates the entity responsible for charges for a specific appointment. This item stores the default account class used for appointments within this department.
DepartmentPatientClassChangeEventDefinitionIdentifierVARCHARThe unique ID of the event which is triggered when a patient class is changed in this department. Facility definition and workflow settings must be configured in order for this trigger to occur.
DepartmentReportGroupTwentyVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentClaimAlternateAddressStateVARCHARThe department level claim alternate address state that you want to be printed on claims.
DepartmentCostCenterIdentifierNUMERICThis column holds the internal cost center identifier associated with a given department. Please note to get the external cost center identifier you will need to link to CL_COST_CNTR.
EmergencyManagerSecondWaitingAreaIdentifierNUMERICThe care area that is the second waiting area in the ED Manager. This area is displayed on the left side, bottom panel of the ED Manager.
DepartmentMailingCountryVARCHARThe category number of the country in the department's mailing address, if the mailng address is not the same as the department's physical address. If the mailing address (all MAILING_* columns and CLARITY_DEP_ADDR_MAILING table) is empty, the physical address (ADDRESS_* columns and CLARITY_DEP_ADDR table) can be assumed to represent both addresses.
DepartmentNormalPatientNurseRatioINTEGERRepresents the normal recommended ratio of patients to nurses in this department.
IsEmergencyDepartmentBedHoldNoteFiledVARCHARIndicates whether bed hold information is filed as an ED note. Y indicates that when a patient is roomed into a bed with a hold the hold information will be summarized into an ED note in the patient's record. N indicates that the hold information will not be summarized into an ED note in the patient's record.
CommunityLogicalOwnerIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
RequireInpatientOutpatientFlagIndicatorVARCHARIndicates if the IP/OP flag must be collected by the scheduler during workflows that display the Appointment Review screen. This setting may be overridden at the visit type level. If null the system level setting will be used.
HomeHealthHospiceMedicaidProviderNumberVARCHARThe agency Medicaid provider number used by Home Health and Hospice.
RequiresDepartmentDualSignoffVARCHARIndicates whether dual signoff is required in this department.
DepartmentReportGroupThirtyEightCategoryVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
MedicationAdministrationRecordAllowsBarcodeScanMatchForDiscontinuedMedicationWithDueTimesIndicatorVARCHARIndicates whether the MAR will only allow barcode scans to match expired/discontinued meds if the med has any outstanding due times.
DepartmentCenterCategoryNumberVARCHARThe category number of the center that this department belongs to.
ReportLogoPrintGroupIdentifierNUMERICThis item defines the print group that should be used as a logo at the top of reports printed from this location. If this item is left blank, the Location level by populating item EAF 17018.
DepartmentReportGroupEighteenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
ReleaseOfInformationDefaultChartTypeVARCHARThe default chart type to be used when creating a release of information record in the corresponding department.
MedicareProviderNumberVARCHARThe agency Medicare provider number used by Home Health and Hospice.
DepartmentDoNotAutoReleaseChildOrdersAtCheckInINTEGERSpecifies whether child orders should be auto-released at check-in if the appoinment is in this department.
DepartmentReportGroupTwelveVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
AllowsInpatientInfusionPumpIndicatorVARCHARIndicates whether this department allows infusion pumps for inpatient devices.
UnverifiedMedicationAdministrationPoolHipIdNUMERICThis column stores the HIP ID of the unverified medication administration notification pool associated with this department.
EnableAppointmentWaitListVARCHARIndicates whether an appointment can be added to the wait list from the Appt Review window during scheduling for this department. If null the system level setting will be used.
MedicationAdministrationFutureWindowMinutesINTEGERNumber of minutes into the future after which administration is not allowed for this DEP.
IsPerioperativeDepartmentFlagVARCHARStores a flag to identify perioperative departments.
IsOrderUpEnabledForDepartmentVARCHARIndicates whether Order Up is enabled for this department. Y indicates that Order Up is enabled for this department. A null value indicates that system, procedure, and category level settings will be evaluated for procedures in this department. N indicates that Order Up is not enabled for this department.
IsDepartmentUsingEpicCareVARCHARIndicates whether the department is using EpicCare. If the item is not set, the value will be NULL instead of 'No'.
RequiresHospitalAccountRecordMatchForInpatientAdmissionRedirectVARCHARFlag to require a HAR match to redirect to an inpatient admission.
LabChargeCloningSubmitterRecordIdentifierNUMERICSpecify a submitter record to which this department is linked for Lab charge cloning
DepartmentEmergencyTeamLabelVARCHARAn alternate label for the word "Team" to be used in the sign-in activity.
MedicationAdministrationRecordDiscontinuedLookbackHoursINTEGERThe number of hours that the MAR activity will look back and display discontinued medications.
ShouldIncludeInMeaningfulUseReportsIndicatorVARCHARThis item defines if the department should be included for meaningful use reports or not.
DepartmentClassificationINTEGERThe type of the department.
DepartmentCopayWaiveExceptionCategoryINTEGERDEP 4060: Department-level copay override item
EncounterRedirectionPromptMessageTextVARCHARThis item stores a configurable prompt to use in the encounter redirection pop-up. The default prompt if no value is entered here is "Will this visit be charted separately from the admission? Selecting
AdjudicateInpatientMedicationsForLongTermCareIndicatorVARCHARIf set to yes then orders will be considered for adjudication based off of pharmacy settings for LTC. This requires the LTC license. This only applies to orders for patients who were originally admitted to this department.
DepartmentReportGroupThirtySevenVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
RealTimeLocationSystemDepartureEventIdentificationVARCHARRTLS provider departure event
EmergencyDepartmentPreadmissionContactRuleIdentifierVARCHARA rule to decide whether to display a warning message on ED arrival if there are existing preadmission contacts.
DepartmentReportGroupThirtyNineVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DefaultTreatmentTeamEventRuleIdentifierVARCHARThe unique ID of the rule to determine the event triggered when assigning default treatment team.
RoomInformationExtensionIdentifierNUMERICThe unique ID of the extension which returns the room info.
DefaultCellTherapyCenterIdentifierINTEGERThe default cell therapy center tied to the department.
DepartmentRevenueLocationIdentificationNUMERICThe unique ID of the revenue location to which the department is linked.
IntraConnectOwningInstanceCommunityIdentifierVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
ExternalPlaceOfServiceIdentifierNUMERICHolds the link from DEP to place of service EAF records. Used for external sites that need a more robust facility structure, such as EpicCare Link clinics. Departments with this item set should not be used internally.
DepartmentEncounterFormReportIdentifierVARCHARThe unique ID of the report used to generate the printout of the MR Encounter Form for this department
DepartmentExpressSchedulingEnabledIndicatorVARCHARIndicates whether or not express scheduling is enabled for the department.
ReferralOwningServiceAreaIdentifierNUMERICLinks referral to a service area through department in which it is created.
SendMedicationAdministrationVARCHARIndicates whether an In Basket message is sent to the Rx Pool whenever a MAR Hold is activated or deactivated in this department.
EmergencyDepartmentTransferInEventIdentifierVARCHARThe unique ID of the event that fires when a patient is transferred into this ED from a different unit or ED.
DeprecatedRefillRequestRoutingPoolIdentifierNUMERICStarting in May 21, this item is no longer used. In February 21 and earlier, this item stores the unique ID of the pool that is responsible to receive refill authorization request for the department.
DepartmentHospitalOutreachVisitSharedListIdentifierVARCHARThe unique ID of the shared list to be used to automatically add HOV patients on admission or a transfer to this department. On a transfer out or a discharge, the patient will be removed from this list.
DefaultEarlyArrivalOffsetMinutesINTEGERDefault number of minutes used when calculating the early arrival offset for all appointments in this department.
EncounterReportDefaultPoolIdentifierNUMERICThe pool that will receive the encounter report if there is no pool specified in the provider record.
IgnoreDispenseLogicOnPatientTransferVARCHAREvery time a patient is transferred to a different unit we evaluate order's dispense location, first dose dispense needed etc. But sometimes the patient is transferred to a unit for couple of hours (example: OR, PACU etc.) and the user don't want to run the whole Rx dispense logic for orders for the patient. If this item is set to Yes then you want to ignore Rx dispense logic for all orders for a patient on patient transfer. Default is "N".
IsDualModeOrderEntrySearchEnabledVARCHARThis setting controls whether or not users can search against both ordering modes in dual mode order entry.
ManagedCareWaitAreaIdNUMERICThe ID of the care area that is listed as the primary waiting area for the department.
DepartmentReportGroupFourteenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentAlternateDisplayNameVARCHARThis is a name that can be used in place of the department record name for bed planning users. This is an alternate name to what is found in CLARITY_DEP__DEPARTMENT_NAME.
LinkArrivalVARCHARThis is a configuration item to distinguish whether to fire a new arrival event and a depart event or update the existing arrival event when updating events for departments using the shared waiting room functionality.
DepartmentNormalWorkloadNUMERICRepresents the normal recommended workload per nurse in this department.
DepartmentReportGrouperElevenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
ReportGrouperTwentyOneVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DeprecatedStandardDepartmentSpecialtyTypeINTEGEREpic standard specialty which is calculated based on DEP 110. Note that this is a calculated item meant to be used only for reporting purposes.
ShowClaimInformationButtonIndicatorVARCHARThis setting controls whether or not to show the Claim Info toolbar button for encounters with hospital account contexts.
DefaultDepartmentPharmacyIdentifierNUMERICThe ID of the pharmacy linked to the department record.
DepartmentReportGroupThirtyOneCategoryVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DeclinedAppointmentAutoSearchIndicatorVARCHARStores the yes/no flag to indicate whether the system should automatically search for dates which the patient could have been scheduled on when documeting declined dates. This flag overrides the system level flag stored in SDF-2018. If this is blank, the system level flag is respected, which has a default value of yes.
DeprecatedDepartmentRefillRequestRoutingOptionCategoryNumberINTEGERStarting in May 21, this item is no longer used. In February 21 and earlier, this item stores refill request routing option category number for the department.
IsAllergenListSentToPrimaryCareProviderVARCHARIndicates whether the allergen list is sent to the PCP.
PointOfCareInterfaceNUMERICHolds a custom IB message type to use for route to MR instead of staff message
MedicationAdministrationRecordGroupDisplayIndicatorVARCHARIndicates whether the medications in the MAR are displayed in a particular order for this department. If this is set to Y, the medications are displayed in the following order: All active medications, all future medications, all completed medications, all discontinued medications.
MedicationAdministrationRecordLabelPrinterIdentificationVARCHARThe printer ID for MAR label.
InpatientOrderModeCaptionVARCHARSpecify the caption to display for inpatient mode here. The default caption for inpatient mode is "During visit".
ExpectedCareAreaIdentifierNUMERICThe unique ID of the Care Area that will appear as the "Expected" area in the bottom panel of the ED Manager. If no Care Area is entered here, the Waiting Room will expand to comprise the entire bottom panel.
MedicationSchedulingTimeUnitCategoryINTEGERThe category number for the time units used to round the scheduling of medication orders and their associated activities.
DepartmentLicensedBedCountINTEGERThe current number of licensed beds for this department.
DecisionTreeAuthorizingProviderIdentifierVARCHARThe unique ID of the provider record to use as the authorizing provider for orders generated from decision trees in this department. This value is only used if the chosen search method (stored in DTREE_NODE_AUTH_PROV_MTHD) is equal to 2-Department Provider. This column is frequently used to join to the CLARITY_SER table.
ResourceScheduleFinalizationSettingIdentifierNUMERICStores the ID of the settings record that is used for resource schedule finalization.
ReportGrouperTwentySevenVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentLevelOfCareINTEGERThis item stores the level of care supported by the department.
SecondaryHospitalAccountVerificationOverrideIdentifierVARCHARThe unique ID of the department override for the second hospital account verification confirmation record.
DepartmentMailingAddressHouseNumberVARCHARThe house number in the department mailing address, if the mailng address is not the same as the department's physical address. If the mailing address (all MAILING_* columns and CLARITY_DEP_ADDR_MAILING table) is empty, the physical address (ADDRESS_* columns and CLARITY_DEP_ADDR table) can be assumed to represent both addresses.
CanUserChangeAppointmentHiddenStatusIndicatorVARCHARIndicates whether users can flag appointments as hidden from the patient within this department.
SkipWeekendForNoShowCallVARCHARIndicates whether or not automated no-show calling should skip weekends. If set to 'Y', the no-show automated calling batch will skip weekends. If null or set to 'N', the batch will not skip weekends.
DepartmentAddressCityVARCHARThe city of the address for the department.
DefaultWorkstationReferenceLinkVARCHARThe default workstation reference link for workstations in the department.
DepartmentReportGrouperFifteenVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentNameAbbreviationVARCHARThe abbreviation of the department name.
DepartmentAllowsLeaveOfAbsenceIndicatorVARCHARIndicates whether leaves of absence are allowed for this department. A Y value indicates that leaves of absence are allowed for this department. A N or null value indicates that leaves of absence are not allowed in this department.
DepartmentAppointmentPhoneNumberVARCHARThe appointment phone number for the department.
DepartmentWorkstationConfigurationProfileIdentifierVARCHARThis column contains the unique ID of the EMR Profile record that specifies the configuration for the department at workstation level.
EmergencyDepartmentArrivalEventIdentifierVARCHARThe unique ID of the event that fires when a patient arrives in this ED.
DepartmentRegisterTypeCodeINTEGERThis item stores the department's register type as defined in the KanTa services registry ID code set (1.2.246.537.5.40150).
DepartmentReportGrouperTwoVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
IsAppointmentRequestResponsibleDepartmentAllowedVARCHARDetermines whether this department is allowed to be set as the Responsible Department in the appointment request. Set to Yes if this department can be set as the Responsible Department. Set to No or leave blank if this department should not be allowed to be set as the Responsible Department. This setting is respected in the appointment request and request entry decision tree.
UseScheduleOrderWorkqueueIndicatorVARCHARIndicates if schedule order workqueues are used in this department. If workqueues are used, the schedule orders worklist will not be available. If this item is empty, "No" is assumed.
DefaultEncounterBillingProviderIdentifierVARCHARStores the billing provider at the department level that will be directly referenced by category value "Default Provider from Department" added to I LPR 8540. This value can be used either in LOS Authorizing Provider Default Order (I LPR 8343) or Charge Capture Billing Provider Defaulting Logic (I LPR 17230).
AppointmentNotesRequirementINTEGERIndicates whether appointment notes are required or recommended during make appointment and quick appointment.
ReportingGroupTwentyEightVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentEmergencyPhoneNumberVARCHARStores the emergency phone number for the department.
IsHospitalOutpatientDepartmentConsideredInpatientVARCHARThis item can be set to yes for HODs in order to mark them as Inpatient. Some reports differentiate between inpatient and non-inpatient departments - normally HODs are considered non-inpatient departments, but if this item is set, they can be considered inpatient. In addition, some non-report functionality could check if a department is considered inpatient. Note that this does not affect every report that checks for inpatient, only those that are trying to determine if a department is inpatient or not. Some reports will use other criteria to determine if a patient should be inpatient, such as patient class, patient base class, or encounter type; this item won't affect that criteria. If this item is set for a non-HOD, it is not respected. Default is No.
SendResultsToProviderSelfIndicatorVARCHARIf any additional recipients are specified in the "Send Results to:" column, the Provider may elect not to receive the results.
UsePostProcedureWoundAssessmentFlowsheetVARCHARDetermines if the measurements from Procedure Documentation Debridement forms should be stored in the released post-procedure wound measurement flowsheet rows, or the released wound measurement flowsheet rows. If set to Yes, the post-procedure wound measurement flowsheet rows (FLO 1570010010, 1570010011, 1570010012, 1570010013, and 1570010014) will be used. If set to No, the wound measurement flowsheet rows (FLO 1570010005, 1570010006, 1570010007, 1570010008, 1570010009) will be used. If left blank, the default is No.
ShowAppointmentReviewAfterFullEntryVARCHARThis setting controls whether the Appointment Review form is shown after scheduling from full appointment entry. All departments being scheduled into must have this set to No for it to skip. The default is to show the Appointment Review.
DepartmentDutchIntensiveCareUnitGroupCategoryNumberINTEGERThe Dutch ICU Unit Group category number for the department. This column is populated only for customers in the Netherlands, and only for departments which are intensive care units.
DepartmentNameVARCHARThe name of the department.
DepartmentSpecialtyNameVARCHARThe name of the medical specialty practiced in this department.
DepartmentDefaultPlaceOfServiceIdentifierNUMERICThe unique ID of the default POS of the department
DepartmentClaimAlternateAddressCityVARCHARThe department level claim alternate address city that you want to be printed on claims.
DepartmentProductModeVARCHARProduct mode for department. Determines feature-set available to users in this department.
IntraConnectSourceInstanceCommunityIdVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
DeprecatedDepartmentSpecialtyCategoryNumberVARCHARThe category number of the medical specialty practiced in this department.
IntraConnectOwnerCommunityIdVARCHARThe Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
DepartmentClaimAlternatePhoneNumberVARCHARThe department level claim alternate phone number that you want to be printed on claims.
DepartmentEmergencyPatientListIdentifierNUMERICThe unique ID of the system patient list corresponding to this department. This is populated for Emergency or Labor & Delivery Departments.
DepartmentReportGroupEightVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentReportGroupTwentyTwoVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
FromVisitRideshareIntegrationIdentifierNUMERICThe unique ID of the desktop integration record for the rideshare service transporting a patient from a visit in this department to their home.
DepartmentAdmissionUnitTypeINTEGERThe type of unit of this department for ADT application.
EmergencyDepartmentRadiologyInterpretedStatusINTEGERThis setting determines the radiology status at which the interpreted time is set for an order used for ED radiology turnaround time reporting.
AttendingProviderRemovalEventIdentifierVARCHARThe unique ID of the event that will be recorded in the Patient Events Log when an attending provider is removed from a patient's treatment team.
MedicationSchedulingDelayMinutesINTEGERDefault number of minutes to delay scheduling for medication orders from the present. If an order is include now, or starts between now and the number of minutes after the delay, the order will actually schedule starting at the specified number of minutes after now. Note: if the user specifies scheduling starting at a time, the delay will not be used. If nothing is entered here, the delay specified in System Definitions will be used instead.
NearestProcedureSchedulingTimeIncrementINTEGERNearest unit of time for scheduling procedure orders
IsNurseVerificationRequiredForMedicationAdministrationVARCHARIndicates whether RN Verification is enabled. Y indicates that RN Verification is enabled. N indicates that RN Verication is disabled. If Y, medications must be verified by an RN before the medications are administered. In this case, meds that have not been verified will be displayed with an icon to indicate this in the MAR. Also, a warning will be displayed if a user attempts to administer a med that has not yet been verified. If the warning is overridden, the user will be allowed to record the administration. If this is field is null, the System Definitions item (LSD-34581) is examined.
DepartmentAddressStateVARCHARThe category number for the state/province of the address for the department.
IsDualSignoffRequiredForUnverifiedMedicationVARCHARIndicates whether a dual signoff is required for medications that are not verified by pharmacy and are not in the exception list for the department.
GuarantorVerificationDepartmentOverrideIdentifierVARCHARThe unique ID of the department override for the guarantor verification confirmation record.
TreatmentPlanReleaseCategoryExtensionIdentifierNUMERICThe unique ID of the extension that determines which categories are currently allowed to release.
CommunityLogicalOwnerIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
AttendingProviderAssignmentEventIdentificationVARCHARThe unique ID of the event that will be recorded in the Patient Events Log when an attending provider is assigned to a patient's treatment team.
DepartmentRegionIdentifierNUMERICThe region of the department. This is derived from the region of the associated revenue location, service area, or facility record. This column is frequently used to link to the CLARITY_POS table.
DepartmentReportGroupThirtyFourCategoryVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentTransferEventIdentifierVARCHARThe unique ID of the event that is fired when a patient is transferred within this ED.
IsIntensiveCareUnitDepartmentVARCHARIndicates whether the department is defined as an intensive care unit (ICU).
DepartmentSchedulingGrouperINTEGERThis grouper is used by Order Up to divide departments into logical groups.
AlternateLabCollectionLocationIdentifierNUMERICThe unique ID of the location the labs that collect specimens for this department are in if different from the standard facility structure.
MedicationMessagePoolIdentifierNUMERICThe unique ID of the In Basket pool (HIP) which will receive medication messages for this department.
DepartmentSiteCodeINTEGERSite code for this clinic (department).
MedicationAdministrationRecordPastTimeLimitINTEGERThis column stores how far in the past it is possible to record administrations on the MAR for patients in this DEP department.
IsPerProviderLicenseDepartmentVARCHARPer Provider License Department. Category item w/ yes/no
AllowReleaseDatePastProviderTemplateVARCHARIndicates whether the release date is allowed to be extended past the end of a providers template by the Cadence End of Day for all providers in the department. This setting is overridden by the provider level offset settings.
DefaultPermanentFilmStationIdentifierVARCHARThe default permanent station for films created in this department.
DefaultRedispensePharmacyIdentifierNUMERICDefault pharmacy to use when redispensing orders to this department.
DepartmentNationalLocationTypeCategoryINTEGERThe location type category number for this department.
SuppressClinicalSummaryPrintingIndicatorVARCHAR"Y" means that clinical summaries for this department are not printed during End of Day processing for clinical summaries and when reprinting clinical summaries from the End of Day Management Menu. If this setting is blank, the default response to this prompt is "N", indicating the clinical summaries will be queued up to print for the department if clinical summaries are printed as an End of Day process.
BlockInpatientOrdersFromVerifyQueueIndicatorVARCHARIndicates whether inpatient mode orders for HOV or outpatient visits in this unit will be blocked from the verify queue. Y indicates that these orders will be blocked from the verify queue. N indicates that these orders will not be blocked from the verify queue. A null value indicates that the corresponding Hospital/Clinic level setting will be used.
DepartmentWorkstationSettingsProfileIdentifierNUMERICThe unique ID of the workstation settings record used for this department. The most specific level of setting is used from system, department, and workstation.
ChargeForDrugsAtAdministrationIndicatorVARCHARIf "Y", then the system will attempt to charge for drugs at administration if the drug is configured to charge at administration. The default is "N".
EmergencyDepartmentRoomedEventIdentifierVARCHARThe unique ID of the event that fires when a patient is roomed in this ED.
DepartmentReportGroupThirtyFiveCategoryVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
IndicateAllLocationsSecondaryVARCHARIndicate that any levels of care not listed in the allowed list are secondary. Note that if a level of care is not allowed based on the location or service area hierarchy, it will not be allowed based on this setting either.
DepartmentMailingZipCodeVARCHARThe ZIP Code in the department mailing address, if the mailng address is not the same as the department's physical address. If the mailing address (all MAILING_* columns and CLARITY_DEP_ADDR_MAILING table) is empty, the physical address (ADDRESS_* columns and CLARITY_DEP_ADDR table) can be assumed to represent both addresses.
RealTimeLocationSystemDepartureEventIdentifierVARCHARThe unique ID of the event that is recorded in a patient's events log when an attending provider leaves the patient's room. This uses the real time location system (RTLS) to track the provider.
RealTimeLocationSystemArrivalEventIdentifierVARCHARThe unique ID of the event that is recorded in a patient's events log when an attending provider arrives in the patient's room. This uses the real time location system (RTLS) to track the provider.
FlashCardPrintingRoutineVARCHARThe routine used to print flash cards in this department.
DepartmentEpicImplementationDateDATETIMEThe date patients were first seen in the department using Epic.
DefaultClinicalServiceCodeVARCHARSpecify a default clinical service based on the user's login department.
AllowRestoreToExpectedCareAreaIndicatorVARCHARIndicates whether users are able to restore patients to the expected care area when returning them to waiting from other care areas.
RequiredDocumentationTaskTemplateIdentifierVARCHARTask template that contains required documentation configuration for the department.
DepartmentReportGroupTwentyThreeVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentFaxNumberVARCHARStores the fax number for the department.
PromptForConfirmationDaysAheadINTEGERThis item stores the number of days ahead that the system should prompt for confirmation
EncounterReportProviderInclusionVARCHARWhether including additional recipients in the "Pool for receiving encounter reports" field.
GoalAppointmentDefaultMaximumDaysINTEGERStores the default maximum number of days allowed between appointment scheduling and the appointment date for the goal.
DepartmentLetterTranscriptionVARCHARThe letter transcription pool for this department.
IsOverridePullLinkDisabledVARCHARIndicates whether the override pull link feature is enabled for this department.
ReportGrouperFourVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
IsAllergenListSentToAttendingProviderIndicatorVARCHARIndicates whether the allergen list is sent to the attending provider.
MyChartSignUpDisplayModeINTEGERThe category number for if and when the MyChart signup popup is displayed at sign in, check in or check out. This setting can be overridden at the system definitions level.
HomeCareEpisodeCreationProgrammingPointIdentifierNUMERICThis item stores the programming point to run after a Home Care episode is created.
UseHospitalAccountRecommendationIndicatorVARCHARUse HAR recommendation?
DepartmentAddressDistrictCategoryNumberINTEGERThe category number of the district of the address for the department.
DepartmentRecordSourceInstanceIdentifierVARCHARThe Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
InteractiveVoiceResponsePronunciationNameVARCHARThis item holds the name of this unit as it should be pronounced by the IVR.
IsOneClickAppointmentNoteRequiredINTEGERIndicates whether appointment notes are required or recommended during one-click scheduling.
IsDiscreteIntervalEnabledForDepartmentVARCHARIndicates whether the department's discrete interval settings have been enabled.
AllowChargeCloningForSubmitterDepartmentLinkVARCHARSpecify charge clone usage for submitter department link
DepartmentAddressHouseNumberVARCHARThe house number of the address for the department.
DefaultDATETIMEThe time used to estimate the start times for orders in inpatient treatment plan days for encounters planned in this department in the Advanced Prep Report.
DepartmentAddressCountryCategory</div>`VARCHARThe category number of the country of the address for the department.
DepartmentMailingAddressCountyCategoryVARCHARThe category number of the county in the department mailing address, if the mailng address is not the same as the department's physical address. If the mailing address (all MAILING_* columns and CLARITY_DEP_ADDR_MAILING table) is empty, the physical address (ADDRESS_* columns and CLARITY_DEP_ADDR table) can be assumed to represent both addresses.
DepartmentExternalNameVARCHARThe external name of the department record. This is often used in patient correspondence such as reminder letters.
DepartmentIdentifierNUMERICThe unique identifier (.1 item) for the department record.
DepartmentIdentifierNUMERICThe unique ID of the Department record.
DepartmentNearestProcedureTimeUnitINTEGERTime unit for item 24301
DepartmentClinicalContextINTEGERThe clinical context of a department. Computed by first looking to I DEP 3800 - Clinical Context Override then up the facility tree to find the appropriate category value in I EAF 15700 - Clinical Context. Defaults to 1 - Hospital if there is no value present in I EAF 15700.
EncounterRedirectionConfirmationPromptIndicatorVARCHARThis setting controls whether or not a pop-up is used to confirm encounter redirection for admitted patients.
AllowSchedulingForDismissedPatientINTEGERDetermines if a patient will ever be dismissed from scheduling from this department. This overrides other patient dismissal settings.
UserLogonDefaultPharmacyIdentifierNUMERICWhen the user logs on to this department, this will be treated as the pharmacy the user logged into. This will be used as default pharmacy when you start some Pharmacy activities, such as Cart Fill, Triggered Fill.
ResponsibleUnitIdentificationNUMERICThe unit that contains the bed records this unit is responsible for.
EncounterVerificationDepartmentOverrideIdentifierVARCHARThe unique ID of the department override for the encounter verification confirmation record.
DepartmentReportGroupNineteenCategoryVARCHARYou can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
DepartmentReportGroupThirtyThreeCategoryVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the category report groupers.
IsReminderTriggerTableRunWithoutDepartmentRuleEvaluationVARCHARDetermines whether the system should run the reminder trigger table specified at the system definitions level (SDF 10221-10213) when no rules at the department level evaluates to true.
DeprecatedDefaultHospitalAccountRecommendationAccountTypeINTEGERDEP item 21211 - Default account type for use in Hospital Account recommendation.
DepartmentReportGroupTwentyFourVARCHARUsers can specify groupers for enterprise reporting, SQL, or report generator reporting. This is one of the free-text report groupers.
DepartmentZipVARCHARZIP code of the department address.
DepartmentStateVARCHARState of the department address.
LocationTypeVARCHARType of location (place of service).