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