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 |