Table Detail Report

SA_FLUID_ADMIN_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Fluid Admin Item
Definition: Surginet Anesthesia Fluid Admin Item
Table Type: ACTIVITY





Column Detail - SA_FLUID_ADMIN_ITEM


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.
ADMIN_AMOUNT DOUBLE N Admin Amount value
ADMIN_START_DT_TM DATETIME N Start Date and Time
ADMIN_STOP_DT_TM DATETIME Y Stop Date and Time
SA_FLUID_ADMIN_ID DOUBLE N Foreign Key from SA Fluid Admin Identifier
SA_FLUID_ADMIN_ITEM_ID DOUBLE N Primary key
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.
VOLUME_RATE DOUBLE N Rate of Volume
WEIGHT_BASED_RATE DOUBLE N Weight Based rate



Relationship Detail - SA_FLUID_ADMIN_ITEM


Child Column in SA_FLUID_ADMIN_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_FLUID_ADMIN_ID SA_FLUID_ADMIN SA_FLUID_ADMIN_ID


SA_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Action Item
Definition: Contains records that documents what items were used for an anesthesia record Based on how many items they used during a case. Estimate 20:1 with SA_ANESTHESIA_RECORD. 522,000
Table Type: ACTIVITY





Column Detail - SA_ITEM


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 the item came from
PRSNL_ID DOUBLE N User that added the item to the anesthesia record, if 0, added by macro
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that this item is being documented for
SA_ITEM_ID DOUBLE N Unique value that identifies the item record
SA_MACRO_ID DOUBLE N Ties to the macro that added the item to the anesthesia record, if 0, done by user
SA_REF_ITEM_ID DOUBLE N Ties to the SA_REF_ITEM table to identify the item that was added
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_ITEM


Child Column in SA_ITEM(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_ITEM_ID SA_REF_ITEM SA_REF_ITEM_ID




Parent Column in SA_ITEM (PK) Child Table Name Child Column Name
Children: SA_ITEM_ID SA_ITEM_USAGE SA_ITEM_ID


SA_ITEM_USAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Item Usage
Definition: Contains records that document the quantities used, returned, wasted for items used on an anesthesia record Based on how many items they used during a case. Estimate 1:1 with SA_ITEM. 522,000
Table Type: ACTIVITY





Column Detail - SA_ITEM_USAGE


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.
CHARGE_QTY DOUBLE N The number of items that should be charged.
LONG_TEXT_ID DOUBLE N The long_text record that contains the comment for the item usage
PREVIOUS_ITEM_USAGE_ID DOUBLE N The id to the usage record before the record was changed. If 0, this is the original unchanged record
PRSNL_ID DOUBLE N The user who documented the quantities, if 0, added by a macro
RETURNED_QTY DOUBLE Y The number of this item that was returned in the anesthesia record
SA_ITEM_ID DOUBLE N The SA_ITEM record id that this usage record is documenting
SA_ITEM_USAGE_ID DOUBLE N Unique value that identifies the item usage record
SA_MACRO_ID DOUBLE N Ties to the macro that added the usage to the anesthesia record, if 0, added by user
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.
USAGE_DT_TM DATETIME Y The date/time the item usage occurred
USED_QTY DOUBLE Y The number of this item that was used in the anesthesia record
WASTED_QTY DOUBLE Y The number of this item that was wasted in the anesthesia record



Relationship Detail - SA_ITEM_USAGE


Child Column in SA_ITEM_USAGE(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_ITEM_ID SA_ITEM SA_ITEM_ID
PREVIOUS_ITEM_USAGE_ID SA_ITEM_USAGE SA_ITEM_USAGE_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID




Parent Column in SA_ITEM_USAGE (PK) Child Table Name Child Column Name
Children: SA_ITEM_USAGE_ID SA_ACTION SA_ITEM_USAGE_ID
SA_ACTION_ITEM SA_ITEM_USAGE_ID
SA_ITEM_USAGE PREVIOUS_ITEM_USAGE_ID


SA_LINKED_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA LINKED RESULT
Definition: Links results (Clinical Events) to the Anesthesia Record
Table Type: ACTIVITY





Column Detail - SA_LINKED_RESULT


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.
EVENT_CD DOUBLE N Event cd for the result
EVENT_ID DOUBLE N Event Id of the result (from CLINICAL_EVENT)
NORMALCY_CD DOUBLE N Normalcy value for the result
ORDER_ID DOUBLE N Order that the result came from
PRSNL_ID DOUBLE N Provider who attached the result to the record
RESULT_DETAILS VARCHAR(255) Y Value of the result
RESULT_DT_TM DATETIME N Date/Time of the result
RESULT_STATUS_CD DOUBLE N Status of the result
SA_ANESTHESIA_RECORD_ID DOUBLE N Anesthesia Record that the result links to
SA_LINKED_RESULT_ID DOUBLE N Unique Identifier for 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.
VERSION_NBR DOUBLE N Version number of the result



Relationship Detail - SA_LINKED_RESULT


Child Column in SA_LINKED_RESULT(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PRSNL_ID PRSNL PERSON_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID


SA_MACRO



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Macro
Definition: Contains records that document when macros are run for a particular anesthesia record Based on how many macros they execute in a case. Estimate 4:1 with SA_ANESTHESIA_RECORD. 104,400
Table Type: ACTIVITY





Column Detail - SA_MACRO


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.
EXECUTE_DT_TM DATETIME Y The date/time the macro was executed
PRSNL_ID DOUBLE N The user that executed the macro
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that this macro was executed for
SA_MACRO_ID DOUBLE N Unique value that identifies the macro record
SA_REF_MACRO_ID DOUBLE N The reference macro that this execution was based on
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_MACRO


Child Column in SA_MACRO(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_REF_MACRO_ID SA_REF_MACRO SA_REF_MACRO_ID




Parent Column in SA_MACRO (PK) Child Table Name Child Column Name
Children: SA_MACRO_ID SA_ACTION SA_MACRO_ID
SA_ACTION_ITEM SA_MACRO_ID
SA_FLUID SA_MACRO_ID
SA_FLUID_ADMIN SA_MACRO_ID
SA_ITEM SA_MACRO_ID
SA_ITEM_USAGE SA_MACRO_ID
SA_MEDICATION SA_MACRO_ID
SA_MEDICATION_ADMIN SA_MACRO_ID
SA_PARAMETER SA_MACRO_ID
SA_PARAMETER_MONITOR SA_MACRO_ID
SA_TODO_ACTION SA_MACRO_ID
SA_TODO_FLUID SA_MACRO_ID
SA_TODO_ITEM SA_MACRO_ID
SA_TODO_MEDICATION SA_MACRO_ID
SA_TODO_PARAMETER SA_MACRO_ID