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	VARCHAR	No
	The unique ID for the multidisciplinary diagnosis associated with this problem.
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.