| Dimensional Warehouse Model Data Model |
Description | An entity that tracks balances of an item of value to the organization. Can be financial (currency denominated) or unit based (for example, Inventory). |
Primary Key | |
![]() |
Dependencies | |
![]() |
|
![]() |
|
![]() |
|
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Concatenated values of a set of business attributes that uniquely identify the row. |
Data Type | Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
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/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
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 |
Description | Indicates the specific type of the account being tracked. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
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/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the specific type of the account being tracked. |
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 |
Description | Account Code describes the specific types of the Accounts being tracked. |
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 |
Description | A free form textual description of what is represented by the account. |
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 |
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 | true |
Description | Indicates the nature of the value represented by the account balance. For example: Actual Budget Estimated Forecast |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the nature of the value represented by the account balance. For example: Actual Budget Estimated Forecast |
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 |
Description | Indicates the nature of the value represented by the account balance. For example: Actual Budget Estimated Forecast |
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 |
Description | The name of the accounting structure. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the atomic model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A word or phrase used to identify (but not uniquely) the account. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Account Num is an identifier used by the healthcare organization to identify an individual account. |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The date upon which the account is opened and is ready for transactions. |
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 |
Description | A numeric surrogate key used to uniquely identify entities in the atomic model. |
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 |
Description | The effective date for the account status. For example: Account is pending with effect from 01/05/2013 |
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 |
Description | Indicates why the account status was changed to its current state. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates why the account status was changed to its current state. |
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 |
Description | Indicates why the account status was changed to its current state. |
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 |
Description | Indicates the life cycle state the account is currently in. For example: Submitted For Approval Pending Open Open Pending Closed Closed Pending Deletion |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the life cycle state the account is currently in. For example: Submitted For Approval Pending Open Open Pending Closed Closed Pending Deletion |
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 |
Description | Indicates the life cycle state the account is currently in. For example: Submitted For Approval Pending Open Open Pending Closed Closed Pending Deletion |
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 |
Description | Indicates the major classification or grouping to which an account naturally belongs. For example: Expense Revenue Asset Statistical |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the major classification or grouping to which an account naturally belongs. For example: Expense Revenue Asset Statistical |
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 |
Description | Indicates the major classification or grouping to which an account naturally belongs. For example: Expense Revenue Asset Statistical |
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 |
Description | The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse. |
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 |
Description | The current value or amount of the account. Can be derived from all the amounts posted in account entries for the account. |
Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The date upon which the account status is changed to closed. |
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 |
Description | The currency used as the basis for all monetary amounts. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The currency used as the basis for all monetary amounts. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
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 | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Set to 'Y' if this is the most recent row of a group having the same Surrogate Key. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether an account or an entry is a debit or a credit. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether an account or an entry is a debit or a credit. |
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 |
Description | Indicates whether an account or an entry is a debit or a credit. |
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 |
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 |
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 |
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 |
Description | Indicates the balance calendar period. For example: Day Week Month Quarter Half Year |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the balance calendar period. For example: Day Week Month Quarter Half Year |
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 |
Description | Indicates the balance calendar period. For example: Day Week Month Quarter Half Year |
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 |
Description | Indicates the purpose of the reserve. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the purpose of the reserve. |
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 |
Description | Indicates the purpose of the reserve. |
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 |
Description | Indicates the method by which the amount reflected by the account balance is calculated. For example: Amount Maximum Minimum Mean Median Mode Total Total Average Net |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the method by which the amount reflected by the account balance is calculated. For example: Amount Maximum Minimum Mean Median Mode Total Total Average Net |
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 |
Description | Indicates the method by which the amount reflected by the account balance is calculated. For example: Amount Maximum Minimum Mean Median Mode Total Total Average Net |
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 |
Description | Indicates the nature of the point in time within an interval of time at which the account balance was recorded. For example: Beginning or Opening Balance Interim Balance - Statement Balance - Capital Balance - YTD Balance End or Closing Balance |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the nature of the point in time within an interval of time at which the account balance was recorded. For example: Beginning or Opening Balance Interim Balance - Statement Balance - Capital Balance - YTD Balance End or Closing Balance |
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 |
Description | Indicates the nature of the point in time within an interval of time at which the account balance was recorded. For example: Beginning or Opening Balance Interim Balance - Statement Balance - Capital Balance - YTD Balance End or Closing Balance |
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 |
Description | Classifies reserves according to the method used for calculating the balance of the reserve. For example: Conventional Not sigmerized Pseudo-premium |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Classifies reserves according to the method used for calculating the balance of the reserve. For example: Conventional Not sigmerized Pseudo-premium |
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 |
Description | Classifies reserves according to the method used for calculating the balance of the reserve. For example: Conventional Not sigmerized Pseudo-premium |
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 |
Description | Classifies reserves according to the method used for funding the reserve. For example: Community rated Cost plus Experience rated Self-funded |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Classifies reserves according to the method used for funding the reserve. For example: Community rated Cost plus Experience rated Self-funded |
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 |
Description | Classifies reserves according to the method used for funding the reserve. For example: Community rated Cost plus Experience rated Self-funded |
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 |
Description | The code that corresponds to the Source Code Sk. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The description that corresponds to the Source Type Cd. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
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 |
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 |
Description | The code that corresponds to the Type Code Sk. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The description that corresponds to the Type Cd. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The code identifying the actual type of the entity as per the type hierarchy defined in the analysis 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 |
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 | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
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 |
Primary Key Details |
Key Attribute | Account Dk |
| Dimensional Warehouse Model Data Model |