Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
MrcMedInfo This table stores FDB (First Data Bank) medication identifier information for medications stored as xml documents in XmlDocStorage and NcpdpOutboundMessage.
Column Name Column Datatype Column Null Option Column Comment
MrcMedicationOidbigintNOT NULL Primary key and Foreign key to Medication table
ScdInRxNormScuivarchar(32)NULL RxNorm Semantic Clinical Drug(SCD)
ScdDescriptionvarchar(300)NULL RxNorm Semantic Clinical Drug(SCD) Description
SbdInRxNormScuivarchar(32)NULL RxNorm Semantic Branded Drug(SBD)
SbdDescriptionvarchar(300)NULL RxNorm Semantic Branded Drug(SBD) Description
GpckInRxNormScuivarchar(32)NULL RxNorm Generic Package(GPCK)
GpckDescriptionvarchar(300)NULL RxNorm Generic Package(GPCK) Description
BpckInRxNormScuivarchar(32)NULL RxNorm Branded Package(BPCK)
BpckDescriptionvarchar(300)NULL RxNorm Branded Package(BPCK) Description
GcnSeqNoInFdbvarchar(32)NULL First DataBank Clinical Formulation ID Sequence Number
GcnSeqNoInFdbDescriptionvarchar(300)NULL First DataBank Clinical Formulation Description
MedIdInFdbvarchar(32)NULL First DataBank medication identification number
MedIdInFdbDescriptionvarchar(300)NULL First DataBank drug name
RouteInNcivarchar(32)NULL Route code in NCI(National Cancer Institute)
RouteInNciDescriptionvarchar(300)NULL Route Description in NCI(National Cancer Institute)
RepresentiveNDCvarchar(11)NULL Representative national drug code(NDC)
ProductTypevarchar(10)NULL Indicates Product type( BrandRx, BrandOtc, GenericRx, GenericOtc )
DeaFmtCodevarchar(32)NULL DEA NCPDP FMT code(Drug Enforcement Administration NCPDP Federal Medication Terminologies Code)
DeaFmtCodeDescriptionvarchar(255)NULL DEA NCPDP FMT code description(Drug Enforcement Administration NCPDP Federal Medication Terminologies Description)
IsSecondaryDeaCodeRequiredtinyintNULL Indicates if Secondary DEA code Required or not(0- no secondary DEA code required; 1- secondary DEA code is required)
LastCngDTimedatetimeNULL Last change date time(UTC date time) for prescription.

Return to Table-Index

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