ConversionOptionPeriodAdjustmentEffectiveDate |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodAdjustmentEffectiveDate |
Logical Rolename | |
ColumnName | ConversionOptionPeriodAdjustmentEffectiveDate |
RoleName | |
Domain | MISMODate |
Definition | The payment due date when the convertible factors become applicable, also known as the conversion period start date. |
Note |
ConversionOptionPeriodAdjustmentEffectiveDate Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodAdjustmentEffectiveDate |
Datatype | DATE |
Nullable | NO |
ConversionOptionPeriodAdjustmentEffectiveDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodAdjustmentEffectiveDate Bound Attachments |
Name | Current Value |
ConversionOptionPeriodAdjustmentEffectiveDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodAdjustmentEffectiveDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodAdjustmentEffectiveDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodAdjustmentEffectiveDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodAdjustmentEffectiveDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber |
Base Entity | CONVERSION_OPTION_PERIOD_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 |
ConversionOptionPeriodDemandNotificationFrequencyCount |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodDemandNotificationFrequencyCount |
Logical Rolename | |
ColumnName | ConversionOptionPeriodDemandNotificationFrequencyCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of payments between demand conversion option notifications to be mailed as a courtesy to the mortgagor. |
Note |
ConversionOptionPeriodDemandNotificationFrequencyCount Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodDemandNotificationFrequencyCount |
Datatype | INTEGER |
Nullable | NO |
ConversionOptionPeriodDemandNotificationFrequencyCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodDemandNotificationFrequencyCount Bound Attachments |
Name | Current Value |
ConversionOptionPeriodDemandNotificationFrequencyCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodDemandNotificationFrequencyCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodDemandNotificationFrequencyCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodDemandNotificationFrequencyCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodDemandNotificationFrequencyCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodExpirationDate |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodExpirationDate |
Logical Rolename | |
ColumnName | ConversionOptionPeriodExpirationDate |
RoleName | |
Domain | MISMODate |
Definition | The payment due date when the convertible factors expire. |
Note |
ConversionOptionPeriodExpirationDate Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodExpirationDate |
Datatype | DATE |
Nullable | NO |
ConversionOptionPeriodExpirationDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodExpirationDate Bound Attachments |
Name | Current Value |
ConversionOptionPeriodExpirationDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodExpirationDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodExpirationDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodExpirationDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodExpirationDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeAmount |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodFeeAmount |
Logical Rolename | |
ColumnName | ConversionOptionPeriodFeeAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount that the mortgagor must pay to exercise the conversion option. |
Note |
ConversionOptionPeriodFeeAmount Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodFeeAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionPeriodFeeAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodFeeAmount Bound Attachments |
Name | Current Value |
ConversionOptionPeriodFeeAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodFeeAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeBalanceCalculationType |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodFeeBalanceCalculationType |
Logical Rolename | |
ColumnName | ConversionOptionPeriodFeeBalanceCalculationType |
RoleName | |
Domain | ConversionOptionPeriodFeeBalanceCalculationEnum |
Definition | Indicates whether the conversion fee is calculated as a percentage of the original principal balance or the principal balance at the time of conversion. |
Note |
ConversionOptionPeriodFeeBalanceCalculationType Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodFeeBalanceCalculationType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConversionOptionPeriodFeeBalanceCalculationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodFeeBalanceCalculationType Reference Value (Bound to Domain) |
Name | ValidationRule78 |
Description | |
Type | By List |
Value | Value Description |
CurrentBalanceAtConversion | CurrentBalanceAtConversion |
OriginalBalance | OriginalBalance |
ConversionOptionPeriodFeeBalanceCalculationType Bound Attachments |
Name | Current Value |
ConversionOptionPeriodFeeBalanceCalculationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodFeeBalanceCalculationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeBalanceCalculationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeBalanceCalculationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeeBalanceCalculationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeePercent |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodFeePercent |
Logical Rolename | |
ColumnName | ConversionOptionPeriodFeePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage of the loans principal balance (either original or at conversion) that the mortgagor must pay to exercise the option to convert. |
Note |
ConversionOptionPeriodFeePercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodFeePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionPeriodFeePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodFeePercent Bound Attachments |
Name | Current Value |
ConversionOptionPeriodFeePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodFeePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodFeePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodReplyDaysCount |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodReplyDaysCount |
Logical Rolename | |
ColumnName | ConversionOptionPeriodReplyDaysCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of days after the notice is generated that the mortgagor must reply to exercise the option to convert. |
Note |
ConversionOptionPeriodReplyDaysCount Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodReplyDaysCount |
Datatype | INTEGER |
Nullable | NO |
ConversionOptionPeriodReplyDaysCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodReplyDaysCount Bound Attachments |
Name | Current Value |
ConversionOptionPeriodReplyDaysCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodReplyDaysCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodReplyDaysCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodReplyDaysCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodReplyDaysCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingPercent |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodRoundingPercent |
Logical Rolename | |
ColumnName | ConversionOptionPeriodRoundingPercent |
RoleName | |
Domain | MISMOPercent |
Definition | The percentage to which the interest rate is rounded when calculating a new interest rate for the option to convert an ARM loan to a fixed rate loan. This field is used in conjunction with Conversion Option Period Rounding Type which indicates how roundin |
Note |
ConversionOptionPeriodRoundingPercent Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodRoundingPercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ConversionOptionPeriodRoundingPercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodRoundingPercent Bound Attachments |
Name | Current Value |
ConversionOptionPeriodRoundingPercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodRoundingPercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingPercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingPercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingPercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingType |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodRoundingType |
Logical Rolename | |
ColumnName | ConversionOptionPeriodRoundingType |
RoleName | |
Domain | ConversionOptionPeriodRoundingEnum |
Definition | Indicates how the Conversion Option Margin Rate Percent is rounded when calculating a new interest rate for the option to convert an ARM loan to a fixed-rate loan. The interest rate can be rounded Up, Down or to the Nearest Rounding Factor. This field is used in conjunction with Conversion Option Period Rounding Percent which indicates the percentage to which the rounding occurs. |
Note |
ConversionOptionPeriodRoundingType Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodRoundingType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConversionOptionPeriodRoundingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodRoundingType Reference Value (Bound to Domain) |
Name | ValidationRule79 |
Description | |
Type | By List |
Value | Value Description |
Down | Down |
Nearest | Nearest |
NoRounding | NoRounding |
Up | Up |
ConversionOptionPeriodRoundingType Bound Attachments |
Name | Current Value |
ConversionOptionPeriodRoundingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodRoundingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodRoundingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodType |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionOptionPeriodType |
Logical Rolename | |
ColumnName | ConversionOptionPeriodType |
RoleName | |
Domain | ConversionOptionPeriodEnum |
Definition | Indicates the type of conversion option associated with the loan. |
Note |
ConversionOptionPeriodType Logical Attribute Properties |
Logical Attribute Name | ConversionOptionPeriodType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConversionOptionPeriodType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionOptionPeriodType Reference Value (Bound to Domain) |
Name | ValidationRule77 |
Description | |
Type | By List |
Value | Value Description |
OnDemand | The borrower must request the conversion. |
OnDemandAtInterestRateChangeDates | OnDemandAtInterestRateChangeDates |
OnDemandMonthly | OnDemandMonthly |
Scheduled | The conversion option is available to the borrower on a regularly scheduled basis. |
ConversionOptionPeriodType Bound Attachments |
Name | Current Value |
ConversionOptionPeriodType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionOptionPeriodType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionOptionPeriodType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionRateCalculationMethodDescription |
Base Entity | CONVERSION_OPTION_PERIOD_ADJUSTMENT_RULE |
Attribute Name | ConversionRateCalculationMethodDescription |
Logical Rolename | |
ColumnName | ConversionRateCalculationMethodDescription |
RoleName | |
Domain | MISMOString |
Definition | Describes how interest rate changes are to be calculated when calculating a new interest rate for the option to convert an ARM loan to a fixed rate loan. |
Note |
ConversionRateCalculationMethodDescription Logical Attribute Properties |
Logical Attribute Name | ConversionRateCalculationMethodDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ConversionRateCalculationMethodDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConversionRateCalculationMethodDescription Bound Attachments |
Name | Current Value |
ConversionRateCalculationMethodDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConversionRateCalculationMethodDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionRateCalculationMethodDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionRateCalculationMethodDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConversionRateCalculationMethodDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |