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 |