BMDI_ACQUIRED_DATA_TRACK



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Acquired Data Track
Definition: Association of Device to person/alternate record Identifiers.
Table Type: ACTIVITY





Column Detail - BMDI_ACQUIRED_DATA_TRACK


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.
ASSOCIATION_DT_TM DATETIME N This is the date and time the association is created.
ASSOCIATION_ID DOUBLE N Used as a primary key
ASSOC_PRSNL_ID DOUBLE N Person_id of associating personnel
DEVICE_CD DOUBLE N Used to identify which physical locations are associated to a service resource
DISSOC_PRSNL_ID DOUBLE N Person_id of dis-associating personnel
DIS_ASSOCIATION_DT_TM DATETIME Y The date and time the association is broken (dis-associated)
HINT_ID DOUBLE N Primary key in BMDI_ASSOCIATION_HINTS table
LOCATION_CD DOUBLE N Specifies the physical location of this person/alternate_record_id.
MONITORED_DEVICE_ID DOUBLE N Will store the monitore_device_id from the bmdi_monitored_device table.
PARENT_ENTITY_ID DOUBLE N Identifies which alternate_record_id is associated with a device and location
PARENT_ENTITY_NAME VARCHAR(32) N Identifies the table which the alternate_record_id is associated with a device and location comes from.
PERSON_ID DOUBLE N Identifies which person is associated with a device and location.
RESOURCE_LOC_CD DOUBLE N Specifies the physical location of this person/alternate_record_id.
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.
UPD_STATUS_CD DOUBLE N Valid values include: RETROSPECTIVE, UNVERIFIED, VERIFIED, Default(0)



Relationship Detail - BMDI_ACQUIRED_DATA_TRACK


Child Column in BMDI_ACQUIRED_DATA_TRACK(FK) Parent Table Name Parent Column Name
Parents: HINT_ID BMDI_ASSOCIATION_HINTS HINT_ID
MONITORED_DEVICE_ID BMDI_MONITORED_DEVICE MONITORED_DEVICE_ID
PERSON_ID PERSON PERSON_ID
ASSOC_PRSNL_ID PRSNL PERSON_ID
DISSOC_PRSNL_ID PRSNL PERSON_ID
DEVICE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in BMDI_ACQUIRED_DATA_TRACK (PK) Child Table Name Child Column Name
Children: ASSOCIATION_ID BMDI_ADT_PERSON_R ASSOCIATION_ID


BMDI_ACQUIRED_RESULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Acquired Results
Definition: All results from BMDI Devices that have been mapped to an event or task assay will be captured in this table.
Table Type: ACTIVITY





Column Detail - BMDI_ACQUIRED_RESULTS


Column Name Type Null? Definition
ACQUIRED_DT_TM DATETIME N Date and time results were received from the interface and stored in CQM.
CLINICAL_DT_TM DATETIME N Date and Time results were captured at the device
DEVICE_ID DOUBLE N Devices will obtain a new instance each time they are started and transmit with results. This value comes from an external source (external to Millennium).
DEVICE_PARAMETER_ID DOUBLE N Identifies parameter on BMDI_DEVICE_PARAMETER table
EVENT_ID DOUBLE N SEQUENCE NAME:CLINICAL_EVENT_SEQ in CLINICAL_EVENT table. Event where this result is stored as part of verification. EVENT_ID
LAB_TYPE_CD DOUBLE N Laboratory Type Code
MONITORED_DEVICE_ID DOUBLE N Identifies device on BMDI_MONITORED_DEVICE table.
NOMENCLATURE_ID DOUBLE N Nomenclature id for the parameter value
PARENT_ENTITY_ID DOUBLE N Alternative form to identify results, currently support for sa_anesthesia_record_id. Could be expanded to others in the future.
PARENT_ENTITY_NAME VARCHAR(32) N Alternative form to identify results, currently support for sa_anesthesia_record_id
PERSON_ID DOUBLE N Identifies person who these results are for.
RESULT_FORMAT_CD DOUBLE N Data Format Type
RESULT_ID DOUBLE N Primary key for this table.
RESULT_VAL VARCHAR(50) Y Result values sent from the device.
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.
VERIFIED_DT_TM DATETIME Y Date and Time results were verified
VERIFIED_IND DOUBLE N Indicates if results were verified.



Relationship Detail - BMDI_ACQUIRED_RESULTS


Child Column in BMDI_ACQUIRED_RESULTS(FK) Parent Table Name Parent Column Name
Parents: DEVICE_PARAMETER_ID BMDI_DEVICE_PARAMETER DEVICE_PARAMETER_ID
MONITORED_DEVICE_ID BMDI_MONITORED_DEVICE MONITORED_DEVICE_ID
PERSON_ID PERSON PERSON_ID


BMDI_ADT_PERSON_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Acquired Data Track Person Relationship
Definition: BMDI Acquired Data Track Person Relationship. Extends BMDI_ACQUIRED_DATA_TRACK database table with details of the person associated with the bedside medical device. Multiple rows could exist in this table for a specific row in BMDI_ACQUIRED_DATA_TRACK
Table Type: ACTIVITY





Column Detail - BMDI_ADT_PERSON_R


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.
ASSOCIATION_ID DOUBLE N Referring parent - Primary key in bmdi_acquired_data_track database table
ASSOCIATION_PRSNL_ID DOUBLE N Associating clinical personnel identifier - Equivalent to PERSON_ID in PRSNL database table
BMDI_ADT_PERSON_R_ID DOUBLE N Primary key
DIS_ASSOCIATION_PRSNL_ID DOUBLE N Disassociation Clinical Personnel Identifier. Equivalent to PERSON_ID in PRSNL table.
ENCNTR_ALIAS VARCHAR(200) Y Encounter alias value in Person Data Model - equivalent to ALIAS in ENCNTR_ALIAS database table
ENCNTR_ALIAS_TYPE_CD DOUBLE N Encounter alias type code value in Person Data Model - equivalent to ENCOUNTER_ALIAS_TYPE_CD in ENCNTR_ALIAS database table, like, FIN, Encounter Number etc.
ENCNTR_ID DOUBLE N Primary key in ENCOUNTER database table
HEIGHT_UNITS_CD DOUBLE N Code value defining UNIT of PERSON_HEIGHT
PERSON_ALIAS VARCHAR(200) Y Person alias value in Person Data Model - equivalent to ALIAS in PERSON_ALIAS database table
PERSON_ALIAS_TYPE_CD DOUBLE N Encounter alias type code value in Person Data Model - equivalent to ENCOUNTER_ALIAS_TYPE_CD in ENCNTR_ALIAS database table, like, FIN, Encounter Number etc.
PERSON_BIRTH_DT_TM DATETIME Y Equivalent to BIRTH_DT_TM in PERSON database table
PERSON_GENDER_CD DOUBLE N Code value defining gender
PERSON_HEIGHT VARCHAR(255) Y Result value in clinical event data model - equivalent to RESULT_VAL in CLINICAL_EVENT database table, corresponding value for EVENT_SET_CD_DISP_KEY of HEIGHT in V500_EVENT_SET_CODE database table
PERSON_NAME VARCHAR(100) N Person name value in Person Data Model - equivalent to NAME_FULL_FORMATTED in PERSON database table
PERSON_WEIGHT VARCHAR(255) Y Result value in clinical event data model - equivalent to RESULT_VAL in CLINICAL_EVENT database table, corresponding value for EVENT_SET_CD_DISP_KEY of WEIGHT in V500_EVENT_SET_CODE database table
STATUS_FLAG DOUBLE N Process Status Flag - Flag values to be documented...
STATUS_MESSAGE VARCHAR(255) Y A Status Message for the process
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.
WEIGHT_UNITS_CD DOUBLE N Code value defining UNIT of PERSON_WEIGHT



Relationship Detail - BMDI_ADT_PERSON_R


Child Column in BMDI_ADT_PERSON_R(FK) Parent Table Name Parent Column Name
Parents: ASSOCIATION_ID BMDI_ACQUIRED_DATA_TRACK ASSOCIATION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ASSOCIATION_PRSNL_ID PRSNL PERSON_ID
DIS_ASSOCIATION_PRSNL_ID PRSNL PERSON_ID


BMDI_ASSOCIATION_HINTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Association Hints
Definition: Hints for Association of Location(Device) to person/alternate record ids
Table Type: ACTIVITY





Column Detail - BMDI_ASSOCIATION_HINTS


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.
HINT_DT_TM DATETIME N Suggests time of association or dissociation of patient with location.
HINT_ID DOUBLE N Used as a primary key
HINT_PROCESSING_CD DOUBLE N Valid values: ACT, OBSOLETE, ACCEPT, DEFER, MODIFY, REJECT ACT - Start processing hint OBSOLETE - Obsoleted by latest entry for the BMDI location. ACCEPT - Confirm association or dissociation at this BMDI location in BMDI_ACQUIRED_DATA_TRACK table DEFER - Suspend default notification about hint. MODIFY - Retrospectively change association or dissociation connected with this hint. REJECT - Reject further processing on hint.
HINT_TYPE_CD DOUBLE N Valid values: ASSOCIATE, DISSOCIATE. ASSOCIATE when person moves to a BMDI location. DISSOCIATE when person moves out of a BMDI location.
LOCATION_CD DOUBLE N Specifies the physical location of this person/alternate_record_id. Usually bed_cd with cdf_meaning BED
PERSON_ID DOUBLE N Identifies which person is associated with the location.
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.
UPD_PRSNL_ID DOUBLE N Person_id of person from personnel table that caused last insert or update.



Relationship Detail - BMDI_ASSOCIATION_HINTS


Child Column in BMDI_ASSOCIATION_HINTS(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
UPD_PRSNL_ID PRSNL PERSON_ID




Parent Column in BMDI_ASSOCIATION_HINTS (PK) Child Table Name Child Column Name
Children: HINT_ID BMDI_ACQUIRED_DATA_TRACK HINT_ID


BMDI_DEVICE_NOMENCLATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: BMDI Device Nomenclature
Definition: Identifies the Alpha translations that can be performed for a given device.
Table Type: REFERENCE





Column Detail - BMDI_DEVICE_NOMENCLATURE


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.
ALPHA_TRANSLATION VARCHAR(50) N Resulting translated value.
DEVICE_CD DOUBLE N Used to identify translations across service resources.
DEVICE_NOMENCLATURE_ID DOUBLE N Used as a primary key.
DEVICE_PARAMETER_ID DOUBLE N Unique identifier for a parameter.
DEVICE_VALUE VARCHAR(50) N Device value requiring translation
NOMENCLATURE_ID DOUBLE N Nomenclature id for the parameter 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.



Relationship Detail - BMDI_DEVICE_NOMENCLATURE


Child Column in BMDI_DEVICE_NOMENCLATURE(FK) Parent Table Name Parent Column Name
Parents: DEVICE_PARAMETER_ID BMDI_DEVICE_PARAMETER DEVICE_PARAMETER_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
DEVICE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD