ROBOTICS_AV_TRANSACTION
Column Section | Top of Page |
Table-level Detail
Description: | ROBOTICS AV TRANSACTION |
Definition: | Autoverification Request passed to Robotics. |
Table Type: | ACTIVITY |
Column Detail - ROBOTICS_AV_TRANSACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
AV_ERROR_CD | DOUBLE | N | Autoverification Error Code. |
INITIAL_IND | DOUBLE | Y | Indicates initial result for the same accession, task assay, and av error code |
ORDER_ID | DOUBLE | N | A system generated number that identifies an order. |
ROBOTICS_AV_TRANSACTION_ID | DOUBLE | N | A system generated number that identifies the request from Autoverify to Robotics. |
SERVICE_RESOURCE_CD | DOUBLE | N | A system generated number representing a service resource. |
TASK_ASSAY_CD | DOUBLE | N | A system generated number representing a discrete task assay. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ROBOTICS_DEST_CODES
Column Section | Top of Page |
Table-level Detail
Description: | ROBOTICS DEST CODES |
Definition: | Destination code assignments per task assay for each service resource. |
Table Type: | REFERENCE |
Column Detail - ROBOTICS_DEST_CODES
Column Name | Type | Null? | Definition |
---|---|---|---|
AV_ERROR_CD | DOUBLE | N | Autoverify Error CodeColumn |
DESTINATION_CODE | CHAR(2) | Y | Numeric string representing a destination on the robotics line |
REFLEX_IND | DOUBLE | Y | An indicator to alert robotics that a rule exists that will cause a reflex test. |
ROBOTICS_SERVICE_RESOURCE_CD | DOUBLE | N | Service Resource that represents a robotics line |
SERVICE_RESOURCE_CD | DOUBLE | N | A service resource for an instrument associated with the robotics line.Column |
SLIDE_IND | DOUBLE | Y | Indicates that a slide will be made on the robotics line.Column |
SUBSEQ_SLIDE_IND | DOUBLE | Y | Indicates a slide should be made on the robotics line if this is a subsequent condition. |
TASK_ASSAY_CD | DOUBLE | N | Discrete Task assay processing on robotics. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ROBOTICS_ITEMS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Robotic components associated with a robotics line. |
Definition: | Any robotics related unit that transfers information to the robotics server. |
Table Type: | REFERENCE |
Column Detail - ROBOTICS_ITEMS
Column Name | Type | Null? | Definition |
---|---|---|---|
AV_DEST_CODE_BUILD_IND | DOUBLE | Y | Controls building of destination codes for autoverifybuild. |
CALL_ROBOTICS_IND | DOUBLE | Y | If set to one call robotics interface. |
DEST_PRIORITY | DOUBLE | Y | Priority for this Takeout unit |
LOGIN_LOC_CD | DOUBLE | N | Login Location for the robotics item |
LONG_DESC | CHAR(80) | Y | Text description of the robotics item. |
MASK_NBR | DOUBLE | N | Provides a mask to quickly select a given identifier |
PICT_INDEX_FLG | DOUBLE | Y | Index number for a robotics item picture box, based on type |
POST_CONTAINER_EVENT_IND | DOUBLE | Y | Allow robotic events from this robotics item to post to the container event table |
RACK_TYPE_CD | DOUBLE | N | Code value of rack type corresponding to this robotics item. |
ROBOTICS_DESC1 | CHAR(20) | Y | Top Row of the Picture Box Descriptor |
ROBOTICS_DESC2 | CHAR(20) | Y | Bottom Row of the Picture Box Descriptor |
ROBOTICS_DEST | DOUBLE | Y | Robotics Destination identifier |
ROBOTICS_ITEM_ID | DOUBLE | N | Unique identifier for Robotics Item |
ROBOTICS_ITEM_TYPE_CD | DOUBLE | N | Robotics Item Type |
ROBOTICS_NAME | CHAR(20) | Y | Name identifier from Robotics Vendor |
ROBOTICS_POS_X | DOUBLE | N | X Coordinate Screen Position for Picture Box |
ROBOTICS_POS_Y | DOUBLE | N | Y Coordinate Screen Position for Picture Box |
ROBOTICS_ROUTE | DOUBLE | Y | Route Code for Robotics Item |
ROBOTICS_SERVICE_RESOURCE_CD | DOUBLE | N | Robotics Line Controller Service Resource Code Value |
ROUTE_ALIAS | VARCHAR(20) | Y | This alias when ordered on robotics will cause a container to be routed to this robotics item. |
SERVICE_RESOURCE_CD | DOUBLE | N | Robotics Item Service Resource |
SHELF_CD | DOUBLE | N | Code value of the shelf corresponding to this robotics item. |
TRANSFER_FLG | CHAR(1) | Y | Transfer Destination Flag |
TRANSFER_TO_SHELF_CD | DOUBLE | N | Code value of the shelf where the rack will be moved when taken off the robotics line.s |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - ROBOTICS_ITEMS
Child Column in ROBOTICS_ITEMS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | CODE_VALUE | CODE_VALUE |
LOGIN_LOC_CD | LOCATION | LOCATION_CD |
ROBOTICS_LIMITS_R
Column Section | Top of Page |
Table-level Detail
Description: | Defines time limits to be used for processing specimens on a robotics line. |
Definition: | Robotics Limits relationship |
Table Type: | REFERENCE |
Column Detail - ROBOTICS_LIMITS_R
Column Name | Type | Null? | Definition |
---|---|---|---|
BARCODE_RETRY_LIMIT | DOUBLE | Y | The number of times/container that an auto repeat will be performed due to a barcode that was misread. |
BARCODE_TIME_LIMIT | DOUBLE | Y | The length of time allowed for a test to be performed before it is assumed the barcode was misread and an auto repeat is performed by robotics. |
COMPLETION_TIME_LIMIT | DOUBLE | Y | The length of time after a test is performed before a container is marked completed and moved to its final destination on the robotics line. |
SERVICE_RESOURCE_CD | DOUBLE | N | Robotics Line Service Resource code |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
ROBOTICS_LOG_EVENTS
Column Section | Top of Page |
Table-level Detail
Description: | Log for Robotics Events |
Definition: | Robotics Log Events |
Table Type: | ACTIVITY |
Column Detail - ROBOTICS_LOG_EVENTS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | CHAR(25) | Y | Accession causing the robotics event |
BARCODE | CHAR(15) | Y | Barcode causing the robotic event |
MESSAGE | CHAR(60) | Y | Text Message logged on this event |
ROBOTICS_ITEM_ID | DOUBLE | N | Robotics Item Identifier |
ROBOTICS_SERVICE_RESOURCE_CD | DOUBLE | N | Robotics Controller Service Resource |
SEQUENCE | DOUBLE | N | Unique Sequence on Robotics Log |
STATUS_CD | DOUBLE | N | Robotics Event Status identifier |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |