PLAN_PROB_HX_EVENTS

Description:

This table contains problem history contact serial numbers (CSNs) and lines to link problem history events to treatment plans that generated them. Problem history events are stored in the PROBLEM_EVENTS table.

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	PROBLEM_HX_CSN	NUMERIC	No
	This item contains the problem history contact serial number (CSN) that this treatment plan is linked to.
4	PROB_HX_EVENT_LINE	INTEGER	No
	This item contains the line from the Problem Event State (I LPL 8100) that this treatment plan is associated with.