Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (31) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Charge table. |
 | VisitID | [dbo].[uniqueid] | 9 | NOT NULL | | | Visit. Link to Visit.ID |
(3)![Foreign Keys FK_Charge_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterID Foreign Keys FK_Charge_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterID](../../../../Images/fk.png) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | | | Encounter. Link to Encounter.ID |
(2)![Foreign Keys FK_Charge_ChargeGroupingID_Charge_Grouping_ID: [dbo].[Charge_Grouping].ChargeGroupingID Foreign Keys FK_Charge_ChargeGroupingID_Charge_Grouping_ID: [dbo].[Charge_Grouping].ChargeGroupingID](../../../../Images/fk.png) | ChargeGroupingID | [dbo].[uniqueid] | 9 | NOT NULL | | | Charge Grouping. Link to Charge_Grouping.ID |
 ![Foreign Keys FK_Charge_ChargeCodeDE_Charge_Code_DE_ID: [dbo].[Charge_Code_DE].ChargeCodeDE Foreign Keys FK_Charge_ChargeCodeDE_Charge_Code_DE_ID: [dbo].[Charge_Code_DE].ChargeCodeDE](../../../../Images/fk.png) | ChargeCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Charge. Link to Charge_Code_DE.ID |
 | PostDTTM | datetime | 8 | NULL allowed | | | Date/time the charge was submitted. Null date time if not submitted. |
![Check Constraints CK_Charge_IsCreditFLAG_Yes_Or_No : ([IsCreditFLAG]='N' OR [IsCreditFLAG]='Y') Check Constraints CK_Charge_IsCreditFLAG_Yes_Or_No : ([IsCreditFLAG]='N' OR [IsCreditFLAG]='Y')](../../../../Images/c-constraint.png) | IsCreditFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Not used |
 ![Check Constraints CK_Charge_IsTechnicalFLAG_Yes_Or_No : ([IsTechnicalFLAG]='N' OR [IsTechnicalFLAG]='Y') Check Constraints CK_Charge_IsTechnicalFLAG_Yes_Or_No : ([IsTechnicalFLAG]='N' OR [IsTechnicalFLAG]='Y')](../../../../Images/c-constraint.png) | IsTechnicalFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Not Used |
 | BillingChargeDescription | varchar(255) | 255 | NOT NULL | | | Not Used |
 ![Foreign Keys FK_Charge_BillingInsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].BillingInsuranceClassDE Foreign Keys FK_Charge_BillingInsuranceClassDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].BillingInsuranceClassDE](../../../../Images/fk.png) | BillingInsuranceClassDE | [dbo].[dict_id] | 5 | NOT NULL | | | Insurance. link to Insurance_Class_DE.ID |
 | BillingArea | varchar(50) | 50 | NOT NULL | | | Not Used |
 | BillingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | The billing provider of the encounter to which charge belongs. |
| BillingReferProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | The referring provider of the encounter to which charge belongs. |
 ![Foreign Keys FK_Charge_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE Foreign Keys FK_Charge_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE](../../../../Images/fk.png) | BillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | | Billing Location. Link to Billing_Location_DE.ID |
| UnitsToBillFor | real | 4 | NOT NULL | | | Billing units for the charge. Decimal value optionally input by user. |
(3) | BillingStatus | char(1) | 1 | NOT NULL | | | Current 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] | 9 | NOT NULL | | | Not Used |
 | BillingApprovedByDTTM | datetime | 8 | NULL allowed | | | Not Used |
![Check Constraints CK_Charge_HasModifierFLAG_Yes_Or_No : ([HasModifierFLAG]='N' OR [HasModifierFLAG]='Y') Check Constraints CK_Charge_HasModifierFLAG_Yes_Or_No : ([HasModifierFLAG]='N' OR [HasModifierFLAG]='Y')](../../../../Images/c-constraint.png) | HasModifierFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y if charge has at least one modifier linked. Else N. |
 ![Check Constraints CK_Charge_HasDiagnosisFLAG_Yes_Or_No : ([HasDiagnosisFLAG]='N' OR [HasDiagnosisFLAG]='Y') Check Constraints CK_Charge_HasDiagnosisFLAG_Yes_Or_No : ([HasDiagnosisFLAG]='N' OR [HasDiagnosisFLAG]='Y')](../../../../Images/c-constraint.png) | HasDiagnosisFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y if charge has at least one diagnosis linked. Else N. |
 ![Check Constraints CK_Charge_IsLevelOfServiceChargeFLAG_Yes_Or_No : ([IsLevelOfServiceChargeFLAG]='N' OR [IsLevelOfServiceChargeFLAG]='Y') Check Constraints CK_Charge_IsLevelOfServiceChargeFLAG_Yes_Or_No : ([IsLevelOfServiceChargeFLAG]='N' OR [IsLevelOfServiceChargeFLAG]='Y')](../../../../Images/c-constraint.png) | IsLevelOfServiceChargeFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y if charge is visit charge. N if procedure charge. |
 | OverrideChargeAmount | smallmoney | 4 | NOT NULL | | | The amount in dollar units for charge. |
![Check Constraints CK_Charge_IsChargeOverrideFLAG_Yes_Or_No : ([IsChargeOverrideFLAG]='N' OR [IsChargeOverrideFLAG]='Y') Check Constraints CK_Charge_IsChargeOverrideFLAG_Yes_Or_No : ([IsChargeOverrideFLAG]='N' OR [IsChargeOverrideFLAG]='Y')](../../../../Images/c-constraint.png) | IsChargeOverrideFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y if charge amount > 0. Else N |
| DiscountPercentage | tinyint | 1 | NOT NULL | | | Charge discount read percentage wise. |
| InjuryDTTM | datetime | 8 | NULL allowed | | | The date/time value when Injury information for encounter to which charge was added. |
 ![Foreign Keys FK_Charge_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDE Foreign Keys FK_Charge_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDE](../../../../Images/fk.png) | InjuryTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Special Billing Type. Link to Injury_Type_DE.ID |
 ![Foreign Keys FK_Charge_DiscountTypeDE_Discount_Type_DE_ID: [dbo].[Discount_Type_DE].DiscountTypeDE Foreign Keys FK_Charge_DiscountTypeDE_Discount_Type_DE_ID: [dbo].[Discount_Type_DE].DiscountTypeDE](../../../../Images/fk.png) | DiscountTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Discount Type. Link to Discount_Type_DE.ID |
 ![Check Constraints CK_Charge_CompanyAccountFLAG_Yes_Or_No : ([CompanyAccountFLAG]='N' OR [CompanyAccountFLAG]='Y') Check Constraints CK_Charge_CompanyAccountFLAG_Yes_Or_No : ([CompanyAccountFLAG]='N' OR [CompanyAccountFLAG]='Y')](../../../../Images/c-constraint.png) | CompanyAccountFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Not used |
 | BillingComment | varchar(255) | 255 | NOT NULL | | | The user comments for charge. |
 | OtherProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Links to Provider2ID of Encounter table. Refers to the performing provider |
 ![Check Constraints CK_Charge_ApprovedFlag_Yes_Or_No : ([ApprovedFlag]='N' OR [ApprovedFlag]='Y') Check Constraints CK_Charge_ApprovedFlag_Yes_Or_No : ([ApprovedFlag]='N' OR [ApprovedFlag]='Y')](../../../../Images/c-constraint.png) | ApprovedFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Not Used |
![Check Constraints CK_Charge_MilestoneMetFlag_Yes_Or_No : ([MilestoneMetFlag]='N' OR [MilestoneMetFlag]='Y') Check Constraints CK_Charge_MilestoneMetFlag_Yes_Or_No : ([MilestoneMetFlag]='N' OR [MilestoneMetFlag]='Y')](../../../../Images/c-constraint.png) | MilestoneMetFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Charge Milestone has been met (Y/N)? |
 | OrderActivityHeaderID | numeric(16,0) | 9 | NULL allowed | | | The ActivityHeaderID of the order to which charge is linked to. |
 | WhenToChargeDET | varchar(255) | 255 | NULL allowed | | | Not Used |
![Check Constraints CK_Charge_MNNFLAG_Yes_Or_No : ([MNNFLAG]='N' OR [MNNFLAG]='Y') Check Constraints CK_Charge_MNNFLAG_Yes_Or_No : ([MNNFLAG]='N' OR [MNNFLAG]='Y')](../../../../Images/c-constraint.png) | MNNFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y- charge needs medical necesity to met. |
 ![Foreign Keys ABN_Status_ID: [dbo].[ABN_Intermediate_Status_DE].ABNStatusDE Foreign Keys ABN_Status_ID: [dbo].[ABN_Intermediate_Status_DE].ABNStatusDE](../../../../Images/fk.png) | ABNStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Medical Necessity Status. link to ABN_Intermediate_Status_DE.ID |
 ![Foreign Keys FK_Charge_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE Foreign Keys FK_Charge_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE](../../../../Images/fk.png) | BillingAreaDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Billing Area. Link to Billining_Area_DE.ID |
(2) | SubmittedByID | [dbo].[uniqueid] | 9 | NULL allowed | | | The user id of provider who submitted the charge. |
| StartTime | datetime | 8 | NULL allowed | | | Start time for time based charges |
 | EndTime | datetime | 8 | NULL allowed | | | End time for time based charges |
| ToothNumber | varchar(3) | 3 | NOT NULL | | ('0') | Tooth Number related to Dental related charges. |
 ![Foreign Keys FK_Charge_ToothSurfaceCodeDE: [dbo].[Tooth_Surface_Code_DE].ToothSurfaceCodeDE Foreign Keys FK_Charge_ToothSurfaceCodeDE: [dbo].[Tooth_Surface_Code_DE].ToothSurfaceCodeDE](../../../../Images/fk.png) | ToothSurfaceCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Tooth Surface for dental charges. Link to Tooth_Surface_Code_DE.ID |
 | InjuryAccountDescription | varchar(255) | 255 | NULL allowed | | | The account description, part of special billing info for encounter to which charge is linked |
 | InjuryAccountNumber | varchar(20) | 20 | NULL allowed | | | The account number, part of special billing info for encounter to which charge is linked |
 | DisplayOrder | smallint | 2 | NOT NULL | | (0) | Charge display order |
| NDC | char(12) | 12 | NOT NULL | | ('') | NDC |
| EncounterBillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Billing Location from the encounter. Link to Billing_Location_DE.ID |