Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PlanClaimCharge
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PlanID | INTEGER | ? | MANDATORY | FK |
| ClaimSID | INTEGER | ? | MANDATORY | FK |
| PolicyNumber | CHARACTER(20) | MANDATORY | FK | |
| LineItem | INTEGER | 0 | MANDATORY | FK |
| ChargeSID | INTEGER | ? | MANDATORY | FK |
| BilledAmount | DECIMAL(10,2) | ? | OPTIONAL | This is the charge's billed amount for this plan claim's last billing run. Note: The line item's billed amount is denormalized on the PlanClaimLineItemData.Amount field. Note: This field was added in 5.00.00 and it is possible that this field is null (?) for prior charges. |
| 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. |
| PatReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all guarantor receipts on the charge as of claim generation. See PlanClaimLineItemData.PatReceipts for the complete patient receipts on the line item. Used by insurance billing's masterfields. |
| InsReceipts | DECIMAL(10,2) | 0 | OPTIONAL | Sum of all Insurance receipts on the charge as of claim generation. See PlanClaimLineItemData.InsReceipts for the complete insurance receipts on the line item. Used by insurance billing's masterfields. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PlanClaimLineItem | PlanClaimCharge.PlanID = PlanClaimLineItem.PlanID and PlanClaimCharge.PolicyNumber = PlanClaimLineItem.PolicyNumber and PlanClaimCharge.ClaimSID = PlanClaimLineItem.ClaimSID and PlanClaimCharge.LineItem = PlanClaimLineItem.LineItem |
CASCADE if PlanClaimCharge exists |
| ClaimCharge | PlanClaimCharge.ClaimSID = ClaimCharge.ClaimSID and PlanClaimCharge.ChargeSID = ClaimCharge.ChargeSID |
CASCADE if PlanClaimCharge exists |
| Child Table | Join Phrase | When deleting PlanClaimCharge record... |
|---|