PAT_SVC_PROV_LIST_RECPNT

Description:

This table stores information of service provider list recipients that received the list through a guest link.

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 unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6	LIST_IDENT	INTEGER	No
	The unique ID in I EPT 97216 for the list that the recipient information is for.
7	RECIPIENT_NAME	VARCHAR	No
	The name of the service provider list recipient.
8	RECIPIENT_CONTACT_METHOD_C_NAME	VARCHAR	No
	The contact method used to send the service provider list to the recipient. May contain organization-specific values: No Category Entries: Text Email Both
9	RECIPIENT_PHONE	VARCHAR	No
	The phone number that was used to send the service provider list to the recipient.
10	RECIPIENT_EMAIL	VARCHAR	No
	The email that was used to send the service provider list to the recipient.
11	RECIPIENT_IS_NEW_CONTACT_YN	VARCHAR	No
	Indicates whether the recipient of a Patient Choice list is a new visit contact created when sharing the list. May contain organization-specific values: No Category Entries: No Yes