ConversionDateMaximumExtensionMonthsCount |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionDateMaximumExtensionMonthsCount |
Logical Rolename | |
ColumnName | ConversionDateMaximumExtensionMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The maximum number of months by which a loan can extend its conversion date. |
Note |
ConversionDateMaximumExtensionMonthsCount Logical Attribute Properties |
Logical Attribute Name | ConversionDateMaximumExtensionMonthsCount |
Datatype | INTEGER |
Nullable | NO |
ConversionDateMaximumExtensionMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionDateMaximumExtensionMonthsCount Bound Attachments |
Name | Current Value |
ConversionDateMaximumExtensionMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionDateMaximumExtensionMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionDateMaximumExtensionMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionDateMaximumExtensionMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionDateMaximumExtensionMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionMaximumAllowedCount |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionMaximumAllowedCount |
Logical Rolename | |
ColumnName | ConversionMaximumAllowedCount |
RoleName | |
Domain | MISMOCount |
Definition | The maximum number of times a borrower can exercise conversion options. |
Note |
ConversionMaximumAllowedCount Logical Attribute Properties |
Logical Attribute Name | ConversionMaximumAllowedCount |
Datatype | INTEGER |
Nullable | NO |
ConversionMaximumAllowedCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionMaximumAllowedCount Bound Attachments |
Name | Current Value |
ConversionMaximumAllowedCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionMaximumAllowedCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionMaximumAllowedCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionMaximumAllowedCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionMaximumAllowedCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionDurationMonthsCount |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionDurationMonthsCount |
Logical Rolename | |
ColumnName | ConversionOptionDurationMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The duration (in months) of the conversion option. |
Note |
ConversionOptionDurationMonthsCount Logical Attribute Properties |
Logical Attribute Name | ConversionOptionDurationMonthsCount |
Datatype | INTEGER |
Nullable | NO |
ConversionOptionDurationMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionDurationMonthsCount Bound Attachments |
Name | Current Value |
ConversionOptionDurationMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionDurationMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionDurationMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionDurationMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionDurationMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMarginRatePercent |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionMarginRatePercent |
Logical Rolename | |
ColumnName | ConversionOptionMarginRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The number of percentage points to be added to the index when calculating a new interest rate for the option to convert an ARM loan to a fixed rate loan. |
Note |
ConversionOptionMarginRatePercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionMarginRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionMarginRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionMarginRatePercent Bound Attachments |
Name | Current Value |
ConversionOptionMarginRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionMarginRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMarginRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMarginRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMarginRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMaximumRatePercent |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionMaximumRatePercent |
Logical Rolename | |
ColumnName | ConversionOptionMaximumRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The highest rate, expressed as a percent, to which the interest rate can increase when calculating a new interest rate for the option to convert an ARM loan to a fixed rate loan. |
Note |
ConversionOptionMaximumRatePercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionMaximumRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionMaximumRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionMaximumRatePercent Bound Attachments |
Name | Current Value |
ConversionOptionMaximumRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionMaximumRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMaximumRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMaximumRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMaximumRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMinimumRatePercent |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionMinimumRatePercent |
Logical Rolename | |
ColumnName | ConversionOptionMinimumRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The lowest rate, expressed as a percent, to which the interest rate can decrease when calculating a new interest rate for the option to convert an ARM loan to a fixed rate loan. |
Note |
ConversionOptionMinimumRatePercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionMinimumRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionMinimumRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionMinimumRatePercent Bound Attachments |
Name | Current Value |
ConversionOptionMinimumRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionMinimumRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMinimumRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMinimumRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionMinimumRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent |
Logical Rolename | |
ColumnName | ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The number of percentage points added to the net yield to obtain the new fixed interest rate when the original term of the Note is greater than 15 years. |
Note |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Bound Attachments |
Name | Current Value |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermGreaterThanFifteenYearsAdditionalPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent |
Logical Rolename | |
ColumnName | ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percent added to the net yield to obtain the new fixed interest rate when the original term of the Note is less than 15 years. |
Note |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Bound Attachments |
Name | Current Value |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionNoteTermLessThanFifteenYearsAdditionalPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleType |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionScheduleType |
Logical Rolename | |
ColumnName | ConversionScheduleType |
RoleName | |
Domain | ConversionScheduleEnum |
Definition | Describes when the loan is eligible to convert. |
Note |
ConversionScheduleType Logical Attribute Properties |
Logical Attribute Name | ConversionScheduleType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConversionScheduleType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionScheduleType Reference Value (Bound to Domain) |
Name | ValidationRule80 |
Description | |
Type | By List |
Value | Value Description |
Anytime | Convertible Anytime Throughout Life of Loan |
OnFirstAndSecondRateAdjustment | Convertible at 1st and 2nd Interest Rate Change Dates |
OnFirstThroughFifthRateAdjustment | Convertible from 1st through 5th Interest Rate Change Dates |
OnFirstThroughThirdRateAdjustment | Convertible at 1st, 2nd, and 3rd Interest Rate Change Dates |
OnSecondThroughTenthRateAdjustment | Convertible from 2nd through 10th Interest Rate Change Dates |
OnThirdThroughFifthRateAdjustment | Convertible at 3rd, 4th, and 5th Interest Rate Change Dates |
Other | Other |
ConversionScheduleType Bound Attachments |
Name | Current Value |
ConversionScheduleType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionScheduleType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleTypeOtherDescription |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionScheduleTypeOtherDescription |
Logical Rolename | |
ColumnName | ConversionScheduleTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Conversion Schedule Type. |
Note |
ConversionScheduleTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | ConversionScheduleTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ConversionScheduleTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionScheduleTypeOtherDescription Bound Attachments |
Name | Current Value |
ConversionScheduleTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionScheduleTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionScheduleTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionType |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionType |
Logical Rolename | |
ColumnName | ConversionType |
RoleName | |
Domain | ConversionEnum |
Definition | Specifies the type of conversion permissible for a loan as stated on the mortgage documents. |
Note |
ConversionType Logical Attribute Properties |
Logical Attribute Name | ConversionType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConversionType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionType Reference Value (Bound to Domain) |
Name | ValidationRule76 |
Description | |
Type | By List |
Value | Value Description |
Other | Other |
ToBiweeklyPaymentFrequency | ToBiweeklyPaymentFrequency |
ToFixedRate | ToFixedRate |
ToFullyAmortizingTerm | ToFullyAmortizingTerm |
ToLevelPayment | ToLevelPayment |
ToLowerInterestRate | ToLowerInterestRate |
ToMonthlyPaymentFrequency | ToMonthlyPaymentFrequency |
ConversionType Bound Attachments |
Name | Current Value |
ConversionType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionTypeOtherDescription |
Base Entity | CONVERSION_ADJUSTMENT_LIFETIME_ADJUSTMENT_RULE |
Attribute Name | ConversionTypeOtherDescription |
Logical Rolename | |
ColumnName | ConversionTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Conversion Type. |
Note |
ConversionTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | ConversionTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ConversionTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionTypeOtherDescription Bound Attachments |
Name | Current Value |
ConversionTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |