SYNDRO_SURV_EVENTS

Description:

Contains syndromic surveillance event information.

Primary Key

Column Name	Ordinal Position
SYNDRO_SURV_EVENT_ID	1

Column Information

	Name	Type	Discontinued?
1	SYNDRO_SURV_EVENT_ID	NUMERIC	No
	The unique identifier (.1 item) for the syndromic surveillance event record.
2	RECORD_STATUS_2_C_NAME	VARCHAR	No
	Stores the record status (hidden, soft-deleted, etc.). May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
3	SYNDRO_REGISTRY_ID	NUMERIC	No
	The unique ID of the syndrome (HFR) for the syndromic surveillance event.
4	SYNDRO_REGISTRY_ID_REGISTRY_NAME	VARCHAR	No
	The name of the registry record.
5	PAT_ID	VARCHAR	No
	The unique ID of the patient for the syndromic surveillance event.
6	CONTRIBUTING_EVENT_DATE	DATETIME	No
	The date that the syndromic surveillance event contributes to the syndrome count.
7	DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
8	POSTAL_CODE_RAW	VARCHAR	No
	The raw postal code that the syndromic surveillance event contributes to in the syndrome trend.
9	HOSPITAL_ONSET_YN	VARCHAR	No
	Indicates whether the syndromic surveillance event is considered hospital onset. 'Y' indicates that the event is considered hospital onset. 'N' or NULL indicate that the event is not considered hospital onset. May contain organization-specific values: No Category Entries: No Yes
10	RECORD_CREATION_DATE	DATETIME	No
	The date the record was created.