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