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 |