DOCS_RCVD_RSLT_COMPS
Description:
This table stores discrete result component information received from outside sources.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
This item stores the Received Document record ID.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 RESULT_COMP_KEY VARCHAR No
Key to link the component with the order
6 COMP_REFID VARCHAR No
Unique Identifier for each result component.
7 RESULT_COMP_NAME VARCHAR No
Free text name for the result component
8 RESULT_COMP_ID NUMERIC No
This item stores the mapped result component in the internal system.
9 RESULT_COMP_ID_NAME VARCHAR No
The name of the component.
10 RESULT_COMP_ABBR VARCHAR No
result component abbreviation
11 RESULT_COMP_GROUP VARCHAR No
grouper for the result components
12 RESULT_COMP_LOINC VARCHAR No
LOINC code for this result component
13 RESULT_VALUE VARCHAR No
Actual value of the result
14 RES_VAL_ST_LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
15 RES_VAL_END_LINE INTEGER No
The end line of result text in stored in Result Impression Information.
16 COMPONENT_COMMENT VARCHAR No
The comment of a result component when less than 255 characters.
17 COMP_CMT_ST_LINE INTEGER No
The line number of result component comments greater than 254 characters
18 COMP_CMT_END_LINE INTEGER No
The line number of result component comments greater than 254 characters
19 RESULT_UNITS VARCHAR No
Units of measure for the result
20 RESULT_FLAG_NAME VARCHAR No
Free text version of the results flag
21 RESULT_FLAG_C_NAME VARCHAR No
Abnormal flag for the result
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
22 RESULT_LOW_RANGE VARCHAR No
Low end of the normal range for this result
23 RESULT_HIGH_RANGE VARCHAR No
High end of the normal range for this result
24 RESULT_NORMAL VARCHAR No
Normal reference range for the result
25 RESULT_COMP_STAT_C_NAME VARCHAR No
Status for the individual result component
May contain organization-specific values: No
Category Entries:
Aborted
Active
Cancelled
Completed
Held
New
Suspended
Nullified
Obsolete
26 UNRECOG_VALUE_TYPE VARCHAR No
One or more types of values that couldn't be parsed from CDA.
27 LRR_ID_AND_INSTANT VARCHAR No
The linked component record ID for this component, concatenated with the result instant.
28 COMP_LOINC_AND_INST VARCHAR No
The LOINC code for this component, concatenated with the result instant
29 RSLT_COMP_STAT_ID_C_NAME VARCHAR No
This item stores the mapped result component status.
May contain organization-specific values: No
Category Entries:
Preliminary
Final
Corrected
Incomplete
30 RSLT_COMP_LOINC_ID NUMERIC No
This item stores the mapped LOINC ID for a result LOINC code.
31 COMP_LAB_REF_IDENT VARCHAR No
This item stores the lab reference ID for a specific component of a result.
32 RSLT_VALUE_RTF_ID VARCHAR No
The unique identifier for the Notes record that contains the result value in RTF format.
33 RSLT_COMMENT_RTF_ID VARCHAR No
The unique identifier for the Notes record that contains the result comment in RTF format.
34 COMP_SIGNATURE VARCHAR No
Signature of the pathologist who verified the component
35 COMP_SIG_ST_LINE INTEGER No
The line number of result component signatures greater than 200 characters
36 COMP_SIG_END_LINE INTEGER No
The end line number of result component signatures greater than 200 characters
37 RESULT_COMP_LRR NUMERIC No
LRR .1 Identifier for result component
38 RSLT_COMP_EFF_TIME_DTTM DATETIME (Local) No
This is the result time parsed from a component associated with a result. This will be used instead of the result time when populated for searching for result components for non-Epic organizations.