Table Detail Report

MM_OMF_MFG_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM OMF MFG ITEM
Definition: Manufacturer item summary table
Table Type: REFERENCE





Column Detail - MM_OMF_MFG_ITEM


Column Name Type Null? Definition
ACTIVE_CD DOUBLE N active status
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.
AWP DOUBLE Y Contains the Average Wholesale Price for the item.
AWP_BULK DOUBLE Y The bulk average wholesale price for this item.
AWP_FACTOR DOUBLE Y Contains the items average wholesale price factor.
BRAND_NAME VARCHAR(100) Y Brand Name of the item.
COST1 DOUBLE Y Cost1 - not currently being used.
COST2 DOUBLE Y Cost2 - not currently being used.
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.
DESCRIPTION VARCHAR(200) Y textual description of the item
ITEM_COUNT DOUBLE Y Stores an item count.
ITEM_NBR VARCHAR(40) Y An identifying number of the item.
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.
MFG_CD DOUBLE N Manufacturer code for the item
MFG_ITEM_ID DOUBLE N Uniquely identifies and Manufacturing Item
NDC VARCHAR(40) Y Uniqule National Drug Code for this item.
QUICKADD_IND DOUBLE Y Indicates whether an item is Quickadd.
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_MFG_ITEM


Child Column in MM_OMF_MFG_ITEM(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


MM_OMF_UPD_QUEUE



Column Section Top of Page


Table-level Detail

Description: MM OMF UPD QUEUE
Definition: Table used to determine what to update for the OMF tables
Table Type: ACTIVITY





Column Detail - MM_OMF_UPD_QUEUE


Column Name Type Null? Definition
ACTION_FLAG DOUBLE Y Field used to determine if the entry is a new or updated one. Currently, this field is not being used.
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
PARENT_ENTITY_ID DOUBLE N Foreign key to a table designated by parent_entity_name
PARENT_ENTITY_NAME VARCHAR(40) N Defines the parent table for parent_entity_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.


MM_OMF_VENDOR_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Vendor Item table
Definition: Vendor Item Summary table built using omf tools.
Table Type: REFERENCE





Column Detail - MM_OMF_VENDOR_ITEM


Column Name Type Null? Definition
ACTIVE_CD DOUBLE N Active Code
ACTIVE_DT_NBR DOUBLE Y Date, in Julian format, this item became active.
ACTIVE_DT_TM DATETIME Y The date and time that this row became active, usually the date and time that it was inserted.
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.
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.
DESCRIPTION VARCHAR(200) Y textual description
ITEM_COUNT DOUBLE Y Stores an item count.
ITEM_NBR VARCHAR(40) Y Item Number Identifier.
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 %Reciept%
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.
QUICKADD_IND DOUBLE Y Indicates whether an item is Quickadd.
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.
VENDOR_CD DOUBLE N Vendor associated with this account
VENDOR_ITEM_ID DOUBLE N Uniquely identifies a vendor item.



Relationship Detail - MM_OMF_VENDOR_ITEM


Child Column in MM_OMF_VENDOR_ITEM(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


MM_PRICE_FORMULA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pricing Formula
Definition: Formula used to determine the patient price for the supply bill items.
Table Type: REFERENCE





Column Detail - MM_PRICE_FORMULA


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.
MM_PRICE_FORMULA_ID DOUBLE N Unique generated number that identifies a single row on the MM_PRICE_FORMULA table.
ORGANIZATION_ID DOUBLE N The organization associated with this pricing formula
PRICE_FORMULA_DESC VARCHAR(40) N Text field describing the formula
PRICE_FORMULA_DESC_KEY VARCHAR(40) N This field contains the price_formula_desc value with all special characters removed and all alpha characters converted to upper case.
PRICE_FORMULA_DESC_KEY_A_NLS VARCHAR(160) N Stores the corresponding non-English character set values for the price_formula_desc_key column. Used to sort correctly internationally.
PRICE_SCHED_ID DOUBLE N Price Schedule associated to this pricing formula.
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_PRICE_FORMULA


Child Column in MM_PRICE_FORMULA(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID




Parent Column in MM_PRICE_FORMULA (PK) Child Table Name Child Column Name
Children: MM_PRICE_FORMULA_ID MM_CS_PATIENT_PRICE MM_PRICE_FORMULA_ID
MM_PRICE_FORMULA_CLASS_R MM_PRICE_FORMULA_ID
MM_PRICE_FORMULA_LOC_RELTN MM_PRICE_FORMULA_ID
MM_PRICE_FORMULA_RANGE MM_PRICE_FORMULA_ID


MM_PRICE_FORMULA_CLASS_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pricing Formula Class Relation
Definition: The class of item this formula applies to.
Table Type: REFERENCE





Column Detail - MM_PRICE_FORMULA_CLASS_R


Column Name Type Null? Definition
CLASS_NODE_ID DOUBLE N The classification for this formula
MM_PRICE_FORMULA_CLASS_R_ID DOUBLE N Unique generated number that identifies a single row on the MM_PRICE_FORMULA_CLASS_R table.
MM_PRICE_FORMULA_ID DOUBLE N The price formula that the classification on this row is associated with.
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_PRICE_FORMULA_CLASS_R


Child Column in MM_PRICE_FORMULA_CLASS_R(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
MM_PRICE_FORMULA_ID MM_PRICE_FORMULA MM_PRICE_FORMULA_ID