| Business Data Model Data Model |
| Description | An account that tracks the use and replenishment of items in the course of performing the activities of the organization. |
| Relationship | |
 Non-Monetary Account_Item Master_FK |
|
| Non-Monetary Account_Organization_FK |
|
| Non-Monetary Account_Location_FK |
|
| Generalization | |
 Generalization1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
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 |
Currency
| Description | The currency that is used as the basis for all monetary amounts. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Device Identifier
| Description | A fixed portion of a UDI that identifies the specific version or model of a device and the labeler of that device. Part of UDI, Unique Device Identifier. |
| 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 |
Domestic Manufacturer
| Description | Indicates whether the inventory item manufacturer is headquartered in the country of the modeled organization. |
| 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 |
Domestic Manufacturing
| Description | Indicates whether the inventory item was created in the country of the modeled organization. |
| 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 |
Inventory Account Expiration Date
| Description | The expiration date of the item in the inventory. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Inventory Account Unit Of Measure
| Description | Indicates the unit of measure for a non-monetary account |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Inventory Control Num
| Description | The text string that uniquely identifies this asset within the inventory control system used by the organization. This is not the same as serial number. |
| 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 |
Inventory Manufacture Date
| Description | Date service item was produced by the manufacturer. Part of UDI, Unique Device Identifier. |
| 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 |
Inventory Received Date
| Description | The date upon which the product or inventory item in question was received into inventory. This might be the most recent receipt of volume items such as bed sheets or the actual receipt date of a single high value serial number tracked item such as a piece of medical equipment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Item Importance Code
| Description | This field contains an indicator of the level of importance of an item considered for this inventory location, such as an indicator signifying whether the item is considered critical for this inventory location. |
| 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 Size
| Description | The magnitude or size of the inventory item. For example: 200 mg. 2 cubic meters 150 kgs |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Lot Number
| Description | This field contains the lot number of the service item in inventory. Part of UDI, Unique Device Identifier. |
| 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 |
Serial Number
| Description | Unique identifier of a specific instance of an item. Part of UDI, Unique Device Identifier. |
| 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 |
Unit Cost Amt
| Description | The unit cost of a single item of inventory. This will be related to the accounting policy for particular inventory items. High cost drugs for example may be accounted for at an individual dose level while paracetamol may be per 100 pills. Similarly hospital beds may be accounted for at an individual bed level while surgical gloves will be counted per box. |
| 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 |
| Relationship Details |
Non-Monetary Account_Item Master_FK
| Is Identifying Relationship | false |
| Child Table | Inventory Account |
| Child Role Name | instance of 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 | Item Master |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Non-Monetary Account_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Inventory Account |
| 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 | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Non-Monetary Account_Location_FK
| Is Identifying Relationship | false |
| Child Table | Inventory Account |
| Child Role Name | location of |
| 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 | Location |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Generalization1
| Supertype | Account |
| Subtype | Inventory Account |
| Transform As | TABLE |
| Business Data Model Data Model |