RES_WORKCARD

Description: |
This table contains information about workcard actions on microbiology results. Workcard actions are the building blocks used to create complete organism identification flows ("decision trees") for aiding the identification of organisms in microbiology tests.

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 | WC_ACTION | VARCHAR | No |
The workcard action for the associated component.
4 | COMPONENT_ID | NUMERIC | No |
Workcard component identifier
5 | COMPONENT_ID_NAME | VARCHAR | No |
The name of the component.
6 | COMPONENT_RESULT | VARCHAR | No |
The workcard result for the associated component.
7 | COMPONENT_VALUE | VARCHAR | No |
The workcard value for the associated component.
8 | COMPONENT_CMT | VARCHAR | No |
The workcard comment for the associated component.
9 | COMPONENT_INST | DATETIME (Local) | No |
The workcard instant for the associated component.
10 | WORKCARD_BILL_SS | VARCHAR | No |
Values from column WORKCARD_USE_YN when this result was last processed by billing