Tables [dbo].[CPT4_Modifier_DE]
The CPT4 Modifier dictionary contains modifiers valid for E/M coding and procedures.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_CPT4_Modifier_DE_ID: IDIndexes TWstat_CPT4_Modifier_DE_CCIFLAG_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_ModifierType_EntryName_IsCurrentFLAG_ID(4)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the CPT4_Modifier_DE table.
Indexes TWstat_CPT4_Modifier_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NULL allowedMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NULL allowedPoints 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_CPT4_Modifier_DE_EntryCode_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryMnemonic_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLEntry Code - Unique alphanumeric code
Indexes NIX_CPT4_Modifier_DE_EntryCode_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryMnemonic_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryName_WithIncludeColumns, TWstat_CPT4_Modifier_DE_CCIFLAG_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_ModifierType_EntryName_IsCurrentFLAG_ID(7)EntryName[dbo].[name]255NOT NULLEntry Name -  Unique alphanumeric "friendly" display name
Indexes NIX_CPT4_Modifier_DE_EntryCode_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryMnemonic_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic
Indexes NIX_CPT4_Modifier_DE_EntryCode_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryMnemonic_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryName_WithIncludeColumns, TWstat_CPT4_Modifier_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_CPT4_Modifier_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_CPT4_Modifier_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Indexes NIX_CPT4_Modifier_DE_EntryCode_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryMnemonic_WithIncludeColumns, NIX_CPT4_Modifier_DE_EntryName_WithIncludeColumns, TWstat_CPT4_Modifier_DE_CCIFLAG_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_CPT4_Modifier_DE_ModifierType_EntryName_IsCurrentFLAG_ID(7)Check Constraints CK_CPT4_Modifier_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date is the last edited date.
Indexes TWstat_CPT4_Modifier_DE_ModifierType_EntryName_IsCurrentFLAG_IDCheck Constraints CK_CPT4_Modifier_DE_ModifierType_rCPT4ModifierType : ([ModifierType]='' OR [ModifierType]='Both' OR [ModifierType]='Procedure' OR [ModifierType]='Visit')ModifierTypevarchar(10)10NOT NULL('')Indicates the type of modifier. Options include Procedure, Visit, and Both.
Indexes TWstat_CPT4_Modifier_DE_CCIFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_CPT4_Modifier_DE_CCIFLAG_Yes_Or_No : ([CCIFLAG]='N' OR [CCIFLAG]='Y')CCIFLAG[dbo].[BOOL]1NOT NULL('N')When the CCI Modifier checkbox is selected, that modifier is a selectable option/modifier when the CCI Edits option is enabled.
IsGuidelinesbit1NOT NULL((0))Default (0) . Indicates whether items needs to be added under the modifier drop down  of charging section  in order details dialog
IsMedAdminAndOrderbit1NOT NULL((0))Indicates if the items need to be added under the modifier drop down of charging section in order details dialog for all admin and non med order charges except the g-code charge.