Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
MrcMedication This table stores medication information for each medication in the xml documents stored in the XmlDocStorage and NcpdpOutboundMessage table
Column Name Column Datatype Column Null Option Column Comment
MrcMedicationOidbigintNOT NULL Primary key
MrcSectionCodevarchar(10)NOT NULL Foreign key reference to MrcMedSection
MrcMedicationTypevarchar(5)NOT NULL Defines the Medication type. Allowable value: MED(STRUCTURED MED ), TXT(FREETEXT), SFT(STRUCTURED_FREETEXT)
OrderIdForClinicalCheckingintNULL Order id assigned during clinical checking
SentenceIDvarchar(25)NOT NULL Unique id in context of UI process
RoutedMedScuivarchar(32)NULL Concept unique identifier(cui) for routed med
StrengthScuivarchar(32)NULL Concept unique identifier(cui) of strength
DoseFormScuivarchar(32)NULL Concept unique identifier(cui) of dose form
Drugvarchar(800)NOT NULL Generic name if structured med, otherwise free text med name
BrandNameScuivarchar(32)NULL Concept unique identifier(cui) of brand name
BrandNamevarchar(300)NULL Brand Name of medication
Strengthvarchar(300)NULL Drug strength
DrugDoseFormvarchar(300)NULL Dose form
DrugDosevarchar(300)NULL Administrative Dose
DoseUnitScuivarchar(32)NULL Administrative Dose Unit Concept unique identifier(cui)
DoseUnitvarchar(300)NULL Administrative Dose unit description
DoseValuevarchar(300)NULL Administrative Dose unit
Routevarchar(300)NULL Medication route
RouteScuivarchar(32)NULL Route Concept unique identifier(cui)
Frequencyvarchar(300)NULL Frequency of medication
FrequencyScuivarchar(32)NULL Concept unique identifier(cui) for frequency
MedNameIdInFdbvarchar(32)NULL Medication Name Id
Durationvarchar(300)NULL Duration of medication
PrnScuivarchar(32)NULL Concept unique identifier(cui) for PRN(as needed)
Timingvarchar(300)NULL Timing of medication
TimingScuivarchar(32)NULL Concept unique identifier(cui) for timing
PRNvarchar(5)NULL Indicates if the medication is PRN(Pro re nata - as the circumstance arises, as needed)
PRNReasonvarchar(300)NULL Reason for taking as needed
PRNReasonScuivarchar(32)NULL Concept unique identifier(cui) for Reason for taking as needed
Priorityvarchar(300)NULL Priority of medication
PriorityScuivarchar(32)NULL Concept unique identifier(cui) for priority
HomeMedStatusvarchar(300)NULL Home Medication Status
HomeMedStatusScuivarchar(32)NULL Concept unique identifier(cui) for Home Med Status
DAWtinyintNULL Dispense as written
DAWScuivarchar(32)NULL Concept unique identifier(cui) for Dispense as written
ExtendedInstructionsvarchar(1000)NULL Extended instructions
MedDescriptionvarchar(max)Null Description of medication in text format
MedDescriptionInHtmlvarchar(max)Null Description of medication in html format
HeldReasonvarchar(300)NULL Held reason
HeldByStaffNamevarchar(187)Null Name of staff who held the medication
HoldInstructionsvarchar(300)NULL Hold instruction
StopReasonvarchar(300)NULL Stopped reason
SupervisorStaffNamevarchar(187)Null Supervisor name
SupervisorStaffOidintNull Supervisor identification, references to HStaff table's Object ID
EnteredByStaffNamevarchar(187)Null Entered by staff name
EnteredByStaffOidintNull Entered by staff identification number, references to HStaff table's Object ID
DeaCodechar(1)NULL Drug Enforcement Administration(DEA) code( allowable values: 1,2,3,4,5,6(FDB specific))
DeaStateQualifiervarchar(2)NULL Drug Enforcement Administration(DEA) state qualifier
MedMatchingStatusvarchar(16)NULL Medications matching status with home medication(Allowable Action State: NotContinued, Continued, PartialMatch, ContinuedPartial, NewMed )
PatientMatchStatusvarchar(8)NULL Patient Matching status values(Allowable Action State: NoMatch, HasMatch)
XMLDocStorageOidintNULL Foreign key to XMLDocStorage table
ERenewResponseOIDbigintNULL Foreign key to the NcpdpOutboundMessage table(formerly known as the ERenewResponse table)
MedStatusvarchar(300)NULL Patient Med List Medication Status( Allowable status: Active, discontinue )
MedStatusReasonvarchar(300)NULL Patient Med Status reason(example: not compliant, not tolerated )
FreeTextDirectionsvarchar(1000)NULL Partially structured free text directions to patient for medication
FreeTextRxTypevarchar(300)NULL Partially structured free text prescription type
FreeTextControlledSubstancevarchar(300)NULL Partially structured free text controlled substance indicator
MaxDailyDosevarchar(300)NULL The maximum dosage the patient should take on any given day
AdminDoseUcumCodevarchar(255)NULL The Unified Code for Unit of Measure for the Administration dose.
PrescribeDosevarchar(300)NULL The full text of the prescribing dose
PrescribeDoseValuevarchar(300)NULL The numeric portion of the prescribing dose
PrescribeDoseUnitvarchar(300)NULL The unit of the prescribing dose
PrescribeDoseUnitScuivarchar(32)NULL Soarian Concept unique identifier(Scui) for unit of the prescribing dose unit
PrescribeDoseUcumCodevarchar(255)NULL The Unified Code for Unit of Measure for the Prescribing dose
MedRouteDescriptionvarchar(255)NULL The route associated with the Formulation ID Sequence Number(GcnSeqNo), provided by Knowledge Data Infrastructure(KDI) content
DrugFormTypevarchar(10)NULL The physical form of the drug, provided by Knowledge Data Infrastructure(KDI) content
ConcentrationStrengthvarchar(300)NULL The numeric strength concentration value
ConcentrationStrengthUnitvarchar(300)NULL The units of the concentration strength
ConcentrationVolumevarchar(300)NULL The numeric volume concentration value
ConcentrationVolumeUnitvarchar(300)NULL The units of the concentration volume
PriorAuthCodevarchar(35)NULL Prior authorization code from Pharmacy Benefit Management(PBM)/Payer.
LastCngDTimedatetimeNULL Last change UTC date time for prescription.

Return to Table-Index

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