Entity Account Dimension

DescriptionAn entity that tracks balances of an item of value to the organization. Can be financial (currency denominated) or unit based (for example, Inventory).

Attributes
Account BkAccount Bk
Account Category CdAccount Category Cd
Account Category Code SkAccount Category Code Sk
Account Category DescrAccount Category Descr
Account CdAccount Cd
Account Class CdAccount Class Cd
Account Class Code SkAccount Class Code Sk
Account Class DescrAccount Class Descr
Account Code DescrAccount Code Descr
Account Code SkAccount Code Sk
Account DescrAccount Descr
Account DkAccount Dk
Accounting Scenario CdAccounting Scenario Cd
Accounting Scenario Code DescrAccounting Scenario Code Descr
Accounting Scenario Code SkAccounting Scenario Code Sk
Accounting Structure NmAccounting Structure Nm
Accounting Structure SkAccounting Structure Sk
Account NmAccount Nm
Account NumAccount Num
Account Opening DtAccount Opening Dt
Account SkAccount Sk
Account Status DtAccount Status Dt
Account Status Reason CdAccount Status Reason Cd
Account Status Reason Code DescrAccount Status Reason Code Descr
Account Status Reason Code SkAccount Status Reason Code Sk
Account Status Type CdAccount Status Type Cd
Account Status Type Code DescrAccount Status Type Code Descr
Account Status Type Code SkAccount Status Type Code Sk
Account Type CdAccount Type Cd
Account Type Code DescrAccount Type Code Descr
Account Type Code SkAccount Type Code Sk
AWM Load Info SkAWM Load Info Sk
Balance AmtBalance Amt
Closing DtClosing Dt
Currency CdCurrency Cd
Currency Code DescrCurrency Code Descr
Currency Code SkCurrency Code Sk
Current IndCurrent Ind
Debit Credit CdDebit Credit Cd
Debit Credit Code DescrDebit Credit Code Descr
Debit Credit Code SkDebit Credit Code Sk
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Measurement Period Type CdMeasurement Period Type Cd
Measurement Period Type Code DescrMeasurement Period Type Code Descr
Measurement Period Type Code SkMeasurement Period Type Code Sk
Nature Of Reserve CdNature Of Reserve Cd
Nature Of Reserve Code DescrNature Of Reserve Code Descr
Nature Of Reserve Code SkNature Of Reserve Code Sk
Period Balance Type CdPeriod Balance Type Cd
Period Balance Type Code DescrPeriod Balance Type Code Descr
Period Balance Type Code SkPeriod Balance Type Code Sk
Point Balance Type CdPoint Balance Type Cd
Point Balance Type Code DescrPoint Balance Type Code Descr
Point Balance Type Code SkPoint Balance Type Code Sk
Reserve Calculation Method CdReserve Calculation Method Cd
Reserve Calculation Method Code DescrReserve Calculation Method Code Descr
Reserve Calculation Method Code SkReserve Calculation Method Code Sk
Reserve Funding Method CdReserve Funding Method Cd
Reserve Funding Method Code DescrReserve Funding Method Code Descr
Reserve Funding Method Code SkReserve Funding Method Code Sk
Source CdSource Cd
Source Code DescrSource Code Descr
Source Code SkSource Code Sk
Tenant SkTenant Sk
Type CdType Cd
Type Code DescrType Code Descr
Type Code SkType Code Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Primary Key
Account Dimension PKAccount Dimension PK

Dependencies
 
 
 
 

Reverse Dependencies
 

Attribute Details

 Account Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Account Category Cd
DescriptionAccounting 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Category Code Sk
DescriptionAccounting 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Category Descr
DescriptionA textual explanation or free form comments about the accounting category for an accounting structure level.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Cd
DescriptionIndicates the specific type of the account being tracked.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Class Cd
DescriptionIndicates the accounting concept that defines the Financial Intelligence.

For example:
Asset
Liability
Income
Expense
Owner's Equity
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Class Code Sk
DescriptionIndicates the accounting concept that defines the Financial Intelligence.

For example:
Asset
Liability
Income
Expense
Owner's Equity
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Class Descr
DescriptionIndicates the accounting concept that defines the Financial Intelligence.

For example:
Asset
Liability
Income
Expense
Owner's Equity
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Code Descr
DescriptionIndicates the specific type of the account being tracked.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Code Sk
DescriptionAccount Code describes the specific types of the Accounts being tracked.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Descr
DescriptionA free form textual description of what is represented by the account.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Accounting Scenario Cd
DescriptionIndicates the nature of the value represented by the account balance.

For example:
Actual
Budget
Estimated
Forecast
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Scenario Code Descr
DescriptionIndicates the nature of the value represented by the account balance.

For example:
Actual
Budget
Estimated
Forecast
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Scenario Code Sk
DescriptionIndicates the nature of the value represented by the account balance.

For example:
Actual
Budget
Estimated
Forecast
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Structure Nm
DescriptionThe name of the accounting structure.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Structure Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Nm
DescriptionA word or phrase used to identify (but not uniquely) the account.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Num
DescriptionAccount Num is an identifier used by the healthcare organization to identify an individual account.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Opening Dt
DescriptionThe date upon which the account is opened and is ready for transactions.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Dt
DescriptionThe effective date for the account status.

For example:
Account is pending with effect from 01/05/2013
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Reason Cd
DescriptionIndicates why the account status was changed to its current state.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Reason Code Descr
DescriptionIndicates why the account status was changed to its current state.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Reason Code Sk
DescriptionIndicates why the account status was changed to its current state.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Type Cd
DescriptionIndicates the life cycle state the account is currently in.

For example:
Submitted For Approval
Pending Open
Open
Pending Closed
Closed
Pending Deletion
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Type Code Descr
DescriptionIndicates the life cycle state the account is currently in.

For example:
Submitted For Approval
Pending Open
Open
Pending Closed
Closed
Pending Deletion
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Status Type Code Sk
DescriptionIndicates the life cycle state the account is currently in.

For example:
Submitted For Approval
Pending Open
Open
Pending Closed
Closed
Pending Deletion
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Type Cd
DescriptionIndicates the major classification or grouping to which an account naturally belongs.

For example:
Expense
Revenue
Asset
Statistical
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Type Code Descr
DescriptionIndicates the major classification or grouping to which an account naturally belongs.

For example:
Expense
Revenue
Asset
Statistical
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Account Type Code Sk
DescriptionIndicates the major classification or grouping to which an account naturally belongs.

For example:
Expense
Revenue
Asset
Statistical
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Balance Amt
DescriptionThe current value or amount of the account. Can be derived from all the amounts posted in account entries for the account.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Closing Dt
DescriptionThe date upon which the account status is changed to closed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Currency Cd
DescriptionThe currency used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Currency Code Descr
DescriptionThe currency used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Currency Code Sk
DescriptionThe currency used as the basis for all monetary amounts.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Debit Credit Cd
DescriptionIndicates whether an account or an entry is a debit or a credit.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Debit Credit Code Descr
DescriptionIndicates whether an account or an entry is a debit or a credit.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Debit Credit Code Sk
DescriptionIndicates whether an account or an entry is a debit or a credit.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Measurement Period Type Cd
DescriptionIndicates the balance calendar period.

For example:
Day
Week
Month
Quarter
Half
Year
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Measurement Period Type Code Descr
DescriptionIndicates the balance calendar period.

For example:
Day
Week
Month
Quarter
Half
Year
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Measurement Period Type Code Sk
DescriptionIndicates the balance calendar period.

For example:
Day
Week
Month
Quarter
Half
Year
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nature Of Reserve Cd
DescriptionIndicates the purpose of the reserve.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nature Of Reserve Code Descr
DescriptionIndicates the purpose of the reserve.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nature Of Reserve Code Sk
DescriptionIndicates the purpose of the reserve.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Period Balance Type Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Period Balance Type Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Period Balance Type Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Balance Type Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Balance Type Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Balance Type Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reserve Calculation Method Cd
DescriptionClassifies reserves according to the method used for calculating the balance of the reserve.

For example:
Conventional
Not sigmerized
Pseudo-premium
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reserve Calculation Method Code Descr
DescriptionClassifies reserves according to the method used for calculating the balance of the reserve.

For example:
Conventional
Not sigmerized
Pseudo-premium
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reserve Calculation Method Code Sk
DescriptionClassifies reserves according to the method used for calculating the balance of the reserve.

For example:
Conventional
Not sigmerized
Pseudo-premium
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reserve Funding Method Cd
DescriptionClassifies reserves according to the method used for funding the reserve.

For example:
Community rated
Cost plus
Experience rated
Self-funded
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reserve Funding Method Code Descr
DescriptionClassifies reserves according to the method used for funding the reserve.

For example:
Community rated
Cost plus
Experience rated
Self-funded
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Reserve Funding Method Code Sk
DescriptionClassifies reserves according to the method used for funding the reserve.

For example:
Community rated
Cost plus
Experience rated
Self-funded
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Descr
DescriptionThe description that corresponds to the Source Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Cd
DescriptionThe code that corresponds to the Type Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Descr
DescriptionThe description that corresponds to the Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Sk
DescriptionThe code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Account Dimension PK
Key AttributeAccount Dk