TPL_UPDATE_INFO

Description:

The update information for the treatment plan.

Primary Key

Column Name	Ordinal Position
TREATMENT_PLAN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TREATMENT_PLAN_ID	NUMERIC	No
	The treatment plan ID.
2	LINE	INTEGER	No
	The line number that corresponds to each update of the treatment plan in this row.
3	UPDATED_BY_USER_ID	VARCHAR	No
	The user ID of the person who performed an update of the treatment plan in this row.
4	UPDATED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	UPDATED_ON_TM	DATETIME (Local)	No
	The date/time in external format of an update to the treatment plan in this row.
6	UPDATED_IN_PAT_ENC_CSN_ID	NUMERIC	No
	Stores the contact serial number (CSN) of a patient visit in which this plan was updated and saved. This item is empty if the update occurred outside of an encounter context.