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 |