|
Name |
Type |
Discontinued? |
|
| 1 |
RESULT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the result record. |
|
|
| 2 |
RES_VAL_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The validation status category number for the result. |
| 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 |
|
|
| 3 |
RES_SPECIMEN_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the specimen that is associated with the result record. |
|
|
| 4 |
RES_SPEC_NO_REL |
VARCHAR |
No |
|
|
|
| The related external specimen ID number for the given result. It gets the specimen ID through related externa ID number (I OVR 10026), which in turn uses the specimen related external ID number (I OVS 26) for the first specimen associated with the result. |
|
|
| 5 |
RES_EPT_PAT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the patient (EPT) associated with the result record. |
|
|
| 6 |
RES_GW_RESULT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the result record for a general workcard associated with this result record. |
|
|
| 7 |
RES_OW_RESULT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the organism workcard result record associated with this result record. |
|
|
| 8 |
RES_ABNORMAL_C_NAME |
VARCHAR |
No |
|
|
|
| The abnormal level category number for the result. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Normal |
|
|
| 9 |
RES_ORDER_ID |
NUMERIC |
No |
|
|
|
| The order ID associated with the result's test. It gets the order ID through the related external ID number (I OVR 10026) , which in turn uses order ID (I OVS 85) for the first specimen associated with the result. |
|
|
| 10 |
RES_TEST_MTHD_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the test method. |
|
|
| 11 |
RES_TEST_MTHD_ID_METHOD_NAME |
VARCHAR |
No |
|
|
|
| The name of the instrument interface, method, method grouper, or middle tier interface record. |
|
|
| 12 |
RES_VERIFY_LAB_ID |
VARCHAR |
No |
|
|
|
| Lab where result was verified |
|
|
| 13 |
RES_RQG_PAT_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the non-participating submitter's patient (RQG) associated with the result record. |
|
|
| 14 |
CURRENT_ACTION_ID |
NUMERIC |
No |
|
|
|
| The action which is currently in progress for the workcard. |
|
|
| 15 |
CURRENT_ACTION_ID_RECORD_NAME |
VARCHAR |
No |
|
|
|
| The name of the node record. |
|
|
| 16 |
SLIDE_REVIEW_RPT_YN |
VARCHAR |
No |
|
|
|
| Setting for a hematology test to determine if the Slide Review part of the test is reported out or not. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 17 |
DIFF_REPORTED_C_NAME |
VARCHAR |
No |
|
|
|
| The type of differential reported category number for the result. Note: this item is used for CBC test only. Also note: unlike DIFF_TYPE_RPTD_C, this item is not set only during result transmittal and so may be set when DIFF_TYPE_RPTD_C is not. |
| May contain organization-specific values: No |
| Category Entries: |
| Auto |
| Manual |
| None |
|
|
| 18 |
DIFF_CELL_COUNT_EVT |
INTEGER |
No |
|
|
|
| Stores the number of cells to count before which an action will be triggered. This value is used when a manual cell count is being performed such as a CBC Differential. |
|
|
| 19 |
MAIN_RPTD_YN |
VARCHAR |
No |
|
|
|
| Setting for a hematology test to determine if the main part of the test is loaded and reported out. |
| The category values for this column were already listed for column: SLIDE_REVIEW_RPT_YN |
|
|
| 20 |
CAT_INI |
VARCHAR |
No |
|
|
|
| Stores the master file from which to select a category list for multiline component level category comments. |
|
|
| 21 |
CAT_ITEM |
NUMERIC |
No |
|
|
|
| Stores the item from which to select a category list for multiline component level category comments. |
|
|
| 22 |
TEST_LINE |
INTEGER |
No |
|
|
|
| The test line number for the information associated with the specimen of this result. Along with RES_SPECIMEN_ID, this forms the foreign key to the SPEC_TEST_REL table. |
|
|
| 23 |
DIFF_TYPE_RPTD_C_NAME |
VARCHAR |
No |
|
|
|
| The type of differential reported category number for the result. Note: this item is used for CBC test only. Since this item is set only during result transmittal, it is not set for Quality Control (QC) results. Lastly, only the main result will have this item set. |
| The category values for this column were already listed for column: DIFF_REPORTED_C_NAME |
|
|
| 24 |
COSIGN_MAJOR_EDT_YN |
VARCHAR |
No |
|
|
|
| Indicates if a cosigned version of the result has been modified with a major edit. |
| The category values for this column were already listed for column: SLIDE_REVIEW_RPT_YN |
|
|
| 25 |
LINKED_CBC_TEST_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the hemogram/auto diff test linked to a manual diff test. If there is no linked test, the unique ID of the manual diff test is stored. |
|
|
| 26 |
RAND_REFX_FIRED_YN |
VARCHAR |
No |
|
|
|
| Tracks if the random rescreen reflex extension was fired for this result |
| The category values for this column were already listed for column: SLIDE_REVIEW_RPT_YN |
|
|
| 27 |
REQ_COSIGNER_USER_ID |
VARCHAR |
No |
|
|
|
| Stores the unique ID of the user record requested to cosign this result. If blank, any user can cosign this result. |
|
|
| 28 |
REQ_COSIGNER_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 29 |
VALIDATION_DATE |
DATETIME |
No |
|
|
|
| The date when the result was validated. |
|
|
| 30 |
SPEC_TYPE_CONTAINER_TYPE_ID |
VARCHAR |
No |
|
|
|
| The unique ID for the container type of the specimen for this result. |
|
|
| 31 |
SPEC_TYPE_CONTAINER_TYPE_ID_CONTAINER_TYPE_NAME |
VARCHAR |
No |
|
|
|
| The name of the container type record. |
|
|
| 32 |
VAR_UPDATE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The date and time when the variant associated with this result was added, updated, or deleted. |
|
|
