Table Detail Report

CQM_ROPRESULTS_TR_1



Column Section Top of Page


Table-level Detail

Description: Contains POC result trigger information
Definition: This table will send a notificiation to the MDI Result Client server telling it that there are records to be processed when new result records are inserted.
Table Type: ACTIVITY





Column Detail - CQM_ROPRESULTS_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 not applicable to MDIColumn
CREATE_DT_TM DATETIME N Record creation date/time.Column
DEBUG_IND DOUBLE Y not applicable to MDIColumn
LAST_RETRY_DT_TM DATETIME Y not applicable to MDIColumn
LISTENER_ID DOUBLE N Represents what MDI server is going to be reading this record.Column
L_R_PROCESS_STATUS_FLAG DOUBLE Y Not applicable to MDIColumn
L_R_TRIGGER_STATUS_TEXT VARCHAR(132) Y Comment explaining the Process Status FlagColumn
NUMBER_OF_RETRIES DOUBLE Y Not applicable to MDIColumn
PRIORITY DOUBLE N Not applicable to MDIColumn
PROCESS_START_DT_TM DATETIME Y When the MDI Result server began processing the recordColumn
PROCESS_STATUS_FLAG DOUBLE N Represents the status of the recordColumn
PROCESS_STOP_DT_TM DATETIME Y When the MDI Result Server completed processing of the recordColumn
QUEUE_ID DOUBLE N Represents a specific record found on the cqm_ropresults_que table.Column
SCHEDULE_DT_TM DATETIME N Not applicable to MDIColumn
TRIGGER_ID DOUBLE N table keyColumn
TRIGGER_STATUS_TEXT VARCHAR(132) Y Comment explaining the Process Status FlagColumn
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 applicable to MDIColumn


DI_CLIENT_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Device Integration Client Configuration
Definition: Configuration information mapping Enterprise Device Connectivity devices to Millenium Service Requests
Table Type: REFERENCE





Column Detail - DI_CLIENT_CONFIG


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.
DEVICE_NAME VARCHAR(256) N EDC Device Name
DI_CLIENT_CONFIG_ID DOUBLE N Unique Device Integration Client Configuration ID. Primary key for this table.
EDC_ENVIRONMENT VARCHAR(255) Y EDC ENVIRONMENT NAME
EDC_SERVICE_TYPE_CD DOUBLE N EDC Service Type code from codeset 4002001
SAMPLE_PERIOD DOUBLE N Minimum time since last sample was posted in seconds.
SERVICE_RESOURCE_CD DOUBLE N Service Resource Code from SERVICE_RESOURCE table
SUBSCRIPTION_NAME VARCHAR(256) N EDC Subscription Name
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 - DI_CLIENT_CONFIG


Child Column in DI_CLIENT_CONFIG(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


LAB_INSTRUMENT_CUSTOM



Column Section Top of Page


Table-level Detail

Description: Contains the site configured custom flags.
Definition: Contains the site specific custom interface flags.
Table Type: REFERENCE





Column Detail - LAB_INSTRUMENT_CUSTOM


Column Name Type Null? Definition
CONFIG_ID DOUBLE N Contains a DBMS unique key field value.
CUSTOM_OPTION VARCHAR(50) Y Contains the site specific string that turns on/off custom interface functionality.
DESCRIPTION LONGTEXT Y Contains an explanation of the custom flag.
DISPLAY VARCHAR(50) Y Reserved for future use
PROCESS_FLAG DOUBLE N This field indicates how the software flag should be processed. 1 - RTL, 2 - Interface, 3 - Both.
SERVICE_RESOURCE_CD DOUBLE N Contains the service resource cd code value.
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.


MDI_APPL_ACK



Column Section Relationship Section Top of Page


Table-level Detail

Description: MDI Application Acknowledgement
Definition: An Activity table which tracks the status and requests for MDI Application Acknowledgements.
Table Type: ACTIVITY





Column Detail - MDI_APPL_ACK


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y Identifies the accession number from the PROP_ORDER table when a request is successful.
CREATE_DT_TM DATETIME Y Date row was created.
ERROR_COND VARCHAR(4) Y A four digit error number that uniquely identifies the error when a request fails to place an order or post results.
INPROCESS_IND DOUBLE Y Indicates if this request is currently being processed.
MESSAGE_IDENT VARCHAR(32) Y A string received via a HL7 version 2.4 interface in the MSH segment, sequence 10. Used to uniquely identify HL7 messages.
ORDER_ID DOUBLE N Order ID to which this transfer record is associated.
PROCESS_STATUS_FLAG DOUBLE Y A two digit value that represents the status of requests in this table.
SERVICE_RESOURCE_CD DOUBLE N Identifies which service resource sent this request.
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 - MDI_APPL_ACK


Child Column in MDI_APPL_ACK(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD LAB_INSTRUMENT SERVICE_RESOURCE_CD


MDI_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MDI PARAMETER
Definition: This table will store MDI demographic parameters
Table Type: REFERENCE





Column Detail - MDI_PARAMETER


Column Name Type Null? Definition
MDI_PARAMETER_CD DOUBLE N MDI PARAMETER CODE from code set 4002311
MDI_PARAMETER_DEF VARCHAR(12) Y CDF MEANING of the MDI_PARAMETER code value (from code set 4002311)
MDI_PARAMETER_ID DOUBLE N PRIMARY KEY
SELECTED_IND DOUBLE N Indicates if the parameter was selected
SERVICE_RESOURCE_CD DOUBLE N Code Set 221: Internal identifier for the instrument.
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 - MDI_PARAMETER


Child Column in MDI_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD