Table Detail Report

SA_REF_REQUIRED_PRSNL_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Required Prsnl Activity
Definition: Required Prsnl Activity
Table Type: REFERENCE





Column Detail - SA_REF_REQUIRED_PRSNL_ACTIVITY


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.
PRSNL_ACTIVITY_TYPE_CD DOUBLE N Prsnl Activity Type Cd that must be documented
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that prsnl activity type must be documented on
SA_REF_REQUIRED_PRSNL_ACT_ID DOUBLE N Unique identifier for row
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_REF_REQUIRED_PRSNL_ACTIVITY


Child Column in SA_REF_REQUIRED_PRSNL_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ACTIVITY_TYPE_CD CODE_VALUE CODE_VALUE
SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID


SA_REMINDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REMINDER
Definition: Contains information about adhoc and pre-built reminders in the anesthesia record.
Table Type: ACTIVITY





Column Detail - SA_REMINDER


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 and time the reminder was completed
COMPLETE_IND DOUBLE N Indication that the reminder has been completed
COMPLETE_PRSNL_ID DOUBLE N The clinical person who completed the reminder
PARENT_ENTITY_ID DOUBLE Y the row PK value from the table identified in field PARENT ENTITY NAME which contains the item this sequence is defining
PARENT_ENTITY_NAME VARCHAR(30) Y the parent table that contains the item this sequence is defining. the PK value of the parent table row id in PARENT_ENTITY_ID ;
PREV_REMINDER_ID DOUBLE N The previous reminder in a set of reminders
REMINDER_ALERT_DT_TM DATETIME Y The date and time the reminder alert triggered
REMINDER_DUE_DT_TM DATETIME Y The date and time the reminder is due
REMINDER_TEXT VARCHAR(250) N Text presented when the reminder triggers
REPEAT_ALERT_MINUTES_VAL DOUBLE Y The default alert time to use for repeat reminders. null value means subsequent repeat reminders will not have an alert.
REPEAT_MINUTES_VAL DOUBLE N The interval in minutes which represents the offset for the new due date/time when this reminder is completed.
SA_ANESTHESIA_RECORD_ID DOUBLE N Anesthesia record the reminder is associated with.
SA_REMINDER_ID DOUBLE N PRIMARY KEY
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_REMINDER


Child Column in SA_REMINDER(FK) Parent Table Name Parent Column Name
Parents: COMPLETE_PRSNL_ID PRSNL PERSON_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID
PREV_REMINDER_ID SA_REMINDER SA_REMINDER_ID




Parent Column in SA_REMINDER (PK) Child Table Name Child Column Name
Children: SA_REMINDER_ID SA_REMINDER PREV_REMINDER_ID


SA_TODO_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - SA_TODO_ACTION


Column Name Type Null? Definition
ACTION_VALUE VARCHAR(250) Y The value associated to this action
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
LONG_TEXT_ID DOUBLE N Stores the Long Text identifier
PREV_TODO_ACTION_ID DOUBLE N The previous version of the todo action 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_REF_ACTION_ID DOUBLE N The Anesthesia action to be performed
SA_REF_ITEM_ID DOUBLE N The item associated as the value to this action
SA_TODO_ACTION_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.



Relationship Detail - SA_TODO_ACTION


Child Column in SA_TODO_ACTION(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_REF_ACTION_ID SA_REF_ACTION SA_REF_ACTION_ID
SA_REF_ITEM_ID SA_REF_ITEM SA_REF_ITEM_ID
PREV_TODO_ACTION_ID SA_TODO_ACTION SA_TODO_ACTION_ID
SA_TODO_LIST_ID SA_TODO_LIST SA_TODO_LIST_ID




Parent Column in SA_TODO_ACTION (PK) Child Table Name Child Column Name
Children: SA_TODO_ACTION_ID SA_TODO_ACTION PREV_TODO_ACTION_ID
SA_TODO_ACTION_ITEM SA_TODO_ACTION_ID


SA_TODO_ACTION_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - SA_TODO_ACTION_ITEM


Column Name Type Null? Definition
ACTION_VALUE VARCHAR(250) Y The value associated to this action item
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_REF_ACTION_ITEM_ID DOUBLE N The Anesthesia Action Item to be added to the action
SA_REF_ITEM_ID DOUBLE N The item associated as the value to this action item
SA_TODO_ACTION_ID DOUBLE N The parent to do action for this action item
SA_TODO_ACTION_ITEM_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.



Relationship Detail - SA_TODO_ACTION_ITEM


Child Column in SA_TODO_ACTION_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_REF_ACTION_ITEM_ID SA_REF_ACTION_ITEM SA_REF_ACTION_ITEM_ID
SA_REF_ITEM_ID SA_REF_ITEM SA_REF_ITEM_ID
SA_TODO_ACTION_ID SA_TODO_ACTION SA_TODO_ACTION_ID


SA_TODO_FLUID



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - SA_TODO_FLUID


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 bag volume of the fluid to be given
ADMIN_RATE_CD DOUBLE N The unit of measure for the rate the fluid is to be given
ADMIN_ROUTE_CD DOUBLE N The route the fluid is to be given
ADMIN_SITE_CD DOUBLE N The site the fluid is to be given
AMOUNT_UNIT_CD DOUBLE N The unit of measure of the amount of the fluid to be given
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
EVENT_CD DOUBLE N The Event Cd for the fluid item
FLUID_ADMIN_TYPE_FLAG DOUBLE N Fluid Admin Type Flag: 0 not defined; 1 Bolus; 2 Infusion
ITEM_ID DOUBLE N The item id for the fluid
LONG_TEXT_ID DOUBLE N Stores the long text identifier
MED_PRODUCT_ID DOUBLE N The med product id for the fluid
PREV_TODO_FLUID_ID DOUBLE N The previous version of the todo fluid 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_FLUID_ID DOUBLE N Unique Identifier for this record
SA_TODO_LIST_ID DOUBLE N The ToDo list record this item belongs to
TASK_ASSAY_CD DOUBLE N Task assay code
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.
VOLUME_AMOUNT_UNIT_CD DOUBLE N Default unit for amount field of volume
VOLUME_RATE_AMOUNT_UNIT_CD DOUBLE N Default unit for amount field of Volume Rate
VOLUME_RATE_TIME_UNIT_CD DOUBLE N Default unit for time field of Volume Rate
WBD_DOSAGE_UNIT_CD DOUBLE N Default unit for dosage in WBD
WBD_TIME_UNIT_CD DOUBLE N Default unit for time in WBD
WBD_WEIGHT_UNIT_CD DOUBLE N Default unit for weight in WBD



Relationship Detail - SA_TODO_FLUID


Child Column in SA_TODO_FLUID(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
PREV_TODO_FLUID_ID SA_TODO_FLUID SA_TODO_FLUID_ID
SA_TODO_LIST_ID SA_TODO_LIST SA_TODO_LIST_ID




Parent Column in SA_TODO_FLUID (PK) Child Table Name Child Column Name
Children: SA_TODO_FLUID_ID SA_TODO_FLUID PREV_TODO_FLUID_ID
SA_TODO_FLUID_ITEM SA_TODO_FLUID_ID