Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientRemitPayment
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientRemitPaymentSID | INTEGER | ? | MANDATORY | Unique ID for Remit File Payment Data from new sequence number PatientRemit |
| PatientRemitSID | INTEGER | ? | MANDATORY | FK - from PatientRemit |
| PracticeID | INTEGER | ? | MANDATORY | FK - Practice |
| Type | CHAR(1) | OPTIONAL | (P)ayment, (R)eversal, (D)enial | |
| Method | CHAR(1) | MANDATORY | Payment Method, e.g. Check, Cash, Credit Card, or Other | |
| TraceNumber | CHARACTER(20) | OPTIONAL | Trace number for tracking payment | |
| PaymentDate | DATE | OPTIONAL | Payment Date | |
| ExternalPatientID | CHAR(10) | MANDATORY | Account Number returned by processing center | |
| Amount | DECIMAL(10,2) | 0 | OPTIONAL | Payment Amount |
| CreditCardFee | DECIMAL(10,2) | 0 | OPTIONAL | Credit Card Fee |
| Voucher | CHARACTER(15) | OPTIONAL | Payment Voucher Number | |
| DoctorNumber | INTEGER | 0 | OPTIONAL | Doctor Number |
| DenialReason | CHARACTER(1) | OPTIONAL | Denial Reason Code | |
| 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 Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Practice | PatientRemitPayment.PracticeID = Practice.PracticeID | CASCADE if PatientRemitPayment exists |
| Child Table | Join Phrase | When deleting PatientRemitPayment record... |
|---|