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 |