Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
MrcMedicationOid | bigint | NOT NULL | Primary key |
MrcSectionCode | varchar(10) | NOT NULL | Foreign key reference to MrcMedSection |
MrcMedicationType | varchar(5) | NOT NULL | Defines the Medication type. Allowable value: MED(STRUCTURED MED ), TXT(FREETEXT), SFT(STRUCTURED_FREETEXT) |
OrderIdForClinicalChecking | int | NULL | Order id assigned during clinical checking |
SentenceID | varchar(25) | NOT NULL | Unique id in context of UI process |
RoutedMedScui | varchar(32) | NULL | Concept unique identifier(cui) for routed med |
StrengthScui | varchar(32) | NULL | Concept unique identifier(cui) of strength |
DoseFormScui | varchar(32) | NULL | Concept unique identifier(cui) of dose form |
Drug | varchar(800) | NOT NULL | Generic name if structured med, otherwise free text med name |
BrandNameScui | varchar(32) | NULL | Concept unique identifier(cui) of brand name |
BrandName | varchar(300) | NULL | Brand Name of medication |
Strength | varchar(300) | NULL | Drug strength |
DrugDoseForm | varchar(300) | NULL | Dose form |
DrugDose | varchar(300) | NULL | Administrative Dose |
DoseUnitScui | varchar(32) | NULL | Administrative Dose Unit Concept unique identifier(cui) |
DoseUnit | varchar(300) | NULL | Administrative Dose unit description |
DoseValue | varchar(300) | NULL | Administrative Dose unit |
Route | varchar(300) | NULL | Medication route |
RouteScui | varchar(32) | NULL | Route Concept unique identifier(cui) |
Frequency | varchar(300) | NULL | Frequency of medication |
FrequencyScui | varchar(32) | NULL | Concept unique identifier(cui) for frequency |
MedNameIdInFdb | varchar(32) | NULL | Medication Name Id |
Duration | varchar(300) | NULL | Duration of medication |
PrnScui | varchar(32) | NULL | Concept unique identifier(cui) for PRN(as needed) |
Timing | varchar(300) | NULL | Timing of medication |
TimingScui | varchar(32) | NULL | Concept unique identifier(cui) for timing |
PRN | varchar(5) | NULL | Indicates if the medication is PRN(Pro re nata - as the circumstance arises, as needed) |
PRNReason | varchar(300) | NULL | Reason for taking as needed |
PRNReasonScui | varchar(32) | NULL | Concept unique identifier(cui) for Reason for taking as needed |
Priority | varchar(300) | NULL | Priority of medication |
PriorityScui | varchar(32) | NULL | Concept unique identifier(cui) for priority |
HomeMedStatus | varchar(300) | NULL | Home Medication Status |
HomeMedStatusScui | varchar(32) | NULL | Concept unique identifier(cui) for Home Med Status |
DAW | tinyint | NULL | Dispense as written |
DAWScui | varchar(32) | NULL | Concept unique identifier(cui) for Dispense as written |
ExtendedInstructions | varchar(1000) | NULL | Extended instructions |
MedDescription | varchar(max) | Null | Description of medication in text format |
MedDescriptionInHtml | varchar(max) | Null | Description of medication in html format |
HeldReason | varchar(300) | NULL | Held reason |
HeldByStaffName | varchar(187) | Null | Name of staff who held the medication |
HoldInstructions | varchar(300) | NULL | Hold instruction |
StopReason | varchar(300) | NULL | Stopped reason |
SupervisorStaffName | varchar(187) | Null | Supervisor name |
SupervisorStaffOid | int | Null | Supervisor identification, references to HStaff table's Object ID |
EnteredByStaffName | varchar(187) | Null | Entered by staff name |
EnteredByStaffOid | int | Null | Entered by staff identification number, references to HStaff table's Object ID |
DeaCode | char(1) | NULL | Drug Enforcement Administration(DEA) code( allowable values: 1,2,3,4,5,6(FDB specific)) |
DeaStateQualifier | varchar(2) | NULL | Drug Enforcement Administration(DEA) state qualifier |
MedMatchingStatus | varchar(16) | NULL | Medications matching status with home medication(Allowable Action State: NotContinued, Continued, PartialMatch, ContinuedPartial, NewMed ) |
PatientMatchStatus | varchar(8) | NULL | Patient Matching status values(Allowable Action State: NoMatch, HasMatch) |
XMLDocStorageOid | int | NULL | Foreign key to XMLDocStorage table |
ERenewResponseOID | bigint | NULL | Foreign key to the NcpdpOutboundMessage table(formerly known as the ERenewResponse table) |
MedStatus | varchar(300) | NULL | Patient Med List Medication Status( Allowable status: Active, discontinue ) |
MedStatusReason | varchar(300) | NULL | Patient Med Status reason(example: not compliant, not tolerated ) |
FreeTextDirections | varchar(1000) | NULL | Partially structured free text directions to patient for medication |
FreeTextRxType | varchar(300) | NULL | Partially structured free text prescription type |
FreeTextControlledSubstance | varchar(300) | NULL | Partially structured free text controlled substance indicator |
MaxDailyDose | varchar(300) | NULL | The maximum dosage the patient should take on any given day |
AdminDoseUcumCode | varchar(255) | NULL | The Unified Code for Unit of Measure for the Administration dose. |
PrescribeDose | varchar(300) | NULL | The full text of the prescribing dose |
PrescribeDoseValue | varchar(300) | NULL | The numeric portion of the prescribing dose |
PrescribeDoseUnit | varchar(300) | NULL | The unit of the prescribing dose |
PrescribeDoseUnitScui | varchar(32) | NULL | Soarian Concept unique identifier(Scui) for unit of the prescribing dose unit |
PrescribeDoseUcumCode | varchar(255) | NULL | The Unified Code for Unit of Measure for the Prescribing dose |
MedRouteDescription | varchar(255) | NULL | The route associated with the Formulation ID Sequence Number(GcnSeqNo), provided by Knowledge Data Infrastructure(KDI) content |
DrugFormType | varchar(10) | NULL | The physical form of the drug, provided by Knowledge Data Infrastructure(KDI) content |
ConcentrationStrength | varchar(300) | NULL | The numeric strength concentration value |
ConcentrationStrengthUnit | varchar(300) | NULL | The units of the concentration strength |
ConcentrationVolume | varchar(300) | NULL | The numeric volume concentration value |
ConcentrationVolumeUnit | varchar(300) | NULL | The units of the concentration volume |
PriorAuthCode | varchar(35) | NULL | Prior authorization code from Pharmacy Benefit Management(PBM)/Payer. |
LastCngDTime | datetime | NULL | Last change UTC date time for prescription. |
|