| Business Data Model Data Model |
| Description | A money item that is an element in the decomposition of a money provision. For example: A single cash flow A cash flow series |
| Attributes | |
Advance Arrears Indicator |
|
Base Amt |
|
Element Sequence Num |
|
| Relationship | |
Money Provision Element_Money Provision Element Part_FK |
|
Money Provision Element_Particular Money Provision_FK |
|
| Generalization | |
Generalization1 |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Advance Arrears Indicator
| Description | Indicates whether this money provision element is due at the beginning of the period or at the end of the period. For example: In arrears In advance |
| 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 |
Base Amt
| Description | The monetary value that is the basis for the calculation of the amount of the payments or payment dues that are derived from this money provision element. |
| 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 |
Element Sequence Num
| Description | The unique sequence number or reference that positions the money provision element within the money provision. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Money Provision Element_Money Provision Element Part_FK
| Is Identifying Relationship | false |
| Child Table | Money Provision Element |
| Child Role Name | belongs to |
| 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 | Money Provision Element Part |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Money Provision Element_Particular Money Provision_FK
| Is Identifying Relationship | false |
| Child Table | Money Provision Element |
| Child Role Name | contains |
| 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 | Particular Money Provision |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Generalization1
| Supertype | Money Item |
| Subtype | Money Provision Element |
| Transform As | TABLE |
| Business Data Model Data Model |