VISIT_SET_VERSION
Description:
The VISIT_SET_VERSION table contains overtime information about a single visit set, which are templates for recurring visits to address the care required for a patient.

Primary Key
Column Name Ordinal Position
VISIT_SET_ID 1
CONTACT_DATE_REAL 2

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 CONTACT_DATE DATETIME No
The date of this contact.
4 VISIT_SET_CSN_ID NUMERIC No
The contact serial number (CSN) of the contact.
5 CONTACT_NUM INTEGER No
The contact number
6 VISIT_TYPE_ID VARCHAR No
The visit type of appointments scheduled from this visit set.
7 START_DATE DATETIME No
The start date of the visit set.
8 END_DATE DATETIME No
The end date of the visit set.
9 DURATION_MINUTES INTEGER No
The duration, in minutes, of the visit defined by this version of the visit set.
10 ORDER_COMMENT_NOTE_CSN_ID NUMERIC No
The CSN of the version of the note record that contains the order comment for this version of the visit set. The order comment is reviewed and approved by a physician.
11 SCHED_INSTRUCTIONS_NOTE_CSN_ID NUMERIC No
The CSN of the version of the note record that contains the scheduling instructions for this version of the visit set. Scheduling instructions serve to provide additional context to schedulers and are neither reviewed nor approved by a physician.
12 FREQUENCY_FREQ_ID VARCHAR No
The frequency record (EFQ) that defines the recurrence of visits for this version of the visit set. Only specified frequencies of type 'same time days of week' and 'relative' are supported.
13 FREQUENCY_FREQ_ID_FREQ_NAME VARCHAR No
The name of the frequency record.
14 VISIT_RECUR_PATTERN_TYPE_C_NAME VARCHAR No
The type of the visit pattern.
May contain organization-specific values: No
Category Entries:
Daily
Weekly
15 VISIT_PATTERN_RECURRENCE INTEGER No
How often visits defined by this version of the visit set should recur.
16 TIME_WINDOW_BEGIN_TM DATETIME (Local) No
The beginning of the time window during which it is acceptable to schedule visits defined by this version of the visit set. If both start and end times are specified, visits must begin within those times. If only a start time is specified, visits must begin at that time. At least a start time is required.
17 TIME_WINDOW_END_TM DATETIME (Local) No
The end of the time window during which it is acceptable to schedule visits defined by this version of the visit set. If both start and end times are specified, visits must begin within those times. If only a start time is specified, visits must begin at that time. At least a start time is required.
18 TOLERANCE_BEFORE_DAYS INTEGER No
The number of days before the specified date that it is acceptable to schedule visits defined by this version of the visit set.
19 TOLERANCE_AFTER_DAYS INTEGER No
The number of days after the specified date that it is acceptable to schedule visits defined by this version of the visit set.
20 AUTO_GENERATED_YN VARCHAR No
Whether or not this version of the visit set was automatically generated. This is always populated with either Yes or No.
May contain organization-specific values: No
Category Entries:
No
Yes
21 INSTANT_OF_ENTRY_DTTM DATETIME (Local) No
Stores the instant of entry when a record is edited