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 |