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 |