Dimensional Warehouse Model Data Model

Entity

Entity Purchase Contract Tier Dimension

Description

The tier of a contract that defines the variable pricing of items based on the purchaser's purchase volume, value or market share.

Attributes
AWM Load Info Sk
Class of Trade Cd
Class of Trade Code Sk
Class of Trade Descr
Current Ind
Distribution Type Cd
Distribution Type Code Sk
Distribution Type Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Purchase Contract Dk
Purchase Contract Sk
Purchase Contract Tier Bk
Purchase Contract Tier Dk
Purchase Contract Tier Sk
Service Provider Class Cd
Service Provider Class Code Sk
Service Provider Class Descr
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Tier Descr
Tier Eligibility Calculation Routine Id
Tier Num
Tier Qualification Calculation Routine Id
Valid From Ts
Valid To Ts

Relationship
Purchase Contract Tier Dimension_Purchase Contract Dimension_FK

Primary Key
Purchase Contract Tier Dimension 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

Class of Trade Cd

Description	Indicates the class of trade, which can be Acute Care, Long Term Care, Educational Institution, etc.
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

Class of Trade Code Sk

Description	Indicates the class of trade, which can be Acute Care, Long Term Care, Educational Institution, etc.
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

Class of Trade Descr

Description	Indicates the class of trade, which can be Acute Care, Long Term Care, Educational Institution, etc.
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

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

Distribution Type Cd

Description	Identifies a Tier as being based on Distributor purchases or Direct purchases from the Supplier.
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

Distribution Type Code Sk

Description	Identifies a Tier as being based on Distributor purchases or Direct purchases from the Supplier.
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

Distribution Type Descr

Description	Identifies a Tier as being based on Distributor purchases or Direct purchases from the Supplier.
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

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

Purchase Contract 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Purchase Contract 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

Purchase Contract Tier Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Purchase Contract Tier 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	true

Purchase Contract Tier 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

Service Provider Class Cd

Description	A sub-categorization of the Class of Trade. If the Class of Trade is 'Pharmacy', then the Service Provider Class (SPC) could be Acute Care Pharmacy, Non-Acute Care Pharmacy, etc. Food Service Providers can also be similarly sub-classified.
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

Service Provider Class Code Sk

Description	A sub-categorization of the Class of Trade. If the Class of Trade is 'Pharmacy', then the Service Provider Class (SPC) could be Acute Care Pharmacy, Non-Acute Care Pharmacy, etc. Food Service Providers can also be similarly sub-classified.
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

Service Provider Class Descr

Description	A sub-categorization of the Class of Trade. If the Class of Trade is 'Pharmacy', then the Service Provider Class (SPC) could be Acute Care Pharmacy, Non-Acute Care Pharmacy, etc. Food Service Providers can also be similarly sub-classified.
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

Source Cd

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

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
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

Tier Descr

Description	A description of the Tier.
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

Tier Eligibility Calculation Routine Id

Description	The name of the JAVA routine that evaluates the Purchase Contract Tier Eligibility parameters for complex combinational logic to determine which for Tiers a Member may be eligible. These parameters may include Members attributes, program enrollment and other factors.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tier Num

Description	Identifies the number of the Tier within a Purchase Contract. Tier numbers are usually unique, but there are exceptions.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier Numeric [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Tier Qualification Calculation Routine Id

Description	The name of the JAVA routine that evaluates the Purchase Contract Tier Qualification parameters for complex combinational logic.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
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	false
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

Purchase Contract Tier Dimension_Purchase Contract Dimension_FK

Is Identifying Relationship	false
Child Table	Purchase Contract Tier Dimension
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	Purchase Contract 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

Purchase Contract Tier Dimension PK

Key Attribute

Purchase Contract Tier Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model