Soarian Clinicals Schema Documentation

Overview

The Soarian Clinicals (SC) operational data store contains files that represent the Patient Data from the Soarian Clinicals domain. Click on the table link to see the details.

Table Name Table Comment
Arc_PublicApiActivityLog Maintains the audit trail of the FHIR-API access.
Arc_PublicApiProxyUserRepository Maintains information about the proxies or authorized representatives defined for the patient. This information can be viewed on Soarian Clinicals UI through the "API Access Management" screen on the Visit taskcard.
Arc_PublicApiTokenManager Controls the linkage between an API user and the patient for whom the user is authorized. This access control is achieved using ActivationToken (just like One Time Password) and PermanentToken and their status fields. Information can be viewed on Soarian Clinicals UI through the "API Access Management" screen on the Visit taskcard.
Arc_PublicApiUser Maintains the FHIR-Api user identity details for the Patient persona. Entry in this table is created when an API user is linked to a patient through Patient Linking workflow.
Arc_PublicApiUserToTokens Mapping table for many-to-many relation between Arc_PuublicApiTokenManager and Arc_PublicApiUser tables.
CDMX CDM Cross Reference Index
DdcAnswer This table contains answers and data associated with concept instances in patient provider documents (DDC).
DdcContributor Contains a row for each Contributor to a document version. Holds target cosigner, cosigner, scribe, etc.
DdcDoc Contains a row for each document. Also contains document data that is unchanged for the life of the document
DdcDocSection Contains a row for each saved section of the document.
DdcDocVersion Contains a row for each version of the document.
DdcMappedConcepts Contains information about finding abbreviations and their values from the Map Definition and concepts with mapping code interfaces.
DdcMappingCodes This table contains various codes (SNOMED, LOINC, UCUM, etc.) which are associated with concepts in the DdcMappedConcepts table.
DdcPath Contains info about the unique path of the node in a document. Defines the relationship between the question and the answer.
DPC_UserHistory Contains history of changes of various DPC (Diagnosis and Procedure Coding) and DRG (Diagnosis-Related Grouping) - related information
HAddress Contains person's Address information.
HAddress_Ver Contains person's changed Address information.
HAppointmentActivity Contains patient appointments activity information.
HAppointmentResource Contains patient appointment resource information.
HAssessment Details on the patient's assessments.
HAssessmentCategory Information on the type of formusage used to chart the assessment, mainly used for chaptered assessments.
HAssessmentEdit Populated when a revert action is performed on an assessment.
HAssociateModifiers Contains associated procedure for clinical coding.
HAssociateModifiers_Ver Contains HAssociateModifiers changed information.
HBed Contains detailed bed information.
HBedTransfer Contains bed information for the visit.
HBedTransferHistory Contains detaile bed transfer history information.
HCallback This table is used to store callback information.
HCallbackAssignment This table is used to store callback assignment information.
HCallbackAttempt This table is used to store callback attempt information.
HCallbackListDef This table holds the definition of the callback lists.
HCareTeamAssignmentHistory Contains patient/staff assignment history information.
HCensusPatientList Contains list of patients/Visits to be displayed in the census.
HChargeHold This table stores the Charge/Credit which needs to be processed raising Soarian_Billing event to eventually form HL7_P03 Transaction.
HChiefComplaintHistory contains Chief Complaint History Information.
HChiefComplaintHistory_Ver Contains visit Chief Complaint changed information.
HClinicalInformation OBSOLETE TABLE - Prior to the IMA (Inter-Module Adaptability) feature , This table used to store data from other modules during order entry. This table was kept for backward compatibility support for older form elements. The older form elements are no more available on Order Detail Forms, and with IMA Feature other module elements are getting saved in HClinicalInformationEx table.
HClinicalInformationEx During Order Entry , this table stores the other module data from IMA (Inter Module Adaptability) elements on Order Detail Form.
HClinicalNote Details about the patient's clinical notes.
HCollectedSample This table stores the Sample Collection details for Laboratory Orders
HCommonDefinition This table stores the details of a Common Definition which can be linked to multiple Services thereby allowing grouping of these services under a common definition. Writing Rules on the common definition then allows same rules to apply on multiple services.
HContainersForSample This table contains the details of the Containers used to collect the sample/specimen
HDataDictionaryItem This table stores the details about any Dictionary Item used by the system. If system needs to define a list of items (system defined / user configured) for any business requirement then this shall be used. Records in this table appears in the Catalog browser of Administrative Desktop as one of the Catalog Item named Data Dictionary Items.
HDeathInformation Contains patient's death information
HDeathInformation_Ver Contains patient's changed Death information.
HDiagnosis Contains detailed patient diagnosis information.
HDiagnosisHistory Contains patient's Diagnosis History Information.
HDiagnosisHistory_Ver Contains patient's changed HDiagnosisHistory data.
HDiagnosisSites Contains information about what side of the body diagnosis relate to
HDiagnosisSites_Ver Contains patient's changed Diagnosis Sites information
HDictation Used to populate the Digital-Dictation Worklist with dictations to be completed and transcribed.
HDictionaryItemType This table defines the Dictionary Item Type , which is used to group the Dictionary Items in HDataDictionaryItem table
HDPAttributes Contains attributes for diagnoses and procedures.
HDPAttributes_Ver Contains changed HDPAttributes information.
HEDTBClinician This table is used to store free text clinicians for EDTB.
HEQAFormList The table contains list of Quality Assuarance Forms triggered by 3rd party tool QSFilter and/or persisted in the 3rd party tool QSMED
HExtendedBedTransfer Contains patient's Bed Transfer Extended information
HExtendedBedTransfer_Ver Contains patient's changed Bed Transfer Extended information
HExtendedOrder This table stores extended information of a Order which can be customized at the Client using the Extensibility feature. Clients use fields from this table to capture specific details about the order which they can use to send to integrating applications or for reporting.
HExtendedPatient Contains extended patient information.
HExtendedPatient_Ver Contains patient's changed Extended information.
HExtendedPatientVisit Contains extended patient visit information
HExtendedPatientVisit_Ver Contains patient's changed Extended Visit information
HExtendedValue This table stores information related to the Result value when the Result value length is more than 80 characters.
HExternalHCProfessional Contains information about External Healthcare Professional
HExternalIdentifier This table has details of when Non-med Order Occurrence were sent out to external systems (like LAB,RAD systems)
HExternalOrderInfo This table stores the details about the Orders originating from external Ambulatory systems.
HFlowSheet This table stores information related to the Flowsheets that are defined.
HFormattedResult This table stores information related to the PDF/RTF Results.
HGranularity This table stores the granularities in the system (E.g. 24 h,15 min,1 month). A granularity is a defined time unit which could be applied to a prescription, this is mandatory for the prescriptions
HGuarantor Contains patient's Guarantor Information
HGuarantor_Ver Contains patient's changed Guarantor information.
HHealthCareUnit Contains Healthcare Unit information.
HHealthcareUnitType Contains information about differet HCU (Health Care Unit) types.
HIDDocuments Collection of different person's identity numbers (SSN, Driver License Number, etc)
HIDDocuments_Ver Contains person's changed IDDocuments information.
HInsuranceDetails Contains visit Insurance Information.
HInsuranceDetails_Ver Contains patient's changed Insurance Details information.
HInvestigationResult_Active This table stores information related to the OBX (Result) and OBR (Order) information of an Inbound R01 Result. It will also contain data for results manually entered on Soarian.
HInvestigationResultSuppInfo_Active This table stores information related to a Result. The data comes from the HL7 OBX and OBR segments on an Inbound R01 Result. HInvestigationResultSuppInfo_Active is an Extended table for HinvestigationResult_Active table.
HLeaveOfAbsence Contains patient Leave of Absence Information.
HLeaveOfAbsence_Ver Contains patient's leave of absence changed information.
HLetterComment This table stores the information for all comments added to the clinical letter.
HLetterInstance This table stores the information for all clinical letters created by the user.
HLetterStylesheet This table stores the values of the stylesheet.
HLetterTemplate This table stores the information for all available clinical letter templates.
HLetterVersions This table stores the information for the versions of a clinical letter.
HLinkedOrderGroup This table stores the definitional data about a Linked Order Group. Orders in an order set can be grouped by this and while performing an order function the user can presented the entire group to be acted upon
HLinkedSetOrigin This table stores the details of the Linked set Origin(definitional data) populated during design time
HLinkType This table stores the details of Link Type (definitional data) which is populated during design time.
HLocation Contains HCU location relative information.
HMedAdministration This table stores the administrations of a medication order
HMedAdministrationH This table stores the historical data of medication order administrations
HMedAlerts This table stores data related to medical alerts raised due to medication interactions
HMedAlertsH This table stores historical data related to medical alerts raised due to medication interactions
HMedDispOrder This table stores the medication dispensed order data
HMedDispOrderCompDosage This table stores data representing dispensed component dosage for a medication
HMedDispOrderCompDosageH This table stores historical data representing dispensed component dosage for a medication
HMedDispOrderComponent This table stores the dispensed component of a medication order
HMedDispOrderComponentH This table stores the historcal data for dispensed component of a medication order
HMedDispOrderH This table stores the dispensed medication order historical data
HMedDispOrderSuppInfo This table stores dispensable medication order supplementary information
HMedDispOrderSuppInfoH This table stores dispensable medication order supplimentary information
HMedDrugService This table stores the Drug Details imported from Drug Database (FDB-US , ID-Berlin etc) and links to Service Definition in Soarian's Service Catalog
HMedEffectiveness This table stores details about medication effectiveness
HMedEffectivenessH This table stores history details about medication effectiveness
HMedMPWDispSelection This table stores temporary administration selection made for the purpose of sign/dispensed or print. When used in an EDR workflow, print service pulls selection data based on the TransactionId, generates the report and prints it.
HMedOrder This table stores medication order data
HMedOrderComponent This table stores the medication order component data
HMedOrderComponentDosage This table stores data representing component dosage for a medication
HMedOrderComponentDosageH This table stores historical data representing component dosage for a medication
HMedOrderComponentH This table stores the historical data of a medication order component
HMedOrderExt This table stores the medication order external data reference
HMedOrderH This table stores history of medication order data
HMedOrderSuppInfo This table stores medication order supplimentary information
HMedOrderSuppInfoH This table stores historical data for medication order supplimentary information
HMedPrescription This table stores data related to a Medication Prescription
HMedPrescriptionH This table stores historical data related to a medication prescription
HMedResolutionAction This table stores resolution actions related to medical alerts
HMedResolutionActionH This table stores history of resolution actions related to medical alerts
HMedScreenInfo This table stores displayed information in relation with alert and resolution action. Stores the interaction between drugs.
HMedScreenInfoH This table stores historical data of HMedScreenInfo records
HMedSign This table stores data associated with a co-signature action of Medication order
HMedSubRouteMap This table stores the details of system-defined Routes for taking a medication and the relationship with its sub-routes.
HMergeInformation Contains patient merge information.
HMergeInformation_Ver Contains person's changed merge information.
HMergeItems Contains merged items information
HMergeItems_Ver Contains merged items changed information
HMergeLog Contains detailed merge information.
HMergeLog_Ver Contains merged changed detail information
HMod2CPTCode This table stores the CPT (Current Procedure Terminology) Modifiers associated with an Non-Medication Order/Occurrence
HMoveLog Contains detailed move visit information.
HMoveLog_Ver Contains moved visit changed detail information
HName Contains person's name information
HName_Ver Contains person's changed name information
HNextofKinDetails Contains patient's next of kin (NOK) relationship.
HNextofKinDetails_Ver Contains patient's changed next of kin (NOK) information.
HObservation_Active Information about the value (example:Temperature)and type (example:UOM(Unit of Measure),Range) of findings charted for the assessment.
HObservationUOM Information about the unit of measure (ex:celsius) is stored in this table.
HObsExtraInfo Information about LTE (Large Text Editor) Elements and Images will be stored in this table.
HObsSurveillance This table is used to store observation collected for syndromic surveillance (syndromic Surveillance preference should be setup to populate this table).
HOccStateTransRec This table has the historical details of the transitions an occurrence of a non-medication order went through in the system.
HOccStatusModifier Order Occurrence Status Modifiers. Used to provide additional status information for an occurrence.
HOccupation Contains person's job information
HOccupation_Ver Contains person's changed Occupation information.
HOccurrenceOrder This table has details about Occurrences of a Non-Medication Order.
HOrdCheckResult This table stores the details of Duplicate Check & Medical Necessity Check Alerts that appeared on Non-Medication Orders during order entry.
HOrdCheckResultAxnDet This table stores the result of the Alert resolution by the user. Applicable only for Duplicate Check and Medical Necessity Check on Non-medication orders.
HOrder This table stores the details about an Order for a Service (Medication & Non-Medication) , entered on a Patient in the system.
HOrder__LinkedOrderGroup A table which links the Order's Identifier with LinkedOrderGroup's Identifier. As this is a many-to-many relationship , this table is created to store the relationship.
HOrderContext This table stores the contextual information that an order is associated with. Eg ED Orders , Ambulatory Orders etc. Design allows to attach multiple contexts to a given order.
HOrderDocument This table stores the Identifier of the Order Detail Form associated to a Non-Medication Order
HOrderFunction This tables stores order function name and code values.
HOrderSourceModifier There are three primary ordering sources (Verbal,Written & Per Protocol) which are used when placing an order. This table stores user defined modifiers for these sources eg e-Mail(Written),Phone(Verbal) etc
HOrderSuppInfo This table stores supplementary(Additional) information about an Order.
HOrderSuppInfoExt This table stores extended supplementary(Additional) information about an Order.
HOrderToBeAckWLItems This is a worktable which holds the order information which is then used populate the Orders to be Acknowledged worklist category in Cinical UI.
HOrderTransitionRecord This table has details of the status transitions and order functions an order has gone through.
HOrderWLItems This is a worktable which holds the order information which is then used to populate worklist categories namely - Orders To be Signed, Orders Approaching Expiration, Intervention & Consultations.
HOrdHeldOrdersInfo Worktable which holds the orders which got suspended from UI or Non-UI workflows
HOrdLevelOfCareTransition This table tracks the user action when Transfer level of Care(TLC) workflow is initiated on the Clinical UI
HPatAccessDef Indicates which usergroups have access to what patients and at what restriction levels.
HPatAccessDef_Ver Indicates which property has been changed by whom from the changes made in HPatAccessDef Table
HPatient Contains patient detailed information.
HPatient_Ver Contains changed HPatient information
HPatientAdditionalInfo Contains latest patient orders and results date information.
HPatientAppointment Contains patient appointments information.
HPatientCareAlert Contains specific alert information for the patient.
HPatientCareAlert_Ver Contains person's changed Care Alert information.
HPatientClass Contains all available patient visit types. Can be edited by the client.
HPatientIdentifiers Contains information about all patient Identifiers like MRN,MPI,SSN
HPatientIdentifiers_Ver Contains person's changed Identifiers information.
HPatientTemporaryLocation Contains information about patient temporary location.
HPatientToUnitAssociation Contains patient to unit association.
HPatientToUnitAssociation_Ver Contains HPatientToUnitAssociation changed information.
HPatientVisit Contains patient's visit information
HPatientVisit_Ver Contains patient's changed visit information.
HPendingLocation Contains patient visit pending location information
HPerformingOrgDetail This table stores information related to the performing organization of a result. It also includes information about the performing organization's medical director.
HPerson Contains person information (can be patient, staff member, next of kin (NOK) to the patient, etc)
HPerson_Ver Contains person's changed information related to HPerson table.
HPersonLanguage Contains person's Language information
HPersonLanguage_Ver Contains person's changed Language information
HProcedure Contains procedure information for the patient visit
HProcedure_Ver Contains patient's changed Procedure information.
HProcedureDevice This table holds the information about various devices which are attached to the patient during clinical procedures.
HProcedureDeviceH This table holds the information about historical changes made to the ProcedureDevice record.
HProcedureHistory Contains patient's Procedure History Information.
HProcedureHistory_Ver Contains patient's changed Procedure History information.
HPtActualOutcome Actual Outcomes of a Patient's Expected Outcomes
HPtAllergy Allergies recorded for a Patient
HPtAllergyIndicator Allergy Indicators recorded for a Patient
HPtAllergyReaction Reaction a Patient has to a component of an allergy
HPtAllergyReassess Records of when allergy information for a patient have been Assessed/Reassessed. An initial assessment as well as subsequent assessments create rows in this table.
HPtAllergyReconcile Records of when a Patient's Allergy have been Reconciled - Patient, Visit, User, Date and Time. US Only.
HPtAllergyReconcileDetail Allergy Reconciliation Details - Row created for every Allergy that was available to be reconciled. US only.
HPtExpectedOutcome Expected Outcomes of a Patient
HPtExpectedOutcomeParameter Parameters and their Values that are associated with an Expected Outcome for a Patient
HPtOutcomeHistory History / Changes made to Expected Outcome Information
HPtOutcomeHistoryDetail History of changes to values for Patient Outcomes (HPtOutcomeHistory)
HPtPoCReview Patient's Plan of Care Review records
HPtPoCTemplate Plan of Care Templates assigned to Visit (Patient's Visit)
HPtProblem Problems associated with a Patient
HPtProblem__PatientVisit Problems associated to a Patient Visit
HPtProblemHistory History of additions and changes to Problems associated with a Patient
HPtProblemParameter Parameters for Problems associated with a Patient
HPtProblemReconcile Records of when a Problem for a Patient has been Reconciled - Patient, Visit, User, Date and Time. US Only.
HPtProblemReconcileDetail Problem Reconciliation Details - Row created for every Problem that was available to be reconciled. US only.
HREAlert This table stores Clinical Alerts for the Patient. Typically populated by Workflow Engine and Rules Engine.
HREAlertRoles This table stores the role codes associated with Alerts.
HREAlertUsers This table stores user ID's associated with Alerts.
HRecOrders4OccGen This is a worktable that holds recurring Non-medication orders which need to have occurrences generated by the scheduled job of occurrence generation.
HRecurrenceInstance This table contains a denormalized record of the recurrence template (Frequency) and Schema used by user to create an recurring order
HReferringInstitution Contains information about institution that referred the patient to the healthcare unit.
HReferringInstitution_Ver Contains changes in person's institution that referred the patient to the healthcare unit.
HRegStatusHistory Contains registration status history information for the patient visit.
HRESuggestedAction This table stores information related to the suggested actions for Alerts.
HRESuggestedActionField This table optionally stores fields for suggested actions.
HResultCodedInfo This table stores a result's relevant clinical information, Result Handling information and the condition of the specimen. This information is sent on an inbound R01 Result transaction with a CWE (Coded With Exceptions) data type. The CWE data type contains multiple data elements.
HResultCopiesToInfo This table stores information related to the CC and BCC recipients of an Inbound Lab Result.
HResultIdentifierDetail This table stores information related to standardized coding systems such as LOINC Snomed, etc. For example, the LOINC code of 10917-3 would be stored in Identifier details Code and Zinc would be stored as the description.
HResultIdentifiers This table stores information related to standardized Coding systems.
HResultObsRequestCommonInfo This table stores information related to the Order associated to a result. It contains data from the OBR Segment and ORC Segment for an Inbound R01 Message.
HResultRefRanges This table stores information related to the Normal and Critical reference ranges of a Result.
HResultSpecimenInfo This table stores Specimen information related to a Result.
HResultSpecimenOBXInfo This table stores information related to the results of the specimen. It is sent on Repeating OBX segments after the SPM segment.
HRole Contains all different User Roles information of Soarian Clinicals application
HSecurityManTestRec Stores zero-to-one relationship between HSecurityManTestRec and Patient. HSecurityManTestRec.Patient_oid = HPatient.Objectoid
HSecurityObject Contains all the Security objects of the Soarian Clinicals application and its types(for example, the data recorded while registering or discharging a patient.)
HSendLetter This table stores the information for all the clinical letters which are cosigned.
HSensitivity This table stores information related to Micro Sensitivity Results.
HService This table has definitional data about various services, findings or both which are given to the patient in a hospital setup.
HServiceDetail This table holds the details of the Service definition in HService table.
HServiceType This table has definitional data that describes the type of service.
HSpecimen This table contains definitional data for Specimen used for Sample collection in Laboratory setup.
HStaff Contains information about staff members.
HStaffAssociations Contains information about staff associated with the patient or the patient visit.
HStaffAssociations_Ver Contains changed HStaffAssociations information.
HStaffPatientAssoHistory Contains patient and staff association history information.
HSTask Defines all the tasks within the Soarian Clinicals application.
HSTaskTemplate Defines tasks available within Soarian Clinicals application with additional details (For example: Description, Code).
HSUser Contains different user's information who are accessing Soarian Clinicals application
HSUserGroup Contains different usergroup information of the Soarian Clinicals application
HTBAssignment This table holds which staff is assigned to each visit.
HTBCodedText This table holds text type columns' values for an Emergency Department visit (e.g. comment, disposition).
HTBColumn This table contains default and system values for each column on the board.
HTBDelay This table indicates that there is a delay either through application logic or workflow for this column.
HTBEventDefinition This table contains the definition of milestone events such as: Patient Arrival, Triage Start, etc.
HTBEventLog This table holds a log of milestone events recorded for each visit.
HTBEventTriggerDefinition This table contains the definition of milestone event triggers.
HTBIndicator This table holds the list of available indicators.
HTBMainLocation This table contains the main location assigned to the patient visit.
HTBPrearrival This table contains information about the pre-arrival visits.
HTBTempLocation This table holds the temporary location assigned to the patient.
HTBTimer This table holds the tracking board timers.
HTBTrackingBoard This table holds the definition of tracking boards.
HTBTriageLevel This table holds the patient visit's triage levels.
HTBVisit This table contains all the Emergency Department tracking board visits.
HTBVisitIndicator This table holds indicators assigned to a visit.
HUserPatientLimitation Contains patient limited to specific user.
HUserPatientUnlock Contains user/staff information for the locked patient
HVisitAccessDef Records visit accesses that belong to specific usergroups and Patients
HVisitAccessDef_Ver Indicates which property has been changed by whom from the changes made in HVisitAccessDef Table
HVisitActivity Cntains information about visit activities.
HVisitActivity_Ver Contains Visit Activity changed information.
HWorkingDiagnosis This table contains the details of the diagnosis associated with the order
MedrecPatInfo This table contains Medication History Prefetch criteria sent to retrieve Medication History from SureScripts
MrcMedDiagnosis This table stores the primary or secondary diagnosis information for the patient medication.
MrcMedication This table stores medication information for each medication in the xml documents stored in the XmlDocStorage and NcpdpOutboundMessage table
MrcMedInfo This table stores FDB (First Data Bank) medication identifier information for medications stored as xml documents in XmlDocStorage and NcpdpOutboundMessage.
MrcMedInfoClassification This table stores medication classification information from xml(Extensible Markup Language ), each sentence within the pxml(Persisted Extensible Markup Language ) corresponds to one row here.
MrcMedSection This table stores static data from MedRec(Medication Reconciliation) flow. Each panel in MedRec work flow UI corresponds to one row in this table.
NcpdpInboundMessage This table stores the electronic prescription (eRx) messages that Soarian has received from pharmacies
NcpdpInboundMessageDrug This table stores information about the medications being requested by pharmacies in electronic prescription (eRx) request messages
NcpdpInboundRxFill This table stores the electronic prescription fill status data specifically for RXFILL inbound messages.
NcpdpOutboundMessage This table stores the message information for electronic prescriptions sent from Soarian.
NRS_DataSourceData Details about the data source used to chart an assessment with IMA (Inter Module Adaptability) element valued.
NRS_Document Details about the document used to chart an assessment with an Inter Module Adaptability (IMA) element valued.
NRS_FormDSLink This table indicates the link between the form and datasource used to chart an assessment with IMA (Inter Module Adaptability) element valued.
NRS_FormInformation Details about the form used to chart an assessment with an IMA (Inter Module Adaptability) element valued.
PatientEligibilityInfo This table holds information about prescription plans. This information is used during the prescription writing process.
PatientLifeTimeCareTeam contains patient/Care team association.
PatientLTCTManuallyAddedMember contains manually added Care team members.
PatientPharmacy This table stores Patient's preferred pharmacies for the ePrescribing workflow.
PatientPrescriptionHistory This table stores information for printed prescriptions and electronic prescriptions that are issued from Discharge Reconciliation. As of Soarian version 4.1, additional information about electronic prescriptions is also stored in NcpdpOutboundMessage.
PdmpViewTracking This table stores the PDMP (prescription drug monitoring program) view information. A record will be added to this table every time a user views PDMP data.
Pharmacy This Table is used by ePrescribing workflow for saving pharmacy information retrieved from HDX (Healthcare Data Exchange).
PHCDT Pharmacy Cumulative Dose Tracking (CDT)
PHCDTBL Pharmacy Cumulative Dose Tracking (CDT) Masterfile
PHCLIN_DIAG_CODED Clinical Patient Diagnosis Coded
PHCLIN_DIAG_FREE_TEXT Clinical Patient Diagnosis Free Text
PHCLIN_HIST_DIAG_CODED Clinical Patient Data History Diagnosis Coded
PHCLIN_HIST_DIAG_FREE_TEXT Clinical Patient Data History Diagnosis Free Text
PHHST_CHARGES Pharmacy Historical Patient Charges
PHHST_CHARGES_INTERV_TOTALS Pharmacy Historical Patient Intervention Charge Totals
PHHST_CHARGES_IV_CMP_TOTALS Pharmacy Historical Patient IV Charges by Component
PHHST_CHARGES_MEDANDIV_TOTALS Pharmacy Historical Patient Med and IV Charges Level 2
PHHST_CHARGES_MINI Pharmacy Historical Patient Mini-Charges summarized by Patient per Day per Drug
PHHST_CHARGES_MINI_TRANS Pharmacy Historical Patient Mini-Charges individual transactions
PHHST_CHARGES_MISC_TOTALS Pharmacy Historical Patient Miscellaneous Charge Totals
PHHST_CLIN_INTERVS Pharmacy Historical Patient Clinical Interventions
PHHST_ORDERS_DIAG_CODED Pharmacy Historical Patient Order Coded Diagnosis Snapshot
PHHST_ORDERS_DIAG_FREE_TEXT Pharmacy Historical Patient Order Free Text Diagnosis Snapshot
PHHST_ORDERS_NOTES Pharmacy Historical Patient Order Notes
PHM_CHARGES Pharmacy Active Patient Charges
PHM_CHARGES_ENHANCED Pharmacy Active Patient Enhanced Charges
PHM_CHARGES_ENHANCED_HELD Pharmacy Active Patient Enhanced Charges Held
PHM_CHARGES_HELD Pharmacy Active Patient Charges Held
PHM_CHARGES_INTERV_TOTALS Pharmacy Active Patient Intervention Charge Totals
PHM_CHARGES_IV_CMP_TOTALS Pharmacy Active Patient IV Charges by Component
PHM_CHARGES_LTC Pharmacy Long Term Care Charges
PHM_CHARGES_LTC_BATCHED Pharmacy Long Term Care Charges Batched Claims
PHM_CHARGES_MEDANDIV_TOTALS Pharmacy Active Patient Med and IV Charges Level 2
PHM_CHARGES_MINI Pharmacy Active Patient Mini-Charges summarized by Patient per Day per Drug
PHM_CHARGES_MINI_TRANS Pharmacy Active Patient Mini-Charges individual transactions
PHM_CHARGES_MISC_TOTALS Pharmacy Active Patient Miscellaneous Charge Totals
PHM_CLIN_AUDIT Pharmacy Clinical Checking Audit
PHM_CLIN_AUDIT_2 Pharmacy Clinical Checking Audit - Part 2
PHM_CLIN_AUDIT_ADDL_DRUGS Pharmacy Clinical Checking Audit - Additional Drugs of Current Order
PHM_CLIN_AUDIT_ADDL_DRUGS_CONF Pharmacy Clinical Checking Audit - Additional Drugs of Conflicting Order
PHM_CLIN_AUDIT_PREV_ADMIN_DRUGS Pharmacy Clinical Checking Audit - Previous Administration Drugs
PHM_CLIN_INTERVS Pharmacy Active Patient Clinical Interventions
PHM_CLIN_INTERVS_DEM Pharmacy Clinical Interventions Patient Demographic Data
PHM_CVXCODES_MASTER Pharmacy CVX codes
PHM_EDM_DOCUMENT_ID EDM (Enterprise Document Management) Document ID
PHM_EDM_DOCUMENT_ID_ACTIONS EDM (Enterprise Document Management) Document ID Link to Orders
PHM_IMMUNIZ_ELIGIBILITY_STATUS_MASTER Immunization eligibility status master
PHM_IMMUNIZ_EVI_OF_IMMUNITY_MASTER Evidence of immunity master
PHM_IMMUNIZ_FUNDING_SOURCE_MASTER Immunization funding source master
PHM_IMMUNIZ_HISTORY Immunization History
PHM_IMMUNIZ_HISTORY_NEXTOFKIN_DEM Immunization History Next of Kin Demographics
PHM_IMMUNIZ_HISTORY_PATIENT_DEM Immunization History Patient Demographics
PHM_IMMUNIZ_INFO_SOURCE_MASTER Immunization information source master
PHM_IMMUNIZ_NCIT_ROUTE_MASTER National cancer institute thesaurus master
PHM_IMMUNIZ_PUBLICITY_CODE_MASTER Publicity code master
PHM_IMMUNIZ_REGISTRY_STATUS_MASTER Immunization registry status master
PHM_IMMUNIZ_SUBS_REFUSAL_REASON_MASTER Substance refusal reason master
PHM_IMMUNIZ_VAC_DOC_TYPE_INDENT_MASTER Vis document type identifier master
PHM_IMMUNIZ_VAC_INFO_STATEMENTS_MASTER Pharmacy vaccination information statements master
PHM_MAC_ERR_DTL Pharmacy Med Administration Check Error Details
PHM_METHOD_MF Pharmacy Method Masterfile
PHM_SPEC_ATTENTION_CODE_MASTER Special Attention Code Masterfile
PHM_SPEC_ATTENTION_CODED Special Attentions Coded
PHM_SPEC_ATTENTION_FREETEXT Special Attentions Free Text
PHM_THERAPEUTIC_CODE_MASTER Pharmacy Therapeutic Code Master
PM_NOTES Pharmacy Active Patient Order Notes
PrescriptionSignature This table stores the digital signature and associated algorithm parameters
PTM Patient Type Masterfile
RtgArtifactRoutingDestination Contains the list of destinations and last received status of sending the artifact to the destination that a routing request has generated.
RtgArtifactRoutingRequest Contains a list of requests to route patient documentation to another provider by either a fax, or direct message.
SIG_LATIN Latin Directions (SIG)
SIG_LATIN_EXCEPTIONS Latin Directions Exceptions
SignaturePublicCert This table stores the certificate and certificate algorithm that will be used to sign the transaction which is sent to surescripts
SITE Site Table
TRANFUNCTION_MASTER Function Codes/Descriptions Masterfile
XMLDocStorage This table stores all the Medication Reconciliation documents.


  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates
Note: Schema Documentation is provided for only those tables that may contain patient data from the operational data store.