PAT_ENC_APPT

Description:

The PAT_ENC_APPT table contains basic information about the appointment records in your system. Since one patient encounter can be an appointment with multiple providers and resources (joint appointment), the primary key of this table comprises PAT_ENC_CSN_ID, and LINE in which LINE is used to identify each provider within the appointment.

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 serial number for this encounter. This number is unique across all patients and encounters in the system.
2	LINE	INTEGER	No
	Used to identify the provider within one appointment.
3	CONTACT_DATE	DATETIME	No
	The date on which the encounter took place.
4	DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
5	PROV_START_TIME	DATETIME (Local)	No
	The date and time that the appointment is scheduled to begin with this provider, such as 01/10/2000 14:45.
6	APPT_PROV_PRIMARY_SPECIALTY_C_NAME	VARCHAR	No
	The provider's primary specialty for this appointment May contain organization-specific values: Yes