APPT_LENGTH_OVERRIDE
Description:
This table contains information about why an appointment's length was different than its scheduled length.

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 OVERRIDE_LENGTH INTEGER No
If the scheduled length of an appointment is not the expected length, enter the expected length here. This does not change the length of the appointment but does visually change how long the appointment is in the Rooming view of the Visit Assignment Wizard.
7 APPT_LEN_OVRD_REASON_C_NAME VARCHAR No
The reason for changing the expected length of an appointment.
May contain organization-specific values: Yes
Category Entries:
Add on Blood
Add on Hydration
Add on Medication
Pharmacy
Lab
Reaction
Patient Specific Factors
Other
8 OVERRIDE_COMMENT VARCHAR No
A comment about overriding an appointment's expected length.
9 OVERRIDE_USER_ID VARCHAR No
The user who changed the expected length of the appointment.
10 OVERRIDE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 OVERRIDE_INSTANT_DTTM DATETIME (Attached) No
The time when the expected length of the appointment was set.