CAREPLAN_INFO

Description:

Contains information about care plan template records.

Primary Key

Column Name	Ordinal Position
CARE_INTG_ID	1

Column Information

	Name	Type	Discontinued?
1	CARE_INTG_ID	VARCHAR	No
	The unique identifier for the care plan record.
2	CAREPLAN_TYPE_C_NAME	VARCHAR	No
	The category ID of the type of the care plan record (Collaborative or Home Health). May contain organization-specific values: No Category Entries: Home Health/Hospice Collaborative Outpatient Care Plan Reading
3	PAT_ENC_CSN_ID	NUMERIC	No
	The linked unique contact serial number for the patient. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI). This column is frequently used to link to the PAT_ENC_HSP table.
4	PATIENT_ID	VARCHAR	No
	Links OP care plan (patient-level and episodic) to the associated patient
5	LINKED_PAT_CAREPLAN_YN	VARCHAR	No
	Indicates whether the outpatient care plan is linked at the patient level or the episode level. Yes means it is patient level, No means it is episode level.
6	RFL_INSTR_NOTE_ID	VARCHAR	No
	Stores the ID of the HNO record that contains the referral instructions
7	READING_CAREPLAN_ID	VARCHAR	No
	The link to the care plan reading Care Plan record.
8	LAST_EDITED_DTTM	DATETIME (Local)	No
	The date and time when the care plan was last edited. This does not include documentation-only changes.
9	RECORD_STATUS_2_C_NAME	VARCHAR	No
	Record status flag. Used in conjunction with record archived flag for encounter archiving. May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
10	PAT_ENROLL_DEPARTMENT_ID	NUMERIC	No
	This item stores the department which enrolled the patient in MyChart care plan.