Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
NcpdpInboundMessageDrug This table stores information about the medications being requested by pharmacies in electronic prescription (eRx) request messages
Column Name Column Datatype Column Null Option Column Comment
NcpdpInboundMessageDrugOidBIGINTNOT NULL Primary key
NcpdpInboundMessageOIDBIGINTNOT NULL References to NcpdpInboundMessage table(foreign key to NcpdpInboundMessage)
OrderInMessageTINYINTNOT NULL Order of the medication in the message(1st requested med: 1, 2nd requested med: 2, etc.)
MedRoleCodeCHAR(1)NOT NULL Indicates Soarian requested or dispensed medication(Allowable values: R: requested medication D: dispensed medication )
RepresentativeNdcVARCHAR(11)NULL NDC(National Drug Code) from the inbound message
RoutedMedScuiVARCHAR(32)NULL KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the routed medication
RoutedMedDescriptionVARCHAR(300)NULL Routed medication description
StrengthScuiVARCHAR(32)NULL KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the med strength(part of triplet + brand)
StrengthDescriptionVARCHAR(300)NULL Medication Strength description
DoseFormScuiVARCHAR(32)NULL KDI(Knowledge Data Infrastructure) scui(concept unique identifier)for the medication dose form(part of triplet + brand)
DoseFormDescriptionVARCHAR(300)NULL Dose Form description
BrandNameScuiVARCHAR(32)NULL KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the medication brand name(part of triplet + brand).
BrandNameDescriptionVARCHAR(300)NULL Brand name description
PotencyUnitDescriptionVARCHAR(255)NULL Readable text for FMT(Federal Medication Terminologies) Code
SigMatchMrcMedicationSlotsVARCHAR(20)NULL Contains matching information of medication standardized dosing designations with MrcMedication table
None: no SIG slots from message identified in MrcMedication table for existing medication
All: SIG value matches
AllExceptDose: all SIG components match except Administrative dose value and Unit
SigDoseValueVARCHAR(300)NULL Administrative Dose description. This column will be valued when SigMatchesMrcMedicationSlots is valued as All
SigDoseUnitVARCHAR(300)NULL Administrative Dose unit description. This column will be valued when SigMatchesMrcMedicationSlots is valued as All

Return to Table-Index

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