TPL_SCHED_VST_DEP

Description:

This is the related-multi table for the 'Visit Department' item in the treatment plan scheduling group of tables. To be used with tables: TPL_SCHED_SELECTED TPL_SCHED_VST_KND TPL_SCHED_VST_LEN TPL_SCHED_VST_PROV TPL_SCHED_VST_TYP

Primary Key

Column Name	Ordinal Position
TREATMENT_PLAN_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	TREATMENT_PLAN_ID	NUMERIC	No
	The unique ID of the treatment plan.
2	GROUP_LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	VALUE_LINE	INTEGER	No
	The Value Count.
4	SCHEDULE_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.