Table Detail Report

SA_CHARGE_POSTPONE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Anesthesia Charge Postpone
Definition: This table is an extension of SA_ANESTHESIA_RECORD table to store reasons of why charges are postponed
Table Type: ACTIVITY





Column Detail - SA_CHARGE_POSTPONE


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.
POSTPONE_REASON VARCHAR(250) Y Reason why charges are postponed
SA_ANESTHESIA_RECORD_ID DOUBLE N Foreign Key from SA_ANESTHESIA_RECORD table.
SA_CHARGE_POSTPONE_ID DOUBLE N Primary key of this 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.



Relationship Detail - SA_CHARGE_POSTPONE


Child Column in SA_CHARGE_POSTPONE(FK) Parent Table Name Parent Column Name
Parents: SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID


SA_DISPLAY_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Display Result
Definition: Contains records that document when results are available to be displayed in an anesthesia record and who/when they were viewed Based on the # of results (labs,etc) that are resulted while the patient is in the OR. Estimate 2:1 with SA_ANESTHESIA_RECORD . 52,200
Table Type: ACTIVITY





Column Detail - SA_DISPLAY_RESULT


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.
CLINICAL_EVENT_ID DOUBLE N The clinical_event_id to the result that is being displayed
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that the result was displayed on
SA_DISPLAY_RESULT_ID DOUBLE N Unique value that identifies the result being displayed
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.
VIEWED_DT_TM DATETIME Y The date/time the result was viewed
VIEWED_IND DOUBLE Y Indicates whether the user viewed the result or not (1=viewed, 0=not viewed)
VIEWED_PRSNL_ID DOUBLE N The user that viewed the result



Relationship Detail - SA_DISPLAY_RESULT


Child Column in SA_DISPLAY_RESULT(FK) Parent Table Name Parent Column Name
Parents: CLINICAL_EVENT_ID CLINICAL_EVENT CLINICAL_EVENT_ID
VIEWED_PRSNL_ID PRSNL PERSON_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID


SA_FLUID



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Fluids
Definition: Contains records that document what fluids are used in an anesthesia record Based on the number of fluids used during a case. Estimate 5:1 with SA_ANESTHESIA_RECORD. 130,500
Table Type: ACTIVITY





Column Detail - SA_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.
DISPLAY_SEQ DOUBLE Y used to see records based on sequence and also can resequence the records when ever needed
PRSNL_ID DOUBLE N User that added the fluid to the anesthesia record, if 0, added by macro
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that this fluid is being documented on
SA_FLUID_ID DOUBLE N Unique value that identifies the fluid record
SA_MACRO_ID DOUBLE N Ties to the macro that added the fluid to the anesthesia record, if 0, done by user
SA_REF_FLUID_ID DOUBLE N Ties to the SA_REF_FLUID table to identify the fluid that was added
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_FLUID


Child Column in SA_FLUID(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_REF_FLUID_ID SA_REF_FLUID SA_REF_FLUID_ID




Parent Column in SA_FLUID (PK) Child Table Name Child Column Name
Children: SA_FLUID_ID SA_FLUID_ADMIN SA_FLUID_ID


SA_FLUID_ADMIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Fluid Admin
Definition: Contains records that document the administration of fluids in an anesthesia record Based on the number of administrations of a given fluid. Estimate 1:1 with SA_FLUID. 130,500
Table Type: ACTIVITY





Column Detail - SA_FLUID_ADMIN


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 amount of the fluid administered
ADMIN_DOSAGE DOUBLE Y This column is not being used. OBSOLETE
ADMIN_RATE_CD DOUBLE N ADMIN RATE CODE
ADMIN_ROUTE_CD DOUBLE N The route used for the administration
ADMIN_SITE_CD DOUBLE N The site that the fluid was administered
ADMIN_START_DT_TM DATETIME Y This column is not being used. OBSOLETE
ADMIN_STOP_DT_TM DATETIME Y This column is not being used. OBSOLETE
AMOUNT_UNIT_CD DOUBLE N The unit of measure for the amount of the fluid administered
BEGIN_BAG_EVENT_ID DOUBLE N The event ID for the last begin bag written out by SAAnesthesia (from CLINICAL EVENT)
CHARGED_IND DOUBLE N Indicates whether admin has been charged for from anesthesia
CONTINUED_NO_BEGIN_BAG_IND DOUBLE N Indicates the fluid was continued from an order which didn't have a begin bag event.
CONTINUE_OUT_IND DOUBLE N An indicator to Continue Fluid Admin Orders Out
DDMO_IND DOUBLE N Indicates whether the admin sent through the DDMO server when finalized
DOSAGE_UNIT_CD DOUBLE N This column is not being used. OBSOLETE
EVENT_ID DOUBLE N Uniquely identifies a logical clinical event row. It is returned from DDMO. It is used to cancel a med order and result when unfinalizing a record..
FLUID_ADMIN_TYPE_FLAG DOUBLE N Type of Fluid Administration. FLUID_ADMIN_TYPE_BOLUS = 1, FLUID_ADMIN_TYPE_INFUSION = 2.
GROUP_EVENT_ID DOUBLE N identifier of fluid administration's grouper clinical event (CLINICAL_EVENT.EVENT_ID)
HEIGHT DOUBLE Y Height value
HEIGHT_UNIT_CD DOUBLE N HEIGHT UNIT CODE
IO_EVENT_ID DOUBLE N identifier of fluid administration's intake or output result clinical event(CLINICAL_EVENT.EVENT_ID)
LONG_TEXT_ID DOUBLE N The long_text record that contains the comment for the administration
ORDERED_IND DOUBLE N Indicates whether the admin was documented against an existing order or is an ad hoc admin
ORDER_ID DOUBLE N Order that the admin is associated to
ORDER_LONG_TEXT_ID DOUBLE N The LONG_TEXT record that contains the comment for the order
PREVIOUS_FLUID_ADMIN_ID DOUBLE N The id to the admin record before the record was changed. If 0, this is the original unchanged record
PRSNL_ID DOUBLE N The user who documented the administration, if 0, added by a macro
RESULT_SET_ID DOUBLE N Identifier of the Result Set the Fluid Administrations intake or output result belongs to. From CE_RESULT_SET_LINK.
SA_FLUID_ADMIN_ID DOUBLE N Unique value that identifies the medication administration record
SA_FLUID_ID DOUBLE N The SA_FLUID record id that this administration record is documenting
SA_MACRO_ID DOUBLE N Ties to the macro that added the admin to the anesthesia record, if 0, added by user
SENT_DT_TM DATETIME Y Date/Time when administration was sent to Clinical Event
TASK_ID DOUBLE N Task that the admin is associated to
TEMPLATE_ORDER_ID DOUBLE N Parent Order that admin is documented against
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 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
WEIGHT DOUBLE Y Weight Value
WEIGHT_UNIT_CD DOUBLE N The unit code for Weight



Relationship Detail - SA_FLUID_ADMIN


Child Column in SA_FLUID_ADMIN(FK) Parent Table Name Parent Column Name
Parents: ORDER_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
TEMPLATE_ORDER_ID ORDERS ORDER_ID
PRSNL_ID PRSNL PERSON_ID
SA_FLUID_ID SA_FLUID SA_FLUID_ID
PREVIOUS_FLUID_ADMIN_ID SA_FLUID_ADMIN SA_FLUID_ADMIN_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
TASK_ID TASK_ACTIVITY TASK_ID




Parent Column in SA_FLUID_ADMIN (PK) Child Table Name Child Column Name
Children: SA_FLUID_ADMIN_ID SA_FLUID_ADMIN PREVIOUS_FLUID_ADMIN_ID
SA_FLUID_ADMIN_BAG SA_FLUID_ADMIN_ID
SA_FLUID_ADMIN_ITEM SA_FLUID_ADMIN_ID


SA_FLUID_ADMIN_BAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Fluid Admin Bag
Definition: Contains Bag information for given Fluid Admin
Table Type: ACTIVITY





Column Detail - SA_FLUID_ADMIN_BAG


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.
BAG_VOLUME DOUBLE Y The volume of the bag
DONOR_IDENTIFIER VARCHAR(250) N The identifier of the donor of the bag
SA_FLUID_ADMIN_BAG_ID DOUBLE N Unique identifier for the record
SA_FLUID_ADMIN_ID DOUBLE N The Fluid Admin the bag is associated to
SEQUENCE DOUBLE N The sequence of the bag
START_DT_TM DATETIME N The date/time the bag was started
STOP_DT_TM DATETIME N The date/time the bag was stopped
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_FLUID_ADMIN_BAG


Child Column in SA_FLUID_ADMIN_BAG(FK) Parent Table Name Parent Column Name
Parents: SA_FLUID_ADMIN_ID SA_FLUID_ADMIN SA_FLUID_ADMIN_ID