ar_session


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of ar_session.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Accounts Receivable overall payment made towards a patient invoice/claim and is the main table that holds the patient payments ledger

Columns

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 MEDIUMTEXT 16777215 √ 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.

Indexes

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

Relationships

Close relationships within degrees of separation