| Business Data Model Data Model |
| Description | An element or detail line within a report on financial movements, known as an account statement. |
| Attributes | |
Allocation Allowed |
|
Amount |
|
Count |
|
Currency |
|
Descr |
|
External Reference |
|
Memo |
|
Origination Date |
|
Posted Date |
|
Referenced Item |
|
Short Descr |
|
Statement Element Sequence Num |
|
| Relationship | |
Statement Element is included in Account Statement |
|
Statement Element_Financial Transaction_FK |
|
| Generalization | |
Statement Element_Document Content_Gen |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Allocation Allowed
| 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 |
Amount
| 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 |
Count
| 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 |
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 |
Descr
| 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 |
External Reference
| 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 |
Memo
| 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 |
Origination Date
| 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 |
Posted Date
| 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 |
Referenced Item
| 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 |
Short Descr
| 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 |
Statement Element Sequence Num
| 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 |
Statement Element is included in Account Statement
| 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 |
Statement Element_Financial Transaction_FK
| 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 |
Statement Element_Document Content_Gen
| Supertype | Document Content |
| Subtype | Statement Element |
| Transform As | TABLE |
| Business Data Model Data Model |