PAT_CR_TX_SINGLE
Description:
This table contains single 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

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 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.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 CM_CT_OWNER_ID VARCHAR No
The ID of the contact owner.