Table Detail Report

ITEM_LOCATION_COST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Location Cost
Definition: Contains an items cost at a location per package type.
Table Type: REFERENCE





Column Detail - ITEM_LOCATION_COST


Column Name Type Null? Definition
COST DOUBLE N This cost of the item.
COST_TYPE_CD DOUBLE N The cost type code allows differentiation between average cost, current cost, last cost, etc.
COST_UPLOAD_IND DOUBLE N Indicates whether this organization's average/last cost was created through cost upload or not.
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
INITIAL_ORG_COST_IND DOUBLE N Indicator to determine whether the item's cost is initial org cost calculated by system. In other way, if this ind is set to 0, then it means that the item has transactions associated for the item at this location.
ITEM_ID DOUBLE N Foreign key to item_definition table.
LOCATION_CD DOUBLE N The field identifies the current permanent location of the patient. The location for an inpatient will be valued with the lowest level location type in the hierarchy of facility, building, nurse unit, room, bed.
MANUAL_ORG_COST_AMT DOUBLE N The Organization cost which is updated/inserted manually through mmdbtool.exe or uploadmanager or interface.
MANUAL_ORG_COST_UPDT_IND DOUBLE N Indicates whether the cost is updated manually (through mmdbtool.exe or uploadmanager or interface) or automatically.
PACKAGE_TYPE_ID DOUBLE N Foreign key to package_type table
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 - ITEM_LOCATION_COST


Child Column in ITEM_LOCATION_COST(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID


ITEM_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Master
Definition: Contains all Inventory Items tracked internally by an entity.
Table Type: REFERENCE





Column Detail - ITEM_MASTER


Column Name Type Null? Definition
COST_CENTER_CD DOUBLE N Cost Center
COUNTABLE_IND DOUBLE Y Indicates whether or not this item is considered countable.
CRITICAL_IND DOUBLE Y Indicates if this item is critical in order for a procedure to be performed.
FDA_REPORTABLE_IND DOUBLE Y Indicates this item is reportable to the FDA.
ITEM_ID DOUBLE N Primary key.
SCHEDULABLE_IND DOUBLE Y Indicates if this item is schedulable.
STERILIZATION_REQUIRED_IND DOUBLE Y Indicates if this item needs sterilization prior to use.
STORAGE_REQUIREMENT_CD DOUBLE N Describes how to store an item.
SUB_ACCOUNT_CD DOUBLE N Sub Account
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 - ITEM_MASTER




Parent Column in ITEM_MASTER (PK) Child Table Name Child Column Name
Children: ITEM_ID ADDITIONAL_AMOUNT_DEF ITEM_ID
CASE_CART_PICK_LIST ITEM_ID
DIST_LINE_DETAIL ACTUAL_ITEM_ID
EQUIPMENT_MASTER ITEM_ID
LINE_ITEM ITEM_MASTER_ID
MEDICATION_DEFINITION ITEM_ID
MM_TRANS_LINE ITEM_ID
RECEIPT_LINE_ITEM ACTUAL_ITEM_ID
SA_REF_DILUENT ITEM_ID
SA_REF_FLUID ITEM_ID
SA_REF_ITEM ITEM_ID
SA_REF_MACRO_FLUID ITEM_ID
SA_REF_MACRO_ITEM ITEM_ID
SA_REF_MACRO_MEDICATION DILUENT_ITEM_ID
SA_REF_MACRO_MEDICATION ITEM_ID
SA_REF_MEDICATION ITEM_ID
SA_TODO_FLUID ITEM_ID
SA_TODO_ITEM ITEM_ID
SA_TODO_MEDICATION DILUENT_ITEM_ID
SA_TODO_MEDICATION ITEM_ID
SN_PREFCARD_MPAGE_SNOOZE ITEM_ID
TRACKING_ITEM INVENTORY_ID


ITEM_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Organization Relation
Definition: Stores the relationship between ITEM_DEFINITION and ORGANIZATION.
Table Type: REFERENCE





Column Detail - ITEM_ORG_RELTN


Column Name Type Null? Definition
ITEM_ID DOUBLE N The inventory item that is related to an organization.
ITEM_ORG_RELTN_ID DOUBLE N The unique, generated number that identifies a single row on the ITEM_ORG_RELTN table.
ORG_ID DOUBLE N The organization that is related to an inventory item.
STATUS_CD DOUBLE N Defines if a new organization has been added to the item through QuickAdd from surgery workflows.
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 - ITEM_ORG_RELTN


Child Column in ITEM_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
ORG_ID ORGANIZATION ORGANIZATION_ID


ITEM_PRICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ITEM PRICE
Definition: Holds an item's price per package type.
Table Type: REFERENCE





Column Detail - ITEM_PRICE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONTRACT_DESCRIPTION VARCHAR(100) Y Contract Description is a free text description field that may be used to describe the associated contract.
CONTRACT_ID DOUBLE N This is the value of the unique primary identifier of the contract on the item price table. It is an internal system assigned number.
CONTRACT_LINE_ID DOUBLE N Key to MM_CNTRCT_LINE table
CONTRACT_NBR VARCHAR(40) Y Contract Number
CONTRACT_TYPE VARCHAR(100) Y The contract type may be used to differentiate between different types of contracts. This may be GPO, Supplier, or Manufacturer.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
EFFECTIVE_DT_TM DATETIME Y The effective date and time indicate the date and time when this price may become effective. It is used to pre-load contract prices into the system. Prices loaded prior to the effective date of the item price will be loaded with a status of inactive. A program may be run to update this status and "activate" the item price.
EXPIRATION_DT_TM DATETIME Y The expiration date and time indicate the date and time when this price expires. It is used to update expiring contract prices in the system. Prices are updated as of the expiration date of the item price with a status of deleted. A program may be run to update this status and "delete" the expiring item prices.
FIXED_PRICE_IND DOUBLE Y The fixed price indicator is used to identify those prices which are on contract and may not be overridden by the user.
ITEM_PRICE_ID DOUBLE N This is the value of the unique primary identifier of the item price table. It is an internal system assigned number.
MIN_ORDER_QTY DOUBLE Y Minimum order quantity for Vendor Item.
ORDER_QTY_MULTIPLE DOUBLE Y The order quantity multiple is a quantity which will be used to determine how many economic order quantity units should be automatically reordered. This is not currently implemented.
ORGANIZATION_ID DOUBLE N Organization associated to the price
PACKAGE_TYPE_ID DOUBLE N This is the value of the unique primary identifier of the package type table. It is an internal system assigned number.
PRICE DOUBLE N This is the price associated with the price type and package type of the vendor item selected.
PRICE_QUOTE_SOURCE VARCHAR(100) Y The price quote source indicates who quoted the price.
PRICE_TYPE_CD DOUBLE N The Price Type code is used to identify whether the price is quoted, contract, or list type.
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_PRICE_SCHEDULE_ID DOUBLE N This is the value of the unique primary identifier of the vendor price schedule table. It is an internal system assigned number used to differentiate between prices at locations.



Relationship Detail - ITEM_PRICE


Child Column in ITEM_PRICE(FK) Parent Table Name Parent Column Name
Parents: CONTRACT_LINE_ID MM_CNTRCT_LINE CNTRCT_LINE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID




Parent Column in ITEM_PRICE (PK) Child Table Name Child Column Name
Children: ITEM_PRICE_ID ITEM_PRICE_HIST ITEM_PRICE_ID
MM_XFI_ITEM PRICE_ID


ITEM_PRICE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Price History
Definition: Store history of price modifications to the ITEM_PRICE table.
Table Type: REFERENCE





Column Detail - ITEM_PRICE_HIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONTRACT_DESCRIPTION VARCHAR(100) Y Contract Description is a free text description field that may be used to describe the associated contract.
CONTRACT_ID DOUBLE N This is the value of the unique primary identifier of the contract on the item price table. It is an internal system assigned number.
CONTRACT_LINE_ID DOUBLE N Key to MM_CNTRCT_LINE table
CONTRACT_NBR VARCHAR(40) Y Contract Number from MM_CNTRCT_HDR
CONTRACT_TYPE VARCHAR(100) Y The contract type may be used to differentiate between different types of contracts. This may be GPO, Supplier, or Manufacturer.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the record was created.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that created the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that inserted the row.
EFFECTIVE_DT_TM DATETIME Y Effective Date and Time value
EXPIRATION_DT_TM DATETIME Y The expiration date and time indicate the date and time when this price expires. It is used to update expiring contract prices in the system. Prices are updated as of the expiration date of the item price with a status of deleted. A program may be run to update this status and "delete" the expiring item prices.
FIXED_PRICE_IND DOUBLE N The fixed price indicator is used to identify those prices which are on contract and may not be overridden by the user.
ITEM_PRICE_HIST_ID DOUBLE N Unique, generated number that identifies a single row on the ITEM_PRICE_HIST table.
ITEM_PRICE_ID DOUBLE N Foreign key to item_price table
MIN_ORDER_QTY DOUBLE Y Minimum order quantity for Vendor Item.
ORDER_QTY_MULTIPLE DOUBLE Y The order quantity multiple is a quantity which will be used to determine how many economic order quantity units should be automatically reordered. This is not currently implemented.
ORGANIZATION_ID DOUBLE N Organization associated to the price
PACKAGE_TYPE_ID DOUBLE N This is the value of the unique primary identifier of the package type table. It is an internal system assigned number.
PRICE DOUBLE N This is the price associated with the price type and package type of the vendor item selected.
PRICE_QUOTE_SOURCE VARCHAR(100) Y The price quote source indicates who quoted the price.
PRICE_TYPE_CD DOUBLE N The Price Type code is used to identify whether the price is quoted, contract, or list type.
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_PRICE_SCHEDULE_ID DOUBLE N This is the value of the unique primary identifier of the vendor price schedule table. It is an internal system assigned number used to differentiate between prices at locations.



Relationship Detail - ITEM_PRICE_HIST


Child Column in ITEM_PRICE_HIST(FK) Parent Table Name Parent Column Name
Parents: ITEM_PRICE_ID ITEM_PRICE ITEM_PRICE_ID
CONTRACT_LINE_ID MM_CNTRCT_LINE CNTRCT_LINE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID