| Atomic Warehouse Model Data Model |
| Description | An element or detail line within a report on financial movements, known as an account statement. |
| Relationship | |
 Statement Element Detail_Statement Element_FK |
|
| Primary Key | |
 Statement Element Detail PK |
|
| Dependencies | |
 |
|
| |
|
| 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 |
Content Type Code Sk
| Description | Indicates the type of document content. For example: Patient History Gross Description Microscopic Description Synopsis |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 Code Sk
| Description | The currency used as the basis for all monetary amounts. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
Document Content Keyword Txt
| Description | The words or phrases that best describe the document's context. Keywords help users find documents of interest. For Example: species, indication, biocompatibility, drug substance, drug product |
| 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 |
Document Content Txt
| Description | Contains the complete content of the document. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Sub Type Code Sk
| Description | Indicates the subtype of document. For example: Anatomical report Clinical report Forensic report Molecular report |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| 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 |
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 |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| 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 Dt
| 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 Dt
| 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 on an item referenced by this statement element. For example: Supplier invoice Hospital bill Claim Payment check or cheque |
| 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 short free form textual explanation of the meaning of the statement element. This may be used for presentation of statement details where there is a limit on available space such as 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 |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 |
Statement Element Sk
| Description | Surrogate key for the anchor entity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Type Code Sk
| Description | Identifies the actual type of the entry based on the entity type hierarchy defined in the business data model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Statement Element Detail_Statement Element_FK
| Is Identifying Relationship | true |
| Child Table | Statement Element Detail |
| 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 | Statement Element |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Statement Element Detail PK
| Key Attribute | Statement Element Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |