| 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 | |
Account Dimension PK |
|
| Dependencies | |
|
|
|
|
|
|
|
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Account Bk
| 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 |
Account Category Cd
| 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 |
Account 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 |
Account 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 |
Account Cd
| 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 |
Account Class Cd
| 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 |
Account 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 |
Account Class Descr
| 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 |
Account Code Descr
| 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 |
Account Code Sk
| 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 |
Account Descr
| 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 |
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 | true |
Accounting Scenario Cd
| 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 |
Accounting Scenario Code Descr
| 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 |
Accounting Scenario Code Sk
| 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 |
Accounting Structure Nm
| 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 |
Accounting Structure Sk
| 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 |
Account Nm
| 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 |
Account Num
| 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 |
Account Opening Dt
| 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 |
Account Sk
| 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 |
Account Status Dt
| 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 |
Account Status Reason Cd
| 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 |
Account Status Reason Code Descr
| 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 |
Account Status Reason Code Sk
| 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 |
Account Status Type Cd
| 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 |
Account Status Type Code Descr
| 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 |
Account Status Type Code Sk
| 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 |
Account Type Cd
| 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 |
Account Type Code Descr
| 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 |
Account Type Code Sk
| 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 |
AWM Load Info Sk
| 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 |
Balance Amt
| 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 |
Closing Dt
| 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 |
Currency Cd
| 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 |
Currency Code Descr
| 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 |
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 | true |
| Is Derived | false |
| Is Surrogate Key | false |
Current Ind
| 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 |
Debit Credit Cd
| 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 |
Debit Credit Code Descr
| 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 |
Debit Credit Code Sk
| 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 |
DWM 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 |
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 |
Measurement Period Type Cd
| 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 |
Measurement Period Type Code Descr
| 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 |
Measurement Period Type Code Sk
| 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 |
Nature Of Reserve Cd
| 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 |
Nature Of Reserve Code Descr
| 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 |
Nature Of Reserve Code Sk
| 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 |
Period Balance Type Cd
| 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 |
Period Balance Type Code Descr
| 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 |
Period Balance Type Code Sk
| 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 |
Point Balance Type Cd
| 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 |
Point Balance Type Code Descr
| 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 |
Point Balance Type Code Sk
| 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 |
Reserve Calculation Method Cd
| 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 |
Reserve Calculation Method Code Descr
| 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 |
Reserve Calculation Method Code Sk
| 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 |
Reserve Funding Method Cd
| 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 |
Reserve Funding Method Code Descr
| 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 |
Reserve Funding Method Code Sk
| 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 |
Source Cd
| 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 |
Source Code Descr
| 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 |
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 |
Type Cd
| 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 |
Type Code Descr
| 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 |
Type Code Sk
| 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 |
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 | false |
| 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 |
| Primary Key Details |
Account Dimension PK
| Key Attribute | Account Dk |
| Dimensional Warehouse Model Data Model |