Table Detail Report

MEDICATION_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medication definition
Definition: The parent table for items stored within the formulary.
Table Type: REFERENCE





Column Detail - MEDICATION_DEFINITION


Column Name Type Null? Definition
ALTERNATE_DISPENSE_CATEGORY_CD DOUBLE N The category used for grouping this product, when ordered in a partial unit, on fill lists and batches for continuous dispensing. This will be defaulted from the form_dispense_cat_r table entries for this item's form.
ALWAYS_DISPENSE_FROM_FLAG DOUBLE Y This field helps to indicate where this product is dispensed from.
CKI VARCHAR(255) Y Cerner Knowledge Index field for Multum MMDC numbers. Syntax is "MUL.FRMLTN!"
COMMENT1_ID DOUBLE N Link to long_text table for the first order note.
COMMENT1_TYPE DOUBLE Y Type of Order comment #1
COMMENT2_ID DOUBLE N Key to long_text table for second order entry note.
COMMENT2_TYPE DOUBLE Y Type of second order entry comment
COMPOUND_TEXT_ID DOUBLE N Key to long_text table for compounding instructions.
CONTINUOUS_FILTER_IND DOUBLE Y Indicates whether this product should be displayed when entering a continuous IV order
DEFAULT_PAR_DOSES DOUBLE Y The default par which overrides any default par value from the frequency schedule. e.g.: PRN bulk item is ordered Q4H. The default par value from the frequency schedule is 6, but for bulk items it should be only 1.
DISPENSE_CATEGORY_CD DOUBLE N The category used for grouping this product, when ordered as a whole unit, on fill lists and batches for continuous dispensing. This will be defaulted from the form_dispense_cat_r table entries for this item's form.
DISPENSE_QTY DOUBLE N The number of units of a pharmacy product that you should dispense for the ordered dose
DISPENSE_QTY_UNIT_CD DOUBLE N Values from PHA_GET_PHARMUNIT or code set 54
DIVISIBLE_IND DOUBLE Y Defines whether this product can be split, broken, etc. To create a dose. The divisible is defaulted from the form.divisible.
FORMULARY_STATUS_CD DOUBLE N Defines the acceptance of this product by the institution.
FORM_CD DOUBLE N The dosage form of the product.
GIVEN_STRENGTH VARCHAR(25) Y Strength of the product as retrieved from the drug database.
INTERMITTENT_FILTER_IND DOUBLE Y Indicates whether this item is selectable when building in Intermittent IV.
INV_MASTER_ID DOUBLE N Identifies the Inventory item which QOH is tracked, in place of the formulary item. This is an FK column from table ITEM_DEFINITION.
ITEM_ID DOUBLE N Item id inherited from item_master
LEGAL_STATUS_CD DOUBLE N The legal status of the drug as assigned by the governing body.
MAX_PAR_SUPPLY DOUBLE Y For a singe dispense event of this item as PRN, the maximum number of units to supply. Mostly, this will be used by multiple-day fill lists, eg, a long-term care facility.
MDX_GFC_NOMEN_ID DOUBLE N Nomenclature id for the Micromedex identifier for this product s generic formulation, including active ingredients, strength and dosage form.
MED_FILTER_IND DOUBLE Y Indicates whether this item is selectable when building a medication order.
MED_TYPE_FLAG DOUBLE Y Indicates the type of this formulation.
MEQ_FACTOR DOUBLE Y strength/volume ratio expressed in millequivalents
MMOL_FACTOR DOUBLE Y strength/volume ratio expressed in millimoles.
OE_FORMAT_FLAG DOUBLE Y Preferred order format for this item
ORDER_ALERT1_CD DOUBLE N First order alert code for this item.
ORDER_ALERT2_CD DOUBLE N Second order alert code for this item.
ORDER_SENTENCE_ID DOUBLE N *** OBSOLETE ***
PARENT_ITEM_ID DOUBLE N Identifies the parent formulary item that the child item is grouped to. This is an FK column from table ITEM_DEFINITION.
PREMIX_IND DOUBLE N Indicates whether the medication product is a premix containing multiple ingredients.
PRICE_SCHED_ID DOUBLE N Link to price schedule for this item.
PRIMARY_MANF_ITEM_ID DOUBLE N Link to the manufacturer item that is currently being dispensed.
SIDE_EFFECT_CODE VARCHAR(10) Y Side effect code (used for printing on MARs)
STRENGTH DOUBLE Y Strength of the product used to determine the available products to dispense based upon the requested dose.
STRENGTH_UNIT_CD DOUBLE N Unit of measurement associated with the Strength.
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.
USED_AS_BASE_IND DOUBLE Y Indicates whether this product can be ordered as a base solution. NOTE: This helps the OE application determine whether to prompt the user whether the order is continuous or intermittent, i.e., whether or not an infusion rate is necessary. Domain: 0 = never, 1 = sometimes, 2 = always domain: never = 0 sometimes = 1 always = 2 0 = Always 1 = Sometimes 2 = Never
VOLUME DOUBLE Y Volume of the product used to determine the available products to dispense based upon the requested dose.
VOLUME_UNIT_CD DOUBLE N Unit of measurement associated with the volume.



Relationship Detail - MEDICATION_DEFINITION


Child Column in MEDICATION_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: ORDER_ALERT1_CD CODE_VALUE CODE_VALUE
ORDER_ALERT2_CD CODE_VALUE CODE_VALUE
INV_MASTER_ID ITEM_DEFINITION ITEM_ID
PARENT_ITEM_ID ITEM_DEFINITION ITEM_ID
PRIMARY_MANF_ITEM_ID ITEM_DEFINITION ITEM_ID
ITEM_ID ITEM_MASTER ITEM_ID
COMMENT1_ID LONG_TEXT LONG_TEXT_ID
MDX_GFC_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID




Parent Column in MEDICATION_DEFINITION (PK) Child Table Name Child Column Name
Children: ITEM_ID CE_MED_ADMIN_IDENT ITEM_ID
DISPENSE_REPLACE_AUDIT REPLACE_ITEM_ID
MED_DEF_FLEX ITEM_ID
MED_DEF_LOC_R MED_DEF_ITEM_ID
MED_IDENTIFIER ITEM_ID
ORDER_THERAP_SBSTTN ITEM_ID
RXA_MED_COPAY_TIER_HX ITEM_ID
RXS_ITEM_COUNTBACK MED_ITEM_ID
RXS_LOCATION_TASK MED_ITEM_ID
RXS_LOC_ENCNTR_INVENTORY ITEM_ID
RX_EXT_DRUG_ITEM_AUDIT ITEM_ID
RX_EXT_ITEM_UPDATE_AUDIT ITEM_ID
RX_EXT_ORD_PRD_SYNC_AUDIT ITEM_ID
RX_EXT_ORD_PRD_SYNC_AUDIT NEW_ITEM_ID
RX_MED_ORD_DETAIL ITEM_ID
RX_PRODUCT_ASSIGN_AUDIT ITEM_ID
RX_PRODUCT_ASSIGN_AUDIT SET_ITEM_ID
RX_PRODUCT_CHANGE_NOTE ITEM_ID
RX_THERAP_SBSTTN_FROM FROM_ITEM_ID
RX_THERAP_SBSTTN_TO TO_ITEM_ID
RX_WORKFLOW_STS ITEM_ID
RX_WORKFLOW_STS_ITEM ITEM_ID
SYNONYM_ITEM_R ITEM_ID


MED_DEF_LOC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Flex table for medication_definiition by location_cd
Definition: Primary table for multi facitilty formulary logic
Table Type: REFERENCE





Column Detail - MED_DEF_LOC_R


Column Name Type Null? Definition
LOCATION_CD DOUBLE N Location code
MED_DEF_ITEM_ID DOUBLE N Medication definition item_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 - MED_DEF_LOC_R


Child Column in MED_DEF_LOC_R(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD CODE_VALUE CODE_VALUE
MED_DEF_ITEM_ID MEDICATION_DEFINITION ITEM_ID


MED_MANF_PT_R



Column Section Top of Page


Table-level Detail

Description: MED MANF PT R
Definition: Relational table joining package_type with manufacturer_item.
Table Type: REFERENCE





Column Detail - MED_MANF_PT_R


Column Name Type Null? Definition
INNER_PKG_ID DOUBLE N Inner package_type_id from package_type table.
ITEM_ID DOUBLE N Item_id matches base manufacturer item_id on package_type table.
OUTER_PKG_ID DOUBLE N Outer package_type_id from package_type 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.


ORDER_ALERTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ORDER ALERTS
Definition: Pharmacy order alerts
Table Type: REFERENCE





Column Detail - ORDER_ALERTS


Column Name Type Null? Definition
ACTION_TEXT_ID DOUBLE N Primary key to LONG_TEXT table.
ACTIVE_DT_TM DATETIME Y Active date and time
ACTIVE_IND DOUBLE Y 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_TYPE_CD DOUBLE N Active type code
ALERT_CD DOUBLE N primary key
ALERT_TYPE_CD DOUBLE N Type of order alert
BEGIN_EFFECTIVE_DT_TM DATETIME Y The date/time from which the row is valid as active current data. This may be valued with the date that the row was created.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INACTIVE_DT_TM DATETIME Y Date/Time the record was inactivated.
PROMPT_FOR_ACTION_IND DOUBLE Y Flag to determine is user is to be prompted for action to resolve the alert.
PROMPT_FOR_REASON_IND DOUBLE Y Flag to indicate if the user should be prompted for a reason for the alert.
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.
VIEW_ONLY_IND DOUBLE Y Alert is view only, no action required.



Relationship Detail - ORDER_ALERTS


Child Column in ORDER_ALERTS(FK) Parent Table Name Parent Column Name
Parents: ALERT_CD CODE_VALUE CODE_VALUE
ACTION_TEXT_ID LONG_TEXT LONG_TEXT_ID


ORDER_CATALOG_ITEM_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Relationship table between order catalog and pharmacy items
Definition: Order catalog/inventory item relationship table,
Table Type: REFERENCE





Column Detail - ORDER_CATALOG_ITEM_R


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Catalog code
ITEM_ID DOUBLE N ID value of the Item
SYNONYM_ID DOUBLE N Order catalog synonym
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_CATALOG_ITEM_R


Child Column in ORDER_CATALOG_ITEM_R(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID