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 |