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	VARCHAR	No
	The unique ID of the provider in the event.
8	VENDOR_ID	VARCHAR	No
	The unique ID of the vendor in the event.
9	VENDOR_ID_VENDOR_NAME	VARCHAR	No
	The name of the vendor.
10	COMMENTS	VARCHAR	No
	The comments of the event.
11	USER_ID	VARCHAR	No
	The unique ID of the user who created the event.
12	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.