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 |