Table Detail Report

BMDI_DEVICE_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Device Parameter
Definition: Identifies the parameters that can be monitored for a given device.
Table Type: REFERENCE





Column Detail - BMDI_DEVICE_PARAMETER


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.
ALARM_HIGH VARCHAR(20) Y High Alarm Limit passed back to the application
ALARM_LOW VARCHAR(20) Y Low Alarm Limit passed back to the application
DECIMAL_PRECISION DOUBLE Y Specifies the number of significant decimal places for numeric types
DEVICE_CD DOUBLE N Used to identify parameters across service resources.
DEVICE_PARAMETER_ID DOUBLE N Provide a unique primary key
EVENT_CD DOUBLE N Event Code Value
PARAMETER_ALIAS VARCHAR(60) N Parameter Alias sent by device.
RESULT_TYPE_CD DOUBLE N Result Type Code identifier
SEQUENCE_NBR DOUBLE N Controls the order in which the parameter displays relative to other parameters for a particular device and relative to other parameters.
STRT_MODEL_PARAMETER_ID DOUBLE N Unique identifier for a parameter. From STRT_BMDI_MODEL_PARAMETER TABLE
TASK_ASSAY_CD DOUBLE N Task Assay Code Value
UNITS_CD DOUBLE N Identifies UnitsColumn
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BMDI_DEVICE_PARAMETER


Child Column in BMDI_DEVICE_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: DEVICE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
STRT_MODEL_PARAMETER_ID STRT_BMDI_MODEL_PARAMETER STRT_MODEL_PARAMETER_ID




Parent Column in BMDI_DEVICE_PARAMETER (PK) Child Table Name Child Column Name
Children: DEVICE_PARAMETER_ID BMDI_ACQUIRED_RESULTS DEVICE_PARAMETER_ID
BMDI_DEVICE_NOMENCLATURE DEVICE_PARAMETER_ID


BMDI_MONITORED_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Monitored Device
Definition: Identifies all BMDI devices, including their locations and aliases.
Table Type: REFERENCE





Column Detail - BMDI_MONITORED_DEVICE


Column Name Type Null? Definition
ALTERNATE_DEVICE_CD DOUBLE N Identifies alternate data port for the device. For example, used to accept demographic data received by the device in response to an appropriate request while the main device port identified by device_cd is used for clinical data sent out. (FK from SERVICE_RESOURCE)
ASSOCIATION_LIMIT_CNT DOUBLE N Determines maximum number of solution associations with the monitored device at a time - most common value is 1
DEVICE_ALIAS VARCHAR(40) N An alias sent by the device to identify itself.
DEVICE_CD DOUBLE N Used to identify which physical locations and device aliases are serviced by a service resource
DEVICE_IND DOUBLE N Identify device versus monitor. Device = 1, Monitor = 0.
DEVICE_TYPE_CD DOUBLE N Indicates the type of the device
LOCATION_CD DOUBLE N Specifies the physical location of this bmdi device alias.
MOBILE_IND DOUBLE N Identifies if this device can be mobile.
MONITORED_DEVICE_ID DOUBLE N the primary key
RESOURCE_LOC_CD DOUBLE N Specifies the physical location of this device alias.
STRT_MODEL_CHILD_ID DOUBLE N Identify child device model. Primary key in STRT_MODEL database table
STRT_MODEL_ID DOUBLE N Identify device to model.
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 - BMDI_MONITORED_DEVICE


Child Column in BMDI_MONITORED_DEVICE(FK) Parent Table Name Parent Column Name
Parents: ALTERNATE_DEVICE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
DEVICE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
STRT_MODEL_CHILD_ID STRT_MODEL STRT_MODEL_ID
STRT_MODEL_ID STRT_MODEL STRT_MODEL_ID




Parent Column in BMDI_MONITORED_DEVICE (PK) Child Table Name Child Column Name
Children: MONITORED_DEVICE_ID BMDI_ACQUIRED_DATA_TRACK MONITORED_DEVICE_ID
BMDI_ACQUIRED_RESULTS MONITORED_DEVICE_ID
SA_REF_DEVICE MONITORED_DEVICE_ID


CQM_BMDI_RESULTS_QUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CQM BMDI Results Queue
Definition: CQM Queue Table for BMDI Results
Table Type: ACTIVITY





Column Detail - CQM_BMDI_RESULTS_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 Will Contain the service_resource_cd of the interface.
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
CONTRIBUTOR_REFNUM VARCHAR(48) N A reference or key assigned to the transaction row by the contributor application.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
CREATE_RETURN_FLAG DOUBLE N create return flag. Can be one of following: not active; active; in progress; hold; failed; completed;
CREATE_RETURN_TEXT VARCHAR(132) Y Return text string from the trigger explosion process of this transaction row.
DEBUG_IND DOUBLE N Defines whether debugging is active or inactive for the queue transaction
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 N 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
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.
SUBTYPE VARCHAR(15) Y Identifies the trigger explosion subtype of the transaction - data format type cd.
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 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 N Defines the verbosity level during debugging for the processing of the transaction.



Relationship Detail - CQM_BMDI_RESULTS_QUE


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


DEVICE_HL7_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Device HL7 Map
Definition: Identifies which HL7 fields/components should be parsed for a given device.
Table Type: REFERENCE





Column Detail - DEVICE_HL7_MAP


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.
COMMON_IND DOUBLE N Indicates if this item should be saved and shared across result_sets.Column
COMPONENT_CD DOUBLE N Component code value
COMPONENT_FORMAT_CD DOUBLE N Identifies how a component should be formatted if required.
COMPONENT_ORDER DOUBLE N Order found in HL7 Data stream
COMPONENT_POSITION DOUBLE N Identifies specific HL7 component within a field.
DEVICE_CD DOUBLE N Used to provide Device HL7 Map across service resources.
DEVICE_HL7_MAP_ID DOUBLE N Sequence used as primary key.
FIELD_POSITION DOUBLE N Identifies specific HL7 field within a segment.
MAX_LENGTH DOUBLE N Maximum number of characters expected for this field/component
REQUIRED_IND DOUBLE N Indicates if this item is required in the result_set. 1 = yes, 0 = no.
RESULT_SET_POSITION DOUBLE N Defines the position in the result_set where this field/component should be stored.
SEGMENT_CD DOUBLE N Identifies HL7 segment
STRT_HL7_MAP_ID DOUBLE N Identifies HL7 Map format
STRT_MODEL_FORMAT_ID DOUBLE N Identifies the Start Model Format. FK from STRT_MODEL_FORMAT
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 - DEVICE_HL7_MAP


Child Column in DEVICE_HL7_MAP(FK) Parent Table Name Parent Column Name
Parents: DEVICE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
STRT_MODEL_FORMAT_ID STRT_MODEL_FORMAT STRT_MODEL_FORMAT_ID
STRT_HL7_MAP_ID STRT_MODEL_HL7_MAP STRT_HL7_MAP_ID


STRT_BMDI_MODEL_NOMENCLATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Starter BMDI Model Nomenclature
Definition: Identifies the alpha translations that can be performed for a given strt_model.
Table Type: REFERENCE





Column Detail - STRT_BMDI_MODEL_NOMENCLATURE


Column Name Type Null? Definition
ALPHA_TRANSLATION VARCHAR(50) N Resulting translated value.
DEFAULT_VALUE VARCHAR(50) N Default Device value requiring translation
STRT_MODEL_ID DOUBLE N This value is used to standardize Model information across systems.
STRT_MODEL_NOMENCLATURE_ID DOUBLE N Unique identifier to be used as a primary key for this table.
STRT_MODEL_PARAMETER_ID DOUBLE N Unique identifier for a parameter.
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 - STRT_BMDI_MODEL_NOMENCLATURE


Child Column in STRT_BMDI_MODEL_NOMENCLATURE(FK) Parent Table Name Parent Column Name
Parents: STRT_MODEL_PARAMETER_ID STRT_BMDI_MODEL_PARAMETER STRT_MODEL_PARAMETER_ID
STRT_MODEL_ID STRT_MODEL STRT_MODEL_ID