PAT_MYC_EVIST_PMNT
Description:
During an e-visit encounter, a message may be sent to the patient containing an e-visit payment request task. This table contains a list of those messages. Typically only one payment request will be sent per encounter, however it is possible to have multiple payment requests therefore the primary key of this table is comprised of PAT_ENC_CSN_ID, and LINE in which LINE is used to identify each payment request message associated with the encounter.

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
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2 LINE INTEGER No
The line count used to identify different messages containing payment links for each encounter.
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 CM_CT_OWNER_ID VARCHAR No
ID of the deployment owner for this contact.
5 PMNT_RQST_MSG_ID VARCHAR No
The unique identifier for the patient message records associated with this encounter that contain payment tasks.