| Business Data Model Data Model |
Description | An element or detail line within a report on financial movements, known as an account statement. |
Attributes | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Relationship | |
![]() |
|
![]() |
Generalization | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Indicates whether the amount specified on the statement element is the result of an allocation of an original amount over multiple accounts. For example, a depreciation charge for a piece of medical equipment may be allocated over several service lines that use that piece of equipment. |
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 |
Description | A monetary amount reported by the statement element. For example: A specific charge item on a patient account An invoice value on a supplier account |
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 |
Description | A quantity reported by the statement element. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
Description | A free-form textual explanation of the meaning of the statement element. |
Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The number or code used for identification or communication purposes. May be a number used by another party for the same transaction such as a purchase order number used by a customer of the modeled organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Additional information about the amount specified on the statement element. This may be used to further describe terms or instructions that may apply to the amount specified. |
Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The date upon which the transaction such as a charge, payment or adjustment described in the statement element was generated or incurred. |
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 |
Description | The date upon which the transaction represented by the statement element was posted to the account. There can be a time lag in the origination of a charge item and its appearance on the relevant account. For example: A credit card purchase on May 4th might be posted to the credit card account on May 7th. |
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 |
Description | Information about an item that is referenced by this statement element. For example: Supplier invoice Hospital bill Claim Payment check |
Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A free-form textual explanation of the meaning of the statement element that can be used for the presentation of statement details where there is a limit on the available space. For example: On a printed patient account statement |
Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the relative position of a statement element on the account statement. Account statements are typically presented in chronological order based on the date of posting to the account but the sequence number ensures consistent presentation of information especially where multiple elements have the same posted date. |
Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Is Identifying Relationship | false |
Child Table | Statement Element |
Child Role Name | is included in |
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 Statement |
Parent Role Name | includes |
Parent Multiplicity | ZERO_TO_ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | false |
Child Table | Statement Element |
Child Role Name | report |
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 | Financial Transaction |
Parent Role Name | reported in |
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 |
Supertype | Document Content |
Subtype | Statement Element |
Transform As | TABLE |
| Business Data Model Data Model |