Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
Claim
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ClaimSID | INTEGER | ? | MANDATORY | System generated unique id using claim sequence. |
| PracticeID | INTEGER | ? | OPTIONAL | FK |
| PatientID | INTEGER | ? | OPTIONAL | FK |
| AccountSID | INTEGER | ? | MANDATORY | FK |
| AilmentSID | INTEGER | ? | OPTIONAL | FK |
| ClaimNumber | CHARACTER(20) | OPTIONAL | System generated unique id using the formula below: YYMM#### where first Y is base 36 second Y is 0-9 MM is 1-12 #### is base 36. | |
| SatisfiedDate | DATE | ? | OPTIONAL | If the claim is satisfied then this field will contain the date the claim was satisfied, otherwise the date will be ?. |
| AssignBenefits | CHARACTER(1) | MANDATORY | Flag to indicate if the benefits are assigned directly to the provider. | |
| 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. |
| LowestRespCoverageOrder | INTEGER | 0 | MANDATORY | System generated. Lowest responsible coverage order for all charges in the claim. Important Note: Coverage Order 99 represents guarantor responsible. |
| ParentClaimSID | INTEGER | ? | OPTIONAL | System generated unique id using claim sequence. |
| LegacyClaimNumber | CHARACTER(20) | OPTIONAL | Patient Control Number - the number sent out to identify the Claim in the Legacy system. This field is only set by the "General Conversion". | |
| Converted | CHARACTER(1) | No_Value__N_ | OPTIONAL | Indicates if the record was created by the Converter - Y indicates that Yes the record was created by the General Conversion. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Claim | Claim.ParentClaimSID = Claim.ClaimSID | NONE if Claim exists |
| Ailment | Claim.AilmentSID = Ailment.AilmentSID | RESTRICT if Claim exists |
| PatientAccount | Claim.PracticeID = PatientAccount.PracticeID and Claim.PatientID = PatientAccount.PatientID and Claim.AccountSID = PatientAccount.AccountSID |
CASCADE if Claim exists |
| Child Table | Join Phrase | When deleting Claim record... |
|---|---|---|
| Claim | Claim.ParentClaimSID = Claim.ClaimSID | NONE if Claim exists |
| ClaimCharge | ClaimCharge.ClaimSID = Claim.ClaimSID | CASCADE if ClaimCharge exists |
| ChargeCoverage | ChargeCoverage.ClaimSID = Claim.ClaimSID | SET NULL if ChargeCoverage exists |
| PlanClaim | PlanClaim.ClaimSID = Claim.ClaimSID | CASCADE if PlanClaim exists |