| Atomic Warehouse Model Data Model |
| Description | An association between an item master and a point 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. |
| Relationship | |
 Item Master / Point of Care Location_Item Master_FK |
|
| Item Master / Point of Care Location_Point Of Care Location_FK |
|
| Primary Key | |
 Item Master / Point of Care Location PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
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 Sk
| Description | The generated surrogate key of the Item Master anchor. |
| 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 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 |
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 |
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 Sk
| Description | Surrogate key for Point Of Care Location. |
| 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 |
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 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 Code Sk
| Description | Identifies the 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 / Point of Care Location_Item Master_FK
| Is Identifying Relationship | true |
| Child Table | Item Master / Point of Care 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 / Point of Care Location_Point Of Care Location_FK
| Is Identifying Relationship | true |
| Child Table | Item Master / Point of Care 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 | Point Of Care Location |
| 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 / Point of Care Location PK
| Key Attribute | Item Master Sk |
| Key Attribute | Point Of Care Location Sk |
| Key Attribute | Relationship Type Code Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |