Table Detail Report

CQM_MICRESULTS_QUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MDI Results CQM Queue
Definition: This CQM queue table is the primary storage locations of the transaction message for the MDI Results application. This table contains the administrative and routing data used for controlling the transaction.
Table Type: ACTIVITY





Column Detail - CQM_MICRESULTS_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 flag
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 his 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.



Relationship Detail - CQM_MICRESULTS_QUE


Child Column in CQM_MICRESULTS_QUE(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_ID CQM_CONTRIBUTOR_CONFIG CONTRIBUTOR_ID




Parent Column in CQM_MICRESULTS_QUE (PK) Child Table Name Child Column Name
Children: QUEUE_ID CQM_MICRESULTS_LOG QUEUE_ID
CQM_MICRESULTS_PAR QUEUE_ID
CQM_MICRESULTS_TR_1 QUEUE_ID


CQM_MICRESULTS_TR_1



Column Section Relationship Section Top of Page


Table-level Detail

Description: MDI Results CQM Listener Trigger #1
Definition: he CQM listener trigger table contains the administrative data for the processing of a trigger exploded CQM transaction by a listener application. This table contains data for the MDI Results application.
Table Type: ACTIVITY





Column Detail - CQM_MICRESULTS_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 Y 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 N 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 CQM Sequence ID
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.



Relationship Detail - CQM_MICRESULTS_TR_1


Child Column in CQM_MICRESULTS_TR_1(FK) Parent Table Name Parent Column Name
Parents: LISTENER_ID CQM_LISTENER_CONFIG LISTENER_ID
QUEUE_ID CQM_MICRESULTS_QUE QUEUE_ID




Parent Column in CQM_MICRESULTS_TR_1 (PK) Child Table Name Child Column Name
Children: TRIGGER_ID CQM_MICRESULTS_LOG TRIGGER_ID


CQM_MICRODNLD_QUE



Column Section Top of Page


Table-level Detail

Description: CQM MICRODNLD QUE
Definition: This table stores all micro orders received by the MDI Order Server
Table Type: ACTIVITY





Column Detail - CQM_MICRODNLD_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 The instrument service resource cd to which the order belongs to.Column
CONTRIBUTOR_EVENT_DT_TM DATETIME Y not usedColumn
CONTRIBUTOR_ID DOUBLE N Represents who inserted the recordColumn
CONTRIBUTOR_REFNUM VARCHAR(48) N The accession number representing the recordColumn
CREATE_DT_TM DATETIME N When the record was inserted in the table.Column
CREATE_RETURN_FLAG DOUBLE Y not usedColumn
CREATE_RETURN_TEXT VARCHAR(132) Y not usedColumn
DEBUG_IND DOUBLE Y not usedColumn
MESSAGE LONGBLOB Y Displays the test orders and patient demographicsColumn
MESSAGE_LEN DOUBLE N The length of the message fieldColumn
PARAM_LIST_IND DOUBLE Y not usedColumn
PRIORITY DOUBLE N not usedColumn
PROCESS_STATUS_FLAG DOUBLE N status of the recordColumn
QUEUE_ID DOUBLE N table keyColumn
SUBTYPE VARCHAR(15) Y not usedColumn
SUBTYPE_DETAIL VARCHAR(15) Y not usedColumn
TRIG_CREATE_END_DT_TM DATETIME Y not usedColumn
TRIG_CREATE_START_DT_TM DATETIME Y not usedColumn
TRIG_MODULE_IDENTIFIER VARCHAR(16) Y not usedColumn
TYPE VARCHAR(15) Y not usedColumn
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 not usedColumn


CQM_MICRODNLD_TR_1



Column Section Top of Page


Table-level Detail

Description: CQM MICRODNLD TR 1
Definition: Trigger table for Micro interface orders.
Table Type: ACTIVITY





Column Detail - CQM_MICRODNLD_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 not usedColumn
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 not usedColumn
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_ROPRESULTS_QUE



Column Section Top of Page


Table-level Detail

Description: CQM ROPRESULTS QUE
Definition: Result information from POC instruments
Table Type: ACTIVITY





Column Detail - CQM_ROPRESULTS_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 Represents the service resource cd that generated the resultsColumn
CONTRIBUTOR_EVENT_DT_TM DATETIME Y not used by mdiColumn
CONTRIBUTOR_ID DOUBLE N Represents what server inserted the record.Column
CONTRIBUTOR_REFNUM VARCHAR(48) N The patient identifier for the results.Column
CREATE_DT_TM DATETIME N when the record was createdColumn
CREATE_RETURN_FLAG DOUBLE Y not applicable to mdiColumn
CREATE_RETURN_TEXT VARCHAR(132) Y not used by mdiColumn
DEBUG_IND DOUBLE Y not used by mdiColumn
MESSAGE LONGBLOB Y results received from an instrumentColumn
MESSAGE_LEN DOUBLE N length of the message fieldColumn
PARAM_LIST_IND DOUBLE Y not used by mdiColumn
PRIORITY DOUBLE N not used by mdiColumn
PROCESS_STATUS_FLAG DOUBLE N The status of the recordColumn
QUEUE_ID DOUBLE N table keyColumn
SUBTYPE VARCHAR(15) Y not usedColumn
SUBTYPE_DETAIL VARCHAR(15) Y not usedColumn
TRIG_CREATE_END_DT_TM DATETIME Y not usedColumn
TRIG_CREATE_START_DT_TM DATETIME Y not usedColumn
TRIG_MODULE_IDENTIFIER VARCHAR(16) Y not usedColumn
TYPE VARCHAR(15) Y not usedColumn
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 not usedColumn