DOCS_RCVD_RES_COMP
Description:
The DOCS_RCVD_RES_COMP table contains information about compiled results components.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique ID of received documents.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 RES_CMP_KEY_CMP VARCHAR No
The key which links the component with the order.
4 RES_COMP_NAME_CMP VARCHAR No
The free text name of the result component.
5 RES_CMP_CMP_ID NUMERIC No
The internal ID of the component to which this result was mapped. This column links to the CLARITY_LRR table.
6 RES_CMP_CMP_ID_NAME VARCHAR No
The name of the component.
7 RES_COMP_ABBR_COMP VARCHAR No
The abbreviation for the result component.
8 RES_COMP_GRP_COMP VARCHAR No
The list of component groups that the component belongs to.
9 RES_COMP_LOINC_CMP VARCHAR No
The LOINC code identifier for the component.
10 RES_VAL_COMP VARCHAR No
The value for this result (populated if a single-line value).
11 RES_VAL_ST_LINE_CMP INTEGER No
The start line for the result component's value (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
12 RES_VAL_END_LN_CMP INTEGER No
The end line for the result component's value (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
13 RES_COMMENT_COMP VARCHAR No
The comment for the result value (populated if a single-line value).
14 RES_CMT_ST_LINE_CMP INTEGER No
The start line for the result component's comment (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
15 RES_CMT_END_LN_CMP INTEGER No
The end line for the result component's comment (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
16 RES_UNIT_COMPILED VARCHAR No
The unit of measurement for the result.
17 RES_FLAG_NAME_CMP VARCHAR No
The free text version of the result flag.
18 RES_FLAG_COMP_C_NAME VARCHAR No
The result component flag category ID for the received results.
May contain organization-specific values: Yes
Category Entries:
(NONE)
Abnormal
Panic
Low
High
Low Panic
High Panic
Low Off-Scale
High Off-Scale
Sig Change Up
Sig Change Down
Better
Worse
Sensitive
Resistant
Intermediate
Moderately Sensitive
Very Sensitive
19 RES_LOW_RNG_CMP VARCHAR No
The low end of the normal range for the result.
20 RES_HIGH_RANGE_CMP VARCHAR No
The high end of the normal range for the result.
21 RES_NORMAL_CMP VARCHAR No
The normal range for the result.
22 RES_COMP_STAT_CMP_C_NAME VARCHAR No
The result component status category ID for the received results.
May contain organization-specific values: No
Category Entries:
Aborted
Active
Cancelled
Completed
Held
New
Suspended
Nullified
Obsolete