CASE_EVENT

Description: |
The CASE_EVENT table allows you to report on events associated with case records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CASE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CASE_ID | NUMERIC | No |
The unique ID of the case record.
2 | LINE | INTEGER | No |
The line number of the events associated with this case record.
3 | EVENT_C_NAME | VARCHAR | No |
The category number of the event.
May contain organization-specific values: Yes
Category Entries:
No-show
Noncompliance
Time off
Returned to work
Outside consultation
4 | EFF_DATE | DATETIME | No |
The effective date of the event.
5 | END_DATE | DATETIME | No |
The end date of the event.
6 | WORK_STATUS_C_NAME | VARCHAR | No |
The work status in the event.
May contain organization-specific values: Yes
7 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
8 | VENDOR_ID_VENDOR_NAME | VARCHAR | No |
The name of the vendor.
9 | COMMENTS | VARCHAR | No |
The comments of the event.
10 | USER_ID | VARCHAR | No |
The unique ID of the user who created the event.
11 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.