SYNOPTIC_RESULT_MAIN
Description:
This table contains synoptic information for a patient or a requisition grouper.

Primary Key
Column Name Ordinal Position
SYNOPTIC_ID 1

Column Information
Name Type Discontinued?
1 SYNOPTIC_ID NUMERIC No
The unique identifier for the synoptic result record.
2 SYNOPTIC_NAME VARCHAR No
The name of the synoptic result record.
3 SPECIMEN_LIST VARCHAR No
Stores a string of specimen names for this synoptic result record.
4 REC_STATUS_C_NAME VARCHAR No
The deletion status category ID for the synoptic result.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
5 SYN_EPT_PAT_ID VARCHAR No
The patient associated with this synoptic result.
6 SYN_RQG_PAT_RECORD_ID NUMERIC No
The requisition grouper associated with this synoptic result.
7 SYN_SOURCE_RES_SYNOPTIC_ID NUMERIC No
Pointer from an extracted synoptic result to the source synoptic result
8 SYN_EXTRACT_ST_C_NAME VARCHAR No
The status of the synoptic result extraction request
May contain organization-specific values: No
Category Entries:
Validation Only
Submitted
Received Results
Applied Results
Failed
9 SYN_RESULT_TYPE_C_NAME VARCHAR No
The type of synoptic form result this record represents
May contain organization-specific values: No
Category Entries:
Result
AI
10 CALCULATED_VAL_CNT INTEGER No
The number of elements on the form that were automatically calculated.
11 CALCULATED_MAN_CNT INTEGER No
The number of values on the form that were manually selected but could have been automatically calculated.
12 REPEAT_SOURCE_SYNOPTIC_ID NUMERIC No
Stores a pointer to the source synoptic result for this repeated section/question.
13 REPEAT_SOURCE_ELMNT_CONCEPT_ID VARCHAR No
Stores the ckey for the source element for this repeat section/question.
14 REPEAT_COUNTER INTEGER No
The counter to uniquely identify this repeat among other repeats for the same form.