Table Detail Report

SA_MEDICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Medication
Definition: Contains records that document what medications are used in an anesthesia record Based on the number of meds used during a case. Estimate 10:1 with SA_ANESTHESIA_RECORD. 261,000
Table Type: ACTIVITY





Column Detail - SA_MEDICATION


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 medication to the anesthesia record, if 0, added by macro
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that this medication is being documented on
SA_MACRO_ID DOUBLE N Ties to the macro that added the medication to the anesthesia record, if 0, done by user
SA_MEDICATION_ID DOUBLE N Ties to the SA_MEDICATION table to identify the medication that was added
SA_REF_MEDICATION_ID DOUBLE N Ties to the SA_REF_MEDICATION table to identify the medication 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_MEDICATION


Child Column in SA_MEDICATION(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_MEDICATION_ID SA_REF_MEDICATION SA_REF_MEDICATION_ID




Parent Column in SA_MEDICATION (PK) Child Table Name Child Column Name
Children: SA_MEDICATION_ID SA_MEDICATION_ADMIN SA_MEDICATION_ID
SA_MEDICATION_SIGNOFF SA_MEDICATION_ID


SA_MEDICATION_ADMIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Medication Administration
Definition: Contains records that document the administration of medications in an anesthesia record Based on the number of administrations of a given medication. Estimate 3:1 with SA_MEDICATION. 783,000
Table Type: ACTIVITY





Column Detail - SA_MEDICATION_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 This column is now obsolete. Valid data is in table SA_MED_ADMIN_ITEM. 8/1/03. The amount of the medication administered
ADMIN_DOSAGE DOUBLE Y This column is now obsolete. Valid data is in table SA_MED_ADMIN_ITEM. 8/1/03. The amount of the medication administered
ADMIN_RATE_CD DOUBLE N Rate code
ADMIN_ROUTE_CD DOUBLE N The route used for the administration
ADMIN_SITE_CD DOUBLE N The site that the medication was administered
ADMIN_START_DT_TM DATETIME Y This column is now obsolete. Valid data is in table SA_MED_ADMIN_ITEM. 8/1/03. The date/time the administration was started
ADMIN_STOP_DT_TM DATETIME Y This column is now obsolete. Valid data is in table SA_MED_ADMIN_ITEM. 8/1/03. The date/time the administration was ended if it was continuous
AMOUNT_UNIT_CD DOUBLE N Unit code
BARCODE_SCAN_TXT VARCHAR(100) Y The column will hold the NDC code of the scanned medication.
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
CONCENTRATION DOUBLE Y ** OBSOLETE** ConcentrationThis column is no longer used after adding the various unit code and amount columns. 6/24/05. CAPE 158789
CONC_AMOUNT DOUBLE N amount field of concentration
CONC_AMOUNT_UNIT_CD DOUBLE N unit for amount field of concentration
CONC_DOSAGE DOUBLE N dosage field of concentration
CONC_DOSAGE_UNIT_CD DOUBLE N unit for dosage field of concentration
CONTINUED_NO_BEGIN_BAG_IND DOUBLE N Indicates the infused medication was continued from an order which didn't have a begin bag event.
CONTINUE_OUT_IND DOUBLE N An indicator to Continue Medication Admin Orders Out of Anesthesia Application
DDMO_IND DOUBLE N Indicates whether the admin sent through the DDMO server when finalized
DILUENT_CONC_VOLUME DOUBLE N Diluent volume field for concentration
DIR_DOSAGE_UNIT_CD DOUBLE N unit for dosage in DIR
DIR_TIME_UNIT_CD DOUBLE N unit for time in DIR
DOSAGE_UNIT_CD DOUBLE N The unit of measure for the amount of the medication administered
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..
EXCLUDE_DIL_IN_TOTAL_VOL_IND DOUBLE Y Indicator to exclude diluent ingredient volume from total concentration volume
EXCLUDE_MED_IN_TOTAL_VOL_IND DOUBLE Y Indicator to exclude medication ingredient volume from total concentration volume
GROUP_EVENT_ID DOUBLE N identifier of medication administration's grouper clinical event (CLINICAL_EVENT.EVENT_ID)
HEIGHT DOUBLE Y Height value
HEIGHT_UNIT_CD DOUBLE N Height Unit Code
IBUS_RESULT_IDENT VARCHAR(50) Y The key used to identify individual medication results received from the ibus
IO_EVENT_ID DOUBLE N identifier of medication administration's intake result clinical event (CLINICAL_EVENT.EVENT_ID)
LONG_TEXT_ID DOUBLE N The long_text record that contains the comment for the administration
MED_ADMIN_TYPE_FLAG DOUBLE Y Med Admin Type Flag 1 = FLUID_ADMIN_TYPE BOLUS; 2 = FLUID_ADMIN_TYPE INFUSION
MED_ORDER_TYPE_CD DOUBLE N The type of medication order. An example would be dialysis, IV, irrigation, etc.
MED_PRODUCT_ID DOUBLE N The column will hold the product id of the scanned medication.
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
PIR_AMOUNT_UNIT_CD DOUBLE N unit for amount in PIR
PIR_TIME_UNIT_CD DOUBLE N unit for time in PIR
PREVIOUS_MED_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 Medication Administrations intake belongs to. From CE_RESULT_SET_LINK.
SA_MACRO_ID DOUBLE N Ties to the macro that added the admin to the anesthesia record, if 0, added by user
SA_MEDICATION_ADMIN_ID DOUBLE N Unique value that identifies the medication administration record
SA_MEDICATION_ID DOUBLE N The SA_MEDICATION record id that this administration record is documenting
SA_REF_DILUENT_ID DOUBLE N Unique ID of medication administrations Diluent Item
SENT_DT_TM DATETIME Y Date/Time when administratin 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. 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.
WBD_DOSAGE_UNIT_CD DOUBLE N unit for dosage in WBD
WBD_TIME_UNIT_CD DOUBLE N unit for time in WBD
WBD_WEIGHT_UNIT_CD DOUBLE N unit for weight in WBD
WEIGHT DOUBLE Y Weight Value
WEIGHT_UNIT_CD DOUBLE N The unit code for Weight



Relationship Detail - SA_MEDICATION_ADMIN


Child Column in SA_MEDICATION_ADMIN(FK) Parent Table Name Parent Column Name
Parents: ORDER_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID
TEMPLATE_ORDER_ID ORDERS ORDER_ID
PRSNL_ID PRSNL PERSON_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_MEDICATION_ID SA_MEDICATION SA_MEDICATION_ID
PREVIOUS_MED_ADMIN_ID SA_MEDICATION_ADMIN SA_MEDICATION_ADMIN_ID
SA_REF_DILUENT_ID SA_REF_DILUENT SA_REF_DILUENT_ID
TASK_ID TASK_ACTIVITY TASK_ID




Parent Column in SA_MEDICATION_ADMIN (PK) Child Table Name Child Column Name
Children: SA_MEDICATION_ADMIN_ID SA_MEDICATION_ADMIN PREVIOUS_MED_ADMIN_ID
SA_MED_ADMIN_ITEM SA_MEDICATION_ADMIN_ID


SA_MEDICATION_SIGNOFF



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Medication Signoff
Definition: Contains records that document the amount of medication that was wasted and returned Based on the number of medications they use that are controlled medications. Estimate it's a 1:3 with SA_MEDICATION. 87,000
Table Type: ACTIVITY





Column Detail - SA_MEDICATION_SIGNOFF


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.
PREVIOUS_MED_SIGNOFF_ID DOUBLE N The id to the signoff record before the record was changed. If 0, this is the original unchanged record
PRSNL_ID DOUBLE N The user who is signing the amounts returned and wasted
RETURNED_QTY DOUBLE Y The amount of the medication that was returned
SA_MEDICATION_ID DOUBLE N The SA_MEDICATION record id that this administration record is documenting
SA_MEDICATION_SIGNOFF_ID DOUBLE N Unique value that identifies the medication signoff record
SIGNED_DT_TM DATETIME Y The date/time the user signed off on the amount returned and wasted
SIGNED_TYPE_FLAG DOUBLE N Indicates what type of signature this record is for, 1=signed, 2=witnessed
TOTAL_DISPENSED_QTY DOUBLE N Total amout of Dispensed Quantity
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_UNIT_CD DOUBLE N Volume code
WASTED_QTY DOUBLE Y The amount of the medication that was wasted



Relationship Detail - SA_MEDICATION_SIGNOFF


Child Column in SA_MEDICATION_SIGNOFF(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_MEDICATION_ID SA_MEDICATION SA_MEDICATION_ID
PREVIOUS_MED_SIGNOFF_ID SA_MEDICATION_SIGNOFF SA_MEDICATION_SIGNOFF_ID




Parent Column in SA_MEDICATION_SIGNOFF (PK) Child Table Name Child Column Name
Children: SA_MEDICATION_SIGNOFF_ID SA_MEDICATION_SIGNOFF PREVIOUS_MED_SIGNOFF_ID
SA_MED_SIGNOFF_SIGNATURE SA_MEDICATION_SIGNOFF_ID


SA_MED_ADMIN_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Medication Admin items
Definition: SA Medication Admin Items - Child of SA_Medication_Admin table.
Table Type: ACTIVITY





Column Detail - SA_MED_ADMIN_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.
ADMIN_AMOUNT DOUBLE Y Admin Amount value
ADMIN_DOSAGE DOUBLE Y Admin Dosage value
ADMIN_START_DT_TM DATETIME Y Start Date and Time
ADMIN_STOP_DT_TM DATETIME Y Stop Date and Time
DOSING_INFUSION_RATE DOUBLE Y The dosing infusion rate
PUMP_INFUSION_RATE DOUBLE Y The Pump Infusion Rate
SA_MEDICATION_ADMIN_ID DOUBLE N SA Medication Admin ID - foreign key
SA_MED_ADMIN_ITEM_ID DOUBLE N SA Medication Admin Item ID - Primary Key
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.
WEIGHT_BASED_DOSE DOUBLE Y Dose based on Weight



Relationship Detail - SA_MED_ADMIN_ITEM


Child Column in SA_MED_ADMIN_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_MEDICATION_ADMIN_ID SA_MEDICATION_ADMIN SA_MEDICATION_ADMIN_ID


SA_MED_SIGNOFF_SIGNATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Medication Signoff Signature
Definition: Contains signatures for medications contained on an anesthesia record.
Table Type: ACTIVITY





Column Detail - SA_MED_SIGNOFF_SIGNATURE


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_MEDICATION_SIGNOFF_ID DOUBLE N SA Medication Signoff ID - Foreign Key from SA_MEDICATION_SIGNOFF that this signature pertains to.
SA_MED_SIGNOFF_SIGNATURE_ID DOUBLE N Primary Key from SURGERY_SEQ - unique ID that identifies this signature.
SIGNATURE_TYPE_FLAG DOUBLE N The type of signature this record is for. 1 = Signature. 2 = Witness.
SIGNED_BY_PRSNL_ID DOUBLE N Signed by Personnel ID - Foreign key from PRSNL table. ID of person who signed the record.
SIGNED_DT_TM DATETIME N The date and time the user signed the 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_MED_SIGNOFF_SIGNATURE


Child Column in SA_MED_SIGNOFF_SIGNATURE(FK) Parent Table Name Parent Column Name
Parents: SIGNED_BY_PRSNL_ID PRSNL PERSON_ID
SA_MEDICATION_SIGNOFF_ID SA_MEDICATION_SIGNOFF SA_MEDICATION_SIGNOFF_ID