Table Detail Report

SA_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Parameter
Definition: Parent record for a parameter that has values contained on an anesthesia record Based on how many parameters they monitor per case. Estimate 30:1 with SA_ANESTHESIA_RECORD. 783,000
Table Type: ACTIVITY





Column Detail - SA_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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
DISPLAY_SEQ DOUBLE Y used to see records based on sequence and also can resequence the records when ever needed
PRSNL_ID DOUBLE N User that added the parameter to the anesthesia record, if 0, added by macro
SA_ANESTHESIA_RECORD_ID DOUBLE N The Anesthesia Record that the parameter exists on
SA_MACRO_ID DOUBLE N Ties to the macro that added the parameter to the anesthesia record, if 0, added by user
SA_PARAMETER_ID DOUBLE N Unique value that identifies the parameter that has values on the anesthesia record
SA_REF_PARAMETER_ID DOUBLE N Ties to the SA_REF_PARAMETER table to identify the 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 - SA_PARAMETER


Child Column in SA_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_REF_PARAMETER_ID SA_REF_PARAMETER SA_REF_PARAMETER_ID




Parent Column in SA_PARAMETER (PK) Child Table Name Child Column Name
Children: SA_PARAMETER_ID SA_PARAMETER_MONITOR SA_PARAMETER_ID
SA_PARAMETER_VALUE SA_PARAMETER_ID


SA_PARAMETER_MONITOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Parameter Monitor
Definition: Based on how often they start/stop monitors within a case. Estimate 1:1 with SA_PARAMETER (maybe a bit larger). 783,000
Table Type: ACTIVITY





Column Detail - SA_PARAMETER_MONITOR


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ACTIVITY_DT_TM DATETIME Y The date/time the monitoring of the parameter was turned on or off
MONITOR_IND DOUBLE Y Indicates whether the parameter is being monitored (1=data pulled from BMDI) or not monitored (0=no data pulled from BMDI for this parameter)
PRSNL_ID DOUBLE N The user who turned the monitoring of the parameter on or off
SA_MACRO_ID DOUBLE N Ties to the macro that turned the monitoring of the parameter on or off, if 0, done by user
SA_PARAMETER_ID DOUBLE N The parent SA_PARAMETER record that is being or not being monitored
SA_PARAMETER_MONITOR_ID DOUBLE N Unique value that identifies the monitor record
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 - SA_PARAMETER_MONITOR


Child Column in SA_PARAMETER_MONITOR(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_PARAMETER_ID SA_PARAMETER SA_PARAMETER_ID


SA_PARAMETER_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Parameter Values
Definition: Contains individual values for the given SA_PARAMETER record contained on an anesthesia record. Based on the frequency they want to capture data and the length of case. For 1-minute intervals, 60 minute case it would be a 60:1 with SA_PARAMETER. For 5-minute intervals, 60 minute case it would be a 12:1 with SA_PARAMETER. Estimate max/year = 93,960,000
Table Type: ACTIVITY





Column Detail - SA_PARAMETER_VALUE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CHART_IND DOUBLE Y Indicates whether or not this value should be added to the persons chart, 1=Add to persons chart
COPIED_FROM_VALUE_ID DOUBLE N The SA_PARAMETER_VALUE_ID this value was copied from. Will = 0 if not copied.
DEVICE_ALIAS VARCHAR(40) Y Alias of the BMDI monitor that feeds the result.
EVENT_ID DOUBLE N Clinical Event row for this parameter value
LONG_TEXT_ID DOUBLE N The id to the long_text record for the comment associated to this value
MONITORED_VALUE_IND DOUBLE Y Monitor value indicator
NOMENCLATURE_ID DOUBLE N nomenclature_id for the parameter value
NUMERIC_VALUE DOUBLE Y Parameter Value
PREVIOUS_PARAMETER_VALUE_ID DOUBLE N The id to the value record before the record was changed. If 0, this is the original unchanged value
PRSNL_ID DOUBLE N The user who added the value
SA_PARAMETER_ID DOUBLE N The parent SA_PARAMETER record that this value is for
SA_PARAMETER_VALUE_ID DOUBLE N Unique value that identifies 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.
VALUE_DT_TM DATETIME Y The date/time that the value applies to



Relationship Detail - SA_PARAMETER_VALUE


Child Column in SA_PARAMETER_VALUE(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PRSNL_ID PRSNL PERSON_ID
SA_PARAMETER_ID SA_PARAMETER SA_PARAMETER_ID
COPIED_FROM_VALUE_ID SA_PARAMETER_VALUE SA_PARAMETER_VALUE_ID
PREVIOUS_PARAMETER_VALUE_ID SA_PARAMETER_VALUE SA_PARAMETER_VALUE_ID




Parent Column in SA_PARAMETER_VALUE (PK) Child Table Name Child Column Name
Children: SA_PARAMETER_VALUE_ID SA_PARAMETER_VALUE COPIED_FROM_VALUE_ID
SA_PARAMETER_VALUE PREVIOUS_PARAMETER_VALUE_ID


SA_PREFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Preference
Definition: Parent record for a subset of preference values used for anesthesia preferences Based on how many different views they want to have. Estimate < 100 rows initially - but may grow as users become more familiar with system. 100
Table Type: REFERENCE





Column Detail - SA_PREFERENCE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
LOCATION_CD DOUBLE N The location that this preference group is valid for, any location if 0
ORDER_CATALOG_CD DOUBLE N The procedure that this preference group is valid for, any procedure if 0
POSITION_CD DOUBLE N Stores position code that this preference applies to
PREFERENCE_SET_NAME CHAR(50) Y The display name of the preference group for this record
PREFERENCE_TYPE_CD DOUBLE N Defines the type of preference group this record is
PRSNL_ID DOUBLE N The user that has access to this preference group, any user if 0
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (i.e., Anesthesia, Case Tracking, CVNet - CardioVascular).
SA_PREFERENCE_ID DOUBLE N Unique value that identifies the preference group
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that the Preference Set is tied to
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 - SA_PREFERENCE


Child Column in SA_PREFERENCE(FK) Parent Table Name Parent Column Name
Parents: PREFERENCE_TYPE_CD CODE_VALUE CODE_VALUE
PRSNL_ID PRSNL PERSON_ID
SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID




Parent Column in SA_PREFERENCE (PK) Child Table Name Child Column Name
Children: SA_PREFERENCE_ID SA_PREFERENCE_VALUE SA_PREFERENCE_ID


SA_PREFERENCE_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Preference Values
Definition: Contains preference values used for anesthesia preferences Based on the number of SA_PREFERENCE rows. Estimate 50:1 with SA_PREFERENCE. 5,000
Table Type: REFERENCE





Column Detail - SA_PREFERENCE_VALUE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
PARENT_ENTITY_ID DOUBLE N For PREFERENCE_VALUE_TYPE_FLAG of ID, contains the id of the preference value
PARENT_ENTITY_NAME CHAR(50) N For PREFERENCE_VALUE_TYPE_FLAG of ID, contains the table name of where the id comes from
PREFERENCE_VALUE VARCHAR(250) Y The value of the preference
PREFERENCE_VALUE_NAME VARCHAR(250) Y The name of preference that is being set
PREFERENCE_VALUE_TYPE_FLAG DOUBLE N The type of value that PREFERENCE_VALUE is (string, number, date, etc.)
SA_PREFERENCE_ID DOUBLE N The parent Preference group that this value belongs to
SA_PREFERENCE_VALUE_ID DOUBLE N Unique value that identifies the preference value
SEQUENCE DOUBLE Y SEQUENCE - The sequence this preference setting should be displayed in
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 - SA_PREFERENCE_VALUE


Child Column in SA_PREFERENCE_VALUE(FK) Parent Table Name Parent Column Name
Parents: SA_PREFERENCE_ID SA_PREFERENCE SA_PREFERENCE_ID