Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
MrcMedicationOid | bigint | NOT NULL | Primary key and Foreign key to Medication table |
ScdInRxNormScui | varchar(32) | NULL | RxNorm Semantic Clinical Drug(SCD) |
ScdDescription | varchar(300) | NULL | RxNorm Semantic Clinical Drug(SCD) Description |
SbdInRxNormScui | varchar(32) | NULL | RxNorm Semantic Branded Drug(SBD) |
SbdDescription | varchar(300) | NULL | RxNorm Semantic Branded Drug(SBD) Description |
GpckInRxNormScui | varchar(32) | NULL | RxNorm Generic Package(GPCK) |
GpckDescription | varchar(300) | NULL | RxNorm Generic Package(GPCK) Description |
BpckInRxNormScui | varchar(32) | NULL | RxNorm Branded Package(BPCK) |
BpckDescription | varchar(300) | NULL | RxNorm Branded Package(BPCK) Description |
GcnSeqNoInFdb | varchar(32) | NULL | First DataBank Clinical Formulation ID Sequence Number |
GcnSeqNoInFdbDescription | varchar(300) | NULL | First DataBank Clinical Formulation Description |
MedIdInFdb | varchar(32) | NULL | First DataBank medication identification number |
MedIdInFdbDescription | varchar(300) | NULL | First DataBank drug name |
RouteInNci | varchar(32) | NULL | Route code in NCI(National Cancer Institute) |
RouteInNciDescription | varchar(300) | NULL | Route Description in NCI(National Cancer Institute) |
RepresentiveNDC | varchar(11) | NULL | Representative national drug code(NDC) |
ProductType | varchar(10) | NULL | Indicates Product type( BrandRx, BrandOtc, GenericRx, GenericOtc ) |
DeaFmtCode | varchar(32) | NULL | DEA NCPDP FMT code(Drug Enforcement Administration NCPDP Federal Medication Terminologies Code) |
DeaFmtCodeDescription | varchar(255) | NULL | DEA NCPDP FMT code description(Drug Enforcement Administration NCPDP Federal Medication Terminologies Description) |
IsSecondaryDeaCodeRequired | tinyint | NULL | Indicates if Secondary DEA code Required or not(0- no secondary DEA code required; 1- secondary DEA code is required) |
LastCngDTime | datetime | NULL | Last change date time(UTC date time) for prescription. |