SA_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Actions
Definition: Contains records that document the anesthesia Actions that exist on an anesthesia record Based on the number of actions that are documented during a case. Estimate 10:1 with SA_ANESTHESIA_RECORD. 261,000
Table Type: ACTIVITY





Column Detail - SA_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y Action Date and Time
ACTION_VALUE VARCHAR(250) Y Action Value
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_ID DOUBLE N identifier for clinical event row(s) for this action
LONG_TEXT_ID DOUBLE N Long Text ID
PREV_ACTION_ID DOUBLE N Previous SA Action ID
PRSNL_ID DOUBLE N Action Personnel ID
SA_ACTION_ID DOUBLE N Unique value that identifies the action contained on an anesthesia record
SA_ANESTHESIA_RECORD_ID DOUBLE N The anesthesia record that the action is documented on
SA_ITEM_USAGE_ID DOUBLE N SA ITEM USAGE ID
SA_MACRO_ID DOUBLE N SA MACRO ID
SA_REF_ACTION_ID DOUBLE N SA REFERENCE ACTION ID
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_ACTION


Child Column in SA_ACTION(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
PREV_ACTION_ID SA_ACTION SA_ACTION_ID
SA_ANESTHESIA_RECORD_ID SA_ANESTHESIA_RECORD SA_ANESTHESIA_RECORD_ID
SA_ITEM_USAGE_ID SA_ITEM_USAGE SA_ITEM_USAGE_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_REF_ACTION_ID SA_REF_ACTION SA_REF_ACTION_ID




Parent Column in SA_ACTION (PK) Child Table Name Child Column Name
Children: SA_ACTION_ID SA_ACTION PREV_ACTION_ID
SA_ACTION_ITEM SA_ACTION_ID
SA_ACTION_SIGNATURE SA_ACTION_ID


SA_ACTION_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN Action Item
Definition: Documents additional information about an instance of an action Based on the number of actions that are documented during a case. Estimate 2:1 with SA_ACTION. 522,000
Table Type: ACTIVITY





Column Detail - SA_ACTION_ITEM


Column Name Type Null? Definition
ACTION_VALUE VARCHAR(250) Y The value associated with this action item
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.
LONG_TEXT_ID DOUBLE N The long_text record that contains the comment for this action item
PRSNL_ID DOUBLE N The user who documented the action item, if 0, added by a macro
SA_ACTION_ID DOUBLE N The action that this action item is documenting
SA_ACTION_ITEM_ID DOUBLE N Unique value that identifies the action item
SA_ITEM_USAGE_ID DOUBLE N The item usage record created from this action item value
SA_MACRO_ID DOUBLE N Ties to the macro that added the action item to the anesthesia record, if 0, added by user
SA_REF_ACTION_ITEM_ID DOUBLE N The action item that this is documenting
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_ACTION_ITEM


Child Column in SA_ACTION_ITEM(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_ACTION_ID SA_ACTION SA_ACTION_ID
SA_ITEM_USAGE_ID SA_ITEM_USAGE SA_ITEM_USAGE_ID
SA_MACRO_ID SA_MACRO SA_MACRO_ID
SA_REF_ACTION_ITEM_ID SA_REF_ACTION_ITEM SA_REF_ACTION_ITEM_ID


SA_ACTION_SIGNATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Action Signature
Definition: Surginet Anesthesia Action Signature
Table Type: ACTIVITY





Column Detail - SA_ACTION_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_ACTION_ID DOUBLE N SA Action that this signature is for
SA_ACTION_SIGNATURE_ID DOUBLE N Unique identifier for record
SIGNED_BY_PRSNL_ID DOUBLE N The user id for the provider who signed the action
SIGNED_DT_TM DATETIME N The date/time the user signed the action
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_ACTION_SIGNATURE


Child Column in SA_ACTION_SIGNATURE(FK) Parent Table Name Parent Column Name
Parents: SIGNED_BY_PRSNL_ID PRSNL PERSON_ID
SA_ACTION_ID SA_ACTION SA_ACTION_ID


SA_ANESTHESIA_CHARGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Anesthesia Charge
Definition: This table is an extension of SA_ANESTHESIA_RECORD table to indicate whether an anesthesia entity should be processed for charging.
Table Type: ACTIVITY





Column Detail - SA_ANESTHESIA_CHARGE


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.
CHARGE_ENTITY_ID DOUBLE N ID of the Anesthesia charging element.
CHARGE_ENTITY_NAME VARCHAR(30) N Name of Anesthesia charging element (table or monitor)
CHARGE_IND DOUBLE N Indicates whether this element should be processed for charging
SA_ANESTHESIA_CHARGE_ID DOUBLE N Primary key for rows in this table
SA_ANESTHESIA_RECORD_ID DOUBLE N Foreign key value from SA_ANESTHESIA_RECORD 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_ANESTHESIA_CHARGE


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


SA_ANESTHESIA_RECORD



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Anethesia Record
Definition: Top-Level Anesthesia Record containing surgical case and when the record was initially created 1 record per case that is documented. 26,100
Table Type: ACTIVITY





Column Detail - SA_ANESTHESIA_RECORD


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 This column is now obsolete. It has been replace by column EVENT_ID. The FK constraint to clinical_event.clinical_event_id has been disabled. 7/31/03
CREATED_BY_PRSNL_ID DOUBLE N User who originally created the anesthesia record
CREATE_DT_TM DATETIME Y Date/Time the anesthesia record was originally created
CREATE_LOCATION_CD DOUBLE N Location where the PC that created the anesthesia record is located
EVENT_ID DOUBLE N Event ID. Logical Event ID from Clinical Event. This is not the CE primary key field.
FINALIZATION_TYPE_FLAG DOUBLE N Determines which method was used to finalize the anesthesia record. 0 = finalized using original finalization method; 1 = finalized using new finalization method
LAST_DOC_DT_TM DATETIME Y The last time the record was opened for documentation.
LAST_DOC_PRSNL_ID DOUBLE N Contains the id of the user who last had the record opened for documentation.
RECORD_DESCRIPTION VARCHAR(50) Y Anesthesia record description
SA_ANESTHESIA_RECORD_ID DOUBLE N Unique value to identify the anesthesia record
SA_REF_DOC_TYPE_ID DOUBLE N The SA Ref Doc Type for this record
SUPERVISOR_REQ_IND DOUBLE N The supervisor_req_ind is set to 1 if Supervision is not required, set to 0 if Supervision is required or if SaDBBuild setting is off.
SURGICAL_CASE_ID DOUBLE N Surgical Case this Anesthesia Record is documenting
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.



Relationship Detail - SA_ANESTHESIA_RECORD


Child Column in SA_ANESTHESIA_RECORD(FK) Parent Table Name Parent Column Name
Parents: CLINICAL_EVENT_ID CLINICAL_EVENT CLINICAL_EVENT_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID
SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID
SURGICAL_CASE_ID SURGICAL_CASE SURG_CASE_ID




Parent Column in SA_ANESTHESIA_RECORD (PK) Child Table Name Child Column Name
Children: SA_ANESTHESIA_RECORD_ID SA_ACTION SA_ANESTHESIA_RECORD_ID
SA_ANESTHESIA_CHARGE SA_ANESTHESIA_RECORD_ID
SA_ANESTHESIA_REC_FIELD_VALUES SA_ANESTHESIA_RECORD_ID
SA_ANESTHESIA_REC_LOCK SA_ANESTHESIA_RECORD_ID
SA_ANESTHESIA_REC_STATUS SA_ANESTHESIA_RECORD_ID
SA_CASE_ATTRIBUTE SA_ANESTHESIA_RECORD_ID
SA_CHARGE_POSTPONE SA_ANESTHESIA_RECORD_ID
SA_DISPLAY_RESULT SA_ANESTHESIA_RECORD_ID
SA_FLUID SA_ANESTHESIA_RECORD_ID
SA_ITEM SA_ANESTHESIA_RECORD_ID
SA_LINKED_RESULT SA_ANESTHESIA_RECORD_ID
SA_MACRO SA_ANESTHESIA_RECORD_ID
SA_MEDICATION SA_ANESTHESIA_RECORD_ID
SA_PARAMETER SA_ANESTHESIA_RECORD_ID
SA_PRSNL_ACTIVITY SA_ANESTHESIA_RECORD_ID
SA_REMINDER SA_ANESTHESIA_RECORD_ID
SA_TODO_LIST SA_ANESTHESIA_RECORD_ID