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 |