PAT_CR_TX_RELATED

Description: |
This table contains related response information about the credit card transaction associated with an e-visit encounter that is stored in the patient record when the encounter is created.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The contact serial number is unique across all patients and all contacts.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | PAT_ENC_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | CM_CT_OWNER_ID | VARCHAR | No |
The ID of the contact owner.
6 | CR_TX_AMOUNT_AUTH | NUMERIC | No |
The amount authorized on the credit card.
7 | CR_TX_INSTANT | DATETIME (Local) | No |
The instant the status was updated.
8 | CR_TX_STATUS_C_NAME | VARCHAR | No |
The status of the transaction.
May contain organization-specific values: No
Category Entries:
Authorized
Charged
Cancelled
Failed
9 | CARDHOLDER_NAME | VARCHAR | No |
To store the name of the pre-auth credit card holder .
10 | CREDIT_CARD_BRAND_C_NAME | VARCHAR | No |
To store the card brand of the pre-auth credit card
May contain organization-specific values: Yes
Category Entries:
Visa
MasterCard
American Express
Discover
Diners Club
Health Benefit
Bank Account (Unknown Type)
Checking Account
Savings Account
Other
11 | EXP_MONTH | VARCHAR | No |
To store the expiration month of the pre-auth credit card
12 | EXP_YEAR | VARCHAR | No |
To store the expiration year of the pre-auth credit
13 | TX_SOURCE_C_NAME | VARCHAR | No |
Stores the transaction source application for copay only pre-authorized transactions. For example, it will store "MyChart Web" for a payment made via MyChart website.
May contain organization-specific values: No
Category Entries:
Transaction Import
Interface
EpicCare
Daily Charge
Bed Charge
Batch Charge Entry
Unit Charge Entry
Payment Posting
Adjustment Posting
Post Adjustment - Account Maintenance
Reverse Transaction - Account Maintenance
Reversal and Repost
Charge Correction
Order Trigger
Transfer Transaction
Combine Accounts
Electronic Remittance
HB Only Quick Payment Posting
Account Maintenance - Actions
Revenue Reclassification - Account Class Change
Revenue Reclassification - Financial Class Change
Claims Accept - Bucket Split
Small Balance Write-Off
System Auto Action
Hourly Charge
Expected Not-Allwd-Auto Write-Off
Claim Denial Payment
Willow Inpatient
Refund - Account Maintenance
OpTime
Radiant
MyChart Web
EpicCare Inpatient
Resolute Professional Billing
Emergency Dept
Home Health
Lab
Cohort
Enterprise Payment Posting
Charge Router Charge Entry
Self-Pay Discount
Payment Collection
Late Fee
Tx Report - Add Corresponding Charge
Patient Refund
Welcome
Cardiology
Obstetrics
Handheld
Late Charge Write-Off
Hospice Per Diem
Hospice
Surcharge
Adjustment Import
DBC Product
DBC Accepted Invoice
Willow Ambulatory
Anesthesia
Reverse Transaction - Tx Report
Billing Activity
Web Service
HB Coding
Auto Pay Payment Plan
Distribution
Claim Accept - Balancing Adjustment
Duplicated Charge
Billing Charge Write-Off
Transaction Classification Balancing
Financial Assistance
Cumulative Billing
MyChart Mobile
Pay as Guest
Unbilled Expected Write-Off
DBC Denied Invoice
Bundle Payment Distribution
DBC Denied Invoice - Ignored
Balance Transfer In
Balance Transfer Out
Balance Correct In
Balance Correct Out
Visit Auto Pay
Trust Transfer
Trust Recurring Payment
Notification Billing
Advance Billing
Two-Way SMS
Linked Procedure
Coverage Automation - Plan Change
Estimate Variance Write-Off
Multi-Instance Consolidated Balances
Virtual Assistant
Tax Charge
Beans
Compass Rose
14 | DIGITAL_WALLET_C_NAME | VARCHAR | No |
Stores the digital wallet used to make the credit card payment
May contain organization-specific values: No
Category Entries:
Apple Pay
Google Pay
15 | CR_LAST_FOUR | VARCHAR | No |
Stores the last four digits of the payment method used to make a pre-authorization for a copay.
16 | PAT_PMT_COLL_WKFL_C_NAME | VARCHAR | No |
The payment collection workflow category used by billing for reporting. See ECT-41109 for possible values.
May contain organization-specific values: No
Category Entries:
Staff Collected
MyChart Billing
MyChart One-Touch
MyChart Pay as Guest
MyChart Visit Payment
MyChart eCheck-in
MyChart Virtual Assistant
Welcome Balance Payment
Welcome Check-in
Two-Way SMS
Payment Posting
Lockbox
Release of Information
Willow Ambulatory
Web Service
17 | PAT_PMT_MYC_AUTH_C_NAME | VARCHAR | No |
The MyChart authentication method at the time of preauthorization. See ECT-41110 for possible values.
May contain organization-specific values: No
Category Entries:
Password Sign-in
Demographics Sign-in
No Sign-in