Entity Statement Element

DescriptionAn element or detail line within a report on financial movements, known as an account statement.

Attributes
Allocation AllowedAllocation Allowed
AmountAmount
CountCount
CurrencyCurrency
DescrDescr
External ReferenceExternal Reference
MemoMemo
Origination DateOrigination Date
Posted DatePosted Date
Referenced ItemReferenced Item
Short DescrShort Descr
Statement Element Sequence NumStatement Element Sequence Num

Relationship
Statement Element is included in Account StatementStatement Element is included in Account Statement
Statement Element_Financial Transaction_FKStatement Element_Financial Transaction_FK

Generalization
Statement Element_Document Content_GenStatement Element_Document Content_Gen

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Allocation Allowed
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Amount
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Count
DescriptionA quantity reported by the statement element.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Currency
DescriptionThe currency that is used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Descr
DescriptionA free-form textual explanation of the meaning of the statement element.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 External Reference
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Memo
DescriptionAdditional 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 TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Origination Date
DescriptionThe date upon which the transaction such as a charge, payment or adjustment described in the statement element was generated or incurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Posted Date
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Referenced Item
DescriptionInformation about an item that is referenced by this statement element.

For example:
Supplier invoice
Hospital bill
Claim
Payment check
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Short Descr
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Statement Element Sequence Num
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Statement Element is included in Account Statement
Is Identifying Relationshipfalse
Child TableStatement Element
Child Role Nameis included in
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAccount Statement
Parent Role Nameincludes
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Statement Element_Financial Transaction_FK
Is Identifying Relationshipfalse
Child TableStatement Element
Child Role Namereport
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFinancial Transaction
Parent Role Namereported in
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Statement Element_Document Content_Gen
SupertypeDocument Content
SubtypeStatement Element
Transform AsTABLE