Table LIMIT_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Limit that share the same characteristics.

Columns
LIMIT_MINI_DIMENSION_IDLIMIT_MINI_DIMENSION_ID
LIMIT_TYPELIMIT_TYPE
BASISBASIS
LIFE_CYCLE_STATUSLIFE_CYCLE_STATUS
LIMIT_STATUSLIMIT_STATUS
OVERRIDEOVERRIDE
PURPOSEPURPOSE
REASONREASON
STRUCTURESTRUCTURE
TIMEFRAMETIMEFRAME
VALUE_SEGMENTVALUE_SEGMENT
VIOLATION_SEVERITYVIOLATION_SEVERITY
POPULATION_DATEPOPULATION_DATE
POPULATION_TIMEPOPULATION_TIME
POPULATION_DESCRIPTIONPOPULATION_DESCRIPTION
SOURCE_SYSTEM_NAMESOURCE_SYSTEM_NAME
SOURCE_SYSTEM_CODESOURCE_SYSTEM_CODE
UNIQUE_ID_IN_SOURCE_SYSTEMUNIQUE_ID_IN_SOURCE_SYSTEM

Primary Key
LIMIT_MINI_DIMENSION_PKLIMIT_MINI_DIMENSION_PK

Indexes
LIMIT_MINI_DIMENSION_PKLIMIT_MINI_DIMENSION_PK

Column Details

 LIMIT_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Limit Mini Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIMIT_TYPE
DescriptionLimit Type classifies Limits based on the valid set of Limits.

* Domain *
Number Of Free Transactions
Fixed Price Payments Included
Minimum Balance
Per Person Benefit Amount
Per Claim Benefit Amount
Per Period Benefit Amount
Policy Aggregate Amount
Clause Benefit Amount
Deductible Amount
Number Of Fund Swaps
Concentration Risk Maximum Amount
Principal Limit
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BASIS
DescriptionBasis classifies Limits based on its role in relation to the object to which the Limit applies.

* Domain *
Ceiling Limit
Floor Limit
Target Limit
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_CYCLE_STATUS
DescriptionLife Cycle Status classifies Limits based on the life cycle states through which they may pass over time.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIMIT_STATUS
DescriptionLimit Status classifies Limits based on whether it causes a violation of the Limit.

* Domain *
In Order
Out of Order
Approved Out of Order
In Default
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OVERRIDE
DescriptionOveride classifies Limits based on whether a condition can be overridden or replaced by a derived object. For example the substitution of a new Condition for a Condition in a base Product.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PURPOSE
DescriptionPurpose classifies Limits based on the valid set of the business activity supported or assist in accomplishing.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REASON
DescriptionReason classifies Limits based on the reason for a limit being placed.

* Domain *
Customer Requested
Financial Institution Imposed
Regulatory Imposed
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STRUCTURE
DescriptionStructure classifies Limits based on the construct used to represent the Condition.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TIMEFRAME
DescriptionTimeframeclassifies Limits based on the valid set of Limit timeframes.

* Domain *
Intraday
Overnight
Specific Expiry Date
Indefinite Limit
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALUE_SEGMENT
DescriptionValue Segment classifies Limits based on the band into which the value of the Limit Amount falls.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VIOLATION_SEVERITY
DescriptionViolation Severity classifies Limits based on the severity with which the violation is to be treated.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DATE
DescriptionPopulation Date indicates the date on which the instance of the entity was last updated.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIME
DescriptionPopulation Time indicates the time on which the instance of the entity was last updated.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_DESCRIPTION
DescriptionPopulation Description indicates the textual description of the population cycle.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_NAME
DescriptionSource System Name indicates the textual name by which the Source System is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SOURCE_SYSTEM_CODE
DescriptionSource System Code indicates the code by which the Source System is known.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIQUE_ID_IN_SOURCE_SYSTEM
DescriptionUnique Id In Source System indicates the unique identifier of the populated instance in the Source System.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 LIMIT_MINI_DIMENSION_PK
MemberLIMIT_MINI_DIMENSION_ID [BIGINT]

Index Details

 LIMIT_MINI_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberLIMIT_MINI_DIMENSION_ID [BIGINT] Ascending