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