|
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 |
|
|
|
|
| 7 |
RPT_ORIG_VALUE |
VARCHAR |
No |
|
|
|
| Repeat component original value |
|
|
| 8 |
RPT_COMP_UNITS |
VARCHAR |
No |
|
|
|
|
| 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 |
|
|
|
|
| 14 |
RPT_METHOD_ID |
VARCHAR |
No |
|
|
|
|
| 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 |
VARCHAR |
No |
|
|
|
| Repeat component resulting lab ID |
|
|
| 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 |
VARCHAR |
No |
|
|
|
| Repeat component verification lab ID |
|
|
| 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 |
|
|
|
|
| 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 |
NUMERIC |
No |
|
|
|
| The unique ID of the LOINC record as reported by the external resulting agency for a specific repeat of the component associated with this result. |
|
|
| 47 |
RPT_SUSC_MTD_LNC_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the LOINC record associated with the susceptibility method for the specific repeat of the component on this result as reported by the external resulting agency. |
|
|
| 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. |
|
|
