PAT_ENC_APPT_TIME_SUGG

Description:

Each row in this table represents an individual suggestion to move a patient's appointment to a different time. A user sends the suggestion to the people responsible for scheduling the appointment the suggestion is being made for, and the row records who suggested it, the time they proposed, and how it was ultimately resolved. An appointment can receive more than one suggestion, so it can have more than one row here.

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	APPT_SUGG_TIME_UTC_DTTM	DATETIME (UTC)	No
	The proposed date and time for an appointment made by a user from the Suggest Change popup in the Brain. Stored in UTC.
7	APPT_SUGG_STATUS_C_NAME	NUMERIC	No
	The current status of the suggested time for an appointment. May contain organization-specific values: No Category Entries: Pending Rejected Withdrawn Obsolete Applied No Suggested Time
8	APPT_SUGG_USER_ID	VARCHAR	No
	The user who proposed the suggested time for the appointment.
9	APPT_SUGG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	APPT_SUGG_INSTANT_UTC_DTTM	DATETIME (UTC)	No
	The date and time the user suggested a new time for the appointment. Stored in UTC.
11	APPT_SUGG_RSLV_USER_ID	VARCHAR	No
	The user who resolved the time suggestion. This item is blank when the suggestion is pending.
12	APPT_SUGG_RSLV_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
13	APPT_SUGG_RSLV_INST_UTC_DTTM	DATETIME (UTC)	No
	The date and time the time suggestion was resolved. Stored in UTC. This item is blank when the suggestion is pending.