Tables [dbo].[Charge]
Patient Charge Data
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Charge_ID: IDIndexes XCharge_EncIDID, TWstat_Charge_ABNStatusDE_ID, TWstat_Charge_ApprovedFlag_ID, TWstat_Charge_BillingApprovedByDTTM_ID, TWstat_Charge_BillingArea_ID, TWstat_Charge_BillingAreaDE_ID, TWstat_Charge_BillingChargeDescription_ID, TWstat_Charge_BillingComment_ID, TWstat_Charge_BillingInsuranceClassDE_ID, TWstat_Charge_BillingLocationDE_ID, TWstat_Charge_BillingProviderID_ID, TWstat_Charge_BillingStatus_ID, TWstat_Charge_ChargeCodeDE_ID, TWstat_Charge_ChargeGroupingID_ID, TWstat_Charge_CompanyAccountFLAG_ID, TWstat_Charge_DiscountTypeDE_ID, TWstat_Charge_DisplayOrder_ID, TWstat_Charge_EndTime_ID, TWstat_Charge_HasDiagnosisFLAG_ID, TWstat_Charge_InjuryAccountDescription_ID, TWstat_Charge_InjuryAccountNumber_ID, TWstat_Charge_InjuryTypeDE_ID, TWstat_Charge_IsLevelOfServiceChargeFLAG_ID, TWstat_Charge_IsTechnicalFLAG_ID, TWstat_Charge_OtherProviderID_ID, TWstat_Charge_OverrideChargeAmount_ID, TWstat_Charge_PostDTTM_ID, TWstat_Charge_SubmittedByID_ID, TWstat_Charge_ToothSurfaceCodeDE_ID, TWstat_Charge_VisitID_ID, TWstat_Charge_WhenToChargeDET_ID(31)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Charge table.
Indexes TWstat_Charge_VisitID_IDVisitID[dbo].[uniqueid]9NOT NULLVisit. Link to Visit.ID
Indexes NIX_Charge_BillingStatus, NIX_Charge_EncounterID_BillingStatus_SubmittedByID, XCharge_EncIDID(3)Foreign Keys FK_Charge_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Indexes NIX_Charge_ChargeGroupingID, TWstat_Charge_ChargeGroupingID_ID(2)Foreign Keys FK_Charge_ChargeGroupingID_Charge_Grouping_ID: [dbo].[Charge_Grouping].ChargeGroupingIDChargeGroupingID[dbo].[uniqueid]9NOT NULLCharge Grouping. Link to Charge_Grouping.ID
Indexes TWstat_Charge_ChargeCodeDE_IDForeign Keys FK_Charge_ChargeCodeDE_Charge_Code_DE_ID: [dbo].[Charge_Code_DE].ChargeCodeDEChargeCodeDE[dbo].[dict_id]5NOT NULLCharge. Link to Charge_Code_DE.ID
Indexes TWstat_Charge_PostDTTM_IDPostDTTMdatetime8NULL allowedDate/time the charge was submitted. Null date time if not submitted.
Check Constraints CK_Charge_IsCreditFLAG_Yes_Or_No : ([IsCreditFLAG]='N' OR [IsCreditFLAG]='Y')IsCreditFLAG[dbo].[BOOL]1NOT NULLNot used
Indexes TWstat_Charge_IsTechnicalFLAG_IDCheck Constraints CK_Charge_IsTechnicalFLAG_Yes_Or_No : ([IsTechnicalFLAG]='N' OR [IsTechnicalFLAG]='Y')IsTechnicalFLAG[dbo].[BOOL]1NOT NULLNot Used
Indexes TWstat_Charge_BillingChargeDescription_IDBillingChargeDescriptionvarchar(255)255NOT NULLNot Used
Indexes TWstat_Charge_BillingInsuranceClassDE_IDForeign Keys FK_Charge_BillingInsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].BillingInsuranceClassDEBillingInsuranceClassDE[dbo].[dict_id]5NOT NULLInsurance. link to Insurance_Class_DE.ID
Indexes TWstat_Charge_BillingArea_IDBillingAreavarchar(50)50NOT NULLNot Used
Indexes TWstat_Charge_BillingProviderID_IDBillingProviderID[dbo].[uniqueid]9NOT NULLThe billing provider of the encounter to which charge belongs.
BillingReferProviderID[dbo].[uniqueid]9NOT NULLThe referring provider of the encounter to which charge belongs.
Indexes TWstat_Charge_BillingLocationDE_IDForeign Keys FK_Charge_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDEBillingLocationDE[dbo].[dict_id]5NOT NULLBilling Location. Link to Billing_Location_DE.ID
UnitsToBillForreal4NOT NULLBilling units for the charge. Decimal value optionally input by user.
Indexes NIX_Charge_BillingStatus, NIX_Charge_EncounterID_BillingStatus_SubmittedByID, TWstat_Charge_BillingStatus_ID(3)BillingStatuschar(1)1NOT NULLCurrent billing status of the charge
B - Submitted
C - Cancel
R - Removed
E- Edited
V - Review
N - Needs Info
G - Ready
S - Saved
BillingApprovedByID[dbo].[uniqueid]9NOT NULLNot Used
Indexes TWstat_Charge_BillingApprovedByDTTM_IDBillingApprovedByDTTMdatetime8NULL allowedNot Used
Check Constraints CK_Charge_HasModifierFLAG_Yes_Or_No : ([HasModifierFLAG]='N' OR [HasModifierFLAG]='Y')HasModifierFLAG[dbo].[BOOL]1NOT NULLY if charge has at least one modifier linked. Else N.
Indexes TWstat_Charge_HasDiagnosisFLAG_IDCheck Constraints CK_Charge_HasDiagnosisFLAG_Yes_Or_No : ([HasDiagnosisFLAG]='N' OR [HasDiagnosisFLAG]='Y')HasDiagnosisFLAG[dbo].[BOOL]1NOT NULLY if charge has at least one diagnosis linked. Else N.
Indexes TWstat_Charge_IsLevelOfServiceChargeFLAG_IDCheck Constraints CK_Charge_IsLevelOfServiceChargeFLAG_Yes_Or_No : ([IsLevelOfServiceChargeFLAG]='N' OR [IsLevelOfServiceChargeFLAG]='Y')IsLevelOfServiceChargeFLAG[dbo].[BOOL]1NOT NULLY if charge is visit charge. N if procedure charge.
Indexes TWstat_Charge_OverrideChargeAmount_IDOverrideChargeAmountsmallmoney4NOT NULLThe amount in dollar units for charge.
Check Constraints CK_Charge_IsChargeOverrideFLAG_Yes_Or_No : ([IsChargeOverrideFLAG]='N' OR [IsChargeOverrideFLAG]='Y')IsChargeOverrideFLAG[dbo].[BOOL]1NOT NULLY if charge amount > 0. Else N
DiscountPercentagetinyint1NOT NULLCharge discount read percentage wise.
InjuryDTTMdatetime8NULL allowedThe date/time value when  Injury information for encounter to which charge was added.
Indexes TWstat_Charge_InjuryTypeDE_IDForeign Keys FK_Charge_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDEInjuryTypeDE[dbo].[dict_id]5NOT NULLSpecial Billing Type. Link to Injury_Type_DE.ID
Indexes TWstat_Charge_DiscountTypeDE_IDForeign Keys FK_Charge_DiscountTypeDE_Discount_Type_DE_ID: [dbo].[Discount_Type_DE].DiscountTypeDEDiscountTypeDE[dbo].[dict_id]5NOT NULLDiscount Type. Link to Discount_Type_DE.ID
Indexes TWstat_Charge_CompanyAccountFLAG_IDCheck Constraints CK_Charge_CompanyAccountFLAG_Yes_Or_No : ([CompanyAccountFLAG]='N' OR [CompanyAccountFLAG]='Y')CompanyAccountFLAG[dbo].[BOOL]1NOT NULLNot used
Indexes TWstat_Charge_BillingComment_IDBillingCommentvarchar(255)255NOT NULLThe user comments for charge.
Indexes TWstat_Charge_OtherProviderID_IDOtherProviderID[dbo].[uniqueid]9NOT NULLLinks to Provider2ID of Encounter table. Refers to the performing provider
Indexes TWstat_Charge_ApprovedFlag_IDCheck Constraints CK_Charge_ApprovedFlag_Yes_Or_No : ([ApprovedFlag]='N' OR [ApprovedFlag]='Y')ApprovedFlag[dbo].[BOOL]1NOT NULL('N')Not Used
Check Constraints CK_Charge_MilestoneMetFlag_Yes_Or_No : ([MilestoneMetFlag]='N' OR [MilestoneMetFlag]='Y')MilestoneMetFlag[dbo].[BOOL]1NOT NULL('N')Charge Milestone has been met (Y/N)?
Indexes IX_ChargeOrderActivityHeaderIDnumeric(16,0)9NULL allowedThe ActivityHeaderID of the order to which charge is linked to.
Indexes TWstat_Charge_WhenToChargeDET_IDWhenToChargeDETvarchar(255)255NULL allowedNot Used
Check Constraints CK_Charge_MNNFLAG_Yes_Or_No : ([MNNFLAG]='N' OR [MNNFLAG]='Y')MNNFLAG[dbo].[BOOL]1NOT NULL('N')Y- charge needs medical necesity to met.
Indexes TWstat_Charge_ABNStatusDE_IDForeign Keys ABN_Status_ID: [dbo].[ABN_Intermediate_Status_DE].ABNStatusDEABNStatusDE[dbo].[dict_id]5NOT NULL('0')Medical Necessity Status. link to ABN_Intermediate_Status_DE.ID
Indexes TWstat_Charge_BillingAreaDE_IDForeign Keys FK_Charge_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDEBillingAreaDE[dbo].[dict_id]5NOT NULL(0)Billing Area. Link to Billining_Area_DE.ID
Indexes NIX_Charge_EncounterID_BillingStatus_SubmittedByID, TWstat_Charge_SubmittedByID_ID(2)SubmittedByID[dbo].[uniqueid]9NULL allowedThe user id of provider who submitted the charge.
StartTimedatetime8NULL allowedStart time for time based charges
Indexes TWstat_Charge_EndTime_IDEndTimedatetime8NULL allowedEnd time for time based charges
ToothNumbervarchar(3)3NOT NULL('0')Tooth Number related to Dental related charges.
Indexes TWstat_Charge_ToothSurfaceCodeDE_IDForeign Keys FK_Charge_ToothSurfaceCodeDE: [dbo].[Tooth_Surface_Code_DE].ToothSurfaceCodeDEToothSurfaceCodeDE[dbo].[dict_id]5NOT NULL(0)Tooth Surface for dental charges. Link to Tooth_Surface_Code_DE.ID
Indexes TWstat_Charge_InjuryAccountDescription_IDInjuryAccountDescriptionvarchar(255)255NULL allowedThe account description, part of special billing info for encounter to which charge is linked
Indexes TWstat_Charge_InjuryAccountNumber_IDInjuryAccountNumbervarchar(20)20NULL allowedThe account number, part of special billing info for encounter to which charge is linked
Indexes TWstat_Charge_DisplayOrder_IDDisplayOrdersmallint2NOT NULL(0)Charge display order
NDCchar(12)12NOT NULL('')NDC
EncounterBillingLocationDE[dbo].[dict_id]5NOT NULL((0))Billing Location from the encounter. Link to Billing_Location_DE.ID