CARE_PLAN_INT_INFO

Description:

Extracts identifying information about the Care Plan Interventions associated with the treatment plan (ID, day, user, and instant).

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	IP_CP_INT_TRTDAY_ID	NUMERIC	No
	Stores treatment day Care Plan intervention was added from
4	IP_CP_INT_USR_ID	VARCHAR	No
	Stores user that added Care Plan intervention from Pathway
5	IP_CP_INT_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	IP_CP_INT_INST_DTTM	DATETIME (Local)	No
	Stores instant Care Plan intervention was added from Pathway