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 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 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 Estimate Variance Write-Off 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 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