TPL_CONVERSION_SESSIONS

Description:

This table contains information about treatment plan conversion sessions.

Primary Key

Column Name	Ordinal Position
TREATMENT_PLAN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TREATMENT_PLAN_ID	NUMERIC	No
	The unique identifier for the plan record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	CONVSESS_FROM_DAY	INTEGER	No
	The line in Treatment Day ID (I TPL 5000) of the first day in this conversion session.
4	CONVSESS_TO_DAY	INTEGER	No
	The line in Treatment Day ID (I TPL 5000) of the day after the last day in this session. This can be blank if the session includes the last day in the plan.
5	CONVSESS_STATUS_C_NAME	VARCHAR	No
	The status of a conversion session for this plan. May contain organization-specific values: No Category Entries: Accepted Discarded Started Active - Step 1 Active - Step 2
6	CONVSESS_TYPE_C_NAME	VARCHAR	No
	The type of a conversion session for a plan, whether inpatient or outpatient. May contain organization-specific values: No Category Entries: Inpatient Outpatient
7	CONVSESS_ACT_UTC_DTTM	DATETIME (UTC)	No
	The instant this conversion session action was done.
8	CONVSESS_ACT_USR_ID	VARCHAR	No
	The user who took this conversion session action.
9	CONVSESS_ACT_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.