VISIT_SET_SLOT

Description:

The VISIT_SET_SLOT table contains slots for visit set versions. A slot is a target for an individual visit to occur, containing an appointment request generated to achieve the visit and other information surrounding its fulfillment.

Primary Key

Column Name	Ordinal Position
VISIT_SET_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	VISIT_SET_ID	NUMERIC	No
	The unique identifier (.1 item) for the visit set record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact.
5	SLOT_PERIOD	INTEGER	No
	The period within the visit set in which the slot falls. A period is the smallest repeatable date window of a visit set, or the unit of its repeating pattern. For example, if a visit set is set to be every week on Monday, Wednesday, and Friday, each period would represent a week. Period 1 is week 1, period 2 is week 2, and so on. To determine this unit, link to VISIT_SET_VERSION and look to VISIT_PATTERN_TYPE_C or FREQUENCY_FREQ_ID (one or the other is populated, not both).
6	SLOT_INDEX	INTEGER	No
	The index of the slot in its period. With N being the slot index, this means the Nth slot in the period. For example, if a visit set is set to be every week on Monday, Wednesday, and Friday, index 1 identifies a slot that falls on Monday, index 2 identifies a slot that falls on Wednesday, and index 3 identifies a slot that falls on Friday. Link to VISIT_SET_VISIT_PATTERN and look to VISIT_SET_WHICH_DAYS_C to find the days of the week of a visit set. A LINE of VISIT_SET_VISIT_PATTERN contains the same day of the week on which the SLOT_INDEX of the same value identifies.
7	SLOT_STATUS_C_NAME	VARCHAR	No
	The status of the slot May contain organization-specific values: No Category Entries: Requested Scheduled Paused Canceled Missed Manual Placeholder Request Canceled Completed Request Error Unused Past Slot
8	SLOT_APPT_REQUEST_ID	NUMERIC	No
	The appointment request created to fill this slot
9	SLOT_DATE	DATETIME	No
	The date for the slot calculated based on the visit set recurrence, period, and index. In addition to corresponding to the requested date on the ORD appointment request, it is used to match slots during evaluation and to determine whether a slot is skipped due to episode pauses.