Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PlanClaimRemit
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PlanID | INTEGER | ? | MANDATORY | FK |
| PolicyNumber | CHARACTER(20) | MANDATORY | FK | |
| ClaimSID | INTEGER | ? | MANDATORY | FK |
| RemitCount | INTEGER | 0 | MANDATORY | |
| PaymentSID | INTEGER | ? | OPTIONAL | Possible values are (I)nsurance, (G)uarantor |
| AdjudicationDate | DATE | MANDATORY | Check date on the remittance. | |
| ClaimFilingIndicatorCode | CHARACTER(20) | OPTIONAL | ||
| ANSIBalanced | CHARACTER(1) | OPTIONAL | ||
| CreateMethod | CHARACTER(1) | OPTIONAL | ||
| PayerID | CHARACTER(30) | OPTIONAL | ||
| 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. |
| BillSecUnbalanced | CHARACTER(1) | OPTIONAL | If 'Y' then Insurance Billing will continue to bill the claim electronically even if the remitted payment info does not balance. If 'N' then Insurance Billing will not bill the claim electronically if the remitted payment info does not balance. | |
| PracticeID | INTEGER | ? | OPTIONAL | FK - Indicates which Practice PlanClaimRemit is for. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Practice | PlanClaimRemit.PracticeID = Practice.PracticeID | RESTRICT if PlanClaimRemit exists |
| Payment | PlanClaimRemit.PaymentSID = Payment.PaymentSID | CASCADE if PlanClaimRemit exists |
| PlanClaim | PlanClaimRemit.PlanID = PlanClaim.PlanID and PlanClaimRemit.PolicyNumber = PlanClaim.PolicyNumber and PlanClaimRemit.ClaimSID = PlanClaim.ClaimSID |
CASCADE if PlanClaimRemit exists |
| Child Table | Join Phrase | When deleting PlanClaimRemit record... |
|---|---|---|
| PlanClaimChargeRemit | PlanClaimChargeRemit.PlanID = PlanClaimRemit.PlanID and PlanClaimChargeRemit.PolicyNumber = PlanClaimRemit.PolicyNumber and PlanClaimChargeRemit.ClaimSID = PlanClaimRemit.ClaimSID and PlanClaimChargeRemit.RemitCount = PlanClaimRemit.RemitCount |
CASCADE if PlanClaimChargeRemit exists |
| PlanClaimRemitMonetaryAmt | PlanClaimRemitMonetaryAmt.PlanID = PlanClaimRemit.PlanID and PlanClaimRemitMonetaryAmt.PolicyNumber = PlanClaimRemit.PolicyNumber and PlanClaimRemitMonetaryAmt.ClaimSID = PlanClaimRemit.ClaimSID and PlanClaimRemitMonetaryAmt.RemitCount = PlanClaimRemit.RemitCount |
CASCADE if PlanClaimRemitMonetaryAmt exists |
| PlanClaimRemitAdj | PlanClaimRemitAdj.PlanID = PlanClaimRemit.PlanID and PlanClaimRemitAdj.PolicyNumber = PlanClaimRemit.PolicyNumber and PlanClaimRemitAdj.ClaimSID = PlanClaimRemit.ClaimSID and PlanClaimRemitAdj.RemitCount = PlanClaimRemit.RemitCount |
CASCADE if PlanClaimRemitAdj exists |