PeriodicBaseRatePercent |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | PeriodicBaseRatePercent |
Logical Rolename | |
ColumnName | PeriodicBaseRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The base rate used to determine the periodic interest rate caps. All calculated interest rates are compared to this base rate to determine whether a limit has been reached for the interim period. |
Note |
PeriodicBaseRatePercent Logical Attribute Properties |
Logical Attribute Name | PeriodicBaseRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PeriodicBaseRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PeriodicBaseRatePercent Bound Attachments |
Name | Current Value |
PeriodicBaseRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PeriodicBaseRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicBaseRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicBaseRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicBaseRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | SequenceNumber |
Logical Rolename | |
ColumnName | SequenceNumber |
RoleName | |
Domain | XSD:Integer |
Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
Note |
SequenceNumber Logical Attribute Properties |
Logical Attribute Name | SequenceNumber |
Datatype | INTEGER |
Nullable | YES |
SequenceNumber Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SequenceNumber Bound Attachments |
Name | Current Value |
SequenceNumber User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SequenceNumber Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicEffectiveDate |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | PeriodicEffectiveDate |
Logical Rolename | |
ColumnName | PeriodicEffectiveDate |
RoleName | |
Domain | MISMODate |
Definition | The payment due date when the periodic adjustment parameters begin. |
Note |
PeriodicEffectiveDate Logical Attribute Properties |
Logical Attribute Name | PeriodicEffectiveDate |
Datatype | DATE |
Nullable | NO |
PeriodicEffectiveDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PeriodicEffectiveDate Bound Attachments |
Name | Current Value |
PeriodicEffectiveDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PeriodicEffectiveDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicEffectiveDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicEffectiveDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicEffectiveDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumDecreaseRatePercent |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | PeriodicMaximumDecreaseRatePercent |
Logical Rolename | |
ColumnName | PeriodicMaximumDecreaseRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The maximum number of percentage points by which the interest rate can decrease from the Periodic Base Rate until the next base rate selection date. |
Note |
PeriodicMaximumDecreaseRatePercent Logical Attribute Properties |
Logical Attribute Name | PeriodicMaximumDecreaseRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PeriodicMaximumDecreaseRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PeriodicMaximumDecreaseRatePercent Bound Attachments |
Name | Current Value |
PeriodicMaximumDecreaseRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PeriodicMaximumDecreaseRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumDecreaseRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumDecreaseRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumDecreaseRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumIncreaseRatePercent |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | PeriodicMaximumIncreaseRatePercent |
Logical Rolename | |
ColumnName | PeriodicMaximumIncreaseRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The maximum number of percentage points by which the interest rate can increase from the Periodic Base Rate until the next base rate selection date. |
Note |
PeriodicMaximumIncreaseRatePercent Logical Attribute Properties |
Logical Attribute Name | PeriodicMaximumIncreaseRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PeriodicMaximumIncreaseRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PeriodicMaximumIncreaseRatePercent Bound Attachments |
Name | Current Value |
PeriodicMaximumIncreaseRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PeriodicMaximumIncreaseRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumIncreaseRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumIncreaseRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicMaximumIncreaseRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicNextBaseRateSelectionDate |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | PeriodicNextBaseRateSelectionDate |
Logical Rolename | |
ColumnName | PeriodicNextBaseRateSelectionDate |
RoleName | |
Domain | MISMODate |
Definition | The date on which a new base rate is to be determined for future periodic interest rate calculations. |
Note |
PeriodicNextBaseRateSelectionDate Logical Attribute Properties |
Logical Attribute Name | PeriodicNextBaseRateSelectionDate |
Datatype | DATE |
Nullable | NO |
PeriodicNextBaseRateSelectionDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PeriodicNextBaseRateSelectionDate Bound Attachments |
Name | Current Value |
PeriodicNextBaseRateSelectionDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PeriodicNextBaseRateSelectionDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicNextBaseRateSelectionDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicNextBaseRateSelectionDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicNextBaseRateSelectionDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicPaymentsBetweenBaseRatesCount |
Base Entity | INTEREST_RATE_PERIODIC_ADJUSTMENT_RULE |
Attribute Name | PeriodicPaymentsBetweenBaseRatesCount |
Logical Rolename | |
ColumnName | PeriodicPaymentsBetweenBaseRatesCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of payments between interest rate changes for which the periodic cap is in effect. At the end of the period a new base rate is established. |
Note |
PeriodicPaymentsBetweenBaseRatesCount Logical Attribute Properties |
Logical Attribute Name | PeriodicPaymentsBetweenBaseRatesCount |
Datatype | INTEGER |
Nullable | NO |
PeriodicPaymentsBetweenBaseRatesCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PeriodicPaymentsBetweenBaseRatesCount Bound Attachments |
Name | Current Value |
PeriodicPaymentsBetweenBaseRatesCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PeriodicPaymentsBetweenBaseRatesCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicPaymentsBetweenBaseRatesCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicPaymentsBetweenBaseRatesCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PeriodicPaymentsBetweenBaseRatesCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |