Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (15) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Charge_Code_DE table. |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
(15) | 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 |
(4) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Entry Code |
(19) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Entry Name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Entry Mnemonic |
(5)![Check Constraints CK_Charge_Code_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Charge_Code_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_Charge_Code_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Charge_Code_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. |
(18)![Check Constraints CK_Charge_Code_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Charge_Code_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. This is the last edited date. |
 | CostCenterDE | [dbo].[dict_id] | 5 | NOT NULL | | | Cost Center. Link to Cost_Center_DE.ID |
 | ChargeReportingCatDE | [dbo].[dict_id] | 5 | NOT NULL | | | Charge Report. Link to Charge_Report_Cat_DE.ID |
(2) | ChargeTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Charge Type. Link to Charge_Type_DE.ID |
![Check Constraints CK_Charge_Code_DE_IsReferralOnlyFLAG_Yes_Or_No : ([IsReferralOnlyFLAG]='N' OR [IsReferralOnlyFLAG]='Y') Check Constraints CK_Charge_Code_DE_IsReferralOnlyFLAG_Yes_Or_No : ([IsReferralOnlyFLAG]='N' OR [IsReferralOnlyFLAG]='Y')](../../../../Images/c-constraint.png) | IsReferralOnlyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Referral (Y/N) ? |
![Check Constraints CK_Charge_Code_DE_AllowModifierFLAG_Yes_Or_No : ([AllowModifierFLAG]='N' OR [AllowModifierFLAG]='Y') Check Constraints CK_Charge_Code_DE_AllowModifierFLAG_Yes_Or_No : ([AllowModifierFLAG]='N' OR [AllowModifierFLAG]='Y')](../../../../Images/c-constraint.png) | AllowModifierFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Allow Modifier (Y/N) ? |
![Check Constraints CK_Charge_Code_DE_IsTaxableFLAG_Yes_Or_No : ([IsTaxableFLAG]='N' OR [IsTaxableFLAG]='Y') Check Constraints CK_Charge_Code_DE_IsTaxableFLAG_Yes_Or_No : ([IsTaxableFLAG]='N' OR [IsTaxableFLAG]='Y')](../../../../Images/c-constraint.png) | IsTaxableFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is the Charge Taxable ( Y/N) ? |
![Check Constraints CK_Charge_Code_DE_RequiresDosesFLAG_Yes_Or_No : ([RequiresDosesFLAG]='N' OR [RequiresDosesFLAG]='Y') Check Constraints CK_Charge_Code_DE_RequiresDosesFLAG_Yes_Or_No : ([RequiresDosesFLAG]='N' OR [RequiresDosesFLAG]='Y')](../../../../Images/c-constraint.png) | RequiresDosesFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Requires Doses (Y/N) ? |
![Check Constraints CK_Charge_Code_DE_IsManuallyPricedFLAG_Yes_Or_No : ([IsManuallyPricedFLAG]='N' OR [IsManuallyPricedFLAG]='Y') Check Constraints CK_Charge_Code_DE_IsManuallyPricedFLAG_Yes_Or_No : ([IsManuallyPricedFLAG]='N' OR [IsManuallyPricedFLAG]='Y')](../../../../Images/c-constraint.png) | IsManuallyPricedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Is Manually Priced ( Y/N) ? |
![Check Constraints CK_Charge_Code_DE_IsAnesthiologyChargeFLAG_Yes_Or_No : ([IsAnesthiologyChargeFLAG]='N' OR [IsAnesthiologyChargeFLAG]='Y') Check Constraints CK_Charge_Code_DE_IsAnesthiologyChargeFLAG_Yes_Or_No : ([IsAnesthiologyChargeFLAG]='N' OR [IsAnesthiologyChargeFLAG]='Y')](../../../../Images/c-constraint.png) | IsAnesthiologyChargeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Not Used |
| DefaultChargeAmount | smallmoney | 4 | NOT NULL | | | Default Charge Amount |
| RelativeValueUnit | char(10) | 10 | NOT NULL | | | Relative Value Unit |
![Check Constraints CK_Charge_Code_DE_IsExplodingChargeFLAG_Yes_Or_No : ([IsExplodingChargeFLAG]='N' OR [IsExplodingChargeFLAG]='Y') Check Constraints CK_Charge_Code_DE_IsExplodingChargeFLAG_Yes_Or_No : ([IsExplodingChargeFLAG]='N' OR [IsExplodingChargeFLAG]='Y')](../../../../Images/c-constraint.png) | IsExplodingChargeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Exploding set charge (Y/N) ? |
![Check Constraints CK_Charge_Code_DE_RequireRPHY_UPIN_NumberFLAG_Yes_Or_No : ([RequireRPHY_UPIN_NumberFLAG]='N' OR [RequireRPHY_UPIN_NumberFLAG]='Y') Check Constraints CK_Charge_Code_DE_RequireRPHY_UPIN_NumberFLAG_Yes_Or_No : ([RequireRPHY_UPIN_NumberFLAG]='N' OR [RequireRPHY_UPIN_NumberFLAG]='Y')](../../../../Images/c-constraint.png) | RequireRPHY_UPIN_NumberFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Not Used |
 | ProfessionalComponentDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Not Used |
(2) | CPT4ModifierDE | [dbo].[dict_id] | 5 | NOT NULL | | | CPT4 Modifier. Link to CPT4_Modifier_DE.ID |
| CPT4ProcedureDE | [dbo].[dict_id] | 5 | NOT NULL | | | CPT4 Procedure. Link to CPT4Procedure_DE.ID |
(2)![Check Constraints CK_Charge_Code_DE_IsLevelOfServiceFlag_Yes_Or_No : ([IsLevelOfServiceFlag]='N' OR [IsLevelOfServiceFlag]='Y') Check Constraints CK_Charge_Code_DE_IsLevelOfServiceFlag_Yes_Or_No : ([IsLevelOfServiceFlag]='N' OR [IsLevelOfServiceFlag]='Y')](../../../../Images/c-constraint.png) | IsLevelOfServiceFlag | [dbo].[BOOL] | 1 | NOT NULL | | | Level of Service (Y/N) ? |
(2) | DisplayName | varchar(255) | 255 | NULL allowed | | | Display Name |
| LMRP | int | 4 | NULL allowed | | | Not Used |
| InterfaceCode | [dbo].[code] | 10 | NOT NULL | | (0) | Interface Code |
(2)![Check Constraints CK_Charge_Code_DE_DentalChargeFLAG_Yes_Or_No : ([DentalChargeFLAG]='N' OR [DentalChargeFLAG]='Y') Check Constraints CK_Charge_Code_DE_DentalChargeFLAG_Yes_Or_No : ([DentalChargeFLAG]='N' OR [DentalChargeFLAG]='Y')](../../../../Images/c-constraint.png) | DentalChargeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is Dental Charge (Y/N) ? |
(2) | HighAge | smallint | 2 | NOT NULL | | (0) | High Age Limit |
(2) | LowAge | smallint | 2 | NOT NULL | | (0) | Low Age Limit |
(2)![Foreign Keys FK_ChargeCodeDE_SexDE: [dbo].[Sex_DE].SexDE Foreign Keys FK_ChargeCodeDE_SexDE: [dbo].[Sex_DE].SexDE](../../../../Images/fk.png) | SexDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Sex Specific. Link to Sex_DE.ID |
(2) | CPT4Code | varchar(10) | 10 | NULL allowed | | | CPT4 Code |
 ![Check Constraints CK_Charge_Code_DE_Check25ModifierFLAG_Yes_Or_No : ([Check25ModifierFLAG]='N' OR [Check25ModifierFLAG]='Y') Check Constraints CK_Charge_Code_DE_Check25ModifierFLAG_Yes_Or_No : ([Check25ModifierFLAG]='N' OR [Check25ModifierFLAG]='Y')](../../../../Images/c-constraint.png) | Check25ModifierFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Indicates whether the 25 modifier applies to this charge (Y/N) ? |
| IsTimeRequiredFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Time is required indicator |
| IsGuidelines | bit | 1 | NOT NULL | | ((0)) | If 1 applies to Radiology Guidelines |