Business Data Model Data Model

Entity

Entity Purchase Contract Tier

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
Ceiling Participation Operator
Ceiling Participation Pct
Ceiling Purchase Cnt
Ceiling Purchase Count Operator
Ceiling Spend Amount Operator
Ceiling Spend Amt
Class of Trade
Currency
Distribution Type
Qualifying Participation Operator
Qualifying Participation Pct
Qualifying Purchase Cnt
Qualifying Purchase Count Operator
Qualifying Spend Amount Operator
Qualifying Spend Amt
Service Provider Class
Tier Descr
Tier Eligibility Calculation Routine Id
Tier Num
Tier Qualification Calculation Routine Id

Relationship
Purchase Contract Tier_Purchase Contract_FK
Purchase Contract Tier_Member Organization_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Ceiling Participation Operator

Description	The mathematical comparison operator applied to the ceiling participation percentage. Typically , , =, = or =.
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

Ceiling Participation Pct

Description	The maximum Member participation or market share percentage that falls within this purchase contract tier.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ceiling Purchase Cnt

Description	The maximum member purchase quantity that falls within the purchase contract tier.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Ceiling Purchase Count Operator

Description	The mathematical comparison operator applied to the ceiling purchase quantity. Typically , , =, = or =.
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

Ceiling Spend Amount Operator

Description	The mathematical comparison operator applied to the ceiling purchase amount. Typically , , =, = or =.
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

Ceiling Spend Amt

Description	The maximum member spend amount that falls within the purchase contract tier.
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

Class of Trade

Description	The class of trade. For example: Acute Care Long Term Care Educational Institution
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

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	false
Is Derived	false
Is Surrogate Key	false

Distribution Type

Description	An indicator that shows a tier as based on distributor purchases or direct purchases from the supplier.
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

Qualifying Participation Operator

Description	The mathematical comparison operator applied to the qualifying participation percentage. Typically , , =, = or =.
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

Qualifying Participation Pct

Description	The minimum participation or market share with this vendor required to qualify for this tier.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Qualifying Purchase Cnt

Description	The minimum purchase quantity required to qualify for this tier.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Qualifying Purchase Count Operator

Description	The mathematical comparison operator applied to the qualifying purchase quantity. Typically , , =, = or =.
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

Qualifying Spend Amount Operator

Description	The mathematical comparison operator applied to the qualifying purchase amount. Typically , , =, = or =.
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

Qualifying Spend Amt

Description	The minimum financial spend amount required in order to qualify for this Tier.
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

Service Provider Class

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
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	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

Relationship Details

Purchase Contract Tier_Purchase Contract_FK

Is Identifying Relationship	true
Child Table	Purchase Contract Tier
Child Multiplicity	ONE_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Purchase Contract
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Purchase Contract Tier_Member Organization_FK

Is Identifying Relationship	false
Child Table	Purchase Contract Tier
Child Role Name	is alliance member-specific tier
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	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model