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.