Dimensional Warehouse Model Data Model

Entity

Entity Item Master / Location Bridge

Description

An association between an item master and apoint of care location. The point of care locations where inventory of an item is required for immediate or near immediate use. These would typically include inpatient wards, emergency departments and day patient treatment centers as well as labs and radiology departments.

Attributes
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Item Master Dk
Item Master Sk
Item Unit of Measure Cd
Item Unit of Measure Code Sk
Operating Room Par Level Ind
Point Of Care Location Dk
Point Of Care Location Sk
Recommended Maximum Days Inventory Cnt
Recommended Order Amt
Recommended Order Point Cnt
Recommended Reorder Theory Cd
Recommended Reorder Theory Code Sk
Recommended Safety Stock Days Cnt
Relationship Type Cd
Relationship Type Code Sk
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Item Master / Location Bridge_Item Master Dimension_FK
Item Master / Location Bridge_Point Of Care Location Dimension_FK

Primary Key
Item Master / Location Bridge PK

Dependencies

Reverse Dependencies

Attribute Details

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

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

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

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	false

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 Unit of Measure Cd

Description	Indicates the unit of measure by which all item amounts on this entity are tracked.
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 Unit of Measure Code Sk

Description	Indicates the unit of measure by which all item amounts on this entity are tracked.
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

Operating Room Par Level Ind

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

Point Of Care Location 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	false

Point Of Care Location 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

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 Cd

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 desired 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 reaches the order point.
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

Recommended Reorder Theory Code Sk

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 desired 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 reaches the order point.
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

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 Type Cd

Description	The code that corresponds to the Relationship Type 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

Relationship Type Code Sk

Description	The code identifying the actual type of the relationship as defined in the business data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	true
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

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	true
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 / Location Bridge_Item Master Dimension_FK

Is Identifying Relationship	true
Child Table	Item Master / Location Bridge
Child Role Name	location item rules
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 Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Item Master / Location Bridge_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	Item Master / Location Bridge
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	Point Of Care Location 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 / Location Bridge PK

Key Attribute	Item Master Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Relationship Type Code Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model