Table Detail Report

SA_REF_MACRO_SEQUENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Macro Sequence
Definition: Contains sequence information for items contained in a macro
Table Type: REFERENCE





Column Detail - SA_REF_MACRO_SEQUENCE


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.
PARENT_ENTITY_ID DOUBLE N The table that contains the item this sequence is defining
PARENT_ENTITY_NAME VARCHAR(30) N The table that contains the item this sequence is defining
SA_REF_MACRO_ID DOUBLE N The macro that this sequence is defining
SA_REF_MACRO_SEQUENCE_ID DOUBLE N Unique identifier for the record
SEQUENCE DOUBLE N Sequence of item within the macro
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_MACRO_SEQUENCE


Child Column in SA_REF_MACRO_SEQUENCE(FK) Parent Table Name Parent Column Name
Parents: SA_REF_MACRO_ID SA_REF_MACRO SA_REF_MACRO_ID


SA_REF_MEDICATION



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - SA_REF_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.
ITEM_ID DOUBLE N The item that identifies the medication item
MED_PRODUCT_ID DOUBLE N The id that identifies the actual pharmacy product item FK from MED_PRODUCT
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (I.e Anesthesia (0), CVNet (1)
SA_REF_MEDICATION_ID DOUBLE N Unique value to the medication 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_MEDICATION


Child Column in SA_REF_MEDICATION(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_MEDICATION (PK) Child Table Name Child Column Name
Children: SA_REF_MEDICATION_ID SA_MEDICATION SA_REF_MEDICATION_ID
SA_REF_CAT_MEDICATION SA_REF_MEDICATION_ID
SA_REF_EXCLUDE_MEDICATION SA_REF_MEDICATION_ID
SA_REF_MED_PREFERENCE SA_REF_MEDICATION_ID
SA_REF_REQUIRED_MEDICATION SA_REF_MEDICATION_ID


SA_REF_MED_PREFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Med Preference
Definition: This table will store the default units of measure and various display options to be used for a medication in the anesthesia meds dialog
Table Type: REFERENCE





Column Detail - SA_REF_MED_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.
BOLUS_DEFAULT_CURSOR_FLAG DOUBLE N Displays the dealult cursor location choosen choosen among the options for Bolus2 Weight Based Dose 4 Amount (Default) 5 Volume
BOLUS_DISPLAY_TYPE_FLAG DOUBLE N Determines what to display for bolus admins
CONC_AMOUNT_UNIT_CD DOUBLE N Default unit for amount field of concentration
CONC_DOSAGE_UNIT_CD DOUBLE N Default unit for dosage field of concentration
DEF_ROUTE_CD DOUBLE N Stores the default route for a medication.
DIR_DOSAGE_UNIT_CD DOUBLE N Default unit for dosage in DIR
DIR_TIME_UNIT_CD DOUBLE N Default unit for time in DIR
EXCLUDE_IN_TOTAL_VOL_IND DOUBLE Y Default Indicator to exclude medication ingredient volume from total concentration volume
INFUSION_DEFAULT_CURSOR_FLAG DOUBLE N Displays the dealult cursor location choosen choosen among the options for Infusion.1 Dosing Infusion Rate (default)2 Weight Based Dose3 Pump Infusion Rate4 Amount Infused5 Volume Infused
INFUSION_DISPLAY_TYPE_FLAG DOUBLE N Determines what to display for infusions
PIR_AMOUNT_UNIT_CD DOUBLE N Default unit for amount in PIR
PIR_TIME_UNIT_CD DOUBLE N Default unit for time in PIR
REMINDER_FREQUENCY_MINS DOUBLE Y The interval in minutes which represents the default value of frequency of the reminder associated to a medication.
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type Preference Set is tied to
SA_REF_MEDICATION_ID DOUBLE N Foreign key to sa_ref_medication
SA_REF_MED_PREFERENCE_ID DOUBLE N Primary table identifier
TOTAL_DISPLAY_TYPE_FLAG DOUBLE N Determines what to display for the total for the medication
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 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_MED_PREFERENCE


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


SA_REF_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Reference Parameter
Definition: Contains records that define all of the parameter values that can be selected within the anesthesia applications. Size - Based on the # of monitors they have and the parameters they want to be able to pull in. Estimate <500 rows.
Table Type: REFERENCE





Column Detail - SA_REF_PARAMETER


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.
REF_TYPE_FLAG DOUBLE N The type of reference this item is built for (I.e Anesthesia (0), CVNet (1)
SA_REF_ICON_ID DOUBLE N Id of the icon used when displaying this parameter or a value of this parameter to the user
SA_REF_PARAMETER_ID DOUBLE N Unique value to the parameter record
TASK_ASSAY_CD DOUBLE N DTA CD associated to the parameter that is being defined CODE SET 14003
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_PARAMETER


Child Column in SA_REF_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: SA_REF_ICON_ID SA_REF_ICON SA_REF_ICON_ID




Parent Column in SA_REF_PARAMETER (PK) Child Table Name Child Column Name
Children: SA_REF_PARAMETER_ID SA_PARAMETER SA_REF_PARAMETER_ID
SA_REF_CAT_PARAMETER SA_REF_PARAMETER_ID
SA_REF_EXCLUDE_PARAMETER SA_REF_PARAMETER_ID
SA_REF_REQUIRED_PARAMETER SA_REF_PARAMETER_ID


SA_REF_REQUIRED_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Required Action
Definition: Required Action
Table Type: REFERENCE





Column Detail - SA_REF_REQUIRED_ACTION


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_ID DOUBLE N Action to be required for the document type
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that action is required to be documented
SA_REF_REQUIRED_ACTION_ID DOUBLE N Unique identifier for row
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_REQUIRED_ACTION


Child Column in SA_REF_REQUIRED_ACTION(FK) Parent Table Name Parent Column Name
Parents: SA_REF_ACTION_ID SA_REF_ACTION SA_REF_ACTION_ID
SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID