Table Detail Report

ORDER_INGREDIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Table is used to hold all the ingredients to a pharmacy order.
Definition: Table is used to hold all the ingredients to a pharmay order.
Table Type: ACTIVITY





Column Detail - ORDER_INGREDIENT


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence number of the action that was performed for this ingredient.
CATALOG_CD DOUBLE N This field contains the coded value for the order catalog code.
CATALOG_TYPE_CD DOUBLE N Identifies the catalog type that the order catalog should be assigned to .
CLINICALLY_SIGNIFICANT_FLAG DOUBLE N Determines if the ingredient is clinically significant to the order
COMP_SEQUENCE DOUBLE N Defines the sequence of components of ingredients.
CONCENTRATION DOUBLE N The amount of the ingredient in a given volume.
CONCENTRATION_UNIT_CD DOUBLE N The unit of measure on the ingredient's concentration.
DAYS_OF_ADMINISTRATION_DISPLAY VARCHAR(100) Y The textual display of the days of administration for an order ingredient which had variable dosage amounts. This represents the abbreviated formatting of the days of week which is based on the locale of the user performing the order action.
DOSE_ADJUSTMENT_DISPLAY VARCHAR(255) Y The textual display of the dose adjustment for an order ingredient. This includes the adjustment percentage and reason for adjustment. The dose calculator text is paired with this field and needs to be considered for usage of this field.
DOSE_CALCULATOR_LONG_TEXT_ID DOUBLE N The associated LONG_TEXT information (in XML) captured by Dose Calculator that contributes to the dosage calculation at ingredient level.
DOSE_QUANTITY DOUBLE Y The Dose Quantity -probably only used for an interface
DOSE_QUANTITY_UNIT DOUBLE Y The dose quantity unit -probably used only for an interface
DOSING_CAPACITY DOUBLE N Represents the total number of potential doses for a given day which were available during ordering for a variable dose order. For variable dose orders, this will always be populated with a positive value and for non-variable dose orders, this will be 0.
FREETEXT_DOSE VARCHAR(100) Y Free text that can be input concerning a dose. Allows the user to write comments about the dose.
FREQ_CD DOUBLE N Code to identify the frequency of the occurrence of this ingredient.
HNA_ORDER_MNEMONIC VARCHAR(100) Y This is the primary_mnemonic from the order_catalog. (The generic name)
INCLUDE_IN_TOTAL_VOLUME_FLAG DOUBLE N Determines if the ingredient is included in the total volume of an order
INGREDIENT_SOURCE_FLAG DOUBLE N Indicates whether the ingredient was added to the ORDER by a USER, or by the SYSTEM to satisfy an order requirement or as part of an auto assign process.
INGREDIENT_TYPE_FLAG DOUBLE Y This shows what type of ingredient it is.
IV_SEQ DOUBLE Y The IV sequence for this ingredient.
NORMALIZED_RATE DOUBLE N The amount of the ingredient to be administered per time unit or the amount of a medication to be administered per patient weight unit per time unit.
NORMALIZED_RATE_UNIT_CD DOUBLE N The unit of measure of the normalized rate.
ORDERED_AS_MNEMONIC VARCHAR(100) Y Text representing the name by which an ingredient was ordered.
ORDERED_AS_SYNONYM_ID DOUBLE N The id of the order catalog synonym for the orderable for this ingredient when it's originally ordered.
ORDERED_DOSE DOUBLE N The amount of the dose that was ordered.
ORDERED_DOSE_UNIT_CD DOUBLE N The unit of measure on the ordered dose.
ORDER_DETAIL_DISPLAY_LINE VARCHAR(255) Y The display line of order details for this order.
ORDER_ID DOUBLE N The order id for the order for this ingredient. Foreign Key to Order table.
ORDER_MNEMONIC VARCHAR(100) Y The mnemonic of the order for these ingredients.
STRENGTH DOUBLE Y The strength of this ingredient.
STRENGTH_UNIT DOUBLE Y The unit of measure for the strength of this ingredient.
SUPPLIED_AS_MNEMONIC VARCHAR(100) Y Supplied As this Mnemonic
SYNONYM_ID DOUBLE N The id of the order catalog synonym for the orderable for this ingredient.
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 DOUBLE Y The volume of this ingredient.
VOLUME_UNIT DOUBLE Y The units of measure for the volume for this ingredient.



Relationship Detail - ORDER_INGREDIENT


Child Column in ORDER_INGREDIENT(FK) Parent Table Name Parent Column Name
Parents: DOSE_CALCULATOR_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
ORDERED_AS_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID




Parent Column in ORDER_INGREDIENT (PK) Child Table Name Child Column Name
Children: ACTION_SEQUENCE ORDER_INGREDIENT_DOSE ACTION_SEQUENCE
COMP_SEQUENCE ORDER_INGREDIENT_DOSE COMP_SEQUENCE
ORDER_ID ORDER_INGREDIENT_DOSE ORDER_ID


ORDER_INGREDIENT_DOSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Ingredient Dose
Definition: Store the dosing information for an order ingredient when the dose ma vary per administration.
Table Type: ACTIVITY





Column Detail - ORDER_INGREDIENT_DOSE


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence of the related order action.
COMP_SEQUENCE DOUBLE N The sequence of the related order ingredient component.
DOSE_SEQUENCE DOUBLE N The sequence of the dose of the related order ingredient component. This value will be unique per order action that an ingredient is associated to. For variable dose ingredients, this dose sequence will resemble a dose's position in regards of a static dose capacity (i.e. third dose of four doses).
ORDERED_DOSE_TYPE_FLAG DOUBLE N Flag that indicates the type of dosing (strength vs. volume) that the ordered dose represents. Valid values: 1 - Ordered dose was entered as a strength dose, 2 - Ordered dose was entered as a volume dose.
ORDERED_DOSE_UNIT_CD DOUBLE N The codified value of the unit of measure associated to the ordered dose. This value will exist if the ordered dose value exists.
ORDERED_DOSE_VALUE DOUBLE N The value of the ordered dose for the given order ingredient dose instance.
ORDERED_DOSE_VALUE_DISPLAY VARCHAR(100) Y The textual display of the ordered dose value for the given order ingredient dose instance. This represents the numeric display formatting which relates to the locale of the user performing the order action. If the ordered dose exists, this display value will exist and should be used for any display purposes.
ORDER_ID DOUBLE N The ID of the related order.This is the ORDER_ID value from the PK of ORDER_INGREDIENT (master parent is ORDERS)
ORDER_INGREDIENT_DOSE_ID DOUBLE N The unique primary key of this table. It is an internally generated number.
SCHEDULE_SEQUENCE DOUBLE N The sequence of the related frequency schedule which this order ingredient dose instance represents. This sequence will always be populated for variable dosing (determined by dosing_method_flag of ORDERS table).
STRENGTH_DOSE_UNIT_CD DOUBLE N The codified value of the unit of measure associated to the strength dose for the given order ingredient dose instance. This value will exist if the strength dose value exists.
STRENGTH_DOSE_VALUE DOUBLE N The value of the volume dose for the given order ingredient dose instance.
STRENGTH_DOSE_VALUE_DISPLAY VARCHAR(100) Y The textual display of the strength dose value for the given order ingredient dose instance. This represents the numeric display formatting which relates to the locale of the user performing the order action. If the strength dose exists, this display value will exist and should be used for any display purposes.
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_DOSE_UNIT_CD DOUBLE N The codified value of the unit of measure associated to the volume dose for the given order ingredient dose instance. This value will exist if the volume dose value exists.
VOLUME_DOSE_VALUE DOUBLE N The value of the volume dose for the given order ingredient dose instance.
VOLUME_DOSE_VALUE_DISPLAY VARCHAR(100) Y The textual display of the volume dose value for the given order ingredient dose instance. This represents the numeric display formatting which relates to the locale of the user performing the order action. If the volume dose exists, this display value will exist and should be used for any display purposes.



Relationship Detail - ORDER_INGREDIENT_DOSE


Child Column in ORDER_INGREDIENT_DOSE(FK) Parent Table Name Parent Column Name
Parents: ACTION_SEQUENCE ORDER_INGREDIENT ACTION_SEQUENCE
COMP_SEQUENCE ORDER_INGREDIENT COMP_SEQUENCE
ORDER_ID ORDER_INGREDIENT ORDER_ID


ORDER_INGREDIENT_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Ingredient History
Definition: This table will store a history of the ingredients for an order, when they are replaced with a different ingredient by the system.
Table Type: ACTIVITY





Column Detail - ORDER_INGREDIENT_HISTORY


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence number of the order action that was performed for this ingredient.
COMP_SEQUENCE DOUBLE N The sequence number identifying the order of the ingredient.
FREETEXT_DOSE VARCHAR(100) Y Free text that can be input concerning a dose. Allows the user to write comments about the dose.
INGREDIENT_ALTER_FLAG DOUBLE N This flag will indicate what type of change occurred on the current order ingredient row. The possible values are: 1 - Modified, 2 - Add and 3 - Delete.
INGREDIENT_ALTER_TRIGGER_CD DOUBLE N This is a codified value that indicates what triggered the system to alter the ingredient. For example, Therapeutic Interchange - THERAPINTRCH.
ORDER_ID DOUBLE N The ID of the order whose ingredient was altered.
ORDER_INGREDIENT_HISTORY_ID DOUBLE N This is the value of the unique primary identifier of this table. It is a number internally assigned by the system.
STRENGTH DOUBLE Y The strength of this ingredient.
STRENGTH_UNIT_CD DOUBLE N Codified unit of measure on strength for this ingredient.
SYNONYM_ID DOUBLE N The ID of the order catalog synonym for this ingredient.
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 DOUBLE Y Volume of this ingredient.
VOLUME_UNIT_CD DOUBLE N Codified unit of measure on volume for this ingredient.



Relationship Detail - ORDER_INGREDIENT_HISTORY


Child Column in ORDER_INGREDIENT_HISTORY(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
ORDER_ID ORDER_ACTION ORDER_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID


ORDER_INTERNAL_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Internal Information
Definition: This table stores internal processing data associated to orders.
Table Type: ACTIVITY





Column Detail - ORDER_INTERNAL_INFO


Column Name Type Null? Definition
ACTION_SEQUENCE DOUBLE N The sequence of the order action that caused this concept to be created or updated.
CONCEPT_NAME_TEXT VARCHAR(50) N Human-readable name of this concept.
CONCEPT_VALUE_TEXT VARCHAR(255) N The value of this concept, adhering to concept-specific formatting rules.
ORDER_ID DOUBLE N Identifies the order to which this concept is associated.
ORDER_INTERNAL_INFO_ID DOUBLE N Unique generated number that identifies a single row on the order_internal_info 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 - ORDER_INTERNAL_INFO


Child Column in ORDER_INTERNAL_INFO(FK) Parent Table Name Parent Column Name
Parents: ACTION_SEQUENCE ORDER_ACTION ACTION_SEQUENCE
ORDER_ID ORDER_ACTION ORDER_ID


ORDER_IV_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: ORDER_IV_INFO
Definition: This table stores information related to IV orders.
Table Type: ACTIVITY





Column Detail - ORDER_IV_INFO


Column Name Type Null? Definition
APPLICABLE_FIELDS_BIT DOUBLE Y Bit mask that indicates what fields on this table contain information that is applicable to the IV order.
FINISHED_BAGS_CNT DOUBLE Y The number of IV bags that have been hung for the order.
ORDER_ID DOUBLE N Unique foreign key from ORDERS table.
ORDER_IV_INFO_ID DOUBLE N Unique generated number that identifies a single row on the ORDER_IV_INFO table.
TOTAL_BAGS_NBR DOUBLE Y Total number of bags to be administered for the IV order.
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 - ORDER_IV_INFO


Child Column in ORDER_IV_INFO(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID