Business Data Model Data Model

Entity

Business Data Model Data Model

Entity Base Item

Description

A supplied commodity, manufactured item or service described at the lowest producible level.

Attributes
Brand Name
Definition Code
Item Consume Qty
Item Consume Unit Of Measure
Item Descr
Item Dispense Qty
Item Dispense Unit Of Measure
Item Num
Item Short Descr
Item Standard Qty
Item Standard Unit Of Measure

Relationship
Base_Item_Base_Item_FK
Product_Category_FK
Base Item_Organization_FK
Base Item_Medication_FK
Base Item_Product_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Description	Brand or trade name for this product. Usually the name appearing on the package label and frequently as a trademark.
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

Definition Code

Description	Categorization level of a product at which certain attributes are assigned.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Item Consume Qty

Description	The number of individual units specified as the quantity to be consumed 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 Consume Unit Of Measure

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

Description	Fully describes the basic product(s) 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 Unit Of Measure

Description	Indicates 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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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	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 Unit Of Measure

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

Relationship Details

Base_Item_Base_Item_FK

Is Identifying Relationship	false
Child Table	Base Item
Child Role Name	relates to
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
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Product_Category_FK

Is Identifying Relationship	true
Child Table	Base Item
Child Role Name	has category
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	Item Category
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Base Item_Organization_FK

Is Identifying Relationship	false
Child Table	Base Item
Child Role Name	Manufacturer
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	Organization
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Base Item_Medication_FK

Is Identifying Relationship	false
Child Table	Base Item
Child Role Name	describes pharmacy 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	Medication
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Base Item_Product_FK

Is Identifying Relationship	false
Child Table	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	Product
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Entity

Business Data Model Data Model