| Dimensional Warehouse Model Data Model |
| Description | To analyze an organization's Cash Flow which is the amount of cash an organization generates and uses during a period, calculated by adding non-cash charges (such as depreciation) to the net income after taxes. |
| Relationship | |
 Cash Flow Analysis_Provider Dimension_FK |
|
| Cash Flow Analysis_Responsibility Center Dimension_FK |
|
| Cash Flow Analysis_Account Dimension_FK |
|
| Cash Flow Analysis_Calendar Dimension_FK |
|
| Primary Key | |
 Cash Flow Analysis PK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Account Dk
| Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
| 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 |
Calendar Dk
| Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
| 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 |
Cash And Cash Equivalents Beginning Balance Amt
| Description | A measure that identifies the value at the start of a period of assets that are cash or assets which can be readily converted into cash. Cash includes money an organization holds and money deposited with Financial Institutions that can be withdrawn without notice. Cash equivalents are defined as short-term, highly liquid investments that are readily convertible to known amounts of cash and which are subject to an insignificant risk of changes in value [International Financial Reporting Standard IAS7.6]. |
| 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 |
Cash And Cash Equivalents Ending Balance Amt
| Description | A measure that identifies the value at the end of a period of assets that are cash or assets which can be readily converted into cash. Cash includes money an organization holds and money deposited with Financial Institutions that can be withdrawn without notice. Cash equivalents are defined as short-term, highly liquid investments that are readily convertible to known amounts of cash and which are subject to an insignificant risk of changes in value [International Financial Reporting Standard IAS7.6]. |
| 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 |
Net Cash Flow From Discontinued Operations Amt
| Description | A measure that identifies the cash flow which is generated by discontinued operations from various activities including Financing Activities, Investing Activities and Operating Activities. |
| 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 |
Net Cash Flow From Financing Activities Amt
| Description | A measure that identifies the cash flow for activities which involve the raising of finances to support other activities. International Financial Reporting Standard-CP It is the accounting of funds related to the financing of the company which is reported on the cash flow statement of a company's annual report. This is where the company reports the money that it took in and paid out in order to finance its activities. In other words, it calculates how much money the company spent or received from its stocks and bonds. This includes any dividend payments that the company made to its shareholders, any money that it made by selling new shares of stock to the public, any money it spent buying back shares of its stock from the public, any money it borrowed, and any money it used to repay money it had previously borrowed. |
| 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 |
Net Cash Flow From Investing Activities Amt
| Description | A measure that identifies the cash flow from activities which involve the purchase and sale of securities (not including cash equivalents), and other assets. International Financial Reporting Standard IAS 7 10 |
| 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 |
Net Cash Flow From Operating Activities Amt
| Description | A measure that identifies the Net Cash Flows from (Used in) Operating Activities. Cash Flow is the measure of the actual cash generated by an organization rather than the accounting profit. International Financial Reporting Standard IAS 7 10 |
| 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 |
Net Increase In Cash And Cash Equivalents Amt
| Description | A measure that identifies the net increase in the value of assets that are cash or assets which can be readily converted into cash. Cash includes money an organization holds and money deposited with Financial Institutions that can be withdrawn without notice. Cash equivalents are defined as short-term, highly liquid investments that are readily convertible to known amounts of cash and which are subject to an insignificant risk of changes in value [International Financial Reporting Standard IAS7.6]. |
| 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 |
Provider Dk
| Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
| 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 |
Responsibility Center Dk
| Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
| 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 |
Supplemental Disclosures On Continuing Operations Amt
| Description | (Supplemental Disclosures On Continuing Operations) A measure that identifies disclosures which provide additional details on continuing operations. |
| 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 |
| Relationship Details |
Cash Flow Analysis_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Cash Flow Analysis |
| 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 | Provider Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Cash Flow Analysis_Responsibility Center Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Cash Flow Analysis |
| 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 | Responsibility Center Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Cash Flow Analysis_Account Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Cash Flow Analysis |
| 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 Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Cash Flow Analysis_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Cash Flow Analysis |
| 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 | Calendar Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Cash Flow Analysis PK
| Description | The unique identifier of the Cash Flow Analysis |
| Key Attribute | Provider Dk |
| Key Attribute | Responsibility Center Dk |
| Key Attribute | Account Dk |
| Key Attribute | Calendar Dk |
| Dimensional Warehouse Model Data Model |