VISIT_SET
Description:
The VISIT_SET table contains high-level information about a single visit set, which is a template for recurring visits to address the care required for a patient. Most workflow-related information in VST is overtime and found in the VISIT_SET_VERSION table.

Primary Key
Column Name Ordinal Position
VISIT_SET_ID 1

Column Information
Name Type Discontinued?
1 VISIT_SET_ID NUMERIC No
The unique identifier (.1 item) for the visit set record.
2 RECORD_STATUS_C_NAME VARCHAR No
Stores the record status (hidden, soft-deleted, etc...). Category values are stored in table ZC_RECORD_STATUS_2.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 RECORD_TYPE_VST_C_NAME VARCHAR No
The type of this visit set record, used to differentiate various implementations of the VST masterfile.
May contain organization-specific values: No
Category Entries:
Service Planning
4 SCHEDULING_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
5 ORDER_COMMENT_NOTE_ID VARCHAR No
The note record that contains order comments for all versions of the visit set. The order comment is reviewed and approved by a physician.
6 SCHED_INSTRUCTIONS_NOTE_ID VARCHAR No
The note record that contains scheduling instructions for all versions of the visit set. Scheduling instructions serve to provide additional context to schedulers and are neither reviewed nor approved by a physician.
7 RECORD_CREATION_DATE DATETIME No
Stores the date the record was created
8 PAT_ID VARCHAR No
The ID of the patient to whom this visit set belongs. This value is populated for visit sets associated with a Compass Rose episode.
9 HOME_HEALTH_DISCIPLINE_C_NAME VARCHAR No
The home health discipline associated with the visit set.
May contain organization-specific values: Yes