|
Name |
Type |
Discontinued? |
|
1 |
CASE_ID |
NUMERIC |
No |
|
|
|
The internal ID of the case record. |
|
|
2 |
CONTACT_DATE_REAL |
FLOAT |
No |
|
|
|
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day. |
|
|
3 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
Contact date in external format |
|
|
4 |
CONTACT_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The contact type category ID for the case event. |
May contain organization-specific values: Yes |
Category Entries: |
Case created |
|
|
5 |
CONTACT_SEVERITY_C_NAME |
VARCHAR |
No |
|
|
|
The contact severity category ID for the case event. |
May contain organization-specific values: Yes |
|
|
6 |
REVIEWED_DATE |
DATETIME |
No |
|
|
|
Date the contact was reviewed |
|
|
7 |
REVIEWED_BY_USER_ID |
VARCHAR |
No |
|
|
|
User who reviewed the contact |
|
|
8 |
REVIEWED_BY_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
9 |
CONTACT_SUMMARY |
VARCHAR |
No |
|
|
|
The case contact summary. |
|
|