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_LAB_NAME VARCHAR No
The name of the lab record.
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_LAB_NAME VARCHAR No
The name of the lab record.
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_LNC_LONG_NAME VARCHAR No
The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
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.
39 COMP_DISP_RANGE_SET_BY_C_NAME VARCHAR No
Records what set the display reference range.
May contain organization-specific values: No
Category Entries:
User
Result Checking Display Range
Result Checking Calculated Range
Interface
40 COMP_INSTR_PROF_IDENT VARCHAR No
Stores the network concept identifier associated with the component's resulting method at the time of resulting or verification.
41 COMPON_TAG_LN INTEGER No
Line number for the tested against group relevant to this row, indicating that all component lines pointing to the same line should be grouped together logically.
42 CMP_ADD_USER_ID VARCHAR No
User who added the component to the test
43 CMP_ADD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
44 CMP_ADD_DTTM DATETIME (Attached) No
Stores the local instant of when the component was originally added to the test.
45 CMP_ADD_UTC_DTTM DATETIME (UTC) No
Stores the UTC instant of when the component was originally added to the test.
46 COMP_NORM_LO_INEQ_C_NAME VARCHAR No
Stores inequalities associated with component normal low (I OVR 51040).
May contain organization-specific values: No
Category Entries:
Equal to
Not equal to
Greater than
Greater than or equal to
Less than
Less than or equal to
In range
Not in range
Always equal to
No values equal to
Always greater than
Always greater than or equal to
Always less than
Always less than or equal to
Contains
Does not contain
Starts with
Ends with
Exists
Does not exist
Field is blank
Field does not contain
47 COMP_NORM_HI_INEQ_C_NAME VARCHAR No
Stores inequalities associated with component normal high (I OVR 51045).
The category values for this column were already listed for column: COMP_NORM_LO_INEQ_C_NAME