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.