PATIENT_PREF_TIME

Description:

The PATIENT_PREF_TIME table contains information of the patient's preferred appointment times during the day.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The ID of the patient with the preferred appointment time.
2	LINE	INTEGER	No
	The line number of the preferred appointment time of the patient.
3	PREF_TIME_BEGIN	DATETIME (Local)	No
	The patient's preferred begin time of the day for appointments. Note: There is no corresponding datatype to Time in enterprise reporting. To work around this, concatenate a default date (01/01/1900) in front of the time.
4	PREF_TIME_END	DATETIME (Local)	No
	The patient's preferred end time of the day for appointments. Note: There is no corresponding datatype to Time in enterprise reporting. To work around this, concatenate a default date (01/01/1900) in front of the time.