Documentation/EHI_Export/docs/tables/ar_session.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| session_id | INT UNSIGNED | 10 | √ | null |
| ar_activity.session_id | Defined in XML | R |
|
|
The unique identifier for an accounting session, used as a surrogate key.
| | payer_id | INT | 10 | | | null |
|
| insurance_companies.id | Defined in XML | R |
|
The insurance company being billed. If this is self-pay the id will be 0
| | user_id | INT | 10 | | | null |
|
| users.id | Defined in XML | R |
|
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 |
|
| list_options.option_id | Defined in XML | R |
|
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 | TEXT | 65535 | √ | | NULL |
|
|
Additional description or notes related to the payment.
| | adjustment_code | VARCHAR | 50 | | | null |
|
| list_options.option_id | Defined in XML | R |
|
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 |
|
| patient_data.pid | Defined in XML | R |
|
The internal patient identifier
| | payment_method | VARCHAR | 25 | | | null |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘payment_method’ The method of payment, e.g., ACH, Cash, CC, Check, etc.
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | session_id |
| deposit_date | Performance | Asc | deposit_date |
| user_closed | Performance | Asc/Asc | user_id + closed |