RES_REPEAT_COMP
Description:
This table is used to extract information on component-level repeats.

Primary Key
Column Name Ordinal Position
RESULT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RESULT_ID VARCHAR No
The unique ID 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 RPT_COMP_ID NUMERIC No
The unique ID associated with the repeat component.
4 RPT_COMP_ID_NAME VARCHAR No
The name of the component.
5 RPT_SELECT_YN_NAME VARCHAR No
Indicates whether a repeat component was selected.
May contain organization-specific values: No
Category Entries:
No
Yes
6 RPT_COMP_VALUE VARCHAR No
Repeat component value
7 RPT_ORIG_VALUE VARCHAR No
Repeat component original value
8 RPT_COMP_UNITS VARCHAR No
Repeat component units
9 RPT_ABNORMAL_C_NAME VARCHAR No
Repeat component abnormal value
May contain organization-specific values: Yes
Category Entries:
Normal
10 RPT_DELTA_YN_NAME VARCHAR No
Repeat component delta
The category values for this column were already listed for column: RPT_SELECT_YN_NAME
11 RPT_NORM_LOW VARCHAR No
Repeat component normal low value
12 RPT_NORM_HIGH VARCHAR No
Repeat component normal high value
13 RPT_COMMENT VARCHAR No
Repeat component comment
14 RPT_METHOD_ID VARCHAR No
Repeat component method
15 RPT_METHOD_ID_METHOD_NAME VARCHAR No
The name of the instrument interface, method, method grouper, or middle tier interface record.
16 RPT_NORM_RANGE VARCHAR No
The normal range for the repeat component or a list of values that are considered normal.
17 RPT_VAL_STATUS_C_NAME VARCHAR No
The repeat component validation status category number for the repeat component.
May contain organization-specific values: No
Category Entries:
Not Verified and Held
Verified and Passed
Verified and Failed
Verified, Failed & Held
Not Evaluated
18 RPT_RES_INSTANT DATETIME No
Repeat component resulting instant
19 RPT_RES_LAB_ID_LAB_NAME VARCHAR No
The name of the lab record.
20 RPT_VER_STAT_C_NAME VARCHAR No
Repeat component verification status
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
21 RPT_VER_INSTANT DATETIME No
Repeat component verification instant
22 RPT_VER_LAB_ID_LAB_NAME VARCHAR No
The name of the lab record.
23 RPT_VER_USER_ID VARCHAR No
Repeat component verification user
24 RPT_VER_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
25 IS_RPT_REPORTD_YN_NAME VARCHAR No
Flags whether or not repeat component is reported
The category values for this column were already listed for column: RPT_SELECT_YN_NAME
26 RPT_INTERPRET_C_NAME VARCHAR No
Repeat component interpretation
May contain organization-specific values: Yes
27 RPT_AB_UNITS_C_NAME VARCHAR No
Repeat component antibiotic units
May contain organization-specific values: Yes
28 RPT_AB_COMMENTS_C_NAME VARCHAR No
The antibiotic comment category number for the repeat antibiotic component.
May contain organization-specific values: Yes
29 RPT_RFLX_ACTIONS VARCHAR No
Repeat component reflex actions fired
30 RPT_CAL_COM_RFLX_R VARCHAR No
Repeat calculated component reflex reasons
31 RPT_COMP_RESULT VARCHAR No
Repeat component result
32 REPEAT_COMP_DILUTE VARCHAR No
The factor by which the value is diluted for each component repeat.
33 REPEAT_LINEARITY_YN VARCHAR No
The linearity flag for this component repeat.
The category values for this column were already listed for column: RPT_SELECT_YN_NAME
34 REPEAT_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
35 REP_CMP_REV_TYP_C_NAME VARCHAR No
Records the type of cytology review performed for a given result.
May contain organization-specific values: No
Category Entries:
Initial cytotech review
Cytotech rescreen
Pathologist review
36 RPT_EDITING_USER_ID VARCHAR No
The user that resulted the related repeat component.
37 RPT_EDITING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
38 REPEAT_INTERP_SET_C_NAME VARCHAR No
Indicates how the interpretation for this component was determined.
May contain organization-specific values: No
Category Entries:
User
Interface
Result Checking
Preference Rules
Cascading Rules
39 USR_OVRD_ABNL_ID VARCHAR No
The unique ID associated with the user record. This column is frequently used to link to the CLARITY_EMP table. Records the user responsible for overriding abnormality or reference range for this component repeat.
40 USR_OVRD_ABNL_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
41 USR_OVRD_RPT_FLG_ID VARCHAR No
The unique ID associated with the user record. This column is frequently used to link to the CLARITY_EMP table. Records the user responsible for overriding the reportable flag for this component repeat.
42 USR_OVRD_RPT_FLG_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
43 REPEAT_RES_UTC_DTTM DATETIME (UTC) No
The instant when the repeat was resulted in UTC.
44 RPT_VERIF_UTC_DTTM DATETIME (UTC) No
Stores the instant in UTC at which the component repeat on the corresponding line was verified.
45 REPEAT_REPORTABLE_C_NAME VARCHAR No
The reportable category ID for the component repeat.
May contain organization-specific values: No
Category Entries:
Not Reportable
Reportable
46 RPT_LNC_ID_LNC_LONG_NAME VARCHAR No
The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
47 RPT_SUSC_MTD_LNC_ID_LNC_LONG_NAME VARCHAR No
The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
48 REPEAT_COMP_ACCR_YN VARCHAR No
This item determines the accreditation status of the corresponding component repeat. If set to Y-Yes, the corresponding component repeat is accredited. If set to N-No, the corresponding component repeated is not accredited. If null, no evaluation was performed on the component repeat to determine if it is accredited or not.
The category values for this column were already listed for column: RPT_SELECT_YN_NAME
49 REPEAT_UNCERTAINTY VARCHAR No
The extent to which a given value is uncertain (e.g. if the uncertainty percentage is 5%, then the repeat 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.
50 RPT_NETWORK_CONCEPT_IDENT VARCHAR No
Copy of OVR-51299 for each repeat of the component. Stores the network concept identifier associated with this component at the time of resulting.
51 RPT_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
52 REP_INSTR_PROF_IDENT VARCHAR No
Stores the network concept identifier associated with the repeat component's resulting method at the time of resulting or verification.
53 RPT_NORM_LO_INEQ_C_NAME VARCHAR No
Stores inequalities associated with repeat component normal low (I OVR 53040).
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
54 RPT_NORM_HI_INEQ_C_NAME VARCHAR No
Stores inequalities associated with component normal high (I OVR 53045).
The category values for this column were already listed for column: RPT_NORM_LO_INEQ_C_NAME