Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
   | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Medication table. |
(6)![Foreign Keys FK_Medication_ItemID_Item_Medication_ID: [dbo].[Item_Medication].ItemID Foreign Keys FK_Medication_ItemID_Item_Medication_ID: [dbo].[Item_Medication].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Item ID of the Medication. Link to Item_Medication.ID |
| NoteActivityID | [dbo].[uniqueid] | 9 | NOT NULL | | Note Activity ID of the audit note. |
| Unused_Med_Pointer | numeric(8,0) | 5 | NOT NULL | ((0)) | Unused Medication Pointer |
(8)![Foreign Keys FK_Medication_Order_Status_DE: [dbo].[Order_Status_DE].MedicationStatusDE Foreign Keys FK_Medication_Order_Status_DE: [dbo].[Order_Status_DE].MedicationStatusDE](../../../../Images/fk.png) | MedicationStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Status. Link to Order_Status_DE.ID |
| FormOfMedicationDE | [dbo].[dict_id] | 5 | NOT NULL | | Form of Medication. Link to Form_of_Medication_DE.ID |
![Foreign Keys FK_Medication_FreqUnitsDE_Frequency_Units_DE_ID: [dbo].[Frequency_Units_DE].FreqUnitsDE Foreign Keys FK_Medication_FreqUnitsDE_Frequency_Units_DE_ID: [dbo].[Frequency_Units_DE].FreqUnitsDE](../../../../Images/fk.png) | FreqUnitsDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Frequency of medication to be applied / consumed/followed. Link to Frequency_Units_DE.ID |
| Dose | varchar(10) | 10 | NOT NULL | (' ') | Dosage of Medication |
 | Refill | smallint | 2 | NOT NULL | ((0)) | Number of refills |
![Foreign Keys FK_Medication_RoutOfAdministrationDE_Route_Of_Admin_DE_ID: [dbo].[Route_Of_Admin_DE].RoutOfAdministrationDE Foreign Keys FK_Medication_RoutOfAdministrationDE_Route_Of_Admin_DE_ID: [dbo].[Route_Of_Admin_DE].RoutOfAdministrationDE](../../../../Images/fk.png) | RoutOfAdministrationDE | [dbo].[dict_id] | 5 | NOT NULL | | Route of Administration. Link to Route_Of_Admin_DE.ID |
![Foreign Keys FK_Medication_PRNDE_PRN_DE_ID: [dbo].[PRN_DE].PRNDE Foreign Keys FK_Medication_PRNDE_PRN_DE_ID: [dbo].[PRN_DE].PRNDE](../../../../Images/fk.png) | PRNDE | [dbo].[dict_id] | 5 | NOT NULL | | As Needed reason. Link to PRN_DE.ID |
| PRN | varchar(25) | 25 | NOT NULL | (' ') | As Needed reason |
![Check Constraints CK_Medication_PRNFLAG : ([PRNFLAG]='Y' OR [PRNFLAG]='N') Check Constraints CK_Medication_PRNFLAG : ([PRNFLAG]='Y' OR [PRNFLAG]='N')](../../../../Images/c-constraint.png) | PRNFLAG | [dbo].[BOOL] | 1 | NOT NULL | | As Needed flag (Y/N) |
 | QuantityToDispense | varchar(20) | 20 | NULL allowed | (' ') | Quantity to Dispense |
(5)![Check Constraints CK_Medication_Disposition : ([Disposition]='ReqA' OR [Disposition]='DocA' OR [Disposition]='None' OR [Disposition]='Rx' OR [Disposition]='Rpt') Check Constraints CK_Medication_Disposition : ([Disposition]='ReqA' OR [Disposition]='DocA' OR [Disposition]='None' OR [Disposition]='Rx' OR [Disposition]='Rpt')](../../../../Images/c-constraint.png) | Disposition | char(4) | 4 | NOT NULL | | Disposition of the medication. |
| DaysToTake | smallint | 2 | NOT NULL | ((0)) | Days to take |
 | Instructions | varchar(255) | 255 | NOT NULL | (' ') | Instruction for the medication |
 ![Check Constraints CK_Medication_DAWFLAG : ([DAWFLAG]='Y' OR [DAWFLAG]='N') Check Constraints CK_Medication_DAWFLAG : ([DAWFLAG]='Y' OR [DAWFLAG]='N')](../../../../Images/c-constraint.png) | DAWFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Dispensed only as written (Y/N) |
![Check Constraints CK_Medication_WarningAcknowledgeFLAG : ([WarningAcknowledgeFLAG]='Y' OR [WarningAcknowledgeFLAG]='N') Check Constraints CK_Medication_WarningAcknowledgeFLAG : ([WarningAcknowledgeFLAG]='Y' OR [WarningAcknowledgeFLAG]='N')](../../../../Images/c-constraint.png) | WarningAcknowledgeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Warning was acknowledged |
| WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Ordering provider when the work flow is done by the Nurse |
| AdministeredByID | [dbo].[uniqueid] | 9 | NOT NULL | | User who administered. Link to Person.ID |
(4) | PrescribedByID | [dbo].[uniqueid] | 9 | NOT NULL | | Proscriber. Link to Provider.ID |
(3) | ReasonForCreateType | char(1) | 1 | NOT NULL | | Reason for Create Type |
(2)![Foreign Keys FK_Medication_PharmacyDE_Pharmacy_DE_ID: [dbo].[Pharmacy_DE].PharmacyDE Foreign Keys FK_Medication_PharmacyDE_Pharmacy_DE_ID: [dbo].[Pharmacy_DE].PharmacyDE](../../../../Images/fk.png) | PharmacyDE | [dbo].[dict_id] | 5 | NOT NULL | | Pharmacy. link to Pharmacy_DE.ID |
(4) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Current Logged in User. Link to IDX_User.ID |
| PerformedFuzzyWhen | varchar(50) | 50 | NOT NULL | | Performed date as entered |
(2) | PerformedFuzzySortAs | datetime | 8 | NULL allowed | | Performed date |
![Check Constraints CK_Medication_PerformedFuzzySpecificity : ([PerformedFuzzySpecificity]='M' OR [PerformedFuzzySpecificity]='D' OR [PerformedFuzzySpecificity]='Y' OR [PerformedFuzzySpecificity]='F') Check Constraints CK_Medication_PerformedFuzzySpecificity : ([PerformedFuzzySpecificity]='M' OR [PerformedFuzzySpecificity]='D' OR [PerformedFuzzySpecificity]='Y' OR [PerformedFuzzySpecificity]='F')](../../../../Images/c-constraint.png) | PerformedFuzzySpecificity | char(1) | 1 | NOT NULL | | Performed date specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text |
(7) | RecordedDTTM | datetime | 8 | NOT NULL | | Medication Recorded Date Time |
| HistoryFuzzyDate | varchar(50) | 50 | NOT NULL | | Previous Medication Date |
| NDC | char(12) | 12 | NOT NULL | (' ') | NDC Code of Medication |
| ScreenableFlag | char(1) | 1 | NOT NULL | | Screenable Flag |
| StartFuzzyWhen | varchar(50) | 50 | NOT NULL | | Medication Start Date as entered |
| StartFuzzySortAs | datetime | 8 | NULL allowed | | Medication Start Date |
![Check Constraints CK_Medication_StartFuzzySpecificity : ([StartFuzzySpecificity]='M' OR [StartFuzzySpecificity]='D' OR [StartFuzzySpecificity]='Y' OR [StartFuzzySpecificity]='F') Check Constraints CK_Medication_StartFuzzySpecificity : ([StartFuzzySpecificity]='M' OR [StartFuzzySpecificity]='D' OR [StartFuzzySpecificity]='Y' OR [StartFuzzySpecificity]='F')](../../../../Images/c-constraint.png) | StartFuzzySpecificity | char(1) | 1 | NOT NULL | ('F') | Medication Start Date specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text |
| EndFuzzyWhen | varchar(50) | 50 | NOT NULL | | Medication End Date as entered |
(2) | EndFuzzySortAs | datetime | 8 | NULL allowed | | Medication End Date |
![Check Constraints CK_Medication_EndFuzzySpecificity : ([EndFuzzySpecificity]='M' OR [EndFuzzySpecificity]='D' OR [EndFuzzySpecificity]='Y' OR [EndFuzzySpecificity]='F') Check Constraints CK_Medication_EndFuzzySpecificity : ([EndFuzzySpecificity]='M' OR [EndFuzzySpecificity]='D' OR [EndFuzzySpecificity]='Y' OR [EndFuzzySpecificity]='F')](../../../../Images/c-constraint.png) | EndFuzzySpecificity | char(1) | 1 | NOT 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') Check Constraints CK_Medication_FreeTextSIGFLAG : ([FreeTextSIGFLAG]='Y' OR [FreeTextSIGFLAG]='N')](../../../../Images/c-constraint.png) | FreeTextSIGFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Free text SIG Flag |
 | FreeTextSIG | varchar(1000) | 1000 | NOT NULL | | Free text SIG |
| DateToAdminister | datetime | 8 | NULL allowed | | Date to Administer |
| AdministrationComment | varchar(255) | 255 | NOT NULL | | Administration Comment |
| AdministrationRequestedByID | [dbo].[uniqueid] | 9 | NOT NULL | | Administration Requested by user. Link to IDX_User.ID |
| AdministrationBodySiteDE | [dbo].[dict_id] | 5 | NOT NULL | | Administered Body Site. Link to Body_Site_DE.ID |
(5) | PrescriptionNumber | varchar(20) | 20 | NULL allowed | | Prescription Number |
| DueDate | datetime | 8 | NULL allowed | (NULL) | Due date for Medication |
| ICD9Code | [dbo].[code] | 10 | NOT NULL | ('') | ICD9 Code for medication |
 | ExpirationDT | datetime | 8 | NULL allowed | | Expiration Date if any |
 | DaysSupply | smallint | 2 | NOT NULL | ((0)) | Days Supply |
(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') 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')](../../../../Images/c-constraint.png) | TransmissionStatus | varchar(12) | 12 | NOT NULL | ('') | Transmission Status of Medication to Pharmacy |
(4) | PrescribeActionDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Prescribe Action. Link to PrescribeAction_DE.ID |
| PriorMedDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Prior Medication. Link to Medication_DE.ID |
 | ReasonForFormularyOverride | varchar(100) | 100 | NULL allowed | ('') | Reasons for Formulary Override |
(5)![Foreign Keys FK_Medication_MedDictDE_Medication_DE_ID: [dbo].[Medication_DE].MedDictDE Foreign Keys FK_Medication_MedDictDE_Medication_DE_ID: [dbo].[Medication_DE].MedDictDE](../../../../Images/fk.png) | MedDictDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Medication. Link to Medication_DE.ID |
| FreeTextPrescriber | varchar(150) | 150 | NOT NULL | ('') | Free text of Prescriber |
| ProblemLinkList | varchar(500) | 500 | NOT NULL | ('') | Linked Problem List. List of Problem_Header.ID |
| AuthorizedByID | [dbo].[uniqueid] | 9 | NULL allowed | | Medication Authorized by. Link to Provider.ID |
| ALLSCRIP_SIG_CD | char(15) | 15 | NULL allowed | ('') | Allscripts SIG ID |
| PKG_TXT | varchar(96) | 96 | NULL allowed | ('') | Package Text |
| PKG_QTY | int | 4 | NULL allowed | ((0)) | Package Quantity |
| PKG_SZ | float | 8 | NULL allowed | ((0)) | Package Size |
| PKG_SZ_UM | char(2) | 2 | NULL allowed | ('') | Package Size Unit of Measure |
(5)![Foreign Keys FK_Medication_SiteDE: [dbo].[Site_DE].SiteDE Foreign Keys FK_Medication_SiteDE: [dbo].[Site_DE].SiteDE](../../../../Images/fk.png) | SiteDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Site. Link to Site_DE.ID |
 ![Foreign Keys FK_Medication_SupervisedByID: [dbo].[Provider].SupervisedByID Foreign Keys FK_Medication_SupervisedByID: [dbo].[Provider].SupervisedByID](../../../../Images/fk.png) | SupervisedByID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Supervised by. Link to Provider.ID. |
| UseMedAuthTasking | char(1) | 1 | NOT NULL | ('Y') | MedAuthTasking Flag |
| AdministrationLot | varchar(20) | 20 | NULL allowed | ('') | Administration Lot |
![Foreign Keys FK_Medication_VaccineManufacturerDE: [dbo].[Vaccine_Manufacturer_DE].VaccineManufacturerDE Foreign Keys FK_Medication_VaccineManufacturerDE: [dbo].[Vaccine_Manufacturer_DE].VaccineManufacturerDE](../../../../Images/fk.png) | VaccineManufacturerDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Vaccine Manufacturer. Link to Vaccine_Manufacturer_DE.ID |
![Foreign Keys FK_Medication_AdministrationRouteDE: [dbo].[Route_Of_Admin_DE].AdministrationRouteDE Foreign Keys FK_Medication_AdministrationRouteDE: [dbo].[Route_Of_Admin_DE].AdministrationRouteDE](../../../../Images/fk.png) | AdministrationRouteDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Administration Route. Link to Route_Of_Admin_DE.ID |
(2)![Foreign Keys FK_Medication_BrandMedDictDE: [dbo].[Medication_DE].BrandMedDictDE Foreign Keys FK_Medication_BrandMedDictDE: [dbo].[Medication_DE].BrandMedDictDE](../../../../Images/fk.png) | BrandMedDictDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Brand Medication. Link to Medication_DE.ID. |
| AdministrationDose | varchar(10) | 10 | NOT NULL | ('') | Administration Dose |
| Creation_Type | char(1) | 1 | NOT NULL | ('') | Creation Type. |
![Check Constraints CK_Medication_UseNonFormAuthTasking : ([UseNonFormAuthTasking]='Y' OR [UseNonFormAuthTasking]='N') Check Constraints CK_Medication_UseNonFormAuthTasking : ([UseNonFormAuthTasking]='Y' OR [UseNonFormAuthTasking]='N')](../../../../Images/c-constraint.png) | UseNonFormAuthTasking | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Use Non Formulary Authorization Tasking Flag |
| AdminStopDate | datetime | 8 | NULL allowed | | Administration End Date |
| AdminSchedDays | varchar(13) | 13 | NULL allowed | | Administration Scheduled Days |
| AdminSchedIntervals | varchar(11) | 11 | NULL allowed | | Administration Scheduled Intervals |
| KOPFlag | char(1) | 1 | NULL allowed | | Keep on Person Flag |
(2) | UserSaveAction | varchar(15) | 15 | NULL allowed | | User Save Action. Ex: Renew / Continue / Re Print Etc |
(2) | SourceScriptMsgID | int | 4 | NULL allowed | ((0)) | Source Script Message ID if any. Link to SCRIPT_MESSAGE.SCRIPT_MSG_ID. |
| Comments | varchar(255) | 255 | NULL allowed | | Comments |
| ResponseMsgType | char(3) | 3 | NULL allowed | | Response Message Type |
| ResponseFreeText | varchar(70) | 70 | NULL allowed | | Response Message Free Text |
| ResponseMsgCode | char(3) | 3 | NULL allowed | | Response Message Code |
(2) | ExpectedActionDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Expected Action. Link to Expected_Action_DE.ID |
(2) | ExpectedActionDTTM | datetime | 8 | NULL allowed | | Expected Action Date and Time |
 ![Check Constraints CK_Medication_IsUnverifiedFLAG : ([IsUnverifiedFLAG]='Y' OR [IsUnverifiedFLAG]='N') Check Constraints CK_Medication_IsUnverifiedFLAG : ([IsUnverifiedFLAG]='Y' OR [IsUnverifiedFLAG]='N')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NULL allowed | | Is Medication is Unverified |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NULL allowed | | Verification Task Owner ID. Link to IDX_User.ID or Team_DE.ID |
| VerificationTaskOwnerType | char(10) | 10 | NULL allowed | | Verification Task owner Type |
| FormuID | int | 4 | NULL allowed | | Formulary ID of the Medication. |
| FormularyAlternativeLevel | smallint | 2 | NULL allowed | | Formulary Alternative Level |
| FormularyAlternativeSetting | smallint | 2 | NULL allowed | | Formulary Alternative Setting |
 ![Check Constraints CK_Medication_Samples : ([Samples]='Y' OR [Samples]='N') Check Constraints CK_Medication_Samples : ([Samples]='Y' OR [Samples]='N')](../../../../Images/c-constraint.png) | Samples | [dbo].[BOOL] | 1 | NULL allowed | | Samples provided (Y/N) |
| SampleQuantity | float | 8 | NULL allowed | | Sample Quantity |
| SampleQuantityUnits | varchar(96) | 96 | NULL allowed | | Sample Quantity Units |
![Foreign Keys FK_Medication_SampleManufacturerCode: [dbo].[Vaccine_Manufacturer_DE].SampleManufacturerCode Foreign Keys FK_Medication_SampleManufacturerCode: [dbo].[Vaccine_Manufacturer_DE].SampleManufacturerCode](../../../../Images/fk.png) | SampleManufacturerCode | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Sample Manufacturer. Link to Vaccine_Manufacturer_DE.ID |
| SampleLot | varchar(20) | 20 | NULL allowed | | Sample LOT |
| SampleDTTM | datetime | 8 | NULL allowed | | Sample Date and time |
![Check Constraints CK_Medication_SampleAdminister : ([SampleAdminister]='Y' OR [SampleAdminister]='N') Check Constraints CK_Medication_SampleAdminister : ([SampleAdminister]='Y' OR [SampleAdminister]='N')](../../../../Images/c-constraint.png) | SampleAdminister | [dbo].[BOOL] | 1 | NULL allowed | | Sample Administered (Y/N) |
| DateToAdministerFuzzyWhen | varchar(50) | 50 | NULL allowed | | Date to Administer |
| DateToAdministerFuzzySpecificity | char(1) | 1 | NULL allowed | | Date to Administer Specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text |
(2) | PBMDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | PBM (Pharmacy Benefit Manager). Link to PBM_DE.ID |
| SplitRxParentItemID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Parent Item ID of Split Rx |
| AdministrationDoseQty | float | 8 | NOT NULL | ((0)) | Administration Dosage Quantity |
| ProcessingType | char(1) | 1 | NULL allowed | | Processing Type |
| TSRX_ID | [dbo].[uniqueid] | 9 | NULL allowed | (NULL) | TSRX ID. |
![Check Constraints CK_Medication_PARChecked : ([PARChecked]='Y' OR [PARChecked]='N') Check Constraints CK_Medication_PARChecked : ([PARChecked]='Y' OR [PARChecked]='N')](../../../../Images/c-constraint.png) | PARChecked | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is PAR (Prior Adverse Reaction) Checked |
![Check Constraints CK_Medication_DrugDoseChecked : ([DrugDoseChecked]='Y' OR [DrugDoseChecked]='N') Check Constraints CK_Medication_DrugDoseChecked : ([DrugDoseChecked]='Y' OR [DrugDoseChecked]='N')](../../../../Images/c-constraint.png) | DrugDoseChecked | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is Drug Dose Checked |
![Check Constraints CK_Medication_DrugDrugChecked : ([DrugDrugChecked]='Y' OR [DrugDrugChecked]='N') Check Constraints CK_Medication_DrugDrugChecked : ([DrugDrugChecked]='Y' OR [DrugDrugChecked]='N')](../../../../Images/c-constraint.png) | DrugDrugChecked | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is Drug Drug Checked |
![Check Constraints CK_Medication_DuplicateTherapyChecked : ([DuplicateTherapyChecked]='Y' OR [DuplicateTherapyChecked]='N') Check Constraints CK_Medication_DuplicateTherapyChecked : ([DuplicateTherapyChecked]='Y' OR [DuplicateTherapyChecked]='N')](../../../../Images/c-constraint.png) | DuplicateTherapyChecked | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is Duplicate Therapy Checked |
![Check Constraints CK_Medication_DrugHealthStateChecked : ([DrugHealthStateChecked]='Y' OR [DrugHealthStateChecked]='N') Check Constraints CK_Medication_DrugHealthStateChecked : ([DrugHealthStateChecked]='Y' OR [DrugHealthStateChecked]='N')](../../../../Images/c-constraint.png) | DrugHealthStateChecked | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is Drug Health State Checked |
| VerifiedDTTM | datetime | 8 | NOT NULL | ('1900/01/01') | Verified Date and Time |
| DoNotFillBeforeDate | datetime | 8 | NULL allowed | | Do Not Fill Before Date |
| IsControlledSubstancePrint | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Flag indicating Control Substance Printable |
| ControlSubstanceCode | varchar(2) | 2 | NOT NULL | ('NA') | Control Substance Code |
| ControlSubstanceCodeReason | varchar(500) | 500 | NOT NULL | ('') | Control Substance Code Reason |
| EPCSTransactionFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | EPCS (electrocin prescribing of controlled substance)Transaction Flag |
| ProcessPA | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Process PA (Prior Authorization) (Y/N) |
| ePaAuthorizationNo | varchar(50) | 50 | NULL allowed | | Authorization Number of ePa (electronic Prior Authorization) |
| VisuallyVerifiedByID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | provider who verified admin. Link to Provider.ID |
| PriorAuthorizationType | char(1) | 1 | NOT NULL | ('') | Prior Authorization Type (R - Retrospective ePA, '' - Prospective ePA). |
 | ArchiveState | tinyint | 1 | NOT NULL | ((0)) | Archive State 0 - not archived, 1 - Archived |
| SpecialtyMed | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Is this a specialty Medication (Y/N)? |
| RetainDefaultPharmacy | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Always retain patient's default pharmacy? |
| IsMedTaking | bit | 1 | NULL allowed | | Is the patient taking the medication? |
![Foreign Keys FK_Medication_MedTakingReasonDE: [dbo].[Medication_Taking_Reason_DE].MedTakingReasonDE Foreign Keys FK_Medication_MedTakingReasonDE: [dbo].[Medication_Taking_Reason_DE].MedTakingReasonDE](../../../../Images/fk.png) | MedTakingReasonDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Reason the patient is taking the medication. Link to Medication_Taking_Reason_DE.ID |
| InventoryID | varchar(64) | 64 | NULL allowed | | Inventory ID for Flexscan interface |
| Barcode | varchar(64) | 64 | NULL allowed | | Barcode of inventory item for Flexscan interface |