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	NUMERIC	No
	The department in which to schedule visits created from this visit set.
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.