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.