Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
NcpdpInboundMessageDrugOid | BIGINT | NOT NULL | Primary key |
NcpdpInboundMessageOID | BIGINT | NOT NULL | References to NcpdpInboundMessage table(foreign key to NcpdpInboundMessage) |
OrderInMessage | TINYINT | NOT NULL | Order of the medication in the message(1st requested med: 1, 2nd requested med: 2, etc.) |
MedRoleCode | CHAR(1) | NOT NULL | Indicates Soarian requested or dispensed medication(Allowable values: R: requested medication D: dispensed medication ) |
RepresentativeNdc | VARCHAR(11) | NULL | NDC(National Drug Code) from the inbound message |
RoutedMedScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the routed medication |
RoutedMedDescription | VARCHAR(300) | NULL | Routed medication description |
StrengthScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the med strength(part of triplet + brand) |
StrengthDescription | VARCHAR(300) | NULL | Medication Strength description |
DoseFormScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier)for the medication dose form(part of triplet + brand) |
DoseFormDescription | VARCHAR(300) | NULL | Dose Form description |
BrandNameScui | VARCHAR(32) | NULL | KDI(Knowledge Data Infrastructure) scui(concept unique identifier) for the medication brand name(part of triplet + brand). |
BrandNameDescription | VARCHAR(300) | NULL | Brand name description |
PotencyUnitDescription | VARCHAR(255) | NULL | Readable text for FMT(Federal Medication Terminologies) Code |
SigMatchMrcMedicationSlots | VARCHAR(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 |
SigDoseValue | VARCHAR(300) | NULL | Administrative Dose description. This column will be valued when SigMatchesMrcMedicationSlots is valued as All |
SigDoseUnit | VARCHAR(300) | NULL | Administrative Dose unit description. This column will be valued when SigMatchesMrcMedicationSlots is valued as All |