Table Detail Report

SA_REF_FLUID



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference - Fluids
Definition: Contains records that define all of the fluid products that can be used in the anesthesia applications. Size - Based on the # of fluid types they want to define. Estimate 50 rows.
Table Type: REFERENCE





Column Detail - SA_REF_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.
EVENT_CD DOUBLE N Event Code from code set 72
ITEM_ID DOUBLE N The item that identifies the fluid item
MED_PRODUCT_ID DOUBLE N The id that identifies the actual pharmacy product item
OUT_IND DOUBLE N Indicates whether this is a fluid in or a fluid out (1=out,0=in)
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (I.e Anesthesia (0), CVNet (1)
SA_REF_FLUID_ID DOUBLE N Unique value to the fluid item record
TASK_ASSAY_CD DOUBLE N TASK ASSAY CODE
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_FLUID


Child Column in SA_REF_FLUID(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID




Parent Column in SA_REF_FLUID (PK) Child Table Name Child Column Name
Children: SA_REF_FLUID_ID SA_FLUID SA_REF_FLUID_ID
SA_REF_CAT_FLUID SA_REF_FLUID_ID
SA_REF_EXCLUDE_FLUID SA_REF_FLUID_ID
SA_REF_FLUID_PREFERENCE SA_REF_FLUID_ID
SA_REF_REQUIRED_FLUID SA_REF_FLUID_ID


SA_REF_FLUID_PREFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Anethesia reference fluid preference
Definition: This table will store the default units of measure and various display options to be used for a fluids in the anesthesia fluids dialog
Table Type: REFERENCE





Column Detail - SA_REF_FLUID_PREFERENCE


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.
DEF_ROUTE_CD DOUBLE N Stores the default route for a Fluid.
INFUSION_DISPLAY_TYPE_FLAG DOUBLE N Determines what to display for fluids
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type Preference Set is tied to
SA_REF_FLUID_ID DOUBLE N Unique value to the fluid item record
SA_REF_FLUID_PREFERENCE_ID DOUBLE N Unique generated number that identifies a single row on the sa_ref_fluid_preference table.
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_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 concentration
VOLUME_RATE_TIME_UNIT_CD DOUBLE N Default unit for time field of concentration
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_FLUID_PREFERENCE


Child Column in SA_REF_FLUID_PREFERENCE(FK) Parent Table Name Parent Column Name
Parents: SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID
SA_REF_FLUID_ID SA_REF_FLUID SA_REF_FLUID_ID


SA_REF_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Group
Definition: Contains all the top level groups that can be associated to an anesthesia action. Size - Based on the number of actions that are built. Estimate 1:1 with SA_REF_ACTION_GROUP_R.
Table Type: REFERENCE





Column Detail - SA_REF_GROUP


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.
BILL_IND DOUBLE N Indicates whether action detail for group should be displayed on the billing summary
GROUP_PROMPT VARCHAR(30) Y Group Prompt
MULTI_SELECT_IND DOUBLE N Indicates whether multiple action items contained within this group can be selected (1=multiple items can be selected, 0=only one item can be selected)
PRINT_IND DOUBLE N Indicates whether action detail for group should be printed on the finalized record
SA_REF_GROUP_ID DOUBLE N Unique value that identifies the group
SELECTION_REQUIRED_IND DOUBLE N Indicates whether there must be an action item selected within the group (1=An action item must be selected, 0=No action item has to be selected)
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_GROUP




Parent Column in SA_REF_GROUP (PK) Child Table Name Child Column Name
Children: SA_REF_GROUP_ID SA_REF_ACTION_GROUP_R SA_REF_GROUP_ID
SA_REF_ACTION_ITEM_CHILD_GROUP CHILD_REF_GROUP_ID
SA_REF_ACTION_ITEM_CHILD_GROUP CONTAINER_REF_GROUP_ID
SA_REF_GROUP_ACTION_ITEM_R SA_REF_GROUP_ID


SA_REF_GROUP_ACTION_ITEM_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Group Action Item - R
Definition: Relates which action items are contained within a group. Size - Based on the number of actions that are built. Estimate 2:1 with SA_REF_ACTION_ITEM.
Table Type: REFERENCE





Column Detail - SA_REF_GROUP_ACTION_ITEM_R


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_REF_ACTION_ITEM_ID DOUBLE N The action item that is contained within the group identified by SA_REF_GROUP_ID
SA_REF_GROUP_ACTION_ITEM_R_ID DOUBLE N Unique value to identify the group action item relationship
SA_REF_GROUP_ID DOUBLE N The group id that has the action item contained within it
SEQUENCE DOUBLE N The sequence that the action item falls within all of the action items within the group
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_GROUP_ACTION_ITEM_R


Child Column in SA_REF_GROUP_ACTION_ITEM_R(FK) Parent Table Name Parent Column Name
Parents: SA_REF_ACTION_ITEM_ID SA_REF_ACTION_ITEM SA_REF_ACTION_ITEM_ID
SA_REF_GROUP_ID SA_REF_GROUP SA_REF_GROUP_ID


SA_REF_ICON



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference - Icon
Definition: Contains all the icons that are used within the anesthesia applications. Size - Based on the # of categories and actions they build and if they want symbols for their parameter displays. Estimate 100 rows.
Table Type: REFERENCE





Column Detail - SA_REF_ICON


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.
ICON_NAME VARCHAR(30) Y Name associated to the icon
ICON_NAME_KEY VARCHAR(250) Y Name associated to the icon _key format
ICON_NAME_KEY_A_NLS VARCHAR(1000) Y ICON_NAME_KEY_A_NLS column
ICON_NAME_KEY_NLS VARCHAR(502) Y Name associated to the icon _key format National Language
ICON_TYPE_FLAG DOUBLE N Flag representing what type of icon is being referenced. 0 = Anesthesia 1 = Case Tracking
LONG_BLOB_ID DOUBLE N Id to the long blob table that contains the icon image
SA_REF_ICON_ID DOUBLE N Unique value to the anesthesia icon 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_ICON


Child Column in SA_REF_ICON(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID




Parent Column in SA_REF_ICON (PK) Child Table Name Child Column Name
Children: SA_REF_ICON_ID SA_REF_ACTION SA_REF_ICON_ID
SA_REF_CATEGORY SA_REF_ICON_ID
SA_REF_PARAMETER SA_REF_ICON_ID
TRACK_EVENT COMPLETE_ICON_ID
TRACK_EVENT REQUEST_ICON_ID
TRACK_EVENT START_ICON_ID