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 |