Item Unit of MeasureOperating Room Par Level IndicatorRecommended Maximum Days Inventory CntRecommended Order AmtRecommended Order Point CntRecommended Reorder TheoryRecommended Safety Stock Days Cnt
| Business Data Model Data Model |
| Description | An association between an occurrence of an item master and a location. It describes the use and control of an item master at a location. For example: The maximum number of days of inventory to have on-hand at any one point in time The recommended level of inventory at which an item should be re-ordered |
| Relationship | |
 Item Master / Location_Item Master_FK |
|
| Item Master / Location_Location_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Item Unit of Measure
| Description | Indicates the unit of measure by which all item amounts on this entity are tracked. |
| 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 |
Operating Room Par Level Indicator
| Description | Indicates whether or not on-hands inventory will be decremented when performing Preference List Issues. If valued with a 'Y', this indicates to the system that the item to be issued is contained in an operating room par level area and not an operating room inventory area; therefore, on-hands of the operation room inventory area will not be decremented. If valued with a 'N', the item is contained in an operating room inventory location and on-hands will be decremented when performing preference list issues. |
| 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 |
Recommended Maximum Days Inventory Cnt
| Description | The maximum number of days of inventory to have on-hand at any one point in time. This value is used in calculations of recommended order quantities. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Recommended Order Amt
| Description | The quantity that the system should recommend to order when the on-hand quantity is equal to or less than the reorder point. The quantity should be set at the order unit of measure. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Recommended Order Point Cnt
| Description | The on-hand quantity referencing the recommended level of inventory at which the item should be re-ordered. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Recommended Reorder Theory
| Description | The method used to calculate a recommendation for when and how much of an inventory supply item to reorder. For example: DOP/DOQ corresponds to the theory that calculates the appropriate order point and recommends the quantity to order based on system parameters and historical trends. DOP stands for Dynamic Order Point, and DOQ stands for Dynamic Order Quantity. MIN/MAX corresponds to theory that the quantity recommended is the order quantity, less the on-hand quantity, and less the on-order quantity. The order amount is the required maximum on-hand quantity. Override the quantity recommended is the order quantity, less the on-order quantity. The order amount is the amount to order when the on-hand quantity reaches the order point. |
| 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 |
Recommended Safety Stock Days Cnt
| Description | The number of days for stock to be kept on-hand to cushion against a stock-out for this item. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Item Master / Location_Item Master_FK
| Is Identifying Relationship | true |
| Child Table | Item Master / Location |
| 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 |
Item Master / Location_Location_FK
| Is Identifying Relationship | true |
| Child Table | Item Master / Location |
| 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 |
| Business Data Model Data Model |