Table Detail Report

SA_REF_MACRO_FLUID_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF MACRO FLUID ITEM
Definition: SA Reference Macro Fluid Item
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_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 N Administrated Amount
DURATION DOUBLE N Duration
SA_REF_MACRO_FLUID_ID DOUBLE N Foreign Key to Ref Macro Fluid key identifier
SA_REF_MACRO_FLUID_ITEM_ID DOUBLE N Primary Key
SEQUENCE DOUBLE N Sequence
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 Volume Rate
WEIGHT_BASED_RATE DOUBLE N The rate based on weight



Relationship Detail - SA_REF_MACRO_FLUID_ITEM


Child Column in SA_REF_MACRO_FLUID_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_REF_MACRO_FLUID_ID SA_REF_MACRO_FLUID SA_REF_MACRO_FLUID_ID


SA_REF_MACRO_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Macro Item
Definition: Contains detail records about items for a macro, when a line is executed an item will be added to the anesthesia record. Based on the # of Macros they have built. Estimate a 2:1 with SA_REF_MACRO. 200
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_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.
EXECUTE_IND DOUBLE Y Indicates whether this record is executed by default. 1=by default, execute this detail record when the macro is executed, the user will have to uncheck the record if they do not want this detail record executed. 0=by default, do not execute this detail record when the macro is executed. This detail record still shows up under the macro, but the user will have to mark this record if they want this record executed.
ITEM_ID DOUBLE N item id from item_master
RETURNED_QTY DOUBLE Y The amount of the item that was returned when the macro is executed
SA_REF_MACRO_ID DOUBLE N The macro id that this item detail belongs to
SA_REF_MACRO_ITEM_ID DOUBLE N Unique value that identifies each macro item detail record
TODO_IND DOUBLE N Indicates whether the item defaults to be put on the ToDo list when the macro is executed
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 amount of the item that should used when the macro is executed
WASTED_QTY DOUBLE Y The amount of the item that was wasted when the macro is executed



Relationship Detail - SA_REF_MACRO_ITEM


Child Column in SA_REF_MACRO_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID
SA_REF_MACRO_ID SA_REF_MACRO SA_REF_MACRO_ID


SA_REF_MACRO_MEDICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Macro Medication
Definition: Contains detail records about medications for a macro, when a line is executed a medication will be added to the anesthesia record. If the dosage, route, and unit cd are populated - an administration record will be added. Based on the # of Macros they have built. Estimate a 2:1 with SA_REF_MACRO. 200
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_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_AMOUNT DOUBLE Y This column is now obsolete. Valid data is in table SA_REF_MACRO_MED_ITEM. 8/1/03. Admin Amount
ADMIN_DOSAGE DOUBLE Y This column is now obsolete. Valid data is in table SA_REF_MACRO_MED_ITEM. 8/1/03. The dosage amount that will be used for the medication administration record that is added
ADMIN_RATE_CD DOUBLE N The admin rate code
ADMIN_ROUTE_CD DOUBLE N The route_cd that will be used for the medication administration record that is added
ADMIN_SITE_CD DOUBLE N The site_cd that will be used for the medication administration record that is added
AMOUNT_UNIT_CD DOUBLE N The admin unit code
CONCENTRATION DOUBLE Y ** OBSOLETE** Concentration NumberThis column will be addition of unit code columns - 6/24/05CAPE 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_cd that will be used for the medication administration record that is added
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
EXECUTE_IND DOUBLE Y Indicates whether this record is executed by default. 1=by default, execute this detail record when the macro is executed, the user will have to uncheck the record if they do not want this detail record executed. 0=by default, do not execute this detail record when the macro is executed. This detail record still shows up under the macro, but the user will have to mark this record if they want this record executed.
ITEM_ID DOUBLE N Item ID from Item master
MED_ADMIN_TYPE_FLAG DOUBLE Y Med Admin Type Flag
MED_PRODUCT_ID DOUBLE N The id that identifies the actual pharmacy product item FK from MED_PRODUCT
PIR_AMOUNT_UNIT_CD DOUBLE N unit for amount in PIR
PIR_TIME_UNIT_CD DOUBLE N unit for time in PIR
SA_REF_MACRO_ID DOUBLE N The macro id that this medication detail belongs to
SA_REF_MACRO_MEDICATION_ID DOUBLE N Unique value that identifies each macro medication detail record
TODO_IND DOUBLE N Indicates whether the item defaults to be put on the ToDo list when the macro is executed
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_REF_MACRO_MEDICATION


Child Column in SA_REF_MACRO_MEDICATION(FK) Parent Table Name Parent Column Name
Parents: DILUENT_ITEM_ID ITEM_MASTER ITEM_ID
ITEM_ID ITEM_MASTER ITEM_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
SA_REF_MACRO_ID SA_REF_MACRO SA_REF_MACRO_ID




Parent Column in SA_REF_MACRO_MEDICATION (PK) Child Table Name Child Column Name
Children: SA_REF_MACRO_MEDICATION_ID SA_REF_MACRO_MED_ITEM SA_REF_MACRO_MEDICATION_ID


SA_REF_MACRO_MED_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF MACRO MED ITEM
Definition: SA Reference Macro medication Item
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_MED_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 Admin Amount
ADMIN_DOSAGE DOUBLE Y Administration Dosage
DOSING_INFUSION_RATE DOUBLE Y The dosing infusion rate
DURATION DOUBLE Y The duration
PUMP_INFUSION_RATE DOUBLE Y The Pump Infusion Rate
SA_REF_MACRO_MEDICATION_ID DOUBLE N Ref macro med ID
SA_REF_MACRO_MED_ITEM_ID DOUBLE N SA Reference Macro Medication Item ID Primary Key
SEQUENCE DOUBLE N Sequence Number
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.
WEIGHT_BASED_DOSE DOUBLE Y The weight based dose



Relationship Detail - SA_REF_MACRO_MED_ITEM


Child Column in SA_REF_MACRO_MED_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_REF_MACRO_MEDICATION_ID SA_REF_MACRO_MEDICATION SA_REF_MACRO_MEDICATION_ID


SA_REF_MACRO_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Macro Parameter
Definition: Contains detail records about parameters for a macro Based on the # of Macros they have built. Estimate a 2:1 with SA_REF_MACRO. 200
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_PARAMETER


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_IND DOUBLE Y Indicates whether this record is executed by default. 1=by default, execute this detail record when the macro is executed, the user will have to uncheck the record if they do not want this detail record executed. 0=by default, do not execute this detail record when the macro is executed. This detail record still shows up under the macro, but the user will have to mark this record if they want this record executed.
MONITOR_IND DOUBLE Y Indicates whether the values associated with the parameter (sa_ref_parameter_id) should be pulled into the anesthesia record.
SA_REF_MACRO_ID DOUBLE N The macro id that this parameter detail belongs to
SA_REF_MACRO_PARAMETER_ID DOUBLE N Unique value that identifies each macro parameter record
TASK_ASSAY_CD DOUBLE N Task Assay Code from CODE_VALUE
TODO_IND DOUBLE N Indicates whether the item defaults to be put on the ToDo list when the macro is executed
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_MACRO_PARAMETER


Child Column in SA_REF_MACRO_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: SA_REF_MACRO_ID SA_REF_MACRO SA_REF_MACRO_ID