Tables [dbo].[Medication]
Medication details
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Medication_ID: IDCluster Key CIX_Medication_ID_ArchiveState: ID\ArchiveStateIndexes nix_Medication_RecordedDTTMID[dbo].[uniqueid]9NOT NULLKey to the Medication table.
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_ItemID_RecordedDTTM_Samples_INC_MedicationStatusDE, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(6)Foreign Keys FK_Medication_ItemID_Item_Medication_ID: [dbo].[Item_Medication].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem ID of the Medication. Link to Item_Medication.ID
NoteActivityID[dbo].[uniqueid]9NOT NULLNote Activity ID of the audit note.
Unused_Med_Pointernumeric(8,0)5NOT NULL((0))Unused Medication Pointer
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_ExpectedActionDE_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_ItemID_RecordedDTTM_Samples_INC_MedicationStatusDE, NIX_Medication_MedicationStatusDE_Disposition_UserSaveAction_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, xPrescriptionNumber, xPrescriptionNumber#NEW#, nix_Medication_RecordedDTTM(8)Foreign Keys FK_Medication_Order_Status_DE: [dbo].[Order_Status_DE].MedicationStatusDEMedicationStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Order_Status_DE.ID
FormOfMedicationDE[dbo].[dict_id]5NOT NULLForm of Medication. Link to Form_of_Medication_DE.ID
Foreign Keys FK_Medication_FreqUnitsDE_Frequency_Units_DE_ID: [dbo].[Frequency_Units_DE].FreqUnitsDEFreqUnitsDE[dbo].[dict_id]5NOT NULL((0))Frequency of medication to be applied / consumed/followed. Link to Frequency_Units_DE.ID
Dosevarchar(10)10NOT NULL(' ')Dosage of Medication
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsRefillsmallint2NOT NULL((0))Number of refills
Foreign Keys FK_Medication_RoutOfAdministrationDE_Route_Of_Admin_DE_ID: [dbo].[Route_Of_Admin_DE].RoutOfAdministrationDERoutOfAdministrationDE[dbo].[dict_id]5NOT NULLRoute of Administration. Link to Route_Of_Admin_DE.ID
Foreign Keys FK_Medication_PRNDE_PRN_DE_ID: [dbo].[PRN_DE].PRNDEPRNDE[dbo].[dict_id]5NOT NULLAs Needed reason. Link to PRN_DE.ID
PRNvarchar(25)25NOT NULL(' ')As Needed reason
Check Constraints CK_Medication_PRNFLAG : ([PRNFLAG]='Y' OR [PRNFLAG]='N')PRNFLAG[dbo].[BOOL]1NOT NULLAs Needed flag (Y/N)
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsQuantityToDispensevarchar(20)20NULL allowed(' ')Quantity to Dispense
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_ExpectedActionDE_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_MedicationStatusDE_Disposition_UserSaveAction_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM(5)Check Constraints CK_Medication_Disposition : ([Disposition]='ReqA' OR [Disposition]='DocA' OR [Disposition]='None' OR [Disposition]='Rx' OR [Disposition]='Rpt')Dispositionchar(4)4NOT NULLDisposition of the medication.
DaysToTakesmallint2NOT NULL((0))Days to take
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsInstructionsvarchar(255)255NOT NULL(' ')Instruction for the medication
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsCheck Constraints CK_Medication_DAWFLAG : ([DAWFLAG]='Y' OR [DAWFLAG]='N')DAWFLAG[dbo].[BOOL]1NOT NULLDispensed only as written (Y/N)
Check Constraints CK_Medication_WarningAcknowledgeFLAG : ([WarningAcknowledgeFLAG]='Y' OR [WarningAcknowledgeFLAG]='N')WarningAcknowledgeFLAG[dbo].[BOOL]1NOT NULLWarning was acknowledged
WhoForID[dbo].[uniqueid]9NOT NULLOrdering provider when the work flow is done by the Nurse
AdministeredByID[dbo].[uniqueid]9NOT NULLUser who administered. Link to Person.ID
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_ItemID_RecordedDTTM_Samples_INC_MedicationStatusDE, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns(4)PrescribedByID[dbo].[uniqueid]9NOT NULLProscriber. Link to Provider.ID
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(3)ReasonForCreateTypechar(1)1NOT NULLReason for Create Type
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(2)Foreign Keys FK_Medication_PharmacyDE_Pharmacy_DE_ID: [dbo].[Pharmacy_DE].PharmacyDEPharmacyDE[dbo].[dict_id]5NOT NULLPharmacy. link to Pharmacy_DE.ID
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(4)WhoDidItID[dbo].[uniqueid]9NOT NULLCurrent Logged in User. Link to IDX_User.ID
PerformedFuzzyWhenvarchar(50)50NOT NULLPerformed date as entered
Indexes NIX_Medication_ExpectedActionDE_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns(2)PerformedFuzzySortAsdatetime8NULL allowedPerformed date
Check Constraints CK_Medication_PerformedFuzzySpecificity : ([PerformedFuzzySpecificity]='M' OR [PerformedFuzzySpecificity]='D' OR [PerformedFuzzySpecificity]='Y' OR [PerformedFuzzySpecificity]='F')PerformedFuzzySpecificitychar(1)1NOT NULLPerformed date specificity.  D - Day, Y - Year , M - Month , T - Date Time , F - Text
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_ItemID_RecordedDTTM_Samples_INC_MedicationStatusDE, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, xPrescriptionNumber, xPrescriptionNumber#NEW#, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM(7)RecordedDTTMdatetime8NOT NULLMedication Recorded Date Time
HistoryFuzzyDatevarchar(50)50NOT NULLPrevious Medication Date
NDCchar(12)12NOT NULL(' ')NDC Code of Medication
ScreenableFlagchar(1)1NOT NULLScreenable Flag
StartFuzzyWhenvarchar(50)50NOT NULLMedication Start Date as entered
StartFuzzySortAsdatetime8NULL allowedMedication Start Date
Check Constraints CK_Medication_StartFuzzySpecificity : ([StartFuzzySpecificity]='M' OR [StartFuzzySpecificity]='D' OR [StartFuzzySpecificity]='Y' OR [StartFuzzySpecificity]='F')StartFuzzySpecificitychar(1)1NOT NULL('F')Medication Start Date specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text
EndFuzzyWhenvarchar(50)50NOT NULLMedication End Date as entered
Indexes NIX_Medication_MedicationStatusDE_Disposition_UserSaveAction_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns(2)EndFuzzySortAsdatetime8NULL allowedMedication End Date
Check Constraints CK_Medication_EndFuzzySpecificity : ([EndFuzzySpecificity]='M' OR [EndFuzzySpecificity]='D' OR [EndFuzzySpecificity]='Y' OR [EndFuzzySpecificity]='F')EndFuzzySpecificitychar(1)1NOT NULL('F')Medication End Date specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text
Check Constraints CK_Medication_FreeTextSIGFLAG : ([FreeTextSIGFLAG]='Y' OR [FreeTextSIGFLAG]='N')FreeTextSIGFLAG[dbo].[BOOL]1NOT NULLFree text SIG Flag
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsFreeTextSIGvarchar(1000)1000NOT NULLFree text SIG
DateToAdministerdatetime8NULL allowedDate to Administer
AdministrationCommentvarchar(255)255NOT NULLAdministration Comment
AdministrationRequestedByID[dbo].[uniqueid]9NOT NULLAdministration Requested by user. Link to IDX_User.ID
AdministrationBodySiteDE[dbo].[dict_id]5NOT NULLAdministered Body Site. Link to Body_Site_DE.ID
Indexes xPrescriptionNumber, xPrescriptionNumber#NEW#, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(5)PrescriptionNumbervarchar(20)20NULL allowedPrescription Number
DueDatedatetime8NULL allowed(NULL)Due date for Medication
ICD9Code[dbo].[code]10NOT NULL('')ICD9 Code for medication
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsExpirationDTdatetime8NULL allowedExpiration Date if any
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsDaysSupplysmallint2NOT NULL((0))Days Supply
Indexes nix_Medication_SourceScriptMsgID, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(2)Check Constraints CK_Medication_TransmissionStatus : ([TransmissionStatus]='e-Rx Sent' OR [TransmissionStatus]='e-Rx Rec''d' OR [TransmissionStatus]='e-Rx Failed' OR [TransmissionStatus]='Verified' OR [TransmissionStatus]='Error' OR [TransmissionStatus]='Autofaxed' OR [TransmissionStatus]='' OR [TransmissionStatus]='DigSigFail' OR [TransmissionStatus]='DigSigPend' OR [TransmissionStatus]='eRxMsgFail' OR [TransmissionStatus]='eRxMsgPub' OR [TransmissionStatus]='TrnPhmFail' OR [TransmissionStatus]='TrnPhmVeri' OR [TransmissionStatus]='DigSigCrt')TransmissionStatusvarchar(12)12NOT NULL('')Transmission Status of Medication to Pharmacy
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM(4)PrescribeActionDE[dbo].[dict_id]5NOT NULL((0))Prescribe Action. Link to PrescribeAction_DE.ID
PriorMedDE[dbo].[dict_id]5NOT NULL((0))Prior Medication. Link to Medication_DE.ID
Indexes NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumnsReasonForFormularyOverridevarchar(100)100NULL allowed('')Reasons for Formulary Override
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(5)Foreign Keys FK_Medication_MedDictDE_Medication_DE_ID: [dbo].[Medication_DE].MedDictDEMedDictDE[dbo].[dict_id]5NOT NULL((0))Medication. Link to Medication_DE.ID
FreeTextPrescribervarchar(150)150NOT NULL('')Free text of Prescriber
ProblemLinkListvarchar(500)500NOT NULL('')Linked Problem List. List of Problem_Header.ID
AuthorizedByID[dbo].[uniqueid]9NULL allowedMedication Authorized by. Link to Provider.ID
ALLSCRIP_SIG_CDchar(15)15NULL allowed('')Allscripts SIG ID
PKG_TXTvarchar(96)96NULL allowed('')Package Text
PKG_QTYint4NULL allowed((0))Package Quantity
PKG_SZfloat8NULL allowed((0))Package Size
PKG_SZ_UMchar(2)2NULL allowed('')Package Size Unit of Measure
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns, NIX_Medication_ReasonForCreateType_PrescriptionNumber_RecordedDTTM_WithIncludeColumns, nix_Medication_RecordedDTTM, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(5)Foreign Keys FK_Medication_SiteDE: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULL((0))Site. Link to Site_DE.ID
Indexes NIX_Medication_ItemID_RecordedDTTM_Samples_INC_MedicationStatusDEForeign Keys FK_Medication_SupervisedByID: [dbo].[Provider].SupervisedByIDSupervisedByID[dbo].[uniqueid]9NOT NULL((0))Supervised by. Link to Provider.ID.
UseMedAuthTaskingchar(1)1NOT NULL('Y')MedAuthTasking Flag
AdministrationLotvarchar(20)20NULL allowed('')Administration Lot
Foreign Keys FK_Medication_VaccineManufacturerDE: [dbo].[Vaccine_Manufacturer_DE].VaccineManufacturerDEVaccineManufacturerDE[dbo].[dict_id]5NOT NULL((0))Vaccine Manufacturer. Link to Vaccine_Manufacturer_DE.ID
Foreign Keys FK_Medication_AdministrationRouteDE: [dbo].[Route_Of_Admin_DE].AdministrationRouteDEAdministrationRouteDE[dbo].[dict_id]5NOT NULL((0))Administration Route. Link to Route_Of_Admin_DE.ID
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns(2)Foreign Keys FK_Medication_BrandMedDictDE: [dbo].[Medication_DE].BrandMedDictDEBrandMedDictDE[dbo].[dict_id]5NOT NULL((0))Brand Medication. Link to Medication_DE.ID.
AdministrationDosevarchar(10)10NOT NULL('')Administration Dose
Creation_Typechar(1)1NOT NULL('')Creation Type.
Check Constraints CK_Medication_UseNonFormAuthTasking : ([UseNonFormAuthTasking]='Y' OR [UseNonFormAuthTasking]='N')UseNonFormAuthTasking[dbo].[BOOL]1NOT NULL('N')Use Non Formulary Authorization Tasking Flag
AdminStopDatedatetime8NULL allowedAdministration End Date
AdminSchedDaysvarchar(13)13NULL allowedAdministration Scheduled Days
AdminSchedIntervalsvarchar(11)11NULL allowedAdministration Scheduled Intervals
KOPFlagchar(1)1NULL allowedKeep on Person Flag
Indexes NIX_Medication_ExpectedActionDE_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_MedicationStatusDE_Disposition_UserSaveAction_ExpectedActionDTTM_WithIncludeColumns(2)UserSaveActionvarchar(15)15NULL allowedUser Save Action. Ex: Renew / Continue / Re Print Etc
Indexes nix_Medication_SourceScriptMsgID, NIX_Medication_TransmissionStatus_SourceScriptMsgID_ReasonForCreateType_WithIncludeColumns(2)SourceScriptMsgIDint4NULL allowed((0))Source Script Message ID if any. Link to SCRIPT_MESSAGE.SCRIPT_MSG_ID.
Commentsvarchar(255)255NULL allowedComments
ResponseMsgTypechar(3)3NULL allowedResponse Message Type
ResponseFreeTextvarchar(70)70NULL allowedResponse Message Free Text
ResponseMsgCodechar(3)3NULL allowedResponse Message Code
Indexes NIX_Medication_ExpectedActionDE_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_MedicationStatusDE_Disposition_UserSaveAction_ExpectedActionDTTM_WithIncludeColumns(2)ExpectedActionDE[dbo].[dict_id]5NOT NULL((0))Expected Action. Link to Expected_Action_DE.ID
Indexes NIX_Medication_ExpectedActionDE_ExpectedActionDTTM_WithIncludeColumns, NIX_Medication_MedicationStatusDE_Disposition_UserSaveAction_ExpectedActionDTTM_WithIncludeColumns(2)ExpectedActionDTTMdatetime8NULL allowedExpected Action Date and Time
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumnsCheck Constraints CK_Medication_IsUnverifiedFLAG : ([IsUnverifiedFLAG]='Y' OR [IsUnverifiedFLAG]='N')IsUnverifiedFLAG[dbo].[BOOL]1NULL allowedIs Medication is Unverified
VerificationTaskOwnerID[dbo].[uniqueid]9NULL allowedVerification Task Owner ID. Link to IDX_User.ID or Team_DE.ID
VerificationTaskOwnerTypechar(10)10NULL allowedVerification Task owner Type
FormuIDint4NULL allowedFormulary ID of the Medication.
FormularyAlternativeLevelsmallint2NULL allowedFormulary Alternative Level
FormularyAlternativeSettingsmallint2NULL allowedFormulary Alternative Setting
Indexes NIX_Medication_ItemID_RecordedDTTM_Samples_INC_MedicationStatusDECheck Constraints CK_Medication_Samples : ([Samples]='Y' OR [Samples]='N')Samples[dbo].[BOOL]1NULL allowedSamples provided (Y/N)
SampleQuantityfloat8NULL allowedSample Quantity
SampleQuantityUnitsvarchar(96)96NULL allowedSample Quantity Units
Foreign Keys FK_Medication_SampleManufacturerCode: [dbo].[Vaccine_Manufacturer_DE].SampleManufacturerCodeSampleManufacturerCode[dbo].[dict_id]5NOT NULL((0))Sample Manufacturer. Link to Vaccine_Manufacturer_DE.ID
SampleLotvarchar(20)20NULL allowedSample LOT
SampleDTTMdatetime8NULL allowedSample Date and time
Check Constraints CK_Medication_SampleAdminister : ([SampleAdminister]='Y' OR [SampleAdminister]='N')SampleAdminister[dbo].[BOOL]1NULL allowedSample Administered (Y/N)
DateToAdministerFuzzyWhenvarchar(50)50NULL allowedDate to Administer
DateToAdministerFuzzySpecificitychar(1)1NULL allowedDate to Administer Specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text
Indexes NIX_Medication_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Medication_PrescribedByID_RecordedDTTM_WithIncludeColumns(2)PBMDE[dbo].[dict_id]5NOT NULL((0))PBM (Pharmacy Benefit Manager). Link to PBM_DE.ID
SplitRxParentItemID[dbo].[uniqueid]9NOT NULL((0))Parent Item ID of Split Rx
AdministrationDoseQtyfloat8NOT NULL((0))Administration Dosage Quantity
ProcessingTypechar(1)1NULL allowedProcessing Type
TSRX_ID[dbo].[uniqueid]9NULL allowed(NULL)TSRX ID.
Check Constraints CK_Medication_PARChecked : ([PARChecked]='Y' OR [PARChecked]='N')PARChecked[dbo].[BOOL]1NOT NULL('N')Is PAR (Prior Adverse Reaction) Checked
Check Constraints CK_Medication_DrugDoseChecked : ([DrugDoseChecked]='Y' OR [DrugDoseChecked]='N')DrugDoseChecked[dbo].[BOOL]1NOT NULL('N')Is Drug Dose Checked
Check Constraints CK_Medication_DrugDrugChecked : ([DrugDrugChecked]='Y' OR [DrugDrugChecked]='N')DrugDrugChecked[dbo].[BOOL]1NOT NULL('N')Is Drug Drug Checked
Check Constraints CK_Medication_DuplicateTherapyChecked : ([DuplicateTherapyChecked]='Y' OR [DuplicateTherapyChecked]='N')DuplicateTherapyChecked[dbo].[BOOL]1NOT NULL('N')Is Duplicate Therapy Checked
Check Constraints CK_Medication_DrugHealthStateChecked : ([DrugHealthStateChecked]='Y' OR [DrugHealthStateChecked]='N')DrugHealthStateChecked[dbo].[BOOL]1NOT NULL('N')Is Drug Health State Checked
VerifiedDTTMdatetime8NOT NULL('1900/01/01')Verified Date and Time
DoNotFillBeforeDatedatetime8NULL allowedDo Not Fill Before Date
IsControlledSubstancePrint[dbo].[BOOL]1NOT NULL('N')Flag indicating Control Substance Printable
ControlSubstanceCodevarchar(2)2NOT NULL('NA')Control Substance Code
ControlSubstanceCodeReasonvarchar(500)500NOT NULL('')Control Substance Code Reason
EPCSTransactionFLAG[dbo].[BOOL]1NOT NULL('N')EPCS (electrocin prescribing of controlled substance)Transaction Flag
ProcessPA[dbo].[BOOL]1NOT NULL('N')Process PA (Prior Authorization) (Y/N)
ePaAuthorizationNovarchar(50)50NULL allowedAuthorization Number of ePa (electronic Prior Authorization)
VisuallyVerifiedByID[dbo].[uniqueid]9NOT NULL((0))provider who verified admin. Link to Provider.ID
PriorAuthorizationTypechar(1)1NOT NULL('')Prior Authorization Type (R - Retrospective ePA, '' - Prospective ePA).
Cluster Key CIX_Medication_ID_ArchiveState: ID\ArchiveStateArchiveStatetinyint1NOT NULL((0))Archive State 0 - not archived, 1 - Archived
SpecialtyMed[dbo].[BOOL]1NOT NULL('N')Is this a specialty Medication (Y/N)?
RetainDefaultPharmacy[dbo].[BOOL]1NOT NULL('N')Always retain patient's default pharmacy?
IsMedTakingbit1NULL allowedIs the patient taking the medication?
Foreign Keys FK_Medication_MedTakingReasonDE: [dbo].[Medication_Taking_Reason_DE].MedTakingReasonDEMedTakingReasonDE[dbo].[dict_id]5NOT NULL((0))Reason the patient is taking the medication. Link to Medication_Taking_Reason_DE.ID
InventoryIDvarchar(64)64NULL allowedInventory ID for Flexscan interface
Barcodevarchar(64)64NULL allowedBarcode of inventory item for Flexscan interface