Last Updated: 9/24/2025 12:09:38 PM

Intergy Version: 22.00.00.00

ClaimCharge

Table Definition Parent Tables Child Tables

Table Definition

Description: This table is used to store the detail information for a line item within a claim. A line item is generated for each charge to be placed on the claim.

Field	Datatype	Default	Null Option	Comment
ClaimSID	INTEGER	?	MANDATORY	FK
ChargeSID	INTEGER	?	MANDATORY	FK
CurrentStatus	CHARACTER(8)		OPTIONAL	Claim line item current status.
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.

Parent Tables

Parent Table Join Phrase When deleting parent record...

Charge ClaimCharge.ChargeSID = Charge.ChargeSID RESTRICT if ClaimCharge exists

Claim ClaimCharge.ClaimSID = Claim.ClaimSID CASCADE if ClaimCharge exists

Child Tables

Child Table	Join Phrase	When deleting ClaimCharge record...
PlanClaimCharge	PlanClaimCharge.ClaimSID = ClaimCharge.ClaimSID and PlanClaimCharge.ChargeSID = ClaimCharge.ChargeSID	CASCADE if PlanClaimCharge exists