Table Detail Report

MM_ITEM_REF_ADDL_ATTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Reference Additional Attribute
Definition: Contains the reference database information of item that contains more than one value
Table Type: REFERENCE





Column Detail - MM_ITEM_REF_ADDL_ATTR


Column Name Type Null? Definition
ATTR_NAME_TXT VARCHAR(255) N The attribute name that has more than one value from the Reference Database.
ATTR_VALUE_TXT LONGTEXT Y The value of the attribute from the Reference Database.
MM_ITEM_REF_ADDL_ATTR_ID DOUBLE N Unique generated number that identifies a single row on the MM_ITEM_REF_ADDL_ATTR table.
MM_ITEM_REF_DATA_ID DOUBLE N The item that these attributes apply to.
SEQ_NBR DOUBLE N The sequence of the values of the attribute.
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 - MM_ITEM_REF_ADDL_ATTR


Child Column in MM_ITEM_REF_ADDL_ATTR(FK) Parent Table Name Parent Column Name
Parents: MM_ITEM_REF_DATA_ID MM_ITEM_REF_DATA MM_ITEM_REF_DATA_ID


MM_ITEM_REF_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Reference Data
Definition: Contains the reference database information of item
Table Type: REFERENCE





Column Detail - MM_ITEM_REF_DATA


Column Name Type Null? Definition
BRAND_NAME VARCHAR(255) Y Proprietary/trade name of the medical device as used inthe labeing or catalog. Received from Reference Database
COMPANY_NAME_TXT VARCHAR(255) Y Manufacturer Company Name from Reference Database
DEVICE_DESCRIPTION_TXT VARCHAR(4000) Y Device Description of Item from Reference Database
DEVICE_ID_TXT VARCHAR(255) Y Primary device identifier number from Reference Database. An identifier that is the primary lookup for a medical device. The primary DI will be located on label of the base package (the lowest package level of a medical device containing a full UDI). For medical devices without packaging, the primary DI number and full UDI may be on the device itself.
LATEX_TXT VARCHAR(255) Y Whether the device or packaging contains natural rubber that contacts humans. "Natural rubber" includes natural rubber latex, dry natural rubber, and synthetic latex or rubber that contains natural rubber. Information from Reference Database
MFR_CATALOG_NBR_TXT VARCHAR(255) Y Manufacturer Catalog number of Item from Reference Database
MM_ITEM_REF_DATA_ID DOUBLE N Unique generated number that identifies a single row on the MM_ITEM_REF_DATA table.
MODEL_NUMBER_TXT VARCHAR(255) Y Identifies a category or design of devices that have specifications, performance, size, and composition within limits set by the company. Provided from Reference Database.
MRI_SAFETY_INFO_TXT VARCHAR(255) Y The information the labeling contains about whether a device is compatible with magnetic resonance imaging (MRI) procedures.
REFERENCE_DATABASE_NAME_TXT VARCHAR(255) N Name of the reference database
REFERENCE_DATA_TXT LONGTEXT Y Complete Reference Data information of the item from Reference Database in JSON format
SNOMED_CT_DESC_TXT VARCHAR(255) Y SNOMED CT Description from Reference Database
SNOMED_CT_IDENTIFIER_TXT VARCHAR(255) Y SNOMED CT Identifier from Reference Database
SOURCE_UPDT_DT_TM DATETIME Y Update date time by the backend process
UNIQUE_PRODUCT_KEY_TXT VARCHAR(255) N Column to store the Unique Product Identifier to resolve the item. This column should be populated irrespective of different reference database.
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 - MM_ITEM_REF_DATA




Parent Column in MM_ITEM_REF_DATA (PK) Child Table Name Child Column Name
Children: MM_ITEM_REF_DATA_ID MM_ITEM_REF_ADDL_ATTR MM_ITEM_REF_DATA_ID


MM_LOT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Materials Management Lot Relation
Definition: Stores the relationship between Receipt_Line_item and Lot_Number_info and also the relationship between Dist_Line_Detail and Lot_Number_Info.
Table Type: ACTIVITY





Column Detail - MM_LOT_RELTN


Column Name Type Null? Definition
BEFORE_TRANSFER_QTY DOUBLE N Quantity before lot transfer.
INCREASE_IND DOUBLE N Used to determine if the quantity documented is increasing or decreasing the lot.
LOT_EXP_SOON_IND DOUBLE N For that lot, for this distribution, indicates if the lot chosen had an expiration date that was defined as "soon".
LOT_NUMBER_ID DOUBLE N Foreign key from LOT_NUMBER_INFO. This is the lot number for the line item.
LOT_QTY DOUBLE N The quantity of the item on the line item in the particular lot.
MM_LOT_RELTN_ID DOUBLE N Unique, generated primary key for the MM_LOT_RELTN table.
PACKAGE_TYPE_ID DOUBLE N Identifies the package type for the lot.
PARENT_ENTITY_ID DOUBLE N Unique identifier from the tables that appear in column parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(32) N The name of the parent table that relates to this component.
PARENT_LOT_NUMBER_ID DOUBLE N In the cases where an item is part of a compound, this identifies the lot number of the compound of which it is a part.
TRANSACTION_ID DOUBLE N Used to capture the altered lot_qty per transaction
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 - MM_LOT_RELTN


Child Column in MM_LOT_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
PARENT_LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
TRANSACTION_ID MM_TRANS_HEADER TRANSACTION_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


MM_OMF_ITEMLOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: This is a summary table of ITEM_CONTROL_INFO,ACQUIREMENT_INFO, QUANTITY_REQUIRE
Definition: This table is exclusively used for ProCure's PowerVision reports.
Table Type: REFERENCE





Column Detail - MM_OMF_ITEMLOC


Column Name Type Null? Definition
ABC_CLASS_CD DOUBLE N Item Classification (A, B, C) Code
ACC_STOCKOUT_FREQ_CD DOUBLE N The acceptable stockout frequency which is allowed at this location
ACQUIRE_UPDT_CNT DOUBLE Y The date that acquirement information on this table has been updated.
AVERAGE_DAILY_USAGE DOUBLE Y Average daily usage of the item in the location.
AVERAGE_LEAD_TIME DOUBLE Y The average lead time the vendor requires
AVERAGE_LEAD_TIME_UOM_CD DOUBLE N The unit of measure that applies to the average lead time
CHARGE_TYPE_CD DOUBLE N The charge type that applies to the item
CONSIGNMENT_IND DOUBLE Y Indicates whether or not it is a consignment item
COST_CENTER_CD DOUBLE N Cost center code
COUNTBACK_FLAG DOUBLE N Flag used to determine if this item/location requires a physical count once the item has been removed. 0 - no count is required; 1 - Blind counting; 2 - Confirm count
COUNT_CYCLE_CD DOUBLE N The type of cycle counting required for the item
ECONOMIC_ORDER_QTY DOUBLE Y The economic order quantity for the item at this location
FILL_LOCATION_CD DOUBLE N The fill location for the item
FIXED_ORDER_QTY DOUBLE N Replenishment quantity will be created in increments of the fixed order quantity.
INSTANCE_IND DOUBLE Y The indicator to reflect if this is an instance
ITEM_ID DOUBLE N Primary Key
I_CTRL_UPDT_CNT DOUBLE Y The number of times the Item Control information has been updated
LAST_SYSCALC_DT_TM DATETIME Y The last date/time the system calculated item-location information.
LOCATION_CD DOUBLE N Location code
LOCATION_TYPE_CD DOUBLE N The type of location
LOCATOR_QTY DOUBLE N The quantity that can be stored in an individual locator.
LOCATOR_TYPE_CD DOUBLE N The type of locator where the item is being stored.
LOCK_IND DOUBLE N Indicator used to determine if the item can be removed from the location. This only applies to RxStation locations.
LOT_TRACKING_LEVEL_CD DOUBLE N The level of lot tracking for the item
MAXIMUM_LEVEL DOUBLE Y Maximum Level of the item that should in the lacation
MAX_DAYS_ADU DOUBLE Y Maximum number of days that the average daily usage is based upon
MINIMUM_LEVEL DOUBLE Y Minimum level of the item that should be in the location
MIN_DAYS_ADU DOUBLE Y Minimum number of days that the average daily usage is based upon
ORGANIZATION_ID DOUBLE N The organization for the location
PRIMARY_VENDOR_CD DOUBLE N The primary reorder vendor
PRIMARY_VENDOR_ITEM_ID DOUBLE N The primary reorder vendor item
PRODUCT_ORIGIN_CD DOUBLE N The code value for the origin of the product
QTY_REQ_UPDT_CNT DOUBLE Y The number of times the quantity requirement information has been updated
REORDER_METHOD_CD DOUBLE N The reorder method being utilized.
REORDER_PACKAGE_TYPE_DESC VARCHAR(100) Y The reorder package type description
REORDER_PACKAGE_TYPE_ID DOUBLE N The primary key for the reorder package type ID
REORDER_POINT DOUBLE Y The quantity when the item will be reordered
REORDER_TYPE_CD DOUBLE N The reorder type being utilized
SAFETY_STOCK_QTY DOUBLE Y The quantity of safety stock defined for the item at this location
SEASONAL_ITEM_IND DOUBLE Y Indicator used to determine if the item is considered seasonal
STOCK_PACKAGE_TYPE_DESC VARCHAR(100) Y The description of the stock package type
STOCK_PACKAGE_TYPE_ID DOUBLE N StoThe foreign key for the stock package type ID
STOCK_TYPE_IND DOUBLE Y The indicator that reflects whether the item is tracked perpetually at this location
SUB_ACCOUNT_CD DOUBLE N The item's sub account code value
SYSCALC_ABC_CLASS_IND DOUBLE Y Indicator to determine if the ABC classification will be calculated by the system.
SYSCALC_PAR_LEVEL_IND DOUBLE Y Indicator to determine if the PAR level will be calculated by the system
SYSCALC_REORDER_POINT_IND DOUBLE Y Indicator to determine if the reorder point will be calculated by the system
SYSCALC_SAFETY_STOCK_IND DOUBLE Y Indicator to determine if the safety stock will be calculated by the system
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_TYPE_CD DOUBLE N The location view type



Relationship Detail - MM_OMF_ITEMLOC


Child Column in MM_OMF_ITEMLOC(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


MM_OMF_ITEM_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF ITEM MASTER
Definition: Item master summary table
Table Type: REFERENCE





Column Detail - MM_OMF_ITEM_MASTER


Column Name Type Null? Definition
ACTIVE_CD DOUBLE N Contains the value of the items' active code.
ACTIVE_DT_NBR DOUBLE Y Date, in Julian format, this item became active.
ACTIVE_DT_TM DATETIME Y Date and time the row is activated (active indicator is set to 1).
ACTIVE_ID DOUBLE N The ID from the person table that activated the item
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_MIN_NBR DOUBLE Y Stores the minute value of when the item became active.
APPROVED_IND DOUBLE Y Indicates whether an item is approved.
BASE_PKG_DESC VARCHAR(40) Y Stores the items' base package description.
BASE_PKG_ID DOUBLE N Stores the items' base package identifier.
BASE_PKG_QTY DOUBLE Y Stores the items' base package quantity.
BASE_PKG_UOM_CD DOUBLE N Stores the items' base package quantity unit of measure.
CLASS_NAME VARCHAR(60) Y % whare %
CLASS_NODE_ID DOUBLE N Relates this OMF Item Master to a specific Class Node
COMPONENT_IND DOUBLE Y Indicates whether an item is a component.
COUNTABLE_IND DOUBLE Y Indicates whether an item is countable.
CREATE_DT_NBR DOUBLE Y A Julian date, number representing the date this item row was created.
CREATE_DT_TM DATETIME Y The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_MIN_NBR DOUBLE Y Contains the minute number of when the item row was created.
CRITICAL_IND DOUBLE Y Indicates whether an item is critical.
DESCRIPTION VARCHAR(200) Y Stores an item description.
FDA_REPORTABLE_IND DOUBLE Y Indicates whether an item is FDA reportable.
ITEM_COUNT DOUBLE Y Stores an item count.
ITEM_LEVEL_FLAG DOUBLE N This flag indicates the item type, specifically for med def items.
ITEM_MASTER_ID DOUBLE N Foreign Key to Item Master
LAST_DIST_DT_NBR DOUBLE Y Stores the items' last distribution date in a Julian format.
LAST_DIST_DT_TM DATETIME Y Stores the date and time of the items' last distribution.
LAST_DIST_MIN_NBR DOUBLE Y Stores the minute value for the items' last distribution.
LAST_ORDER_CONTRACT_DESC VARCHAR(100) Y % lst%
LAST_ORDER_DT_NBR DOUBLE Y Stores the last order date for the item in Julian format.
LAST_ORDER_DT_TM DATETIME Y Stores the date and time of the items' last order.
LAST_ORDER_MIN_NBR DOUBLE Y Stores the minute value for the items last order time.
LAST_ORDER_PKG_DESC VARCHAR(40) Y Stores the Package Description for the items' last order.
LAST_ORDER_PRICE DOUBLE Y Stores the price of the items' last order.
LAST_ORDER_PRICE_TYPE_CD DOUBLE N Stores the type of order price for the items' last order.
LAST_RECEIPT_DT_NBR DOUBLE Y Last Receipt Date, in Julian format, for this item.
LAST_RECEIPT_DT_TM DATETIME Y Date and Time for the Last Receipt for this item.
LAST_RECEIPT_MIN_NBR DOUBLE Y Minute Number Value for the Last Receipt for this item.
LAST_RECEIPT_PKG_DESC VARCHAR(40) Y Package Description for the Last Receipt for this item.
LAST_REQ_DT_NBR DOUBLE Y date, in Julian format, of the last requisition, for this item.
LAST_REQ_DT_TM DATETIME Y Date and time of the last requisition for this item.
LAST_REQ_MIN_NBR DOUBLE Y Minute value for the last requisition for this item.
LAST_UPDT_DT_NBR DOUBLE Y Date, in Julian format of the Last Update for this item.
LAST_UPDT_DT_TM DATETIME Y Date and time of the Last Update for this item.
LAST_UPDT_ID DOUBLE N Identification of the person who performed the Last Update on this item.
LAST_UPDT_MIN_NBR DOUBLE Y Value of the minutes for the Last Update for this item.
LAST_VOUCHER_DT_NBR DOUBLE Y Date, in Julian format, of the Last Voucher for this item.
LAST_VOUCHER_DT_TM DATETIME Y Date and Time of the Last Voucher for this item.
LAST_VOUCHER_MIN_NBR DOUBLE Y Value of the minutes for the Last Voucher for this item.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NDC VARCHAR(40) Y National Drug Code related number for this item.
PHA_TYPE_FLAG DOUBLE N This flag indicates the pharmacy item type: inpatient, retail or shared.
QUICKADD_IND DOUBLE Y Indicates whether an item is Quickadd.
REUSABLE_IND DOUBLE Y Indicates whether an item is reusable.
SCHEDUABLE_IND DOUBLE Y Indicates whether an item is schedulable.
SHORT_DESC VARCHAR(200) Y Contains a short description of the item.
STERILE_REQ_IND DOUBLE Y Indicates whether Sterilization is required.
STOCK_NBR VARCHAR(40) Y Contains the stock number for the item.
SYS_ITEM_NBR VARCHAR(20) Y Contains the system item number for the item.
TYPE_CD DOUBLE N A code that identifies the type of item.
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 - MM_OMF_ITEM_MASTER


Child Column in MM_OMF_ITEM_MASTER(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
ITEM_MASTER_ID ITEM_DEFINITION ITEM_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
BASE_PKG_ID PACKAGE_TYPE PACKAGE_TYPE_ID