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.