Account Agreement TypeAgreement Past Due StatusAllow Multi Currency Balances IndAllow Multi Currency Transactions IndEndorsementInterest Posting FrequencyMinimum Monthly RepaymentTax Status Ind
| Business Data Model Data Model |
| Description | An agreement between a healthcare insurer and an account holder related to the management of an account. |
| Relationship | |
 Account Agreement_Account_FK |
|
| Generalization | |
 Account Agreement_Agreement_Gen |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Account Agreement Type
| Description | Classifies account agreement according to the nature or purpose of the Account Agreement. |
| 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 |
Agreement Past Due Status
| Description | Classifies account agreement according to the length of time that the account agreement has been delinquent with respect to due payments. |
| 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 |
Allow Multi Currency Balances Ind
| Description | Indicates whether the account can hold balances in multiple currencies. |
| 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 |
Allow Multi Currency Transactions Ind
| Description | Indicates whether the account holder can make transactions in multiple currencies on this account. |
| 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 |
Endorsement
| Description | The type of card endorsement according to whether the card has the stamp or endorsement of a third party such as a non-profit organization, for promotional purposes. For example: Non-endorsed Private |
| 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 |
Interest Posting Frequency
| Description | Classifies account agreement according to the frequency at which interest is posted on the account agreement. This usually depends on the type of account but individual exceptions are possible. |
| 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 |
Minimum Monthly Repayment
| Description | The minimum proportion of the outstanding balance which must be paid by the owner monthly. |
| 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 |
Tax Status Ind
| Description | Indicates whether or not taxing is required. |
| 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 |
| Relationship Details |
Account Agreement_Account_FK
| Is Identifying Relationship | false |
| Child Table | Account Agreement |
| 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 | Account |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Account Agreement_Agreement_Gen
| Supertype | Agreement |
| Subtype | Account Agreement |
| Transform As | TABLE |
| Business Data Model Data Model |