| Dimensional Warehouse Model Data Model |
| Description | To support the organization in the generation and analysis of the Security And Exchange Commissions (SEC) 10Q and 10K reports. |
| Primary Key | |
 Financial Summary 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 |
Basic Earnings (Loss) Per Share Amt
| Description | A measure that identifies the Basic Earnings (Loss) Per Share. Basic earnings is calculated as the net profit or loss attributable to ordinary shareholders less preference dividends. International Financial Reporting Standard IAS 33 66 |
| 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 |
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 |
Capital Expense Amt
| Description | A measure that identifies all costs associated with funding the running of an Organization Unit (or part thereof), including capital costs and dividends paid. |
| 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 Income Amt
| Description | A measure that identifies the difference between revenue earned (Income) and costs incurred (Expenses) including taxes and any income or loss generated by discontinued 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 |
Net Income Applicable To Common Shareholders Amt
| Description | A measure that identifies the funds applicable to common stock shareholders of the organization based on Net income after Tax and after any dividends payable to preference shareholders. |
| 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 Income From Continuing Operations Amt
| Description | A measure that identifies the value of income from continuing operations after income tax has been deducted. |
| 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 |
Operating Income Amt
| Description | A measure that identifies the monetary value of profit (or loss) generated by the organization through its normal activities during a period of time. |
| 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 |
Profit Margin Amt
| Description | A measure that identifies the value of sales minus cost of goods sold. Also known as Gross Margin or Gross Profit. Note that this value can be negative where goods are sold at a loss. |
| 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 |
Return On Assets Amt
| Description | A measure that identifies the net operating income divided by total average assets for the organization. |
| 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 |
Return On Equity Amt
| Description | A measure that identifies the net operating income divided by average total equity of the organization. |
| 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 |
Total Assets Amt
| Description | A measure that identifies the value of everything owned by an Involved Party that has commercial exchange or book value. Listed on the Balance Sheet, this figure represents the total assets of the company. Total Assets include all the Current Assets, Net Property/Plant/Equipment, and any other miscellaneous assets the company may have. Importance of Total Assets: Total Assets in and of themselves are important, but it is even more important to look at what makes up the Total Assets and how these figures change over time. For example a company with a higher amounts of cash and marketable securities, but low amounts of inventory over time is one that is becoming more efficient in its asset-handling practices and is generally a good sign. Total assets include fair market value of securities owned, plus collateral held for securities loaned, un-invested cash, foreign currency, receivables, forward foreign currency contract appreciation, variation margin, and other miscellaneous assets, as of the date indicated. For example: Shareholder equity is the difference between total assets and total liabilities on the balance sheet. |
| 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 |
Total Liabilities And Share Capital Amt
| Description | A measure that identifies the value associated with the calculation of total liabilities and share capital. Total liabilities include short term liabilities, long term liabilities, long term debt and liabilities from discontinued operations. Share capital is the capital stipulated in a corporation's articles of association. The articles also specify the number of shares into which the share capital is divided. The company issues shares in the amount of its share capital. |
| 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 |
Financial Summary Analysis_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Financial Summary 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 |
Financial Summary Analysis_Responsibility Center Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Financial Summary 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 |
Financial Summary Analysis_Account Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Financial Summary 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 |
Financial Summary Analysis_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Financial Summary 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 |
Financial Summary Analysis PK
| Key Attribute | Provider Dk |
| Key Attribute | Account Dk |
| Key Attribute | Responsibility Center Dk |
| Key Attribute | Calendar Dk |
| Dimensional Warehouse Model Data Model |