| Atomic Warehouse Model Data Model |
| Description | A group that contains all the elements that are at the same level in a hierarchy. Nodes that comprise a hierarchy level are not necessarily all child nodes of the same parent node. They are nevertheless placed on the same logical level in the hierarchy For example: All the cities in an administrative division hierarchy are part of the same level, regardless of what country or region they belong to. |
| Relationship | |
 Accounting Structure Level Detail_Accounting Structure Level_FK |
|
| Primary Key | |
 Accounting Structure Level Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Accounting Category Code Sk
| Description | Accounting Category represents a standard category definition of accounting topics. The entire set of Accounting Categories (established by the organization) establishes the universe of topics about which accounting information will be monitored; for example, Ledger Accounting Category could have sub-categories such as Interest Income, Salary Expenses and Employee Benefit Expense. Managerial Accounting Categories could have sub-categories such as Hours Worked By Salaried Employees and Customer Accounting Categories could have sub-categories such as Demand Deposit or Saving Deposit. Examples: Managerial Accounting Categories could have Hours Worked By Salaried Employees. Customer Accounting Categories could have Demand Deposit or Saving Deposit. Ledger Accounting Category could have Interest Income, Salary Expenses and Employee Benefit Expense. Asset Accounting Category could have : Cash Loans Shares And Other Equity Non Share Securities Money Market Paper Fixed Assets Remaining Assets Capital Accounting Category could have : Regulatory Capital Discretionary Capital -- Reserves ---- Loan Loss Reserve ---- Cash Reserve -- Other Discretionary Capital Capital Accounting Category Type could have Accounting Categories that measure the difference between the Organization's assets and liabilities (this is also known as Owner's Equity or Net Worth ), according to the nature of the capital involved, for example: Common Stock, Preferred Stock, Capital Notes, Debentures, Loan Loss Reserves. General Ledger Accounting Category Type represents a standard category definition of accounting topics as found in the General Ledger of the Organization i.e. the universe of topics about which accounting information will be monitored in the General Ledger. Credit Risk Accounting Category Type could have Accounting Categories according to the accounting method for treating the product as on or off balance sheet, and whether the exposure position is an exchange traded position. Examples (these examples are more towards the creation of financial instrument): Over The Counter Derivatives Exposure Securities Exposure Loan Credit Exposure Commitments Exposure -- Committed Exposure -- Uncommitted Exposure ---- Communicated Exposure ---- Uncommunicated Exposure Other Non-Derivative Off Balance Sheet Items |
| 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 |
Accounting Category Descr
| Description | A textual explanation or free form comments about the accounting category for an accounting structure level. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Accounting Class Code Sk
| Description | Indicates the accounting concept that defines the Financial Intelligence. For example: Asset Liability Income Expense Owner's Equity |
| 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 |
Accounting Structure Level Descr
| Description | A description of the Accounting Structure Level. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Accounting Structure Level Sk
| Description | Surrogate key for the 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 |
Bottom Level Ind
| Description | Indicates whether the hierarchy level is at the bottom of the hierarchy. |
| 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 |
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 |
Level Num
| Description | A zero-based integer indicating the depth at which the hierarchy level is located in the hierarchy. Level number 0 indicates the topmost level (the coarsest grained concept). The numeric sequence of the level numbers indicates the ordering of the hierarchy levels. |
| 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 |
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 |
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 |
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 |
Top Level Ind
| Description | Indicates whether the hierarchy level is at the top of the hierarchy. |
| 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 |
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 |
Accounting Structure Level Detail_Accounting Structure Level_FK
| Is Identifying Relationship | true |
| Child Table | Accounting Structure Level 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 | Accounting Structure Level |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Accounting Structure Level Detail PK
| Key Attribute | Accounting Structure Level Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |