Table Detail Report

SA_REF_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Item
Definition: Contains records that define all of the items that can be used within the anesthesia applications. Size - Based on the # of inventory items they want to define. Estimate 100 rows.
Table Type: REFERENCE





Column Detail - SA_REF_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.
ITEM_ID DOUBLE N Id of the materials management item FK from ITEM_MASTER
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (I.e Anesthesia (0), CVNet (1)
SA_REF_ITEM_ID DOUBLE N Unique value to the anesthesia item 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_REF_ITEM


Child Column in SA_REF_ITEM(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID




Parent Column in SA_REF_ITEM (PK) Child Table Name Child Column Name
Children: SA_REF_ITEM_ID SA_ITEM SA_REF_ITEM_ID
SA_REF_CAT_ITEM SA_REF_ITEM_ID
SA_REF_EXCLUDE_ITEM SA_REF_ITEM_ID
SA_REF_MACRO_ACTION SA_REF_ITEM_ID
SA_REF_REQUIRED_ITEM SA_REF_ITEM_ID
SA_TODO_ACTION SA_REF_ITEM_ID
SA_TODO_ACTION_ITEM SA_REF_ITEM_ID


SA_REF_MACRO



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Macros
Definition: Parent record for all macros for the anesthesia applications, contains info about macro, details of the what the macro does is contained in the SA_REF_MACRO* tables Based on the # of Macros they want to build and how they want to build them (at facility/user/procedure level). As small as 5 or 6 - as large as ???? . 100
Table Type: REFERENCE





Column Detail - SA_REF_MACRO


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.
LOCATION_CD DOUBLE N Defines the only location that the macro can be executed from, any location if 0
MACRO_NAME VARCHAR(50) N The display name of the macro
MACRO_NAME_KEY VARCHAR(50) Y Macro Name Key. All Caps with no spaces.
MACRO_NAME_KEY_A_NLS VARCHAR(200) Y MACRO_NAME_KEY_A_NLS column
MACRO_NAME_KEY_NLS VARCHAR(102) Y Macro Name Key NLS component
ORDER_CATALOG_CD DOUBLE N Defines the only procedure for the surgical_case that the macro can be executed for, any procedure if 0
PRSNL_ID DOUBLE N Defines the only user that can execute the macro, any user if 0
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (I.e Anesthesia (0), CVNet (1)
SA_REF_CATEGORY_ID DOUBLE N Id to the SA category that the macro belongs to
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that Macro is available for.
SA_REF_MACRO_ID DOUBLE N Unique value that identifies each macro
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


Child Column in SA_REF_MACRO(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_REF_CATEGORY_ID SA_REF_CATEGORY SA_REF_CATEGORY_ID
SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID




Parent Column in SA_REF_MACRO (PK) Child Table Name Child Column Name
Children: SA_REF_MACRO_ID SA_MACRO SA_REF_MACRO_ID
SA_REF_MACRO_ACTION SA_REF_MACRO_ID
SA_REF_MACRO_FLUID SA_REF_MACRO_ID
SA_REF_MACRO_ITEM SA_REF_MACRO_ID
SA_REF_MACRO_MEDICATION SA_REF_MACRO_ID
SA_REF_MACRO_PARAMETER SA_REF_MACRO_ID
SA_REF_MACRO_SEQUENCE SA_REF_MACRO_ID


SA_REF_MACRO_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Macro Action
Definition: Contains detail records about actions for a macro, when a line is executed an action instance will be added to the anesthesia record. Based on the number of macros and the number of actions that are built. Estimate 1:1 with SA_REF_MACRO. 100
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_ACTION


Column Name Type Null? Definition
ACTION_VALUE VARCHAR(250) Y The value that will be used for the action when it is executed
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.
SA_REF_ACTION_ID DOUBLE N The action that will added when the macro is executed
SA_REF_ITEM_ID DOUBLE N The item that will be used as the item value for the action when it is executed
SA_REF_MACRO_ACTION_ID DOUBLE N Unique value that identifies each macro action detail record
SA_REF_MACRO_ID DOUBLE N The macro id that this item detail belongs to
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_ACTION


Child Column in SA_REF_MACRO_ACTION(FK) Parent Table Name Parent Column Name
Parents: SA_REF_ACTION_ID SA_REF_ACTION SA_REF_ACTION_ID
SA_REF_ITEM_ID SA_REF_ITEM SA_REF_ITEM_ID
SA_REF_MACRO_ID SA_REF_MACRO SA_REF_MACRO_ID




Parent Column in SA_REF_MACRO_ACTION (PK) Child Table Name Child Column Name
Children: SA_REF_MACRO_ACTION_ID SA_REF_MACRO_ACTION_ITEM SA_REF_MACRO_ACTION_ID


SA_REF_MACRO_ACTION_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Macro Action Item
Definition: Contains the action items that will documented when the parent macro action is executed Based on the number of macros and the number of actions that are built. Estimate 2:1 with SA_REF_MACRO_ACTION. 200
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_ACTION_ITEM


Column Name Type Null? Definition
ACTION_VALUE VARCHAR(250) Y The value that will be used for the action item when the parent macro action is executed
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 action item that will be documented if the parent macro action is executed
SA_REF_ITEM_ID DOUBLE N The item that will be used as the item value for the action item when the parent macro action is executed
SA_REF_MACRO_ACTION_ID DOUBLE N The parent action item that this action item falls under
SA_REF_MACRO_ACTION_ITEM_ID DOUBLE N Unique value that identifies the macro action item 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_REF_MACRO_ACTION_ITEM


Child Column in SA_REF_MACRO_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_MACRO_ACTION_ID SA_REF_MACRO_ACTION SA_REF_MACRO_ACTION_ID


SA_REF_MACRO_FLUID



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Macro Fluid
Definition: Contains detail records about fluids for a macro, when a line is executed a fluid will be added to the anesthesia record. If the dosage, site and unit cd are populated - an administration record will be added. Based on the # of Macros they have built. Estimate a 1:1 with SA_REF_MACRO. 100
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_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 dosage amount that will be used for the fluid administration record that is added
ADMIN_DOSAGE DOUBLE Y This column is not being used. OBSOLETE
ADMIN_RATE_CD DOUBLE N The unit_cd that will be used for the fluid administration record that is added
ADMIN_ROUTE_CD DOUBLE N Admin Route Code
ADMIN_SITE_CD DOUBLE N The site_cd that will be used for the fluid administration record that is added
AMOUNT_UNIT_CD DOUBLE N Amount Unit Code
DOSAGE_UNIT_CD DOUBLE N This column is not being used. OBSOLETE
EVENT_CD DOUBLE N The event code
EXECUTE_IND DOUBLE N Execute Indicator
FLUID_ADMIN_TYPE_FLAG DOUBLE N Fluid Admin Type Flag 0 not defined; 1 Bolus; 2 Infusion
ITEM_ID DOUBLE N ITEM ID FROM ITEM MASTER
MED_PRODUCT_ID DOUBLE N Medical Product ID. FK from Med_Product
OUT_IND DOUBLE Y This column is not being used. OBSOLETE
SA_REF_MACRO_FLUID_ID DOUBLE N Unique value that identifies each macro fluid detail record
SA_REF_MACRO_ID DOUBLE N The macro id that this fluid detail belongs to
TASK_ASSAY_CD DOUBLE N Task Assay code
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. 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_REF_MACRO_FLUID


Child Column in SA_REF_MACRO_FLUID(FK) Parent Table Name Parent Column Name
Parents: 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_FLUID (PK) Child Table Name Child Column Name
Children: SA_REF_MACRO_FLUID_ID SA_REF_MACRO_FLUID_ITEM SA_REF_MACRO_FLUID_ID