Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ChargeCoverage
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ChargeSID | INTEGER | ? | MANDATORY | FK |
| CoverageOrder | INTEGER | 0 | MANDATORY | Coverage order number indicating which plan gets billed next. |
| PlanID | INTEGER | ? | MANDATORY | FK |
| PolicyNumber | CHARACTER(20) | MANDATORY | FK | |
| PersonID | INTEGER | ? | MANDATORY | FK |
| ClaimSID | INTEGER | ? | OPTIONAL | System generates unique ID using claim SID sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| AilmentSID | INTEGER | ? | OPTIONAL | FK |
| AssignBenefits | CHARACTER(1) | MANDATORY | Flag to indicate if the benefits have bee assigned to the provider. | |
| EMCBillable | CHARACTER(1) | OPTIONAL | Flag to indicate the charge may be billed via EMC. Valid values are (Y)es or (N)o. | |
| CurrentStatus | CHARACTER(8) | MANDATORY | Charge coverage current status. Acceptable values are: READY , BILLED , REBILL, VOIDED, WAIT , NONCOV and CLOSED | |
| 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. |
| PreBillBatchCode | CHARACTER(10) | OPTIONAL | Batch code for the prebill run of the charge. | |
| PreBillRunNumber | INTEGER | ? | OPTIONAL | Run number for the prebill run of the charge. |
| PreBillClaimSID | INTEGER | ? | OPTIONAL | ClaimSID generated for the prebill run of the charge. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Charge | ChargeCoverage.ChargeSID = Charge.ChargeSID | CASCADE if ChargeCoverage exists |
| Claim | ChargeCoverage.ClaimSID = Claim.ClaimSID | SET NULL if ChargeCoverage exists |
| PolicyMember | ChargeCoverage.PlanID = PolicyMember.PlanID and ChargeCoverage.PolicyNumber = PolicyMember.PolicyNumber and ChargeCoverage.PersonID = PolicyMember.PersonID |
RESTRICT if ChargeCoverage exists |
| Practice | ChargeCoverage.PracticeID = Practice.PracticeID | CASCADE if ChargeCoverage exists |
| Ailment | ChargeCoverage.AilmentSID = Ailment.AilmentSID | SET NULL if ChargeCoverage exists |
| Child Table | Join Phrase | When deleting ChargeCoverage record... |
|---|