HH_INTVTN_ENC

Description: |
Contains Home Health care plan intervention overtime single items information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INTERVENTION_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INTERVENTION_ID | VARCHAR | No |
Unique identifier for the care plan intervention.
2 | CONTACT_DATE_REAL | FLOAT | No |
Unique identifier for this contact for this patient.
3 | CONTACT_NUM | VARCHAR | No |
Contact number.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | CM_CT_OWNER_ID | VARCHAR | No |
ID of the contact owner deployment for this record. Links to table CL_COMMUNTY_INSTNC.
6 | INT_START_DT | DATETIME | No |
Care plan intervention start date.
7 | INT_RESOLV_DT | DATETIME | No |
Care plan intervention resolved date.
8 | EDIT_USER_ID | VARCHAR | No |
User ID of person who edited care plan intervention data. Links to table CLARITY_EMP.
9 | EDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | EDIT_INSTANT | DATETIME (Local) | No |
Instant at which care plan intervention was edited.
11 | INTV_FREQ_ID | VARCHAR | No |
Care plan intervention frequency ID. Links to table IP_FREQUENCY.
12 | INTV_FREQ_ID_FREQ_NAME | VARCHAR | No |
The name of the frequency record.
13 | SCHEDULED_VISITS | VARCHAR | No |
Care plan intervention scheduled visits.
14 | CARE_PLAN_CSN | VARCHAR | No |
Link to care plan contact. Used to recreate historic versions of care plan.
15 | HAS_PENDED_ORDER_YN | VARCHAR | No |
Determines whether the intervention order was created but not sent. This is set to Yes if any user created an intervention order without sending it; No if an order is not created or it was created and already sent.
May contain organization-specific values: No
Category Entries:
No
Yes
16 | HOME_CARE_ORDER_ID | VARCHAR | No |
This item stores the supplemental order ID that is created or generated for care plan intervention edit.