Activation Source TypeActivation StatusChargeback IdMember Contract Activation Status Date
| Business Data Model Data Model |
| Description | The purchase contract tier which an organization is eligible to activate and their current activation status. It records the outcome of an eligibility determination, not the rules necessary to make that determination. |
| Attributes | |
| Activation Source Type |
|
| Activation Status |
|
| Chargeback Id |
|
| Member Contract Activation Status Date |
|
| Relationship | |
 Member Contract Activation_Organization_FK |
|
| Member Contract Activation_Purchase Contract Tier_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Activation Source Type
| Description | Identifies the internal or external source of the Alliance Member contract activation or eligibility determination. |
| 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 |
Activation Status
| Description | Indicates the current status of the Member's Contract Price Tier activation. For example: Ineligible Eligible Active Expired |
| 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 |
Chargeback Id
| Description | A contract identifier used for Rx contracts that controls the reimbursement of the Distributor by the Supplier for price discounts issued to the Alliance Members for purchases. |
| 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 |
Member Contract Activation Status Date
| Description | The date upon which the member's contract price tier became active. |
| 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 |
| Relationship Details |
Member Contract Activation_Organization_FK
| Is Identifying Relationship | true |
| Child Table | Purchase Contract Tier Activation |
| 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 | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Member Contract Activation_Purchase Contract Tier_FK
| Is Identifying Relationship | true |
| Child Table | Purchase Contract Tier Activation |
| 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 Tier |
| 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 |