|
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. |
|
|