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
Treatment
Customized
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_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
11 IS_AUTOGENERATED_YN VARCHAR No
This item determines whether a care plan is autogenerated.
May contain organization-specific values: No
Category Entries:
No
Yes
12 PT_TSKS_STAT_C_NAME VARCHAR No
The current status of patient-assigned tasks within the care plan.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Paused
Partially Paused
13 PT_TSKS_STAT_RSN_C_NAME VARCHAR No
The reason for the current status of patient-assigned tasks within the care plan.
May contain organization-specific values: No
Category Entries:
Paused via Admission Behavior
Resumed via Admission Behavior
Paused via Extension
Resumed via Extension
Resumed via Patient To Do List
Clean-up Batch Job
14 PT_TSKS_START_LOCAL_DTTM DATETIME (Local) No
The instant in local time of when patient-assigned tasks were first present in the care plan. For a Care Companion care plan, this is synonymous with care plan's start instant.
15 PT_TSKS_END_LOCAL_DTTM DATETIME (Local) No
The instant in local time of when patient-assigned tasks in the care plan were no longer active. For a Care Companion care plan, this is synonymous with care plan's end instant.