V_PatientPayment
The V_PatientPayment view displays patient payments by transaction date. This view displays only the amount a patient has paid, and does not display outstanding patient balances. The view contains the following data:
| Column Heading | Unique to SQL Database | Description |
|---|---|---|
|
Patientid |
|
The Patient ID number displayed on the patient profile. |
|
TransactionDate |
|
The date of the transaction. |
|
OrderID |
|
Unique ID number for the lab order; displayed on the patient’s Orders and Transactions pages. |
|
PaymentID |
|
Unique ID number for the payment; displayed on the invoice for the transaction. |
|
TransactionAmount |
|
The total amount, in dollars, that the patient is expected to pay. The amount includes the copay, if any. |
|
TotalPayment |
|
The total amount, in dollars, that the patient has paid so far. |
|
isJustCredit |
Y |
0 = No customer credit was applied to the transaction. 1 = Some customer credit was applied to the transaction. |
|
CreditPayment |
|
The dollar amount the patient paid with credit card. |
|
CashPayment |
|
The dollar amount the patient paid with cash or check. |
|
CustomerCreditPayment |
|
The dollar amount of customer credit applied to the transaction. |
You can filter the data by the transaction date.
Here is an example of the V_PatientPayment view imported into a spreadsheet:
