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 |