Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
MrcMedInfoClassificationOid | bigint | NOT NULL | Medication classification id(Primary key) |
MrcMedicationOid | bigint | NOT NULL | Foreign Key(FK) to MrcMedication table |
SpecifiedOrder | smallint | NOT NULL | Indicating classification Ordinal |
Source | varchar(10) | NOT NULL | Classification source(Allowable values: FDB, AHFS, ATC) |
DrugClassificationId | varchar(12) | NOT NULL | The drug classification id as defined by the source vocabulary(FDB and AHFS have different schemes) |
DrugClassificationDesc | varchar(300) | NOT NULL | The drug classification description |
LastCngDTime | datetime | NULL | Last change date time(UTC date time) for prescription. |
|