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.