Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Charge
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ChargeSID | INTEGER | ? | MANDATORY | System generated id using the Charge sequence. |
| PracticeID | INTEGER | ? | OPTIONAL | FK from Practice |
| StaffID | INTEGER | ? | MANDATORY | FK from Staff |
| PatientID | INTEGER | ? | OPTIONAL | FK from Patient |
| AccountSID | INTEGER | ? | MANDATORY | FK from Account |
| FinanceCenterID | INTEGER | ? | OPTIONAL | FK from FinanceCenter |
| JournalSID | INTEGER | ? | MANDATORY | FK from JournalDay |
| PostDate | DATE | MANDATORY | FK from JournalDay | |
| DepartmentCode | CHARACTER(3) | OPTIONAL | FK from Department | |
| ChargeType | CHARACTER(1) | MANDATORY | Charge type indicates if the charge was a procedure charge or admin charge. Possible values are (P)rocedure , (A)dmin and (I)nterest. | |
| AdminChargeCode | CHARACTER(10) | OPTIONAL | FK | |
| DefaultFeeOverrode | CHARACTER(1) | OPTIONAL | Programmatically set field which indicates the default fee as obtained from the proper profile was manually overridden. Possible values are (Y)es or (N)o. | |
| Amount | DECIMAL(10,2) | 0 | OPTIONAL | Amount of the charge. |
| ApprovedAmount | DECIMAL(10,2) | 0 | OPTIONAL | Amount of charge approved by primary insurance plan. |
| CopayAmount | DECIMAL(10,2) | 0 | OPTIONAL | The amount the patient will or has copayed. |
| VisitCopay | DECIMAL(10,2) | 0 | OPTIONAL | Amount of the visit copay amount. |
| DeductibleApplied | DECIMAL(10,2) | 0 | OPTIONAL | Amount of insurance deductible applied to the charge. |
| TaxAmount | DECIMAL(10,2) | 0 | OPTIONAL | NOT SUPPORTED. |
| CurrentStatus | CHARACTER(8) | OPTIONAL | Current status of charge. User selects charge status. Possible values: G - guarantor responsible charge , GT - responsibility manually transferred to guarantor , GA - responsibility automatically transferred to guarantor , I - insurance responsible charge , IU - unbilled insurance responsible charge, IT - responsibility manually transferred to insurance and IF - responsibility forwarded to insurance | |
| DateSatisfied | DATE | OPTIONAL | Programmatically set date which indicates the date the charge was satisfied. | |
| AssignBenefits | CHARACTER(1) | OPTIONAL | The assigned flag is used to indicate if assignment of benefits has been accepted. Possible values are (Y)es or (N)o. | |
| StmtCommentCode | CHARACTER(4) | OPTIONAL | User entered. Code for the statement. Field is supported by the lookup types:[StmntComment]. Values are defined in the LookupCode table for the above lookup types. | |
| GuarantorRespDate | DATE | OPTIONAL | The date in which the charge responsibility was set to guarantor. If the charge has no insurance coverage and it is a service charge, it will be set to the charge service date. If the charge was previously insurance responsible, the date will be set to the responsibility transfer date of the charge. If the charge is an Admin Charge it will be set to the post date. | |
| ForcePaperClaim | CHARACTER(1) | OPTIONAL | User set flag to indicate the charge must be billed via paper claim. Possible values are (Y)es or (N)o. Values are validated by the lookup type confirmation. | |
| PatientBilled | CHARACTER(1) | MANDATORY | Flag to indicate if the charge has been put on a bill to the patient. | |
| PatientStatement | CHARACTER(1) | MANDATORY | Flag to indicate if the charge has been put on a statement to the patient. | |
| RecordStatus | CHARACTER(1) | MANDATORY | System set status to indicate the state of the charge. Possible values are: (O)pen , (S)atisfied , (V)oided and (P) = OverPaid (i.e. negative charge balance) | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| GuarantorReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Amount of monies collected from the guarantor on the charge. |
| InsuranceReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Amount of monies collected from insurance on the charge. |
| Adjustments | DECIMAL(10,2) | 0 | OPTIONAL | Amount of monies in the form of adjustments on the charge. |
| Voucher | CHARACTER(20) | OPTIONAL | User entered voucher number. | |
| RespPartyType | CHARACTER(1) | OPTIONAL | Identifies the current responsibility for the charge. The responsibility may be guarantor or insurance plan. | |
| RespPartyID | INTEGER | ? | OPTIONAL | FK |
| PolicyNumber | CHARACTER(20) | OPTIONAL | FK | |
| RespCoverageOrder | INTEGER | 0 | MANDATORY | Coverage order of the responsible party on the charge. A value of 99 means guarantor. |
| VisitCopayClass | CHARACTER(6) | OPTIONAL | Records the Visit Copay Class used during Charge Posting. | |
| ChargeSourceModuleID | INTEGER | ? | OPTIONAL | System Defined. Records the module that created the charge. This should help debug problems seen in the field. |
| SevTwoRuleBillingHold | CHAR(2) | OPTIONAL | 72 Hour billing rule hold status. Possible values are: NU - User No NS - System No Y - Yes | |
| SevTwoRuleBillingHoldDate | DATE | OPTIONAL | 72 Hour billing rule hold date | |
| SevTwoRuleOffHoldUserID | INTEGER | 0 | OPTIONAL | 72 Hour billing rule hold userID |
| PatientOrderSetSID | INTEGER | ? | OPTIONAL | System-defined. System generated unique id using the "OMOrder" sequence. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PatientOrderSet | Charge.PatientOrderSetSID = PatientOrderSet.PatientOrderSetSID | RESTRICT if Charge exists |
| Policy | Charge.RespPartyID = Policy.PlanID and Charge.PolicyNumber = Policy.PolicyNumber |
RESTRICT if Charge exists |
| Account | Charge.AccountSID = Account.AccountSID | RESTRICT if Charge exists |
| Department | Charge.DepartmentCode = Department.DepartmentCode | RESTRICT if Charge exists |
| Staff | Charge.PracticeID = Staff.PracticeID and Charge.StaffID = Staff.StaffID |
CASCADE if Charge exists |
| FinanceCenter | Charge.FinanceCenterID = FinanceCenter.FinanceCenterID | RESTRICT if Charge exists |
| PatientAccount | Charge.PracticeID = PatientAccount.PracticeID and Charge.PatientID = PatientAccount.PatientID and Charge.AccountSID = PatientAccount.AccountSID |
RESTRICT if Charge exists |
| Child Table | Join Phrase | When deleting Charge record... |
|---|---|---|
| ChargeClaimNote | ChargeClaimNote.ChargeSID = Charge.ChargeSID | CASCADE if ChargeClaimNote exists |
| EAObjectData | EAObjectData.EAObjectSID = Charge.ChargeSID | CASCADE if EAObjectData exists |
| PlanClaimChargeRemit | PlanClaimChargeRemit.ChargeSID = Charge.ChargeSID | CASCADE if PlanClaimChargeRemit exists |
| EncounterEvent | EncounterEvent.ChargeSID = Charge.ChargeSID | SET NULL if EncounterEvent exists |
| ReferralTreatmentResult | ReferralTreatmentResult.ChargeSID = Charge.ChargeSID | CASCADE if ReferralTreatmentResult exists |
| ChargeAuxData | ChargeAuxData.ChargeSID = Charge.ChargeSID | CASCADE if ChargeAuxData exists |
| ClaimCharge | ClaimCharge.ChargeSID = Charge.ChargeSID | RESTRICT if ClaimCharge exists |
| CopayActivity | CopayActivity.ChargeSID = Charge.ChargeSID | CASCADE if CopayActivity exists |
| ChargeNote | ChargeNote.ChargeSID = Charge.ChargeSID | CASCADE if ChargeNote exists |
| ChargeActivity | ChargeActivity.ChargeSID = Charge.ChargeSID | CASCADE if ChargeActivity exists |
| ChargeCoverage | ChargeCoverage.ChargeSID = Charge.ChargeSID | CASCADE if ChargeCoverage exists |
| ProcedureEvent | ProcedureEvent.ChargeSID = Charge.ChargeSID | CASCADE if ProcedureEvent exists |