Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
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.
Column Name Column Datatype Column Null Option Column Comment
PatientPrescriptionHistoryOIDintNOT NULL Primary key. PatientPrescriptionHistory Object ID
PatientOIDintNOT NULL References to HPatient table Object ID column
PatientVisitOIDintNOT NULL References to HPatientVisit table Object ID column
XMLDocStorageOIDintNOT NULL foreign key for XMLDocStorage table XMLDocStorageOid column
FormularyStatusvarchar(40)NULL Prescription Plan Formulary Status. Allowable values: OnFormulary, Preferred,NonFormulary,Not Reimbursable,Unknown.
PreferenceLevelvarchar(2)NULL Prescription Plan coverage level. Allowable values: from 0 to 99 or U(Unknown).
PrescriptionMethodvarchar(20)NOT NULL Prescription Method like ePrescribe or print or fax. Allowable values ePrescribe, Print or Fax.
PatientEligibilityInfoOIDintNULL References to PatientEligibilityInfo table Object ID column
PatientPharmacyOIDintNULL References to PatientPharmacy table Object ID column
PrescriptionStatussmallintNOT NULL Status of prescription sent to HDX(Healthcare Data Exchange) , SureScripts and Pharmacy.
HDXTransactionIDintNULL HDX(Healthcare Data Exchange) assigned transaction ID used to check Prescription status
HDXToSoarianTransactionIdvarchar(20)NULL Request id from Soarian to HDX(Healthcare Data Exchange)
FailureCodevarchar(20)NULL Failure code from HDX(Healthcare Data Exchange) and Surescript for failed transaction
NCPDPDatavarchar(max)NULL Prescription transaction formatted data sent to HDX(Healthcare Data Exchange)
UserOIDintNOT NULL References to HSUser table Object ID column
UserNamevarchar(12)NOT NULL User Name
StaffOIDintNOT NULL References to HStaff table Object ID column
StaffNamevarchar(187)NOT NULL HStaff Name
Coverage_QDTsmallintNULL Prescription Coverage Quantity Limits(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_RRTsmallintNULL Prescription Coverage Resource Link Drug Specific(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_RDTsmallintNULL Prescription Coverage Resource Link Summary(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_MDTsmallintNULL Prescription Coverage Step Medications(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_GDTsmallintNULL Prescription Coverage Gender Limits(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_TDTsmallintNULL Prescription Coverage Coverage Messages(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_GDAsmallintNULL Prescription Coverage Age limits(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
Coverage_DDTsmallintNULL Prescription Coverage StepMeds, Exclusions and Medical Necessity header(Allowable values 0 and 1. 1:Segment Present and 0:Absent)
DAWsmallintNOT NULL Dispense as written(Allowable values 0 and 1. 1:Yes and 0:No)
CreateDTimedatetimeNOT NULL Created Date Time(wall clock)
LastResponseStatusCheckDateTimedatetimeNULL Date/time when the last status check call to HDX was made for this ePrescription. Null on initial population of row.
ElapsedTimeOfCallToHDXintNULL Elapsed time it took for the call to the send Rx or the check status service; whichever was called.
LastCngDTimedatetimeNOT NULL Last change Date Time(UTC)
MessageIDvarchar(35)NULL Message ID used in NCPDP(National Council for Prescription Drug Programs) ePrescription message
PrescriberOrderNumbervarchar(35)NULL prescriber order number of ePrescription
PrescriptionSignatureOIDbigintNULL reference oid for NCPDP response message's signature signed by private key
PharmacyRolevarchar(6)NULL Type of Pharmacy(Allowable value: MAIL, RETAIL)
Quantityvarchar(300)NULL Prescription quantity
Refillsvarchar(300)NULL Refills quantity
DispensingUnitFmtCodevarchar(10)NULL NCPDP(National Council for Prescription Drug Programs) FMT(Federal Medication Terminologies) code, for NCPDP transaction
DispensingUnitFmtDescvarchar(50)NULL NCPDP(National Council for Prescription Drug Programs) FMT(Federal Medication Terminologies) code description
MrcMedicationOidbigintNULL Foreign key to MrcMedication table
EarliestFillDatesmalldatetimeNULL Earliest Fill Date for prescription
IsPrescriberOrderNumberActivetinyintNULL Status of prescriber order number(0 inactive; 1 active)
PONDeactivatedSystemDateTimedatetimeNULL Wall clock date time when prescriber order number was deactivated
PONDeactivatedNcpdpOutboundMessageOidbigintNULL NcpdpOutboundMessageOid of the outbound message that deactivated the PON(Prescriber Order Number).
Null if the ePrescription was simply removed with no cancel message.
PONDeactivatedUserOidintNULL User OID of user who deactivated the PON(Prescriber Order Number)
TransmittedDataFormatvarchar(3)NULL NCPDP data format('xml', 'edi' [edifact])
TransmittedViaApiVersionvarchar(10)NULL which HDX(Healthcare Data Exchange) API was used to transmit the NEWRX('MU2' = sendPrescriptionService, 'MU3' - outboundMessage for edifact prescriptions, 'HDX2017' - outboundMessage for XML prescriptions)
DaysSupplysmallintNULL Days Supply for a medication(e.g. '1')

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates