RES_COMPONENTS
Description:
Primary table for result component information.

Primary Key
Column Name Ordinal Position
RESULT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RESULT_ID VARCHAR No
The unique identifier of the result record.
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 COMPONENT_ID NUMERIC No
Internal component ID
4 COMPONENT_ID_NAME VARCHAR No
The name of the component.
5 COMPONENT_RESULT VARCHAR No
Component result interpreted value
6 COMPONENT_VALUE VARCHAR No
Component result value
7 COMPONENT_UNITS VARCHAR No
Component result units
8 COMPONENT_ABN_C_NAME VARCHAR No
Component abnormal category value
May contain organization-specific values: Yes
Category Entries:
Normal
9 COMPONENT_DELTA_YN_NAME VARCHAR No
If this value is 1 (true), it indicates that a delta has occurred for this component.
May contain organization-specific values: No
Category Entries:
No
Yes
10 COMPONENT_NRML_LO VARCHAR No
This item specifies the lowest "normal" value for this component if applicable.
11 COMPONENT_NRML_HI VARCHAR No
This item specifies the highest "normal" value for this component, if applicable.
12 COMPONENT_CMT VARCHAR No
This item allows entry of a free-text comment related specifically to this component.
13 COMPONENT_MTHD_ID VARCHAR No
The testing method for this component.
14 COMPONENT_MTHD_ID_METHOD_NAME VARCHAR No
The name of the instrument interface, method, method grouper, or middle tier interface record.
15 COMPONENT_RANGE VARCHAR No
The normal range for the component or a list of values that are considered normal.
16 COMPONENT_INST DATETIME (Local) No
The instant the component was resulted.
17 COMPONENT_LAB_ID VARCHAR No
Resulting lab ID for this component.
18 COMPONENT_REPORT_YN_NAME VARCHAR No
This item indicates whether or not a component should be reported.
May contain organization-specific values: No
Category Entries:
No
Yes
Value
Interpretation
19 COMPON_DILUTION VARCHAR No
The factor by which the value is diluted
20 COMPON_LINEAR_YN VARCHAR No
The linearity flag for this component
The category values for this column were already listed for column: COMPONENT_DELTA_YN_NAME
21 COMPON_RPT_SET_BY_C_NAME VARCHAR No
Indicates how the report flag for this component was determined
May contain organization-specific values: No
Category Entries:
Test Settings
User
Preference Rules
Cascading Rules
Organism Result Checking
Suppressed by User
Suppressed by Auto Verification
Interface
22 COMPON_REPORTABLE_C_NAME VARCHAR No
The reportable (notifiable) flag for this component
May contain organization-specific values: No
Category Entries:
Not Reportable
Reportable
23 COMP_VAL_STAT_C_NAME VARCHAR No
The validation status category number for this component.
May contain organization-specific values: No
Category Entries:
Not Verified and Held
Verified and Passed
Verified and Failed
Verified, Failed & Held
Not Evaluated
24 COMP_VERIF_STATUS_C_NAME VARCHAR No
The verification status category number for this component.
May contain organization-specific values: No
Category Entries:
In Progress
Resulted
Preliminary
Verified
Cancel
Don't Test
Deleted
Pending Preliminary Verification
Pending Final Verification
Corrected
Cosign
Workflow Step Completed
25 COMP_VERIF_LAB_ID VARCHAR No
The unique ID of the lab that verified the component.
26 COMP_VERIF_USER_ID VARCHAR No
The unique ID of the user who verified the component.
27 COMP_VERIF_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
28 USR_OVRD_ABNRML_ID VARCHAR No
The unique ID associated with the user record responsible for overriding abnormality or reference range. This column is frequently used to link to the CLARITY_EMP table.
29 USR_OVRD_ABNRML_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
30 USR_OVRD_REP_FLG_ID VARCHAR No
The unique ID associated with the user record responsible for overriding the reportable flag. This column is frequently used to link to the CLARITY_EMP table.
31 USR_OVRD_REP_FLG_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
32 OVRIDE_ABNRML_YN VARCHAR No
Indicates whether users can override the reference range or abnormality from Result Entry.
The category values for this column were already listed for column: COMPONENT_DELTA_YN_NAME
33 OVRIDE_REP_FLAG_YN VARCHAR No
Indicates whether users can override the reportable flag from Result Entry.
The category values for this column were already listed for column: COMPONENT_DELTA_YN_NAME
34 CMP_VERIF_UTC_DTTM DATETIME (UTC) No
Stores the instant in UTC at which the component on the corresponding line was verified.
35 COMP_LNC_RECORD_ID NUMERIC No
The unique ID associated with the LOINC record for this row as populated by the interface when results are received from an external resulting agency.
36 COMP_ACCREDITED_YN VARCHAR No
This item determines the accreditation status of the corresponding component. If set to Y-Yes, the corresponding component is accredited. If set to N-No, the corresponding component is not accredited. If null, no evaluation was performed on the component to determine if it is accredited or not.
The category values for this column were already listed for column: COMPONENT_DELTA_YN_NAME
37 COMP_UNCERTAIN_MEAS VARCHAR No
The extent to which a given value is uncertain (e.g. if the uncertainty percentage is 5%, then the component uncertainty value for a result of 1.00 will be +/- 0.05). NOTE: This is how the data is stored in the database; as string format. This field stores numeric in M internal format, using a period as the decimal separator irrespective of locale.
38 COMP_NETWORK_CONCEPT_IDENT VARCHAR No
Stores the network concept identifier associated with this component at the time of resulting.