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