| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| session_id | INT UNSIGNED | 10 | √ | null |
|
|
The unique identifier for an accounting session, used as a surrogate key. |
||||
| payer_id | INT | 10 | null |
|
|
The insurance company being billed. If this is self-pay the id will be 0 |
|||||
| user_id | INT | 10 | null |
|
|
The reference to the user ID the created this billing session |
|||||
| closed | BOOLEAN | 3 | 0 |
|
|
A flag indicating if the session is closed. 0 for open, 1 for closed. |
|||||
| reference | VARCHAR | 255 | '' |
|
|
The check or EOB (Explanation of Benefits) number associated with the payment. |
|||||
| check_date | DATE | 10 | √ | NULL |
|
|
The date when the check was received for the payment. |
||||
| deposit_date | DATE | 10 | √ | NULL |
|
|
The date when the payment was deposited. |
||||
| pay_total | DECIMAL | 12,2 | 0.00 |
|
|
The total payment amount for the claim or billing invoice. |
|||||
| created_time | TIMESTAMP | 19 | current_timestamp() |
|
|
The timestamp when the payment record was created. |
|||||
| modified_time | DATETIME | 19 | null |
|
|
The date and time of the last modification to the payment record. |
|||||
| global_amount | DECIMAL | 12,2 | null |
|
|
The global amount for the payment. |
|||||
| payment_type | VARCHAR | 50 | null |
|
|
Comes from the list_options.list_id=‘payment_type’ and represents the type of payment, such as if this is a patient or insurance payment. |
|||||
| description | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
Additional description or notes related to the payment. |
||||
| adjustment_code | VARCHAR | 50 | null |
|
|
Comes from the list_options.list_id=‘payment_adjustment_code’ and represents the payment adjustment code to apply. |
|||||
| post_to_date | DATE | 10 | null |
|
|
The date when the payment is posted to the claim or billing invoice. |
|||||
| patient_id | BIGINT | 19 | null |
|
|
The internal patient identifier |
|||||
| payment_method | VARCHAR | 25 | null |
|
|
Comes from the list_options.list_id=‘payment_method’ The method of payment, e.g., ACH, Cash, CC, Check, etc. |