Dimensional Warehouse Model Data Model

Entity

Entity Item Master Dimension

Description

A collection of base items that are packaged for sale or distribution. Pricing, contracting, ordering and invoicing occur at the item master level.

Attributes
Approved To Buy Price Amt
Approved To Buy Qty
Approved to Buy Unit Of Measure Cd
Approved to Buy Unit Of Measure Code Descr
Approved to Buy Unit Of Measure Code Sk
AWM Load Info Sk
Base Item Dk
Base Item Sk
Brand Nm
Consignment Item Ind
Current Ind
Custom Order Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Equipment Maintenance Type Cd
Equipment Maintenance Type Code Descr
Equipment Maintenance Type Code Sk
Freight Charge Ind
Item Consume Qty
Item Consume UOM Cd
Item Consume UOM Code Descr
Item Consume UOM Code Sk
Item Consume UOM Descr
Item Descr
Item Dispense Qty
Item Dispense UOM Cd
Item Dispense UOM Code Descr
Item Dispense UOM Code Sk
Item Dispense UOM Descr
Item Master Bk
Item Master Dk
Item Master Sk
Item Master Type Cd
Item Master Type Code Descr
Item Master Type Code Sk
Item Master Type Descr
Item Num
Item Short Descr
Item Standard Qty
Item Standard UOM Cd
Item Standard UOM Code Descr
Item Standard UOM Code Sk
Item Standard UOM Descr
Item Status Cd
Item Status Code Descr
Item Status Code Sk
Label Descr
Latex Ind
Make
Manufactured Item Type Cd
Manufactured Item Type Code Descr
Manufactured Item Type Code Sk
Model
Model Year
Name
Package Qty
Package UOM Cd
Package UOM Code Descr
Package UOM Code Sk
Package UOM Descr
Reusable Item Ind
Source Cd
Source Code Descr
Source Code Sk
Subject to Expiration Ind
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Item Master Dimension_Base Item Dimension_FK

Primary Key
Item Master Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Approved To Buy Price Amt

Description	The currency limit of this item that you can purchase within a user-defined time frame (for example, one year).
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Approved To Buy Qty

Description	The quantity of this item that can be purchased within a user-defined time frame (for example, one year) at the order unit of measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Approved to Buy Unit Of Measure Cd

Description	Indicates the unit of measure in which the Approved To Buy Quantity is expressed. For example: Each 1000 Kg liter
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Approved to Buy Unit Of Measure Code Descr

Description	Indicates the unit of measure in which the Approved To Buy Quantity is expressed. For example: Each 1000 Kg liter
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Approved to Buy Unit Of Measure Code Sk

Description	Indicates the unit of measure in which the Approved To Buy Quantity is expressed. For example: Each 1000 Kg liter
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Base Item Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Base Item Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Brand Nm

Description	Description assigned to the product by the manufacturer and used for item look up and item validation.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Consignment Item Ind

Description	Indicates whether or not the inventory supply item is purchased on consignment. If the item is purchased on consignment, the healthcare organization does not pay for the inventory supply item until it is used.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Custom Order Ind

Description	Indicates whether or not an item is custom built for a customer or consumer.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Equipment Maintenance Type Cd

Description	Indicates the level or nature of maintenance required for the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Equipment Maintenance Type Code Descr

Description	Indicates the level or nature of maintenance required for the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Equipment Maintenance Type Code Sk

Description	Indicates the level or nature of maintenance required for the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Freight Charge Ind

Description	Indicates whether or not freight is an allowable charge to be allocated to the line of an invoice containing the item.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Consume Qty

Description	Quantity per unit of measure- Field describes the number of vials, ampoules, bottles, or bags in a box/case (NDDF too)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Consume UOM Cd

Description	Indicates the Unit of Measure describing the level specification of a package.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Consume UOM Code Descr

Description	Indicates the Unit of Measure describing the level specification of a package.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Consume UOM Code Sk

Description	Indicates the Unit of Measure describing the level specification of a package.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Consume UOM Descr

Description	Indicates the Unit of Measure describing the level specification of a package.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Descr

Description	Description assigned to the product by the manufacturer and used for item look up and item validation.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Dispense Qty

Description	The number of individual units specified as the quantity to be dispensed at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Dispense UOM Cd

Description	The unit of measure of the number of individual units specified as the quantity to be dispensed at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Dispense UOM Code Descr

Description	The unit of measure of the number of individual units specified as the quantity to be dispensed at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Dispense UOM Code Sk

Description	The unit of measure of the number of individual units specified as the quantity to be dispensed at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Dispense UOM Descr

Description	The unit of measure of the number of individual units specified as the quantity to be dispensed at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Master Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Item Master Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

Item Master Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Item Master Type Cd

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Item Master Type Code Descr

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Item Master Type Code Sk

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Item Master Type Descr

Description	Code identifying the actual type of the entity as per the type hierarchy defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Item Num

Description	Standard identifier for the Item.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Short Descr

Description	Briefly describes the basic product(s) for item look up and item validation (Many MMIS systems hold only 30 characters).
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Standard Qty

Description	The number of standard individual units purchased at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Standard UOM Cd

Description	The unit of measure of the number of standard individual units purchased at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Standard UOM Code Descr

Description	The unit of measure of the number of standard individual units purchased at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Standard UOM Code Sk

Description	The unit of measure of the number of standard individual units purchased at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Standard UOM Descr

Description	The unit of measure of the number of standard individual units purchased at one time.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Status Cd

Description	Indicates the current status of the item.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Status Code Descr

Description	Indicates the current status of the item.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Status Code Sk

Description	Indicates the current status of the item.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Label Descr

Description	Description of an item used by the distributor.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Latex Ind

Description	Indicates whether or not the item is made of or contains latex.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Make

Description	The make of the equipment. For example: Victoria Health Equipment
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufactured Item Type Cd

Description	Indicates the nature or category of the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufactured Item Type Code Descr

Description	Indicates the nature or category of the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufactured Item Type Code Sk

Description	Indicates the nature or category of the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Model

Description	The model of the equipment. For example: Precision X-ray 2006
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Model Year

Description	The model year of the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Name

Description	The word or phrase used to identify (but not uniquely) the equipment.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Package Qty

Description	Describes the number of vials, ampoules, bottles, or bags in a box/case (NDDF too)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Package UOM Cd

Description	Indicates the unit of measure for inner package quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Package UOM Code Descr

Description	Indicates the unit of measure for inner package quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Package UOM Code Sk

Description	Indicates the unit of measure for inner package quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Package UOM Descr

Description	Indicates the unit of measure for inner package quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Reusable Item Ind

Description	Indicates whether or not the inventory supply item is reusable, for example, after sterilization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Subject to Expiration Ind

Description	Indicates whether or not the item is subject to containing an expiration date.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Item Master Dimension_Base Item Dimension_FK

Is Identifying Relationship	false
Child Table	Item Master Dimension
Child Role Name	has base item
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Base Item Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Item Master Dimension PK

Key Attribute

Item Master Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model