Table Detail Report

SA_TODO_FLUID_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA To Do Fluid Item
Definition: Surginet Anesthesia To Do Fluid Item
Table Type: ACTIVITY





Column Detail - SA_TODO_FLUID_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 Y The admin amount for this fluid item
DURATION DOUBLE Y The duration of this item for the fluid
SA_TODO_FLUID_ID DOUBLE N The ToDo list fluid record this item belongs to
SA_TODO_FLUID_ITEM_ID DOUBLE N Unique Identifier for this record
SEQUENCE DOUBLE Y The sequence of this item for this fluid
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 Y the volume rate for the fluid item
WEIGHT_BASED_RATE DOUBLE Y The weight based rate for this fluid item



Relationship Detail - SA_TODO_FLUID_ITEM


Child Column in SA_TODO_FLUID_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_TODO_FLUID_ID SA_TODO_FLUID SA_TODO_FLUID_ID


SA_TODO_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA To Do Item
Definition: Surginet Anesthesia To Do Item
Table Type: ACTIVITY





Column Detail - SA_TODO_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.
COMPLETE_DT_TM DATETIME Y The date/time the todo item was completed
COMPLETE_IND DOUBLE N Indicates whether the todo item has been completed
ITEM_ID DOUBLE N The item id for the item being documented
LONG_TEXT_ID DOUBLE N Stores the Long Text Identifier
PREV_TODO_ITEM_ID DOUBLE N The previous version of the todo item item
PRSNL_ID DOUBLE N The Provider who added the item to the todo list.
RETURNED_QTY DOUBLE Y The number of this item that were returned
SA_MACRO_ID DOUBLE N The instance of a macro that added the item to the todo list.
SA_TODO_ITEM_ID DOUBLE N Unique Identifier for this record
SA_TODO_LIST_ID DOUBLE N The ToDo list record this item belongs 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.
USED_QTY DOUBLE Y The number of this item that were used
WASTED_QTY DOUBLE Y The number of this item that were wasted



Relationship Detail - SA_TODO_ITEM


Child Column in SA_TODO_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
PREV_TODO_ITEM_ID SA_TODO_ITEM SA_TODO_ITEM_ID
SA_TODO_LIST_ID SA_TODO_LIST SA_TODO_LIST_ID




Parent Column in SA_TODO_ITEM (PK) Child Table Name Child Column Name
Children: SA_TODO_ITEM_ID SA_TODO_ITEM PREV_TODO_ITEM_ID


SA_TODO_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA To Do List
Definition: Surginet Anesthesia To Do List
Table Type: ACTIVITY





Column Detail - SA_TODO_LIST


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.
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that this todo list belongs to
SA_TODO_LIST_ID DOUBLE N Unique identifier for the record
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_TODO_LIST


Child Column in SA_TODO_LIST(FK) Parent Table Name Parent Column Name
Parents: SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID




Parent Column in SA_TODO_LIST (PK) Child Table Name Child Column Name
Children: SA_TODO_LIST_ID SA_TODO_ACTION SA_TODO_LIST_ID
SA_TODO_FLUID SA_TODO_LIST_ID
SA_TODO_ITEM SA_TODO_LIST_ID
SA_TODO_LIST_SEQUENCE SA_TODO_LIST_ID
SA_TODO_MEDICATION SA_TODO_LIST_ID
SA_TODO_PARAMETER SA_TODO_LIST_ID


SA_TODO_LIST_SEQUENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA ToDo List Sequence
Definition: Defines sequence of To Do list items
Table Type: ACTIVITY





Column Detail - SA_TODO_LIST_SEQUENCE


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 The ID of the parent entity name table that this row refers to
PARENT_ENTITY_NAME VARCHAR(30) Y The table that this row refers to
SA_TODO_LIST_ID DOUBLE N The ToDo list this row is associated to
SA_TODO_LIST_SEQUENCE_ID DOUBLE N Unique identifier for the record
SEQUENCE DOUBLE Y The sequence of the item in the To Do list
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_TODO_LIST_SEQUENCE


Child Column in SA_TODO_LIST_SEQUENCE(FK) Parent Table Name Parent Column Name
Parents: SA_TODO_LIST_ID SA_TODO_LIST SA_TODO_LIST_ID


SA_TODO_MEDICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA To Do Medication
Definition: Surginet Anesthesia To Do Medication
Table Type: ACTIVITY





Column Detail - SA_TODO_MEDICATION


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_RATE_CD DOUBLE N The unit of measure for the rate the medication to be given
ADMIN_ROUTE_CD DOUBLE N The route the medication is to be given
ADMIN_SITE_CD DOUBLE N The site the medication is to be given
AMOUNT_UNIT_CD DOUBLE N The amount unit code
COMPLETE_DT_TM DATETIME Y The date/time the todo item was completed
COMPLETE_IND DOUBLE N Indicates whether the todo item has been completed
CONCENTRATION DOUBLE Y ** OBSOLETE** The concentration of the medicationThis column will no longer be used after addition of the various unit code and amount columns. 6/24/05. CAPE 158789
CONC_AMOUNT DOUBLE N amount field of concentration
CONC_AMOUNT_UNIT_CD DOUBLE N unit for amount field of concentration
CONC_DOSAGE DOUBLE N dosage field of concentration
CONC_DOSAGE_UNIT_CD DOUBLE N unit for dosage field of concentration
DILUENT_CONC_VOLUME DOUBLE N Diluent volume field for concentration
DILUENT_ITEM_ID DOUBLE N The item that identifies the diluent item, FK from ITEM_MASTER
DIR_DOSAGE_UNIT_CD DOUBLE N unit for dosage in DIR
DIR_TIME_UNIT_CD DOUBLE N unit for time in DIR
DOSAGE_UNIT_CD DOUBLE N The unit of measure for the dose of the medication to be given
ENCNTR_ID DOUBLE N Encounter which the order is associated with.
EXCLUDE_DIL_IN_TOTAL_VOL_IND DOUBLE Y Indicator to exclude diluent ingredient volume from total concentration volume
EXCLUDE_MED_IN_TOTAL_VOL_IND DOUBLE Y Indicator to exclude medication ingredient volume from total concentration volume
ITEM_ID DOUBLE N The item id for the medication
LONG_TEXT_ID DOUBLE N Stores the long text identifier
MED_ADMIN_TYPE_FLAG DOUBLE N The type of admin (bolus or infusion) this item is
MED_ORDER_TYPE_CD DOUBLE N The type of medication order. An example would be dialysis, IV, irrigation, etc.
MED_PRODUCT_ID DOUBLE N The med product id for the medication
ORDER_ID DOUBLE N Order that the Admin is associated to
PIR_AMOUNT_UNIT_CD DOUBLE N unit for amount in PIR
PIR_TIME_UNIT_CD DOUBLE N unit for time in PIR
PREV_TODO_MEDICATION_ID DOUBLE N The previous version of the todo medication item
PRSNL_ID DOUBLE N The provider who added the item to the todo list.
SA_MACRO_ID DOUBLE N The instance of a macro that added the item to the todo list.
SA_TODO_LIST_ID DOUBLE N The ToDo list record this item belongs to
SA_TODO_MEDICATION_ID DOUBLE N Unique Identifier for this record
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.
WBD_DOSAGE_UNIT_CD DOUBLE N unit for dosage in WBD
WBD_TIME_UNIT_CD DOUBLE N unit for time in WBD
WBD_WEIGHT_UNIT_CD DOUBLE N unit for weight in WBD



Relationship Detail - SA_TODO_MEDICATION


Child Column in SA_TODO_MEDICATION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
DILUENT_ITEM_ID ITEM_MASTER ITEM_ID
ITEM_ID ITEM_MASTER ITEM_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
ORDER_ID ORDERS ORDER_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_TODO_LIST_ID SA_TODO_LIST SA_TODO_LIST_ID
PREV_TODO_MEDICATION_ID SA_TODO_MEDICATION SA_TODO_MEDICATION_ID




Parent Column in SA_TODO_MEDICATION (PK) Child Table Name Child Column Name
Children: SA_TODO_MEDICATION_ID SA_TODO_MEDICATION PREV_TODO_MEDICATION_ID
SA_TODO_MED_ITEM SA_TODO_MEDICATION_ID