ASSAY_PROCESS_EVENT



Column Section Top of Page


Table-level Detail

Description: Contains the errors that a laboratory analyzer can return for a discrete assay.
Definition: Contains the errors that a laboratory analyzer can return for a discrete assay and the action to be taken upon reciept of the error, by model.
Table Type: REFERENCE





Column Detail - ASSAY_PROCESS_EVENT


Column Name Type Null? Definition
ACTION_CD DOUBLE N Contains the DBMS assigned unique code value for an action to be taken upon receipt of a discrete assay error from a laboratory analyzer.
APPLY_TO_ALL_IND DOUBLE Y Specifies if the error flag applies to all DTAs for the service resource
AV_FLAG DOUBLE N Defines if auto verification is turned on or off by task assay
INSTRU_ERROR_CODE VARCHAR(20) N Contains the error(s) that have been configured for an action upon receipt from an analyzer for a discrete assay.
SERVICE_RESOURCE_CD DOUBLE N Contains the DBMS assigned unique code value indicating service_resource_cd.
STRT_ASSAY_ID DOUBLE N Contains the DBMS assigned unique key field value from strt_assay table.
STRT_MODEL_ID DOUBLE N Contains the DBMS assigned unique key field value from strt_model table.
TASK_ASSAY_CD DOUBLE N Contains the unique key field value from 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.


ASSAY_RESOURCE_TRANSLATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains discrete assay information.
Definition: Contains discrete assay functionality (e.g., download y/n, upld alias, dnld alias, etc.) information by model that is required by the medical device interface to process the assay.
Table Type: REFERENCE





Column Detail - ASSAY_RESOURCE_TRANSLATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
DECIMAL_MOVEMENT_NBR DOUBLE Y Defines the decimal movement to be performed by the MDI Result server (231) on the result value obtained from the interface. This column would be updated by MDI Install tool while configuring the interface.
LOADED_SERVICE_RESOURCE_CD DOUBLE N Service Resource where tests have been loaded.
POST_ZERO_RESULT_IND DOUBLE Y Contains a Boolean character to indicate if the user wants a value of 0 (zero) to post when received by the analyzer.
PROCESS_SEQUENCE DOUBLE Y Reserved for future use.
SERVICE_RESOURCE_CD DOUBLE N Contains the service resource code of the analyzer.
TASK_ASSAY_CD DOUBLE N Contains the DBMS assigned unique key field value from discrete_task_assay table.
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.
UPLD_ASSAY_ALIAS VARCHAR(25) N Contains the test mnemonic sent by the analyzer for a discrete assay.



Relationship Detail - ASSAY_RESOURCE_TRANSLATION


Child Column in ASSAY_RESOURCE_TRANSLATION(FK) Parent Table Name Parent Column Name
Parents: LOADED_SERVICE_RESOURCE_CD ASSAY_PROCESSING_R LOADED_SERVICE_RESOURCE_CD
SERVICE_RESOURCE_CD ASSAY_PROCESSING_R SERVICE_RESOURCE_CD
TASK_ASSAY_CD ASSAY_PROCESSING_R TASK_ASSAY_CD


CQM_GNLBDNLD_QUE



Column Section Top of Page


Table-level Detail

Description: CQM GNLBDNLD QUE
Definition: Contains General Lab instrument orders for bi-directional interfaces.
Table Type: ACTIVITY





Column Detail - CQM_GNLBDNLD_QUE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CLASS VARCHAR(15) Y Identifies the trigger explosion class of the transaction.
CONTRIBUTOR_EVENT_DT_TM DATETIME Y Significant date and time associated with the transaction row as supplied by the contributor application
CONTRIBUTOR_ID DOUBLE N This is the value of the unique primary identifier of the CQM contributor configuration table. It is an internal system assigned number.
CONTRIBUTOR_REFNUM VARCHAR(48) N A reference or key assigned to the transaction row by the contributor application. It recommended that this identifier be unique although it is not required.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
CREATE_RETURN_FLAG DOUBLE Y create return flagColumn
CREATE_RETURN_TEXT VARCHAR(132) Y Return text string from the trigger explosion process of this transaction row.
DEBUG_IND DOUBLE Y Defines whether debugging is active or inactive for the queue transaction unidentified in this row.
MESSAGE LONGBLOB Y This is the binary longraw field which contains the contents of the original message.
MESSAGE_LEN DOUBLE N The length of the textual or binary object placed in the message field.
PARAM_LIST_IND DOUBLE Y Identifies whether there are row in the queue parameters table associated with this transaction row.
PRIORITY DOUBLE N Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 through 99, highest to lowest, respectively.
PROCESS_STATUS_FLAG DOUBLE N The current trigger explosion state for this transaction row.
QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number.
SUBTYPE VARCHAR(15) Y Identifies the trigger explosion subtype of the transaction.
SUBTYPE_DETAIL VARCHAR(15) Y Identifies the trigger explosion subtype detail of the transaction.
TRIG_CREATE_END_DT_TM DATETIME Y The date and time the trigger explosion completed on this transaction row.
TRIG_CREATE_START_DT_TM DATETIME Y The date and time the trigger explosion began on this transaction row.
TRIG_MODULE_IDENTIFIER VARCHAR(16) Y Future. Identifies the process/module which performs the trigger explosion on this transaction row.
TYPE VARCHAR(15) Y Identifies the trigger explosion type of the transaction.
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.
VERBOSITY_FLAG DOUBLE Y Defines the verbosity level during debugging for the processing of the transaction.


CQM_GNLBDNLD_TR_1



Column Section Top of Page


Table-level Detail

Description: CQM GNLBDNLD TR 1
Definition: Trigger table for General Lab interface orders.
Table Type: ACTIVITY





Column Detail - CQM_GNLBDNLD_TR_1


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
COMPLETION_SEQUENCE_ID DOUBLE N This is the value that unique identifies the transaction completion order by the listener application. It is an internal system assigned number.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
DEBUG_IND DOUBLE Y Defines whether debugging is active or inactive for the listener trigger explosion event unidentifie in this row.
LAST_RETRY_DT_TM DATETIME Y The date and time of the last retry to process this trigger exploded transaction row. This field may or may not be used by the listener application.
LISTENER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener configuration table. It is an internal system assigned number.
L_R_PROCESS_STATUS_FLAG DOUBLE Y The last retry processing state for this trigger exploded transaction row. This field may or may not be used by the listener application.
L_R_TRIGGER_STATUS_TEXT VARCHAR(132) Y The last retry processing text for this trigger exploded transaction row. This field may or may not be used by the listener application.
NUMBER_OF_RETRIES DOUBLE Y Set to 0 on insert. Optionally incremented by 1 by the listener application to specify the number of times the listener attempted to process the trigger exploded transaction.
PRIORITY DOUBLE N Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 throug 99, highest to lowest, respectively.
PROCESS_START_DT_TM DATETIME Y The date and time the listener application started processing on this exploded transaction.
PROCESS_STATUS_FLAG DOUBLE Y The current processing state for this trigger exploded transaction row.
PROCESS_STOP_DT_TM DATETIME Y The date and time the listener application completed processing on this exploded transaction.
QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number.
SCHEDULE_DT_TM DATETIME N The date and time this exploded transaction row is scheduled for processing.
TRIGGER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener trigger table. It is an internal system assigned number.
TRIGGER_STATUS_TEXT VARCHAR(132) Y The status text associated with the processing status flag.
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.
VERBOSITY_FLAG DOUBLE Y Defines the verbosity level during debugging for the processing of the transaction.


CQM_MDRESULTS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: MDI Results CQM Log
Definition: This CQM log table presents debugging and logging information associated with the MDI Results application.
Table Type: ACTIVITY





Column Detail - CQM_MDRESULTS_LOG


Column Name Type Null? Definition
CONTRIBUTOR_ID DOUBLE Y This is the value of the unique primary identifier of the CQM contributor configuration table. It is an internal system assigned number.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
LISTENER_ID DOUBLE Y This is the value of the unique primary identifier of the CQM listener configuration table. It is an internal system assigned number.
LOG_ERROR_LOCATION VARCHAR(80) Y The code module that generated the error message in this row.
LOG_ERROR_TEXT VARCHAR(132) Y The error text message.
LOG_ID DOUBLE N This is the value of the unique primary identifier of the CQM log table. It is an internal system assigned number.
PARAM_ID DOUBLE Y This is the value of the unique primary identifier of the CQM queue parameters table. It is an internal system assigned number.
PROCESS_STATUS_FLAG DOUBLE Y The current trigger explosion state for this transaction row.
PROCESS_STATUS_TEXT VARCHAR(132) Y Descriptive text string associated to the processing status flag.
QUEUE_ID DOUBLE Y This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number.
REGISTRY_ID DOUBLE Y This is the value of the unique primary identifier of the CQM listener registry table. It is an internal system assigned number.
TRIGGER_ID DOUBLE Y This is the value of the unique primary identifier of the CQM listener trigger table. It is an internal system assigned number.
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 - CQM_MDRESULTS_LOG


Child Column in CQM_MDRESULTS_LOG(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_MDRESULTS_QUE QUEUE_ID
TRIGGER_ID CQM_MDRESULTS_TR_1 TRIGGER_ID