MERGED_PROTOCOLS

Description:

This table links Pathway and SmartSet uses to the Pathway or SmartSet templates that were used to create them.

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	MERGE_PROTOCOL_ID	NUMERIC	No
	The unique ID of a protocol added to the treatment plan.
4	MERGE_PROTOCOL_ID_PROTOCOL_NAME	VARCHAR	No
	The SmartSet/Protocol record name. This is different from the display name, which is stored in CL_PRL_SS_OT.DISPLAY_NAME.
5	MERGED_PROTOCOL_DTE	FLOAT	No
	The CONTACT_DATE_REAL of a protocol added to the treatment plan.
6	MERGE_PROTOCOL_TY_C_NAME	VARCHAR	No
	The add method category number for a protocol added to this treatment plan. May contain organization-specific values: No Category Entries: Merge Protocol