Table CATEGORY

DescriptionThe period of time for which the policy is written.
Typically used in long-term insurance, for analysis of premiums, maturity payouts, surrenders etc
A standard category definition of accounting topics. The entire set of accounting categories (established by the Financial Institution) establishes the universe of topics about which accounting information will be monitored.
Categorisation of peril types by the nature of circumstances that describe the peril.
Includes both peril types to which organisation asset or activities are exposed, and insurable peril types for which the modelled organisation issues insurance policies to its customers.
A distinct subset of a market, society, industry, or economy, whose components share similar characteristics.

Stocks are often grouped into different sectors depending upon the company's business.
Standard & Poor's breaks the market into 11 sectors. Two of these sectors, utilities and consumer staples, are said to be defensive sectors, while the rest tend to be more cyclical in nature. The other nine sectors are: transportation, technology, health care, financial, energy, consumer cyclicals, basic materials, capital goods, and communications services. Other groups break up the market into different sector categorizations, and sometimes break them down further into subsectors.
Solvency risk category is a grouping of assets and liabilities, risk exposures and other data elements which may be used as a data source for a given solvency risk component calculation.
A sub grouping of s with similar characteristics.
This is the category of expenses linked to servicing of both Life and Non Life Insurance and Reinsurance contracts that can be subject to variation over time. Expenses should include both overhead expenses and expenses which are directly assignable to individual claims, policies or transactions.
The Default risk category should reflect possible losses due to unexpected default, or deterioration in the credit standing, of the counterparties and debtors of undertakings over the forthcoming twelve months. This risk category includes risk-mitigating contracts, such as reinsurance arrangements, securitisations and derivatives, and receivables from intermediaries, as well as any other credit exposures which are not covered in the spread risk category.
A categorisation of derivatives according to purpose.
An assessment of whether the derivative is used for risk mitigattion or risk exposure.
A categorisation of cash flows based on particular characteristics of that cash flow.
A categorisation used to classify hedging strategies.
A sub grouping of solvency risk categories with similar characteristics.

e.g. Asset Accounting Category
e.g. Balance Sheet Classified
e.g. Balance Sheet Net Assets
e.g. Balance Sheet Order Of Liquidity
e.g. Balance Sheet Portfolio Basis
e.g. Capital Accounting Category
e.g. Cash Flow Direct
e.g. Cash Flow Direct Financial Institution
e.g. Cash Flow Indirect
e.g. Cash Flow Indirect Financial Institution
e.g. Collateral Accounting Category
e.g. Customer Balance Accounting Category
e.g. Expense Accounting Category
e.g. Income Accounting Category
e.g. Income Statement By Financial Institution
e.g. Income Statement By Function
e.g. Income Statement By Nature
e.g. Liability Accounting Category
e.g. Managerial Accounting Category
e.g. Statement Of Changes In Equity
e.g. Taxation Accounting Category

Columns
CATEGORY_IDCATEGORY_ID
ANCHOR_IDANCHOR_ID
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
END_DATEEND_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
MAXIMUM_SIZEMAXIMUM_SIZE
NAMENAME
ONLY_RULE_DRIVENONLY_RULE_DRIVEN
REFRESH_DATEREFRESH_DATE
START_DATESTART_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
CATEGORY_PKCATEGORY_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CATEGORY_ID
DescriptionThe unique identifier of the Category
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA free-text statement used to explain the meaning of the category.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 END_DATE
DescriptionThe date from which the category can no longer be used to qualify a business model object.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code used for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MAXIMUM_SIZE
DescriptionThe maximum number of members at any point in time.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionThe word or phrase that identifies (but not uniquely) the category.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ONLY_RULE_DRIVEN
DescriptionIndicates whether a business model object may belong to the category regardless of whether they fulfil the category definition rule.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REFRESH_DATE
DescriptionThe date on which the membership in the category was most recently updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 START_DATE
DescriptionThe date from which the category can be used to qualify a business model object.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Category.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CATEGORY_PK
DescriptionThe unique identifier of the Category
MemberCATEGORY_ID [BIGINT]

Dependency Details

 AWM - Transformation