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. |