PROB_CONTACT

Description:

This table contains contact specific information on care integrator problems associated with a patient.

Primary Key

Column Name	Ordinal Position
PROBLEM_ID	1
CONTACT_DATE_REAL	2

Column Information

	Name	Type	Discontinued?
1	PROBLEM_ID	VARCHAR	No
	The unique ID for the care integrator problem.
2	CONTACT_DATE_REAL	FLOAT	No
	The contact date for the problem in internal format.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	USER_ID	VARCHAR	No
	The unique ID of the user who added the problem.
5	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	LAST_EDIT_TIME	DATETIME (Local)	No
	The instant that this problem was last edited.
7	RESOLVED_YN	VARCHAR	No
	Indicates if this problem has been resolved. May contain organization-specific values: No Category Entries: YES NO
8	CP_PRIORITY_C_NAME	VARCHAR	No
	The priority level assigned to a given problem. May contain organization-specific values: Yes
9	START_DATE	DATETIME	No
	The start date assigned to begin work on a problem.
10	RESOLVED_DATE	DATETIME	No
	The date a problem is considered resolved.
11	PAT_CSN	NUMERIC	No
	Patient contact serial number (CSN) associated with a particular care plan problem contact.
12	READING_UTC_DTTM	DATETIME (UTC)	No
	Documents when the original reading contact was documented. Used to order active documentation readings in the order they clinically happened.
13	CONTACT_NUMBER	VARCHAR	No
	The serial number of the contact on the care plan problem record.
14	CAREPLAN_CSN_ID	NUMERIC	No
	The unique contact serial number of the care plan problem contact that is associated with the care plan.