Tables [dbo].[Charge_Code_DE]
Charge Code Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Charge_Code_DE_ID: IDIndexes TWstat_Charge_Code_DE_ChargeReportingCatDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ChargeTypeDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Check25ModifierFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CostCenterDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4Code_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4ModifierDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, STAT_Charge_Code_DE_DentalChargeFLAG, TWstat_Charge_Code_DE_EnterpriseEntryID_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Entry_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsCurrentFLAG_EntryName_DefinitionSetID_ID, TWstat_Charge_Code_DE_IsInactiveFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsLevelOfServiceFlag_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ProfessionalComponentDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_SexDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(15)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Charge_Code_DE table.
Indexes TWstat_Charge_Code_DE_EnterpriseEntryID_EntryName_DefinitionSetID_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Charge_Code_DE_ChargeReportingCatDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ChargeTypeDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Check25ModifierFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CostCenterDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4Code_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4ModifierDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, STAT_Charge_Code_DE_DentalChargeFLAG, TWstat_Charge_Code_DE_EnterpriseEntryID_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Entry_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsCurrentFLAG_EntryName_DefinitionSetID_ID, TWstat_Charge_Code_DE_IsInactiveFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsLevelOfServiceFlag_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ProfessionalComponentDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_SexDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(15)DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_Charge_Code_DE_Entry_EntryName_DefinitionSetID_IsCurrentFLAG_IDEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Charge_Code_DE_EntryCode_WithIncludeColumns, NIX_Charge_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Charge_Code_DE_EntryName_WithIncludeColumns, NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns(4)EntryCode[dbo].[code]10NOT NULLEntry Code
Indexes NIX_Charge_Code_DE_EntryCode_WithIncludeColumns, NIX_Charge_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Charge_Code_DE_EntryName_WithIncludeColumns, NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_ChargeReportingCatDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ChargeTypeDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Check25ModifierFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CostCenterDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4Code_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4ModifierDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, STAT_Charge_Code_DE_DentalChargeFLAG, TWstat_Charge_Code_DE_EnterpriseEntryID_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Entry_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsCurrentFLAG_EntryName_DefinitionSetID_ID, TWstat_Charge_Code_DE_IsInactiveFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsLevelOfServiceFlag_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ProfessionalComponentDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_SexDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(19)EntryName[dbo].[name]255NOT NULLEntry Name
Indexes NIX_Charge_Code_DE_EntryCode_WithIncludeColumns, NIX_Charge_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Charge_Code_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic
Indexes NIX_Charge_Code_DE_EntryCode_WithIncludeColumns, NIX_Charge_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Charge_Code_DE_EntryName_WithIncludeColumns, NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_IsInactiveFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID(5)Check Constraints CK_Charge_Code_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Charge_Code_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_Charge_Code_DE_EntryCode_WithIncludeColumns, NIX_Charge_Code_DE_EntryMnemonic_WithIncludeColumns, NIX_Charge_Code_DE_EntryName_WithIncludeColumns, TWstat_Charge_Code_DE_ChargeReportingCatDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ChargeTypeDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Check25ModifierFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CostCenterDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4Code_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_CPT4ModifierDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, STAT_Charge_Code_DE_DentalChargeFLAG, TWstat_Charge_Code_DE_EnterpriseEntryID_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_Entry_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsCurrentFLAG_EntryName_DefinitionSetID_ID, TWstat_Charge_Code_DE_IsInactiveFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_IsLevelOfServiceFlag_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_ProfessionalComponentDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID, TWstat_Charge_Code_DE_SexDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(18)Check Constraints CK_Charge_Code_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.
Indexes TWstat_Charge_Code_DE_CostCenterDE_EntryName_DefinitionSetID_IsCurrentFLAG_IDCostCenterDE[dbo].[dict_id]5NOT NULLCost Center. Link to Cost_Center_DE.ID
Indexes TWstat_Charge_Code_DE_ChargeReportingCatDE_EntryName_DefinitionSetID_IsCurrentFLAG_IDChargeReportingCatDE[dbo].[dict_id]5NOT NULLCharge Report. Link to Charge_Report_Cat_DE.ID
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_ChargeTypeDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(2)ChargeTypeDE[dbo].[dict_id]5NOT NULLCharge Type. Link to Charge_Type_DE.ID
Check Constraints CK_Charge_Code_DE_IsReferralOnlyFLAG_Yes_Or_No : ([IsReferralOnlyFLAG]='N' OR [IsReferralOnlyFLAG]='Y')IsReferralOnlyFLAG[dbo].[BOOL]1NOT NULLReferral (Y/N) ?
Check Constraints CK_Charge_Code_DE_AllowModifierFLAG_Yes_Or_No : ([AllowModifierFLAG]='N' OR [AllowModifierFLAG]='Y')AllowModifierFLAG[dbo].[BOOL]1NOT NULLAllow Modifier (Y/N) ?
Check Constraints CK_Charge_Code_DE_IsTaxableFLAG_Yes_Or_No : ([IsTaxableFLAG]='N' OR [IsTaxableFLAG]='Y')IsTaxableFLAG[dbo].[BOOL]1NOT NULLIs the Charge Taxable ( Y/N) ?
Check Constraints CK_Charge_Code_DE_RequiresDosesFLAG_Yes_Or_No : ([RequiresDosesFLAG]='N' OR [RequiresDosesFLAG]='Y')RequiresDosesFLAG[dbo].[BOOL]1NOT NULLRequires Doses (Y/N) ?
Check Constraints CK_Charge_Code_DE_IsManuallyPricedFLAG_Yes_Or_No : ([IsManuallyPricedFLAG]='N' OR [IsManuallyPricedFLAG]='Y')IsManuallyPricedFLAG[dbo].[BOOL]1NOT NULLIs Manually Priced ( Y/N) ?
Check Constraints CK_Charge_Code_DE_IsAnesthiologyChargeFLAG_Yes_Or_No : ([IsAnesthiologyChargeFLAG]='N' OR [IsAnesthiologyChargeFLAG]='Y')IsAnesthiologyChargeFLAG[dbo].[BOOL]1NOT NULLNot Used
DefaultChargeAmountsmallmoney4NOT NULLDefault Charge Amount
RelativeValueUnitchar(10)10NOT NULLRelative Value Unit
Check Constraints CK_Charge_Code_DE_IsExplodingChargeFLAG_Yes_Or_No : ([IsExplodingChargeFLAG]='N' OR [IsExplodingChargeFLAG]='Y')IsExplodingChargeFLAG[dbo].[BOOL]1NOT NULLExploding 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')RequireRPHY_UPIN_NumberFLAG[dbo].[BOOL]1NOT NULLNot Used
Indexes TWstat_Charge_Code_DE_ProfessionalComponentDE_EntryName_DefinitionSetID_IsCurrentFLAG_IDProfessionalComponentDE[dbo].[dict_id]5NOT NULL(0)Not Used
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_CPT4ModifierDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(2)CPT4ModifierDE[dbo].[dict_id]5NOT NULLCPT4 Modifier. Link  to CPT4_Modifier_DE.ID
CPT4ProcedureDE[dbo].[dict_id]5NOT NULLCPT4 Procedure. Link to CPT4Procedure_DE.ID
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_IsLevelOfServiceFlag_EntryName_DefinitionSetID_IsCurrentFLAG_ID(2)Check Constraints CK_Charge_Code_DE_IsLevelOfServiceFlag_Yes_Or_No : ([IsLevelOfServiceFlag]='N' OR [IsLevelOfServiceFlag]='Y')IsLevelOfServiceFlag[dbo].[BOOL]1NOT NULLLevel of Service (Y/N) ?
Indexes XAK4CHARGE_CODE_DE, NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns(2)DisplayNamevarchar(255)255NULL allowedDisplay Name
LMRPint4NULL allowedNot Used
InterfaceCode[dbo].[code]10NOT NULL(0)Interface Code
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, STAT_Charge_Code_DE_DentalChargeFLAG(2)Check Constraints CK_Charge_Code_DE_DentalChargeFLAG_Yes_Or_No : ([DentalChargeFLAG]='N' OR [DentalChargeFLAG]='Y')DentalChargeFLAG[dbo].[BOOL]1NOT NULL('N')Is Dental Charge (Y/N) ?
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_HighAge(2)HighAgesmallint2NOT NULL(0)High Age Limit
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_LowAge(2)LowAgesmallint2NOT NULL(0)Low Age Limit
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_SexDE_EntryName_DefinitionSetID_IsCurrentFLAG_ID(2)Foreign Keys FK_ChargeCodeDE_SexDE: [dbo].[Sex_DE].SexDESexDE[dbo].[dict_id]5NOT NULL(0)Sex Specific. Link to Sex_DE.ID
Indexes NIX_Charge_Code_DE_IsInactiveFLAG_IsLevelOfServiceFlag_WithIncludeColumns, TWstat_Charge_Code_DE_CPT4Code_EntryName_DefinitionSetID_IsCurrentFLAG_ID(2)CPT4Codevarchar(10)10NULL allowedCPT4 Code
Indexes TWstat_Charge_Code_DE_Check25ModifierFLAG_EntryName_DefinitionSetID_IsCurrentFLAG_IDCheck Constraints CK_Charge_Code_DE_Check25ModifierFLAG_Yes_Or_No : ([Check25ModifierFLAG]='N' OR [Check25ModifierFLAG]='Y')Check25ModifierFLAG[dbo].[BOOL]1NOT NULL('N')Indicates whether the 25 modifier applies to this charge (Y/N) ?
IsTimeRequiredFlag[dbo].[BOOL]1NOT NULL('N')Time is required indicator
IsGuidelinesbit1NOT NULL((0))If 1 applies to Radiology Guidelines