Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (5) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Medication_DE table. |
| EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
| Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(10) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique Medication code |
(15) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Medication Description. Entries could be Immunizations / Medications |
(10) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Mnemonic. Can be blank. |
(10) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
| IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
(14)![Check Constraints CK_Medication_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Medication_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
 | EffectiveDT | datetime | 8 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
(2) | NDC | char(12) | 12 | NOT NULL | | | National Drug Code. |
(3) | DDI | int | 4 | NOT NULL | | | Drug Descriptor Identifier |
(2) | Strength | varchar(15) | 15 | NOT NULL | | | Strength of Drug. Ex : 20-4-500 or 100-1-10 |
(2) | Form | varchar(4) | 4 | NOT NULL | | | Form of Drug Ex: Pack or Susp Etc |
| Qty | varchar(6) | 6 | NOT NULL | | | Quantity of Drug |
(2) | UnitOfMeasure | [dbo].[code] | 10 | NOT NULL | | | Unit of Measure of Medication / Immunization. Ex : MG/TSP |
 | ControlSubstanceCode | char(2) | 2 | NOT NULL | | | Control Substance Code of the medicaiton. |
(2) | RouteOfAdminDE | [dbo].[dict_id] | 5 | NOT NULL | | | Route of Administration. Link to Route_Of_Admin_DE.ID |
 | SecurityCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Security Code . Link to Security_Code_DE.ID. |
 | DrugName | varchar(30) | 30 | NOT NULL | | | Drug Name |
| LabelerName | varchar(30) | 30 | NOT NULL | | | Labeler Name as Provided by Medispan. |
| GPI_TC3 | char(6) | 6 | NOT NULL | | | First 6 digits of the Generic Product Identifier |
| DDI_Pointer | int | 4 | NULL allowed | | | DDI of Drug. This column is not beign used/populated. |
 | DisplayName | varchar(255) | 255 | NOT NULL | | ('') | Display name of the Medication |
 ![Check Constraints CK_Medication_DE_IsVitalAdminFLAG_Yes_Or_No : ([IsVitalAdminFLAG]='N' OR [IsVitalAdminFLAG]='Y') Check Constraints CK_Medication_DE_IsVitalAdminFLAG_Yes_Or_No : ([IsVitalAdminFLAG]='N' OR [IsVitalAdminFLAG]='Y')](../../../../Images/c-constraint.png) | IsVitalAdminFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag indicating Vital Admin |
(2)![Check Constraints CK_Medication_DE_KOPProhibited_Yes_Or_No : ([KOPProhibited]='N' OR [KOPProhibited]='Y') Check Constraints CK_Medication_DE_KOPProhibited_Yes_Or_No : ([KOPProhibited]='N' OR [KOPProhibited]='Y')](../../../../Images/c-constraint.png) | KOPProhibited | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag indicating KOP (Keep On Person) Prohibited |
 | CPT4Code | char(10) | 10 | NOT NULL | | ('') | Current Procedural Terminology code |
| CPT4Text | varchar(255) | 255 | NOT NULL | | ('') | Description for CPT4 code |
![Foreign Keys FK_Medication_DE_AllscriptsPatientInstructionID: [dbo].[QO_Class_Instruction].AllscriptsPatientInstructionID Foreign Keys FK_Medication_DE_AllscriptsPatientInstructionID: [dbo].[QO_Class_Instruction].AllscriptsPatientInstructionID](../../../../Images/fk.png) | AllscriptsPatientInstructionID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Key to the dbo.QO_Class_Instruction table |
 ![Foreign Keys FK_Medication_DE_CVXDE_CVX_DE_ID: [dbo].[CVX_DE].CVXDE Foreign Keys FK_Medication_DE_CVXDE_CVX_DE_ID: [dbo].[CVX_DE].CVXDE](../../../../Images/fk.png) | CVXDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | CVX. Link to CVX_DE.ID |
![Check Constraints CK_Medication_DE_IsCompound_Yes_Or_No : ([IsCompound]='N' OR [IsCompound]='Y') Check Constraints CK_Medication_DE_IsCompound_Yes_Or_No : ([IsCompound]='N' OR [IsCompound]='Y')](../../../../Images/c-constraint.png) | IsCompound | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is Compound Medication |
![Check Constraints CK_Medication_DE_IsSupply_Yes_Or_No : ([IsSupply]='N' OR [IsSupply]='Y') Check Constraints CK_Medication_DE_IsSupply_Yes_Or_No : ([IsSupply]='N' OR [IsSupply]='Y')](../../../../Images/c-constraint.png) | IsSupply | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag for Supply |
| KeepActiveUntil | datetime | 8 | NULL allowed | | | Keep this medication usable till the date specified. |
| LocalInactivationFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is the medication inactivated Locally |
| RxNormCode | [dbo].[code] | 10 | NOT NULL | | ('') | RxNorm code of the Medication |
| RxNormCodeNormalized | [dbo].[code] | 10 | NOT NULL | | ('') | Normalized Rx Norm Code |
| TransmitToImmunizationRegistry | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | When True corresponding immunization will be sent to Registry |
| GenericName | varchar(30) | 30 | NULL allowed | | ('') | Generic Name of the Drug/Medication |
| DisplayInHx | [dbo].[BOOL] | 1 | NOT NULL | | ('Y') | This flag is applicable only for Immunization entries in Medication_DE dictionary. If Y then it will be displayed in history (Hx). |