Tables [dbo].[Medication_DE]
Medications
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Medication_DE_ID: IDIndexes TWstat_Medication_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_IsVitalAdminFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_KOPProhibited_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(5)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Medication_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Medication_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Medication_DE_CPT4Code, NIX_Medication_DE_CVXDE_WithIncludeColumns, NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_DisplayName_WithIncludeColumns, NIX_Medication_DE_DrugName, NIX_Medication_DE_EntryCode_WithIncludeColumns, NIX_Medication_DE_EntryMnemonic_WithIncludeColumns, NIX_Medication_DE_EntryName_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns, NIX_Medication_DE_NDC(10)EntryCode[dbo].[code]10NOT NULLUnique Medication code
Indexes NIX_Medication_DE_CPT4Code, NIX_Medication_DE_CVXDE_WithIncludeColumns, NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_DisplayName_WithIncludeColumns, NIX_Medication_DE_DrugName, NIX_Medication_DE_EntryCode_WithIncludeColumns, NIX_Medication_DE_EntryMnemonic_WithIncludeColumns, NIX_Medication_DE_EntryName_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns, NIX_Medication_DE_NDC, TWstat_Medication_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_IsVitalAdminFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_KOPProhibited_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(15)EntryName[dbo].[name]255NOT NULLMedication Description. Entries could be Immunizations / Medications
Indexes NIX_Medication_DE_CPT4Code, NIX_Medication_DE_CVXDE_WithIncludeColumns, NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_DisplayName_WithIncludeColumns, NIX_Medication_DE_DrugName, NIX_Medication_DE_EntryCode_WithIncludeColumns, NIX_Medication_DE_EntryMnemonic_WithIncludeColumns, NIX_Medication_DE_EntryName_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns, NIX_Medication_DE_NDC(10)EntryMnemonic[dbo].[code]10NOT NULLMnemonic. Can be blank.
Indexes NIX_Medication_DE_CPT4Code, NIX_Medication_DE_CVXDE_WithIncludeColumns, NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_DisplayName_WithIncludeColumns, NIX_Medication_DE_DrugName, NIX_Medication_DE_EntryCode_WithIncludeColumns, NIX_Medication_DE_EntryMnemonic_WithIncludeColumns, NIX_Medication_DE_EntryName_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns, NIX_Medication_DE_NDC(10)IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Medication_DE_CPT4Code, NIX_Medication_DE_CVXDE_WithIncludeColumns, NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_DisplayName_WithIncludeColumns, NIX_Medication_DE_DrugName, NIX_Medication_DE_EntryCode_WithIncludeColumns, NIX_Medication_DE_EntryMnemonic_WithIncludeColumns, NIX_Medication_DE_EntryName_WithIncludeColumns, NIX_Medication_DE_NDC, TWstat_Medication_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_IsVitalAdminFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_KOPProhibited_EntryName_IsCurrentFLAG_ID, TWstat_Medication_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_ID(14)Check Constraints CK_Medication_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
Indexes TWstat_Medication_DE_EffectiveDT_EntryName_IsCurrentFLAG_IDEffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Indexes NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns, NIX_Medication_DE_NDC(2)NDCchar(12)12NOT NULLNational Drug Code.
Indexes NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_EntryName_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns(3)DDIint4NOT NULLDrug Descriptor Identifier
Indexes NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns(2)Strengthvarchar(15)15NOT NULLStrength of Drug. Ex : 20-4-500   or 100-1-10       
Indexes NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns(2)Formvarchar(4)4NOT NULLForm of Drug Ex: Pack or Susp Etc
Qtyvarchar(6)6NOT NULLQuantity of Drug
Indexes NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns(2)UnitOfMeasure[dbo].[code]10NOT NULLUnit of Measure of Medication / Immunization. Ex : MG/TSP    
Indexes NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumnsControlSubstanceCodechar(2)2NOT NULLControl Substance Code of the medicaiton.
Indexes NIX_Medication_DE_DDI_WithIncludeColumns, NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns(2)RouteOfAdminDE[dbo].[dict_id]5NOT NULLRoute of Administration. Link to Route_Of_Admin_DE.ID
Indexes TWstat_Medication_DE_SecurityCodeDE_EntryName_IsCurrentFLAG_IDSecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code . Link to Security_Code_DE.ID.
Indexes NIX_Medication_DE_DrugNameDrugNamevarchar(30)30NOT NULLDrug Name
LabelerNamevarchar(30)30NOT NULLLabeler Name as Provided by Medispan.
GPI_TC3char(6)6NOT NULLFirst 6 digits of the Generic Product Identifier
DDI_Pointerint4NULL allowedDDI of Drug. This column is not beign used/populated.
Indexes NIX_Medication_DE_DisplayName_WithIncludeColumnsDisplayNamevarchar(255)255NOT NULL('')Display name of the Medication
Indexes TWstat_Medication_DE_IsVitalAdminFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Medication_DE_IsVitalAdminFLAG_Yes_Or_No : ([IsVitalAdminFLAG]='N' OR [IsVitalAdminFLAG]='Y')IsVitalAdminFLAG[dbo].[BOOL]1NOT NULL('N')Flag indicating Vital Admin
Indexes NIX_Medication_DE_IsInactiveFLAG_WithIncludeColumns, TWstat_Medication_DE_KOPProhibited_EntryName_IsCurrentFLAG_ID(2)Check Constraints CK_Medication_DE_KOPProhibited_Yes_Or_No : ([KOPProhibited]='N' OR [KOPProhibited]='Y')KOPProhibited[dbo].[BOOL]1NOT NULL('N')Flag indicating KOP (Keep On Person) Prohibited
Indexes NIX_Medication_DE_CPT4CodeCPT4Codechar(10)10NOT NULL('')Current Procedural Terminology code
CPT4Textvarchar(255)255NOT NULL('')Description for CPT4 code
Foreign Keys FK_Medication_DE_AllscriptsPatientInstructionID: [dbo].[QO_Class_Instruction].AllscriptsPatientInstructionIDAllscriptsPatientInstructionID[dbo].[dict_id]5NOT NULL(0)Key to the dbo.QO_Class_Instruction table
Indexes NIX_Medication_DE_CVXDE_WithIncludeColumnsForeign Keys FK_Medication_DE_CVXDE_CVX_DE_ID: [dbo].[CVX_DE].CVXDECVXDE[dbo].[dict_id]5NOT NULL((0))CVX. Link to CVX_DE.ID
Check Constraints CK_Medication_DE_IsCompound_Yes_Or_No : ([IsCompound]='N' OR [IsCompound]='Y')IsCompound[dbo].[BOOL]1NOT NULL('N')Is Compound Medication
Check Constraints CK_Medication_DE_IsSupply_Yes_Or_No : ([IsSupply]='N' OR [IsSupply]='Y')IsSupply[dbo].[BOOL]1NOT NULL('N')Flag for Supply
KeepActiveUntildatetime8NULL allowedKeep this medication usable till the date specified.
LocalInactivationFlag[dbo].[BOOL]1NOT NULL('N')Is the medication inactivated Locally
RxNormCode[dbo].[code]10NOT NULL('')RxNorm code of the Medication
RxNormCodeNormalized[dbo].[code]10NOT NULL('')Normalized Rx Norm Code
TransmitToImmunizationRegistry[dbo].[BOOL]1NOT NULL('N')When True corresponding immunization will be sent to Registry
GenericNamevarchar(30)30NULL allowed('')Generic Name of the Drug/Medication
DisplayInHx[dbo].[BOOL]1NOT NULL('Y')This flag is applicable only for Immunization entries in Medication_DE dictionary. If Y then it will be displayed in history (Hx).