PROBLEM

Description: |
This table contains data on care integrator problems associated with a patient.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PROBLEM_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PROBLEM_ID | VARCHAR | No |
The unique ID for the care integrator problem.
2 | TYPE_PROBLEM_ID_NAME | VARCHAR | No |
The name of the multidisciplinary diagnoses.
3 | CREATED_DATE | DATETIME | No |
The date the problem was added to the patient's care plan.
4 | DELETED_DATE | DATETIME | No |
The date the problem was removed from the patient's care plan.
5 | DEL_REASON_C_NAME | VARCHAR | No |
The reason a problem was removed.
May contain organization-specific values: Yes
6 | DISCIPLINE_C_NAME | VARCHAR | No |
The discipline associated with this problem.
May contain organization-specific values: Yes
7 | IP_DISC_TYPE_ID | VARCHAR | No |
The unique ID for the discipline associated with this problem.
8 | IP_DISC_TYPE_ID_DISC_NAME | VARCHAR | No |
The name of the discipline record.
9 | DISPLAY_NAME | VARCHAR | No |
This column shows the record's display name.
10 | PROBLEM_DESCRIPTION_HNO_ID | VARCHAR | No |
The linked note record for the care plan problem description. This column is frequently used to link to the HNO_INFO table.
11 | HH_EPISODE_ID | NUMERIC | No |
The associated episode ID for a care plan problem.
12 | CHILD_LAST_ADDED_DTTM | DATETIME (Local) | No |
The date and time when a goal or intervention was last added to the problem.
13 | IS_AUTOGENERATED_YN | VARCHAR | No |
This item determines whether a problem is autogenerated.
May contain organization-specific values: No
Category Entries:
No
Yes