Table Detail Report

MED_IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Med_Identifier
Definition: The Med_identifier file stores all pharmacy identifiers for the formulary.
Table Type: REFERENCE





Column Detail - MED_IDENTIFIER


Column Name Type Null? Definition
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.
FLEX_SORT_FLAG DOUBLE Y Used to sort the flex records so that the most specific records float to the top
FLEX_TYPE_CD DOUBLE N This indicates the type of flex. This field can be 0, if parent_entity_id is 0.
ITEM_ID DOUBLE N Points to the Medication_definition table that the identifier is related to.
MED_DEF_FLEX_ID DOUBLE N Points to the Med_def_flex table that identifier is related to. Can never be 0
MED_IDENTIFIER_ID DOUBLE N Unique, generated number that identifies a single row on the MED_IDENTIFIER table.
MED_IDENTIFIER_TYPE_CD DOUBLE N The type of identifier
MED_INGRED_SET_ID DOUBLE N Points to the Med_ingredient_set table that identifier is related to. Can be 0
MED_PACKAGE_TYPE_ID DOUBLE N med Package type id
MED_PRODUCT_ID DOUBLE N This field can be 0. If it is not zero, this is a manufacturer level identifier. The MED_PRODUCT that the identifier is related to.
MED_TYPE_FLAG DOUBLE Y Indicates the medication type of the item the identifier is related to.
PARENT_ENTITY_ID DOUBLE N Coded field that will be a location (Facility, Nursing Unit, Ambulatory) or a 0.
PARENT_ENTITY_NAME VARCHAR(32) Y If the parent_entity_id is filled out, then this will point to the related table.
PHARMACY_TYPE_CD DOUBLE N Indicates the Pharmacy Type that owns the identifier.
PRIMARY_IND DOUBLE Y Indicates that this identifier, for a specific identifier type, is primary.
SEQUENCE DOUBLE N Sequence
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.
VALUE VARCHAR(200) Y Text string of identifier. This field is required.
VALUE_KEY VARCHAR(200) Y Text string of identifier. This field is required.
VALUE_KEY_A_NLS VARCHAR(800) Y Corresponding Global support field for the associated VALUE_KEY column.
VALUE_KEY_NLS VARCHAR(402) Y Corresponding Global support field for the associated VALUE_KEY column. Replaced by value_key_a_nls.



Relationship Detail - MED_IDENTIFIER


Child Column in MED_IDENTIFIER(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID MEDICATION_DEFINITION ITEM_ID
MED_DEF_FLEX_ID MED_DEF_FLEX MED_DEF_FLEX_ID
MED_INGRED_SET_ID MED_INGRED_SET MED_INGRED_SET_ID
MED_PACKAGE_TYPE_ID MED_PACKAGE_TYPE MED_PACKAGE_TYPE_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID


MED_INGRED_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medical Ingredient Set
Definition: Contains items in two types of sets. IV Sets contain ingredients that make up the IV. When ordered, all will be contained on one order. Order Sets can be made up of components that are either IV Sets or individual ingredients. When ordered, a separate order will be created for each component in the Order Set.
Table Type: REFERENCE





Column Detail - MED_INGRED_SET


Column Name Type Null? Definition
BASE_IND DOUBLE Y Indicates which child ingredient is the base for the compound.
CHILD_ITEM_ID DOUBLE N ITEM_ID of a component ingredient of the set.
CHILD_MED_PROD_ID DOUBLE N The id that identifies the actual pharmacy product item of the child item.
CHILD_PKG_TYPE_ID DOUBLE N The type of base package for the child ingredient.
CMPD_QTY DOUBLE Y The quantity for the child ingredient used within the compound.
DEFAULT_ACTION_CD DOUBLE N Indicates whether or not to include, exclude, or review the child ingredient for an order set.
INC_IN_TOTAL_IND DOUBLE Y Indicates whether or not the ingredient is included in the total volume.
MED_INGRED_SET_ID DOUBLE N Unique, generated number that identifies a single row on the MED_INGRED_SET table.
NORMALIZED_RATE_IND DOUBLE N Indicates which one item in a set (if any) is associated to the normalized rate defined on the set.
PARENT_ITEM_ID DOUBLE N The ITEM_ID of the set.
SEQUENCE DOUBLE N A number that orders the components of a set.
STRENGTH DOUBLE N Premix ingredient strength.
STRENGTH_UNIT_CD DOUBLE N Premix ingredient strength unit.
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 N Premix ingredient volume
VOLUME_UNIT_CD DOUBLE N Premix ingredient volume unit



Relationship Detail - MED_INGRED_SET


Child Column in MED_INGRED_SET(FK) Parent Table Name Parent Column Name
Parents: CHILD_ITEM_ID ITEM_DEFINITION ITEM_ID
PARENT_ITEM_ID ITEM_DEFINITION ITEM_ID
CHILD_MED_PROD_ID MED_PRODUCT MED_PRODUCT_ID
CHILD_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID




Parent Column in MED_INGRED_SET (PK) Child Table Name Child Column Name
Children: MED_INGRED_SET_ID MED_IDENTIFIER MED_INGRED_SET_ID


MED_OE_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medical Order Entry Defaults
Definition: Contains values used as defaults for many attributes of an order.
Table Type: REFERENCE





Column Detail - MED_OE_DEFAULTS


Column Name Type Null? Definition
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.
ALTERNATE_DISPENSE_CATEGORY_CD DOUBLE N alternate dispense category
COMMENT1_ID DOUBLE N The LONG_TEXT_ID of the first comment for the product.
COMMENT1_TYPE DOUBLE Y Indicates what the first comment for the product applies to.
COMMENT2_ID DOUBLE N The LONG_TEXT_ID of the second comment for the product.
COMMENT2_TYPE DOUBLE Y Indicates what the second comment for the product applies to.
CONT_DISPENSE_CATEGORY_CD DOUBLE N The dispense category that will default when the product is ordered with an order type of continuous.
DAW_CD DOUBLE N Dispense options and rules.
DEFAULT_PAR_DOSES DOUBLE Y The number of doses to default when the product is ordered as PRN.
DISPENSE_CATEGORY_CD DOUBLE N The dispense category that will default when the product is ordered.
DURATION DOUBLE Y The dose that will be defaulted when the default dose (default strength and/or default volume) cannot be parsed into an individual strength and/or volume.
DURATION_UNIT_CD DOUBLE N The frequency that will default when the product is ordered.
FREETEXT_DOSE VARCHAR(255) Y The dose that will be defaulted when the default dose cannot be parsed into an individual strength and/or volume.
FREETEXT_RATE_TXT VARCHAR(100) Y String that represents the rate for an order that cannot be defined with a standard numeric representation.
FREQUENCY_CD DOUBLE N The frequency that will default when the product is ordered.
GRACE_PERIOD_DAYS DOUBLE N The number of days in the grace period defined for a product for Lot Tracking.
INFUSE_OVER DOUBLE Y The amount of time over which the order will be infused that will default when the product is ordered.
INFUSE_OVER_CD DOUBLE N The infuse over unit that will default when the product is ordered.
INT_DISPENSE_CATEGORY_CD DOUBLE N The dispense category that will default when the product is ordered with an order type of intermittent.
MAX_PAR_SUPPLY DOUBLE Y The maximum number of PRN doses that can be given in a 24 hour period. Display only.
MED_DISPENSE_CATEGORY_CD DOUBLE N The dispense category that will default when the product is ordered with an order type of medication.
MED_OE_DEFAULTS_ID DOUBLE N Unique, generated number that will identify a single row on the MED_OE_DEFAULTS table.
NBR_LABELS DOUBLE Y The number of label copies that default when the product is dispensed.
NORMALIZED_RATE_NBR DOUBLE N Default volume or strength per weight and/or time rate for the product or set.
NORMALIZED_RATE_UNIT_CD DOUBLE N The unit of measure of the normalized rate.
ORD_AS_SYNONYM_ID DOUBLE N Text representing the default synonym to which the product will be associated when ordered.
PRICE_SCHED_ID DOUBLE N The price schedule that will default when the product is ordered.
PRN_IND DOUBLE Y Indicates whether or not the product will default as PRN when ordered.
PRN_REASON_CD DOUBLE N Indicates the PRN reason that will default when the PRN Indicator is set to default as checked.
RATE_NBR DOUBLE N Default volume per time rate of infusion for the product or set.
RATE_UNIT_CD DOUBLE N Unit of measure for the infusion rate.
ROUTE_CD DOUBLE N The route of administration that will default when the product is ordered.
RX_QTY DOUBLE Y The default initial prescription quantity when the product is ordered.
SIG_CODES VARCHAR(255) Y The sig code that will default when the product is ordered.
STOP_TYPE_CD DOUBLE N The default stop type that defaults when the product is ordered.
STRENGTH DOUBLE Y The strength that will be defaulted when the default dose can be parsed into an individual strength and/or volume.
STRENGTH_UNIT_CD DOUBLE N The strength unit that will be defaulted when the default dose can be parsed into an individual strength and/or volume.
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.
VOLUME DOUBLE Y The volume that will be defaulted when the default dose can be parsed into an individual strength and/or volume.
VOLUME_UNIT_CD DOUBLE N The volume unit that will be defaulted when the default dose can be parsed into an individual strength and/or volume.



Relationship Detail - MED_OE_DEFAULTS


Child Column in MED_OE_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: COMMENT1_ID LONG_TEXT LONG_TEXT_ID
COMMENT2_ID LONG_TEXT LONG_TEXT_ID
ORD_AS_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID


MED_PACKAGE_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Med Package Type
Definition: Med Package Type
Table Type: REFERENCE





Column Detail - MED_PACKAGE_TYPE


Column Name Type Null? Definition
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.
BASE_UOM_CD DOUBLE N Base unit of measure
DESCRIPTION VARCHAR(100) Y textual description
DISPENSE_QTY DOUBLE N Quantity amount of the dispensed product.
MED_PACKAGE_TYPE_ID DOUBLE N Med Package Type id
QTY DOUBLE N This column is no longer used. QTY has been replaced by DISPENSE_QTY.
UOM_CD DOUBLE N Unit of Measure
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_PACKAGE_TYPE




Parent Column in MED_PACKAGE_TYPE (PK) Child Table Name Child Column Name
Children: MED_PACKAGE_TYPE_ID MED_DEF_FLEX MED_PACKAGE_TYPE_ID
MED_DISPENSE MED_PACKAGE_TYPE_ID
MED_IDENTIFIER MED_PACKAGE_TYPE_ID


MED_PRODUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Med Product
Definition: Stores the manufacturer item information for pharmacy products.
Table Type: REFERENCE





Column Detail - MED_PRODUCT


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.
BILLING_FACTOR_NBR DOUBLE N Used to calculate a charge services billing amount, by applying the billing factor to the normal charge quantity
BILLING_FACTOR_UOM_CD DOUBLE N Passed to charge services with the billing factor to identify the correct unit of measure for the charge services bill amount.
BIO_EQUIV_IND DOUBLE Y bio equiv ind
BRAND_IND DOUBLE Y brand ind
COST_FACTOR_NBR DOUBLE N Used to calculate a charge amount by applying the cost_factor on the actual cost of the manufacturer item.
FORMULARY_STATUS_CD DOUBLE N Code used to determine the status of the drug, i.e. Formulary, Non-Formulary, Investigational.
INNER_PKG_TYPE_ID DOUBLE N Represents the number of individual units present in the innermost packaging of a drug.
INV_FACTOR_NBR DOUBLE N Indicates the relationship of package information between the Pharmacy and Inventory systems.
MANF_ITEM_ID DOUBLE N manf item id
MED_DEF_CKI VARCHAR(255) N *** OBSOLETE ***
MED_PRODUCT_ID DOUBLE N med product id
OUTER_PKG_TYPE_ID DOUBLE N Represents the total number of inner packages present in the final packaged product.
UNIT_DOSE_IND DOUBLE Y unit_dose_ind
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.



Relationship Detail - MED_PRODUCT


Child Column in MED_PRODUCT(FK) Parent Table Name Parent Column Name
Parents: MANF_ITEM_ID MANUFACTURER_ITEM ITEM_ID
INNER_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
OUTER_PKG_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID




Parent Column in MED_PRODUCT (PK) Child Table Name Child Column Name
Children: MED_PRODUCT_ID CE_MED_ADMIN_IDENT MED_PRODUCT_ID
FILL_PRINT_ORD_HX MED_PRODUCT_ID
LOT_NUMBER_INFO MED_PRODUCT_ID
MED_COST_HX MED_PRODUCT_ID
MED_IDENTIFIER MED_PRODUCT_ID
MED_INGRED_SET CHILD_MED_PROD_ID
PROD_DISPENSE_HX MED_PRODUCT_ID
RXS_ITEM_COUNTBACK MED_PRODUCT_ID
RX_MED_PROD_DESC MED_PRODUCT_ID
SA_MEDICATION_ADMIN MED_PRODUCT_ID
SA_REF_FLUID MED_PRODUCT_ID
SA_REF_MACRO_FLUID MED_PRODUCT_ID
SA_REF_MACRO_MEDICATION MED_PRODUCT_ID
SA_REF_MEDICATION MED_PRODUCT_ID
SA_TODO_FLUID MED_PRODUCT_ID
SA_TODO_MEDICATION MED_PRODUCT_ID