Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (4) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the CPT4_Modifier_DE table. |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NULL allowed | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
| DefinitionSetID | [dbo].[dict_id] | 5 | NULL allowed | | | 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 |
(3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Entry Code - Unique alphanumeric code |
(7) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Entry Name - Unique alphanumeric "friendly" display name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Entry Mnemonic |
(4)![Check Constraints CK_CPT4_Modifier_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_CPT4_Modifier_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry inactive (Y/N)? |
![Check Constraints CK_CPT4_Modifier_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_CPT4_Modifier_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry Enforced (Y/N)? Enforced entries can not be modified by the application. |
(7)![Check Constraints CK_CPT4_Modifier_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_CPT4_Modifier_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the entry Current (Y/N)? |
| EffectiveDT | datetime | 8 | NULL allowed | | | Effective Date is the last edited date. |
 ![Check Constraints CK_CPT4_Modifier_DE_ModifierType_rCPT4ModifierType : ([ModifierType]='' OR [ModifierType]='Both' OR [ModifierType]='Procedure' OR [ModifierType]='Visit') Check Constraints CK_CPT4_Modifier_DE_ModifierType_rCPT4ModifierType : ([ModifierType]='' OR [ModifierType]='Both' OR [ModifierType]='Procedure' OR [ModifierType]='Visit')](../../../../Images/c-constraint.png) | ModifierType | varchar(10) | 10 | NOT NULL | | ('') | Indicates the type of modifier. Options include Procedure, Visit, and Both. |
 ![Check Constraints CK_CPT4_Modifier_DE_CCIFLAG_Yes_Or_No : ([CCIFLAG]='N' OR [CCIFLAG]='Y') Check Constraints CK_CPT4_Modifier_DE_CCIFLAG_Yes_Or_No : ([CCIFLAG]='N' OR [CCIFLAG]='Y')](../../../../Images/c-constraint.png) | CCIFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | When the CCI Modifier checkbox is selected, that modifier is a selectable option/modifier when the CCI Edits option is enabled. |
| IsGuidelines | bit | 1 | NOT NULL | | ((0)) | Default (0) . Indicates whether items needs to be added under the modifier drop down of charging section in order details dialog |
| IsMedAdminAndOrder | bit | 1 | NOT 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. |