Table Detail Report

STRT_BMDI_MODEL_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Starter BMDI Model Parameter
Definition: Identifies the parameters that can be monitored for a given strt_model.
Table Type: REFERENCE





Column Detail - STRT_BMDI_MODEL_PARAMETER


Column Name Type Null? Definition
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
DEFAULT_ALIAS VARCHAR(50) Y Parameter Alias sent by strt_model
PARAMETER_CD DOUBLE N Unique identifier for a parameter.
RESULT_TYPE_CD DOUBLE N Result Type identifier code
STRT_MODEL_ID DOUBLE N This value is used to standardize Model information across systems.
STRT_MODEL_PARAMETER_ID DOUBLE N Unique identifier to be used as a primary key for this table.
UNITS_CD DOUBLE N Identifies Units code
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_PARAMETER


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




Parent Column in STRT_BMDI_MODEL_PARAMETER (PK) Child Table Name Child Column Name
Children: STRT_MODEL_PARAMETER_ID BMDI_DEVICE_PARAMETER STRT_MODEL_PARAMETER_ID
STRT_BMDI_MODEL_NOMENCLATURE STRT_MODEL_PARAMETER_ID


STRT_MODEL_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Starter Model Format
Definition: Identifies which format should be used for a model by a version number
Table Type: REFERENCE





Column Detail - STRT_MODEL_FORMAT


Column Name Type Null? Definition
MODEL_VERSION DOUBLE N Identifies starter model version
RESULT_FORMAT_CD DOUBLE N Identifies the format that will be used for packaging results
STRT_MODEL_FORMAT_ID DOUBLE N Unique identifier to be used as a primary key for this table.
STRT_MODEL_ID DOUBLE N Identifies starter 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 - STRT_MODEL_FORMAT


Child Column in STRT_MODEL_FORMAT(FK) Parent Table Name Parent Column Name
Parents: STRT_MODEL_ID STRT_MODEL STRT_MODEL_ID




Parent Column in STRT_MODEL_FORMAT (PK) Child Table Name Child Column Name
Children: STRT_MODEL_FORMAT_ID DEVICE_HL7_MAP STRT_MODEL_FORMAT_ID
STRT_MODEL_HL7_MAP STRT_MODEL_FORMAT_ID


STRT_MODEL_HL7_MAP



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - STRT_MODEL_HL7_MAP


Column Name Type Null? Definition
COMMON_IND DOUBLE N Indicates if this item should be saved and shared across result_sets.
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 datastream
COMPONENT_POSITION DOUBLE N Identifies specific HL7 component within a field.
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 Sequence used as primary key
STRT_MODEL_FORMAT_ID DOUBLE N Identifies Starter Model format
STRT_MODEL_ID DOUBLE N This value is used to standardize Model information across systems.
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_MODEL_HL7_MAP


Child Column in STRT_MODEL_HL7_MAP(FK) Parent Table Name Parent Column Name
Parents: STRT_MODEL_ID STRT_MODEL STRT_MODEL_ID
STRT_MODEL_FORMAT_ID STRT_MODEL_FORMAT STRT_MODEL_FORMAT_ID




Parent Column in STRT_MODEL_HL7_MAP (PK) Child Table Name Child Column Name
Children: STRT_HL7_MAP_ID DEVICE_HL7_MAP STRT_HL7_MAP_ID


STRT_MODEL_LAB_TYPE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Starter Model Lab Type Relation
Definition: This table stores the default Lab Type relationships to the Starter models on the Starter Model Table.
Table Type: REFERENCE





Column Detail - STRT_MODEL_LAB_TYPE_R


Column Name Type Null? Definition
LAB_TYPE_CD DOUBLE N A related Lab Type Code for the given Starter Model.
STRT_MODEL_ID DOUBLE N The related Starter Model ID from the STRT_MODEL table.
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_MODEL_LAB_TYPE_R


Child Column in STRT_MODEL_LAB_TYPE_R(FK) Parent Table Name Parent Column Name
Parents: STRT_MODEL_ID STRT_MODEL STRT_MODEL_ID