AcceleratedPaymentProgramIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  AcceleratedPaymentProgramIndicator 
Logical Rolename   
ColumnName  AcceleratedPaymentProgramIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that mortgagor participates in some sort of accelerated principal re-payment program which may be administered by a third party. 
Note 
 

AcceleratedPaymentProgramIndicator Logical Attribute Properties 
Logical Attribute Name  AcceleratedPaymentProgramIndicator 
Datatype  BIT 
Nullable  NO 

AcceleratedPaymentProgramIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AcceleratedPaymentProgramIndicator Bound Attachments 
Name  Current Value 

AcceleratedPaymentProgramIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AcceleratedPaymentProgramIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AcceleratedPaymentProgramIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AcceleratedPaymentProgramIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AcceleratedPaymentProgramIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ApplicationReceivedDate 
Base Entity  LOAN_DETAIL 
Attribute Name  ApplicationReceivedDate 
Logical Rolename   
ColumnName  ApplicationReceivedDate 
RoleName   
Domain  MISMODate 
Definition  The date the creditor or originator received the application from the borrower for the subject mortgage loan that would trigger the truth in lending disclosure. 
Note 
 

ApplicationReceivedDate Logical Attribute Properties 
Logical Attribute Name  ApplicationReceivedDate 
Datatype  DATE 
Nullable  NO 

ApplicationReceivedDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ApplicationReceivedDate Bound Attachments 
Name  Current Value 

ApplicationReceivedDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ApplicationReceivedDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ApplicationReceivedDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ApplicationReceivedDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ApplicationReceivedDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ArmsLengthIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ArmsLengthIndicator 
Logical Rolename   
ColumnName  ArmsLengthIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that this is an Arms Length Transaction. An Arms length transaction is between a willing buyer and a willing seller with no undue influence on either party and there is no relationship between the parties except that of the specific transaction. 
Note 
 

ArmsLengthIndicator Logical Attribute Properties 
Logical Attribute Name  ArmsLengthIndicator 
Datatype  BIT 
Nullable  NO 

ArmsLengthIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ArmsLengthIndicator Bound Attachments 
Name  Current Value 

ArmsLengthIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ArmsLengthIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ArmsLengthIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ArmsLengthIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ArmsLengthIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AssumabilityIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  AssumabilityIndicator 
Logical Rolename   
ColumnName  AssumabilityIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the loan is assumable by another borrower. 
Note 
 

AssumabilityIndicator Logical Attribute Properties 
Logical Attribute Name  AssumabilityIndicator 
Datatype  BIT 
Nullable  NO 

AssumabilityIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AssumabilityIndicator Bound Attachments 
Name  Current Value 

AssumabilityIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AssumabilityIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AssumabilityIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AssumabilityIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AssumabilityIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AssumedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  AssumedIndicator 
Logical Rolename   
ColumnName  AssumedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates if the loan has been assumed 
Note 
 

AssumedIndicator Logical Attribute Properties 
Logical Attribute Name  AssumedIndicator 
Datatype  BIT 
Nullable  NO 

AssumedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AssumedIndicator Bound Attachments 
Name  Current Value 

AssumedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AssumedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AssumedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AssumedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AssumedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BalloonGuaranteedRefinancingIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  BalloonGuaranteedRefinancingIndicator 
Logical Rolename   
ColumnName  BalloonGuaranteedRefinancingIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates refinancing of the balloon mortgage loan is guaranteed by the lender. 
Note 
 

BalloonGuaranteedRefinancingIndicator Logical Attribute Properties 
Logical Attribute Name  BalloonGuaranteedRefinancingIndicator 
Datatype  BIT 
Nullable  NO 

BalloonGuaranteedRefinancingIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BalloonGuaranteedRefinancingIndicator Bound Attachments 
Name  Current Value 

BalloonGuaranteedRefinancingIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BalloonGuaranteedRefinancingIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonGuaranteedRefinancingIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonGuaranteedRefinancingIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonGuaranteedRefinancingIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BalloonIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  BalloonIndicator 
Logical Rolename   
ColumnName  BalloonIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether or not a final balloon payment is required under the terms of the loan repayment schedule to fully pay off the loan. 
Note 
 

BalloonIndicator Logical Attribute Properties 
Logical Attribute Name  BalloonIndicator 
Datatype  BIT 
Nullable  NO 

BalloonIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BalloonIndicator Bound Attachments 
Name  Current Value 

BalloonIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BalloonIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BalloonPaymentAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  BalloonPaymentAmount 
Logical Rolename   
ColumnName  BalloonPaymentAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount of the final, or lump sum, balloon payment. 
Note 
 

BalloonPaymentAmount Logical Attribute Properties 
Logical Attribute Name  BalloonPaymentAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

BalloonPaymentAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BalloonPaymentAmount Bound Attachments 
Name  Current Value 

BalloonPaymentAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BalloonPaymentAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonPaymentAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonPaymentAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonPaymentAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BalloonResetIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  BalloonResetIndicator 
Logical Rolename   
ColumnName  BalloonResetIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that the balloon loan has been reset to the current market rate. 
Note 
 

BalloonResetIndicator Logical Attribute Properties 
Logical Attribute Name  BalloonResetIndicator 
Datatype  BIT 
Nullable  NO 

BalloonResetIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BalloonResetIndicator Bound Attachments 
Name  Current Value 

BalloonResetIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BalloonResetIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonResetIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonResetIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BalloonResetIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BelowMarketSubordinateFinancingIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  BelowMarketSubordinateFinancingIndicator 
Logical Rolename   
ColumnName  BelowMarketSubordinateFinancingIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the seller provided below-market subordinate financing. 
Note 
 

BelowMarketSubordinateFinancingIndicator Logical Attribute Properties 
Logical Attribute Name  BelowMarketSubordinateFinancingIndicator 
Datatype  BIT 
Nullable  NO 

BelowMarketSubordinateFinancingIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BelowMarketSubordinateFinancingIndicator Bound Attachments 
Name  Current Value 

BelowMarketSubordinateFinancingIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BelowMarketSubordinateFinancingIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BelowMarketSubordinateFinancingIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BelowMarketSubordinateFinancingIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BelowMarketSubordinateFinancingIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BiweeklyToMonthlyOnDefaultIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  BiweeklyToMonthlyOnDefaultIndicator 
Logical Rolename   
ColumnName  BiweeklyToMonthlyOnDefaultIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates if the lender allows conversion from Bi-weekly payments to monthly upon a default by the borrower. 
Note 
 

BiweeklyToMonthlyOnDefaultIndicator Logical Attribute Properties 
Logical Attribute Name  BiweeklyToMonthlyOnDefaultIndicator 
Datatype  BIT 
Nullable  NO 

BiweeklyToMonthlyOnDefaultIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BiweeklyToMonthlyOnDefaultIndicator Bound Attachments 
Name  Current Value 

BiweeklyToMonthlyOnDefaultIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BiweeklyToMonthlyOnDefaultIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BiweeklyToMonthlyOnDefaultIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BiweeklyToMonthlyOnDefaultIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BiweeklyToMonthlyOnDefaultIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BorrowerCount 
Base Entity  LOAN_DETAIL 
Attribute Name  BorrowerCount 
Logical Rolename   
ColumnName  BorrowerCount 
RoleName   
Domain  MISMOCount 
Definition  The number of borrowers obligated on the note. 
Note 
 

BorrowerCount Logical Attribute Properties 
Logical Attribute Name  BorrowerCount 
Datatype  INTEGER 
Nullable  NO 

BorrowerCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BorrowerCount Bound Attachments 
Name  Current Value 

BorrowerCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BorrowerCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BorrowerCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BuydownTemporarySubsidyFundingIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  BuydownTemporarySubsidyFundingIndicator 
Logical Rolename   
ColumnName  BuydownTemporarySubsidyFundingIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether there is buydown funding on this loan. A buydown is money paid by the borrower or third party for the purpose of reducing the interest rate and/or the monthly payments on a temporary basis. 
Note 
 

BuydownTemporarySubsidyFundingIndicator Logical Attribute Properties 
Logical Attribute Name  BuydownTemporarySubsidyFundingIndicator 
Datatype  BIT 
Nullable  NO 

BuydownTemporarySubsidyFundingIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BuydownTemporarySubsidyFundingIndicator Bound Attachments 
Name  Current Value 

BuydownTemporarySubsidyFundingIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

BuydownTemporarySubsidyFundingIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BuydownTemporarySubsidyFundingIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BuydownTemporarySubsidyFundingIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BuydownTemporarySubsidyFundingIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CapitalizedFeesIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  CapitalizedFeesIndicator 
Logical Rolename   
ColumnName  CapitalizedFeesIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the mortgage balance includes capitalized origination fees. 
Note 
 

CapitalizedFeesIndicator Logical Attribute Properties 
Logical Attribute Name  CapitalizedFeesIndicator 
Datatype  BIT 
Nullable  NO 

CapitalizedFeesIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CapitalizedFeesIndicator Bound Attachments 
Name  Current Value 

CapitalizedFeesIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CapitalizedFeesIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CapitalizedFeesIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CapitalizedFeesIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CapitalizedFeesIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CapitalizedLoanIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  CapitalizedLoanIndicator 
Logical Rolename   
ColumnName  CapitalizedLoanIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that interest accrued, escrow disbursements made and/or fees charged are included in the unpaid principal balance. 
Note 
 

CapitalizedLoanIndicator Logical Attribute Properties 
Logical Attribute Name  CapitalizedLoanIndicator 
Datatype  BIT 
Nullable  NO 

CapitalizedLoanIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CapitalizedLoanIndicator Bound Attachments 
Name  Current Value 

CapitalizedLoanIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CapitalizedLoanIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CapitalizedLoanIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CapitalizedLoanIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CapitalizedLoanIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ClosingCostFinancedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ClosingCostFinancedIndicator 
Logical Rolename   
ColumnName  ClosingCostFinancedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that some or all of the closing costs were financed into the Borrower Requested Loan Amount. 
Note 
 

ClosingCostFinancedIndicator Logical Attribute Properties 
Logical Attribute Name  ClosingCostFinancedIndicator 
Datatype  BIT 
Nullable  NO 

ClosingCostFinancedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ClosingCostFinancedIndicator Bound Attachments 
Name  Current Value 

ClosingCostFinancedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ClosingCostFinancedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ClosingCostFinancedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ClosingCostFinancedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ClosingCostFinancedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CollateralPledgedToName 
Base Entity  LOAN_DETAIL 
Attribute Name  CollateralPledgedToName 
Logical Rolename   
ColumnName  CollateralPledgedToName 
RoleName   
Domain  MISMOString 
Definition  Specifies to whom the loan has been pledged as collateral. 
Note 
 

CollateralPledgedToName Logical Attribute Properties 
Logical Attribute Name  CollateralPledgedToName 
Datatype  VARCHAR(0) 
Nullable  NO 

CollateralPledgedToName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CollateralPledgedToName Bound Attachments 
Name  Current Value 

CollateralPledgedToName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CollateralPledgedToName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CollateralPledgedToName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CollateralPledgedToName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CollateralPledgedToName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConcurrentOriginationIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ConcurrentOriginationIndicator 
Logical Rolename   
ColumnName  ConcurrentOriginationIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that a new first mortgage will be closed concurrently with a second or a HELOC loan. 
Note 
 

ConcurrentOriginationIndicator Logical Attribute Properties 
Logical Attribute Name  ConcurrentOriginationIndicator 
Datatype  BIT 
Nullable  NO 

ConcurrentOriginationIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ConcurrentOriginationIndicator Bound Attachments 
Name  Current Value 

ConcurrentOriginationIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ConcurrentOriginationIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConcurrentOriginationIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConcurrentOriginationIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConcurrentOriginationIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConcurrentOriginationLenderIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ConcurrentOriginationLenderIndicator 
Logical Rolename   
ColumnName  ConcurrentOriginationLenderIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that a concurrent loan is from the same lender. This is in conjunction with Concurrent Origination Indicator. 
Note 
 

ConcurrentOriginationLenderIndicator Logical Attribute Properties 
Logical Attribute Name  ConcurrentOriginationLenderIndicator 
Datatype  BIT 
Nullable  NO 

ConcurrentOriginationLenderIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ConcurrentOriginationLenderIndicator Bound Attachments 
Name  Current Value 

ConcurrentOriginationLenderIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ConcurrentOriginationLenderIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConcurrentOriginationLenderIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConcurrentOriginationLenderIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConcurrentOriginationLenderIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConformingIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ConformingIndicator 
Logical Rolename   
ColumnName  ConformingIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that the loan amount is a conforming loan amount by Fannie Mae and Freddie Mac standards. 
Note 
 

ConformingIndicator Logical Attribute Properties 
Logical Attribute Name  ConformingIndicator 
Datatype  BIT 
Nullable  NO 

ConformingIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ConformingIndicator Bound Attachments 
Name  Current Value 

ConformingIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ConformingIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConformingIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConformingIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConformingIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConstructionLoanIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ConstructionLoanIndicator 
Logical Rolename   
ColumnName  ConstructionLoanIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether or not this is a construction loan. 
Note 
 

ConstructionLoanIndicator Logical Attribute Properties 
Logical Attribute Name  ConstructionLoanIndicator 
Datatype  BIT 
Nullable  NO 

ConstructionLoanIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ConstructionLoanIndicator Bound Attachments 
Name  Current Value 

ConstructionLoanIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ConstructionLoanIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConstructionLoanIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConstructionLoanIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConstructionLoanIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConvertibleIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ConvertibleIndicator 
Logical Rolename   
ColumnName  ConvertibleIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the loan has a convertible characteristic. 
Note 
 

ConvertibleIndicator Logical Attribute Properties 
Logical Attribute Name  ConvertibleIndicator 
Datatype  BIT 
Nullable  NO 

ConvertibleIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ConvertibleIndicator Bound Attachments 
Name  Current Value 

ConvertibleIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ConvertibleIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConvertibleIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConvertibleIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConvertibleIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CurrentInterestRatePercent 
Base Entity  LOAN_DETAIL 
Attribute Name  CurrentInterestRatePercent 
Logical Rolename   
ColumnName  CurrentInterestRatePercent 
RoleName   
Domain  MISMOPercent 
Definition  The current interest rate, expressed as a percent, for this loan. 
Note 
 

CurrentInterestRatePercent Logical Attribute Properties 
Logical Attribute Name  CurrentInterestRatePercent 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

CurrentInterestRatePercent Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CurrentInterestRatePercent Bound Attachments 
Name  Current Value 

CurrentInterestRatePercent User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CurrentInterestRatePercent Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentInterestRatePercent Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentInterestRatePercent Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CurrentInterestRatePercent Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DeferredInterestBalanceAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  DeferredInterestBalanceAmount 
Logical Rolename   
ColumnName  DeferredInterestBalanceAmount 
RoleName   
Domain  MISMOAmount 
Definition  Accrued Uncollected Interest 
Note 
 

DeferredInterestBalanceAmount Logical Attribute Properties 
Logical Attribute Name  DeferredInterestBalanceAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

DeferredInterestBalanceAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DeferredInterestBalanceAmount Bound Attachments 
Name  Current Value 

DeferredInterestBalanceAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

DeferredInterestBalanceAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DeferredInterestBalanceAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DeferredInterestBalanceAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DeferredInterestBalanceAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DemandFeatureIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  DemandFeatureIndicator 
Logical Rolename   
ColumnName  DemandFeatureIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that the loan has a demand feature. 
Note 
 

DemandFeatureIndicator Logical Attribute Properties 
Logical Attribute Name  DemandFeatureIndicator 
Datatype  BIT 
Nullable  NO 

DemandFeatureIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DemandFeatureIndicator Bound Attachments 
Name  Current Value 

DemandFeatureIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

DemandFeatureIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DemandFeatureIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DemandFeatureIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DemandFeatureIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EligibleForLenderPaidMIIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  EligibleForLenderPaidMIIndicator 
Logical Rolename   
ColumnName  EligibleForLenderPaidMIIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the mortgage loan is eligible for lender-paid MI. 
Note 
 

EligibleForLenderPaidMIIndicator Logical Attribute Properties 
Logical Attribute Name  EligibleForLenderPaidMIIndicator 
Datatype  BIT 
Nullable  NO 

EligibleForLenderPaidMIIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EligibleForLenderPaidMIIndicator Bound Attachments 
Name  Current Value 

EligibleForLenderPaidMIIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EligibleForLenderPaidMIIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EligibleForLenderPaidMIIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EligibleForLenderPaidMIIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EligibleForLenderPaidMIIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EmployeeLoanProgramIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  EmployeeLoanProgramIndicator 
Logical Rolename   
ColumnName  EmployeeLoanProgramIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates if the loan is part of an employee loan program. 
Note 
 

EmployeeLoanProgramIndicator Logical Attribute Properties 
Logical Attribute Name  EmployeeLoanProgramIndicator 
Datatype  BIT 
Nullable  NO 

EmployeeLoanProgramIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EmployeeLoanProgramIndicator Bound Attachments 
Name  Current Value 

EmployeeLoanProgramIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EmployeeLoanProgramIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EmployeeLoanProgramIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EmployeeLoanProgramIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EmployeeLoanProgramIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ENoteCertifiedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ENoteCertifiedIndicator 
Logical Rolename   
ColumnName  ENoteCertifiedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the loan delivery data has been automatically certified against eNote data. 
Note 
 

ENoteCertifiedIndicator Logical Attribute Properties 
Logical Attribute Name  ENoteCertifiedIndicator 
Datatype  BIT 
Nullable  NO 

ENoteCertifiedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ENoteCertifiedIndicator Bound Attachments 
Name  Current Value 

ENoteCertifiedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ENoteCertifiedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ENoteCertifiedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ENoteCertifiedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ENoteCertifiedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ENoteIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ENoteIndicator 
Logical Rolename   
ColumnName  ENoteIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that an eNote is used as part of this loan. 
Note 
 

ENoteIndicator Logical Attribute Properties 
Logical Attribute Name  ENoteIndicator 
Datatype  BIT 
Nullable  NO 

ENoteIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ENoteIndicator Bound Attachments 
Name  Current Value 

ENoteIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ENoteIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ENoteIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ENoteIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ENoteIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EscrowAccountLenderRequirementType 
Base Entity  LOAN_DETAIL 
Attribute Name  EscrowAccountLenderRequirementType 
Logical Rolename   
ColumnName  EscrowAccountLenderRequirementType 
RoleName   
Domain  EscrowAccountLenderRequirementEnum 
Definition  Identifies the escrow account status in terms of the requirements of the lender in the mortgage loan transaction.  
Note 
 

EscrowAccountLenderRequirementType Logical Attribute Properties 
Logical Attribute Name  EscrowAccountLenderRequirementType 
Datatype  VARCHAR(0) 
Nullable  YES 

EscrowAccountLenderRequirementType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EscrowAccountLenderRequirementType Reference Value (Bound to Domain) 
Name  ValidationRule146 
Description   
Type  By List 
Value  Value Description 
EscrowsRequiredByLender  Indicates an escrow account is required by the lender. 
EscrowsWaivedByLender  Indicates the escrow account requirement has been waived by the lender. 

EscrowAccountLenderRequirementType Bound Attachments 
Name  Current Value 

EscrowAccountLenderRequirementType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EscrowAccountLenderRequirementType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowAccountLenderRequirementType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowAccountLenderRequirementType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowAccountLenderRequirementType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EscrowAccountRequestedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  EscrowAccountRequestedIndicator 
Logical Rolename   
ColumnName  EscrowAccountRequestedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that the establishment of an escrow account has been requested by the borrower(s) for the loan. 
Note 
 

EscrowAccountRequestedIndicator Logical Attribute Properties 
Logical Attribute Name  EscrowAccountRequestedIndicator 
Datatype  BIT 
Nullable  NO 

EscrowAccountRequestedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EscrowAccountRequestedIndicator Bound Attachments 
Name  Current Value 

EscrowAccountRequestedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EscrowAccountRequestedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowAccountRequestedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowAccountRequestedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowAccountRequestedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EscrowIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  EscrowIndicator 
Logical Rolename   
ColumnName  EscrowIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether or not escrows are associated with this loan. 
Note 
 

EscrowIndicator Logical Attribute Properties 
Logical Attribute Name  EscrowIndicator 
Datatype  BIT 
Nullable  NO 

EscrowIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EscrowIndicator Bound Attachments 
Name  Current Value 

EscrowIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EscrowIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EscrowNotAllowedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  EscrowNotAllowedIndicator 
Logical Rolename   
ColumnName  EscrowNotAllowedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that, under applicable law, a servicer may not establish an escrow account for the mortgage loan being modified. 
Note 
 

EscrowNotAllowedIndicator Logical Attribute Properties 
Logical Attribute Name  EscrowNotAllowedIndicator 
Datatype  BIT 
Nullable  NO 

EscrowNotAllowedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EscrowNotAllowedIndicator Bound Attachments 
Name  Current Value 

EscrowNotAllowedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EscrowNotAllowedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowNotAllowedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowNotAllowedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowNotAllowedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EscrowsElectedByBorrowerIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  EscrowsElectedByBorrowerIndicator 
Logical Rolename   
ColumnName  EscrowsElectedByBorrowerIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates the borrower has elected to establish an escrow account. 
Note 
 

EscrowsElectedByBorrowerIndicator Logical Attribute Properties 
Logical Attribute Name  EscrowsElectedByBorrowerIndicator 
Datatype  BIT 
Nullable  NO 

EscrowsElectedByBorrowerIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EscrowsElectedByBorrowerIndicator Bound Attachments 
Name  Current Value 

EscrowsElectedByBorrowerIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

EscrowsElectedByBorrowerIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowsElectedByBorrowerIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowsElectedByBorrowerIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EscrowsElectedByBorrowerIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HELOCIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  HELOCIndicator 
Logical Rolename   
ColumnName  HELOCIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether or not a loan is a Home Equity Line of Credit (HELOC). 
Note 
 

HELOCIndicator Logical Attribute Properties 
Logical Attribute Name  HELOCIndicator 
Datatype  BIT 
Nullable  NO 

HELOCIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HELOCIndicator Bound Attachments 
Name  Current Value 

HELOCIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HELOCIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HELOCIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HELOCIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HELOCIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HomeBuyersHomeownershipEducationCertificateIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  HomeBuyersHomeownershipEducationCertificateIndicator 
Logical Rolename   
ColumnName  HomeBuyersHomeownershipEducationCertificateIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the Home Buyers/Home Ownership Education certificate is included in the loan file. 
Note 
 

HomeBuyersHomeownershipEducationCertificateIndicator Logical Attribute Properties 
Logical Attribute Name  HomeBuyersHomeownershipEducationCertificateIndicator 
Datatype  BIT 
Nullable  NO 

HomeBuyersHomeownershipEducationCertificateIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HomeBuyersHomeownershipEducationCertificateIndicator Bound Attachments 
Name  Current Value 

HomeBuyersHomeownershipEducationCertificateIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

HomeBuyersHomeownershipEducationCertificateIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HomeBuyersHomeownershipEducationCertificateIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HomeBuyersHomeownershipEducationCertificateIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HomeBuyersHomeownershipEducationCertificateIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


InitialFixedPeriodEffectiveMonthsCount 
Base Entity  LOAN_DETAIL 
Attribute Name  InitialFixedPeriodEffectiveMonthsCount 
Logical Rolename   
ColumnName  InitialFixedPeriodEffectiveMonthsCount 
RoleName   
Domain  MISMOCount 
Definition  The number of months that the initial fixed period of a hybrid ARM is in effect 
Note 
 

InitialFixedPeriodEffectiveMonthsCount Logical Attribute Properties 
Logical Attribute Name  InitialFixedPeriodEffectiveMonthsCount 
Datatype  INTEGER 
Nullable  NO 

InitialFixedPeriodEffectiveMonthsCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

InitialFixedPeriodEffectiveMonthsCount Bound Attachments 
Name  Current Value 

InitialFixedPeriodEffectiveMonthsCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

InitialFixedPeriodEffectiveMonthsCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

InitialFixedPeriodEffectiveMonthsCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

InitialFixedPeriodEffectiveMonthsCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

InitialFixedPeriodEffectiveMonthsCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


InterestCreditedToBorrowerIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  InterestCreditedToBorrowerIndicator 
Logical Rolename   
ColumnName  InterestCreditedToBorrowerIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Identifies whether interest was credited to the borrower at time of closing for a closed-end mortgage. 
Note 
 

InterestCreditedToBorrowerIndicator Logical Attribute Properties 
Logical Attribute Name  InterestCreditedToBorrowerIndicator 
Datatype  BIT 
Nullable  NO 

InterestCreditedToBorrowerIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

InterestCreditedToBorrowerIndicator Bound Attachments 
Name  Current Value 

InterestCreditedToBorrowerIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

InterestCreditedToBorrowerIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

InterestCreditedToBorrowerIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

InterestCreditedToBorrowerIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

InterestCreditedToBorrowerIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


InterestOnlyIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  InterestOnlyIndicator 
Logical Rolename   
ColumnName  InterestOnlyIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether loan is set up with interest only payments. 
Note 
 

InterestOnlyIndicator Logical Attribute Properties 
Logical Attribute Name  InterestOnlyIndicator 
Datatype  BIT 
Nullable  NO 

InterestOnlyIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

InterestOnlyIndicator Bound Attachments 
Name  Current Value 

InterestOnlyIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

InterestOnlyIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

InterestOnlyIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

InterestOnlyIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

InterestOnlyIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LenderSelfInsuredIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  LenderSelfInsuredIndicator 
Logical Rolename   
ColumnName  LenderSelfInsuredIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the Lender will provide self-insurance. 
Note 
 

LenderSelfInsuredIndicator Logical Attribute Properties 
Logical Attribute Name  LenderSelfInsuredIndicator 
Datatype  BIT 
Nullable  NO 

LenderSelfInsuredIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LenderSelfInsuredIndicator Bound Attachments 
Name  Current Value 

LenderSelfInsuredIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LenderSelfInsuredIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LenderSelfInsuredIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LenderSelfInsuredIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LenderSelfInsuredIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LienHolderSameAsSubjectLoanIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  LienHolderSameAsSubjectLoanIndicator 
Logical Rolename   
ColumnName  LienHolderSameAsSubjectLoanIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the lien holder of the related loan is the same as the lien holder of the subject loan. 
Note 
 

LienHolderSameAsSubjectLoanIndicator Logical Attribute Properties 
Logical Attribute Name  LienHolderSameAsSubjectLoanIndicator 
Datatype  BIT 
Nullable  NO 

LienHolderSameAsSubjectLoanIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LienHolderSameAsSubjectLoanIndicator Bound Attachments 
Name  Current Value 

LienHolderSameAsSubjectLoanIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LienHolderSameAsSubjectLoanIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LienHolderSameAsSubjectLoanIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LienHolderSameAsSubjectLoanIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LienHolderSameAsSubjectLoanIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanAffordableIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanAffordableIndicator 
Logical Rolename   
ColumnName  LoanAffordableIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that the loan is classified as an affordable loan by the lender or the investor. 
Note 
 

LoanAffordableIndicator Logical Attribute Properties 
Logical Attribute Name  LoanAffordableIndicator 
Datatype  BIT 
Nullable  NO 

LoanAffordableIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanAffordableIndicator Bound Attachments 
Name  Current Value 

LoanAffordableIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanAffordableIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanAffordableIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanAffordableIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanAffordableIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanApprovalDate 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanApprovalDate 
Logical Rolename   
ColumnName  LoanApprovalDate 
RoleName   
Domain  MISMODate 
Definition  The date the mortgage loan approval was made by the lender to the borrower. A loan approval involves verifying credit, down payment, employment history, etc. of the borrower(s) and will generally state that the borrower is approved for a loan upon satisf 
Note 
 

LoanApprovalDate Logical Attribute Properties 
Logical Attribute Name  LoanApprovalDate 
Datatype  DATE 
Nullable  NO 

LoanApprovalDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanApprovalDate Bound Attachments 
Name  Current Value 

LoanApprovalDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanApprovalDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanApprovalExpirationDate 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanApprovalExpirationDate 
Logical Rolename   
ColumnName  LoanApprovalExpirationDate 
RoleName   
Domain  MISMODate 
Definition  The date the mortgage loan approval expires. 
Note 
 

LoanApprovalExpirationDate Logical Attribute Properties 
Logical Attribute Name  LoanApprovalExpirationDate 
Datatype  DATE 
Nullable  NO 

LoanApprovalExpirationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanApprovalExpirationDate Bound Attachments 
Name  Current Value 

LoanApprovalExpirationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanApprovalExpirationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalExpirationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalExpirationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalExpirationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanApprovalPeriodDaysCount 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanApprovalPeriodDaysCount 
Logical Rolename   
ColumnName  LoanApprovalPeriodDaysCount 
RoleName   
Domain  MISMOCount 
Definition  The number of days the mortgage loan approval is in effect. 
Note 
 

LoanApprovalPeriodDaysCount Logical Attribute Properties 
Logical Attribute Name  LoanApprovalPeriodDaysCount 
Datatype  INTEGER 
Nullable  NO 

LoanApprovalPeriodDaysCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanApprovalPeriodDaysCount Bound Attachments 
Name  Current Value 

LoanApprovalPeriodDaysCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanApprovalPeriodDaysCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalPeriodDaysCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalPeriodDaysCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanApprovalPeriodDaysCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanClosingStatusType 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanClosingStatusType 
Logical Rolename   
ColumnName  LoanClosingStatusType 
RoleName   
Domain  LoanClosingStatusEnum 
Definition  Defines whether the loan is a closed loan purchase or a table funded loan.  
Note 
 

LoanClosingStatusType Logical Attribute Properties 
Logical Attribute Name  LoanClosingStatusType 
Datatype  VARCHAR(0) 
Nullable  YES 

LoanClosingStatusType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanClosingStatusType Reference Value (Bound to Domain) 
Name  ValidationRule253 
Description   
Type  By List 
Value  Value Description 
Closed  The loan has already been closed and is now being purchased by an investor. 
TableFunded  The loan is being funded with money advanced by the lender at the closing table. 

LoanClosingStatusType Bound Attachments 
Name  Current Value 

LoanClosingStatusType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanClosingStatusType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanClosingStatusType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanClosingStatusType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanClosingStatusType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanCommitmentDate 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanCommitmentDate 
Logical Rolename   
ColumnName  LoanCommitmentDate 
RoleName   
Domain  MISMODate 
Definition  The date the mortgage loan commitment to the borrower was made. The loan commitment is a formal, binding offer from a lender that a specified amount of loan or line of credit will be made available to the named borrower at a certain interest rate, during 
Note 
 

LoanCommitmentDate Logical Attribute Properties 
Logical Attribute Name  LoanCommitmentDate 
Datatype  DATE 
Nullable  NO 

LoanCommitmentDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanCommitmentDate Bound Attachments 
Name  Current Value 

LoanCommitmentDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanCommitmentDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanCommitmentExpirationDate 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanCommitmentExpirationDate 
Logical Rolename   
ColumnName  LoanCommitmentExpirationDate 
RoleName   
Domain  MISMODate 
Definition  The date the mortgage loan commitment expires. 
Note 
 

LoanCommitmentExpirationDate Logical Attribute Properties 
Logical Attribute Name  LoanCommitmentExpirationDate 
Datatype  DATE 
Nullable  NO 

LoanCommitmentExpirationDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanCommitmentExpirationDate Bound Attachments 
Name  Current Value 

LoanCommitmentExpirationDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanCommitmentExpirationDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentExpirationDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentExpirationDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentExpirationDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanCommitmentPeriodDaysCount 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanCommitmentPeriodDaysCount 
Logical Rolename   
ColumnName  LoanCommitmentPeriodDaysCount 
RoleName   
Domain  MISMOCount 
Definition  The number of days the mortgage loan commitment is in effect. 
Note 
 

LoanCommitmentPeriodDaysCount Logical Attribute Properties 
Logical Attribute Name  LoanCommitmentPeriodDaysCount 
Datatype  INTEGER 
Nullable  NO 

LoanCommitmentPeriodDaysCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanCommitmentPeriodDaysCount Bound Attachments 
Name  Current Value 

LoanCommitmentPeriodDaysCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanCommitmentPeriodDaysCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentPeriodDaysCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentPeriodDaysCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanCommitmentPeriodDaysCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanFundingDate 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanFundingDate 
Logical Rolename   
ColumnName  LoanFundingDate 
RoleName   
Domain  MISMODate 
Definition  The date the original lender funds were released to the borrower. 
Note 
 

LoanFundingDate Logical Attribute Properties 
Logical Attribute Name  LoanFundingDate 
Datatype  DATE 
Nullable  NO 

LoanFundingDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanFundingDate Bound Attachments 
Name  Current Value 

LoanFundingDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanFundingDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanFundingDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanFundingDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanFundingDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanRepaymentType 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanRepaymentType 
Logical Rolename   
ColumnName  LoanRepaymentType 
RoleName   
Domain  LoanRepaymentEnum 
Definition  Specifies whether the loan payment schedule has been calculated to fully repay the loan over the mortgage term.  
Note 
 

LoanRepaymentType Logical Attribute Properties 
Logical Attribute Name  LoanRepaymentType 
Datatype  VARCHAR(0) 
Nullable  YES 

LoanRepaymentType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanRepaymentType Reference Value (Bound to Domain) 
Name  ValidationRule271 
Description   
Type  By List 
Value  Value Description 
ConstantPrincipal  ConstantPrincipal 
Other  Other 
PrincipalPaymentOption  PrincipalPaymentOption 
ScheduledAmortization  ScheduledAmortization 

LoanRepaymentType Bound Attachments 
Name  Current Value 

LoanRepaymentType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanRepaymentType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRepaymentType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRepaymentType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRepaymentType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanRepaymentTypeOtherDescription 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanRepaymentTypeOtherDescription 
Logical Rolename   
ColumnName  LoanRepaymentTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Loan Repayment Type. 
Note 
 

LoanRepaymentTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  LoanRepaymentTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

LoanRepaymentTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanRepaymentTypeOtherDescription Bound Attachments 
Name  Current Value 

LoanRepaymentTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanRepaymentTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRepaymentTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRepaymentTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanRepaymentTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanSaleFundingDate 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanSaleFundingDate 
Logical Rolename   
ColumnName  LoanSaleFundingDate 
RoleName   
Domain  MISMODate 
Definition  The date the investor releases funds to the seller of the loan. 
Note 
 

LoanSaleFundingDate Logical Attribute Properties 
Logical Attribute Name  LoanSaleFundingDate 
Datatype  DATE 
Nullable  NO 

LoanSaleFundingDate Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanSaleFundingDate Bound Attachments 
Name  Current Value 

LoanSaleFundingDate User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanSaleFundingDate Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanSaleFundingDate Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanSaleFundingDate Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanSaleFundingDate Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LoanSellerProvidedInvestmentRatingDescription 
Base Entity  LOAN_DETAIL 
Attribute Name  LoanSellerProvidedInvestmentRatingDescription 
Logical Rolename   
ColumnName  LoanSellerProvidedInvestmentRatingDescription 
RoleName   
Domain  MISMOString 
Definition  The widely-recognized alpha code (e.g., AA, A, B, etc.) provided by the seller which specifies the credit risk class of a financial asset (e.g. a loan or mortgage backed security). 
Note 
 

LoanSellerProvidedInvestmentRatingDescription Logical Attribute Properties 
Logical Attribute Name  LoanSellerProvidedInvestmentRatingDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

LoanSellerProvidedInvestmentRatingDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LoanSellerProvidedInvestmentRatingDescription Bound Attachments 
Name  Current Value 

LoanSellerProvidedInvestmentRatingDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LoanSellerProvidedInvestmentRatingDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanSellerProvidedInvestmentRatingDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LoanSellerProvidedInvestmentRatingDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LoanSellerProvidedInvestmentRatingDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LostNoteAffidavitIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  LostNoteAffidavitIndicator 
Logical Rolename   
ColumnName  LostNoteAffidavitIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether or not a lost note affidavit (LNA) is associated with the loan. 
Note 
 

LostNoteAffidavitIndicator Logical Attribute Properties 
Logical Attribute Name  LostNoteAffidavitIndicator 
Datatype  BIT 
Nullable  NO 

LostNoteAffidavitIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

LostNoteAffidavitIndicator Bound Attachments 
Name  Current Value 

LostNoteAffidavitIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

LostNoteAffidavitIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LostNoteAffidavitIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LostNoteAffidavitIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LostNoteAffidavitIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MIRequiredIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  MIRequiredIndicator 
Logical Rolename   
ColumnName  MIRequiredIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that Mortgage Insurance is or was required as a condition for originating the loan. 
Note 
 

MIRequiredIndicator Logical Attribute Properties 
Logical Attribute Name  MIRequiredIndicator 
Datatype  BIT 
Nullable  NO 

MIRequiredIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIRequiredIndicator Bound Attachments 
Name  Current Value 

MIRequiredIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MIRequiredIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIRequiredIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIRequiredIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIRequiredIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MortgageModificationIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  MortgageModificationIndicator 
Logical Rolename   
ColumnName  MortgageModificationIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that a loan modification exists. 
Note 
 

MortgageModificationIndicator Logical Attribute Properties 
Logical Attribute Name  MortgageModificationIndicator 
Datatype  BIT 
Nullable  NO 

MortgageModificationIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MortgageModificationIndicator Bound Attachments 
Name  Current Value 

MortgageModificationIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MortgageModificationIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MortgageModificationIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MortgageModificationIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MortgageModificationIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NegativeAmortizationIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  NegativeAmortizationIndicator 
Logical Rolename   
ColumnName  NegativeAmortizationIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the loan allows negative amortization. 
Note 
 

NegativeAmortizationIndicator Logical Attribute Properties 
Logical Attribute Name  NegativeAmortizationIndicator 
Datatype  BIT 
Nullable  NO 

NegativeAmortizationIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NegativeAmortizationIndicator Bound Attachments 
Name  Current Value 

NegativeAmortizationIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

NegativeAmortizationIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NegativeAmortizationIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NegativeAmortizationIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NegativeAmortizationIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


OriginalLoanStandardEscrowProvisionsIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  OriginalLoanStandardEscrowProvisionsIndicator 
Logical Rolename   
ColumnName  OriginalLoanStandardEscrowProvisionsIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true indicates the original loan documents included standard Fannie Mae/Freddie Mac Uniform Instrument provisions for escrow items. 
Note 
 

OriginalLoanStandardEscrowProvisionsIndicator Logical Attribute Properties 
Logical Attribute Name  OriginalLoanStandardEscrowProvisionsIndicator 
Datatype  BIT 
Nullable  NO 

OriginalLoanStandardEscrowProvisionsIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

OriginalLoanStandardEscrowProvisionsIndicator Bound Attachments 
Name  Current Value 

OriginalLoanStandardEscrowProvisionsIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

OriginalLoanStandardEscrowProvisionsIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OriginalLoanStandardEscrowProvisionsIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OriginalLoanStandardEscrowProvisionsIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OriginalLoanStandardEscrowProvisionsIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


OverdueInterestAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  OverdueInterestAmount 
Logical Rolename   
ColumnName  OverdueInterestAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of interest accrued but not yet paid for Daily Simple Interest loans. This interest is considered overdue interest and is paid first when a payment is applied. 
Note 
 

OverdueInterestAmount Logical Attribute Properties 
Logical Attribute Name  OverdueInterestAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

OverdueInterestAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

OverdueInterestAmount Bound Attachments 
Name  Current Value 

OverdueInterestAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

OverdueInterestAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

OverdueInterestAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

OverdueInterestAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

OverdueInterestAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PiggybackLoanIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  PiggybackLoanIndicator 
Logical Rolename   
ColumnName  PiggybackLoanIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates a second lien being carried under the same loan number as a first mortgage. Generally one mortgage is covered by two notes and the borrower makes one combined payment. 
Note 
 

PiggybackLoanIndicator Logical Attribute Properties 
Logical Attribute Name  PiggybackLoanIndicator 
Datatype  BIT 
Nullable  NO 

PiggybackLoanIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PiggybackLoanIndicator Bound Attachments 
Name  Current Value 

PiggybackLoanIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PiggybackLoanIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PiggybackLoanIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PiggybackLoanIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PiggybackLoanIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PrepaymentPenaltyIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  PrepaymentPenaltyIndicator 
Logical Rolename   
ColumnName  PrepaymentPenaltyIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the loan includes a penalty charged to the borrower in the event of prepayment. 
Note 
 

PrepaymentPenaltyIndicator Logical Attribute Properties 
Logical Attribute Name  PrepaymentPenaltyIndicator 
Datatype  BIT 
Nullable  NO 

PrepaymentPenaltyIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PrepaymentPenaltyIndicator Bound Attachments 
Name  Current Value 

PrepaymentPenaltyIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PrepaymentPenaltyIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentPenaltyIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentPenaltyIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentPenaltyIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PrepaymentPenaltyWaivedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  PrepaymentPenaltyWaivedIndicator 
Logical Rolename   
ColumnName  PrepaymentPenaltyWaivedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the prepayment penalty has been waived. 
Note 
 

PrepaymentPenaltyWaivedIndicator Logical Attribute Properties 
Logical Attribute Name  PrepaymentPenaltyWaivedIndicator 
Datatype  BIT 
Nullable  NO 

PrepaymentPenaltyWaivedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PrepaymentPenaltyWaivedIndicator Bound Attachments 
Name  Current Value 

PrepaymentPenaltyWaivedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PrepaymentPenaltyWaivedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentPenaltyWaivedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentPenaltyWaivedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentPenaltyWaivedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PrepaymentRestrictionIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  PrepaymentRestrictionIndicator 
Logical Rolename   
ColumnName  PrepaymentRestrictionIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether the loan has any restrictions on the prepayment of the loan (i.e. paying off the principal and or interest at a rate faster than prescribed by the payment schedule). 
Note 
 

PrepaymentRestrictionIndicator Logical Attribute Properties 
Logical Attribute Name  PrepaymentRestrictionIndicator 
Datatype  BIT 
Nullable  NO 

PrepaymentRestrictionIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PrepaymentRestrictionIndicator Bound Attachments 
Name  Current Value 

PrepaymentRestrictionIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PrepaymentRestrictionIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentRestrictionIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentRestrictionIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PrepaymentRestrictionIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PropertiesFinancedByLenderCount 
Base Entity  LOAN_DETAIL 
Attribute Name  PropertiesFinancedByLenderCount 
Logical Rolename   
ColumnName  PropertiesFinancedByLenderCount 
RoleName   
Domain  MISMOCount 
Definition  Case or loan level count of properties already financed by this lender for the borrower(s) named on the loan application. Does not include subject property 
Note 
 

PropertiesFinancedByLenderCount Logical Attribute Properties 
Logical Attribute Name  PropertiesFinancedByLenderCount 
Datatype  INTEGER 
Nullable  NO 

PropertiesFinancedByLenderCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PropertiesFinancedByLenderCount Bound Attachments 
Name  Current Value 

PropertiesFinancedByLenderCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PropertiesFinancedByLenderCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PropertiesFinancedByLenderCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PropertiesFinancedByLenderCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PropertiesFinancedByLenderCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PropertyInspectionWaiverIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  PropertyInspectionWaiverIndicator 
Logical Rolename   
ColumnName  PropertyInspectionWaiverIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates whether a documented inspection of the property has been waived. 
Note 
 

PropertyInspectionWaiverIndicator Logical Attribute Properties 
Logical Attribute Name  PropertyInspectionWaiverIndicator 
Datatype  BIT 
Nullable  NO 

PropertyInspectionWaiverIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PropertyInspectionWaiverIndicator Bound Attachments 
Name  Current Value 

PropertyInspectionWaiverIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PropertyInspectionWaiverIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyInspectionWaiverIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyInspectionWaiverIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PropertyInspectionWaiverIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RecoverableCorporateAdvanceBalanceFromBorrowerAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  RecoverableCorporateAdvanceBalanceFromBorrowerAmount 
Logical Rolename   
ColumnName  RecoverableCorporateAdvanceBalanceFromBorrowerAmount 
RoleName   
Domain  MISMOAmount 
Definition  Monies advanced on the loan (i.e. delinquency expense, tax penalty, repairs, etc.). 
Note 
 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Logical Attribute Properties 
Logical Attribute Name  RecoverableCorporateAdvanceBalanceFromBorrowerAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Bound Attachments 
Name  Current Value 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RecoverableCorporateAdvanceBalanceFromBorrowerAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RecoverableCorporateAdvanceBalanceFromThirdPartyAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  RecoverableCorporateAdvanceBalanceFromThirdPartyAmount 
Logical Rolename   
ColumnName  RecoverableCorporateAdvanceBalanceFromThirdPartyAmount 
RoleName   
Domain  MISMOAmount 
Definition  Monies advanced on the loan (i.e. delinquency expense, tax penalty, repairs, etc.). 
Note 
 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Logical Attribute Properties 
Logical Attribute Name  RecoverableCorporateAdvanceBalanceFromThirdPartyAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Bound Attachments 
Name  Current Value 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RefundOfOverpaidInterestCalendarYearAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  RefundOfOverpaidInterestCalendarYearAmount 
Logical Rolename   
ColumnName  RefundOfOverpaidInterestCalendarYearAmount 
RoleName   
Domain  MISMOAmount 
Definition  The amount of overpaid interest refunded to the borrower for the calendar year. 
Note 
 

RefundOfOverpaidInterestCalendarYearAmount Logical Attribute Properties 
Logical Attribute Name  RefundOfOverpaidInterestCalendarYearAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

RefundOfOverpaidInterestCalendarYearAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RefundOfOverpaidInterestCalendarYearAmount Bound Attachments 
Name  Current Value 

RefundOfOverpaidInterestCalendarYearAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RefundOfOverpaidInterestCalendarYearAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefundOfOverpaidInterestCalendarYearAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RefundOfOverpaidInterestCalendarYearAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RefundOfOverpaidInterestCalendarYearAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RelocationLoanIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  RelocationLoanIndicator 
Logical Rolename   
ColumnName  RelocationLoanIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates if the loan is part of a corporate relocation program. 
Note 
 

RelocationLoanIndicator Logical Attribute Properties 
Logical Attribute Name  RelocationLoanIndicator 
Datatype  BIT 
Nullable  NO 

RelocationLoanIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RelocationLoanIndicator Bound Attachments 
Name  Current Value 

RelocationLoanIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RelocationLoanIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RelocationLoanIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RelocationLoanIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RelocationLoanIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RemainingUnearnedInterestAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  RemainingUnearnedInterestAmount 
Logical Rolename   
ColumnName  RemainingUnearnedInterestAmount 
RoleName   
Domain  MISMOAmount 
Definition  The remaining amount of interest scheduled to be paid on a rule of 78s loan. 
Note 
 

RemainingUnearnedInterestAmount Logical Attribute Properties 
Logical Attribute Name  RemainingUnearnedInterestAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

RemainingUnearnedInterestAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RemainingUnearnedInterestAmount Bound Attachments 
Name  Current Value 

RemainingUnearnedInterestAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RemainingUnearnedInterestAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RemainingUnearnedInterestAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RemainingUnearnedInterestAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RemainingUnearnedInterestAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ServicingTransferProhibitedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  ServicingTransferProhibitedIndicator 
Logical Rolename   
ColumnName  ServicingTransferProhibitedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  When true, indicates that the transfer of servicing is prohibited during life of the loan or for a designated period of time or until a certain event or condition is satisfied. 
Note 
 

ServicingTransferProhibitedIndicator Logical Attribute Properties 
Logical Attribute Name  ServicingTransferProhibitedIndicator 
Datatype  BIT 
Nullable  NO 

ServicingTransferProhibitedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ServicingTransferProhibitedIndicator Bound Attachments 
Name  Current Value 

ServicingTransferProhibitedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ServicingTransferProhibitedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ServicingTransferProhibitedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ServicingTransferProhibitedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ServicingTransferProhibitedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ServicingTransferStatusType 
Base Entity  LOAN_DETAIL 
Attribute Name  ServicingTransferStatusType 
Logical Rolename   
ColumnName  ServicingTransferStatusType 
RoleName   
Domain  ServicingTransferStatusEnum 
Definition  Defines whether the servicing on the loan will be retained or transferred to another party. Typically only on closed loans.  
Note 
 

ServicingTransferStatusType Logical Attribute Properties 
Logical Attribute Name  ServicingTransferStatusType 
Datatype  VARCHAR(0) 
Nullable  YES 

ServicingTransferStatusType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ServicingTransferStatusType Reference Value (Bound to Domain) 
Name  ValidationRule448 
Description   
Type  By List 
Value  Value Description 
Released  The servicing rights are being transferred to another party. 
Retained  The servicing rights are being retained by the seller. 

ServicingTransferStatusType Bound Attachments 
Name  Current Value 

ServicingTransferStatusType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

ServicingTransferStatusType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ServicingTransferStatusType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ServicingTransferStatusType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ServicingTransferStatusType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SharedAppreciationIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  SharedAppreciationIndicator 
Logical Rolename   
ColumnName  SharedAppreciationIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates the loan is one in which the lender, in exchange for a loan with a favorable interest rate, participates in the profits (if any) the borrow receives when the property is eventually sold. 
Note 
 

SharedAppreciationIndicator Logical Attribute Properties 
Logical Attribute Name  SharedAppreciationIndicator 
Datatype  BIT 
Nullable  NO 

SharedAppreciationIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SharedAppreciationIndicator Bound Attachments 
Name  Current Value 

SharedAppreciationIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SharedAppreciationIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SharedAppreciationIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SharedAppreciationIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SharedAppreciationIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SharedEquityIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  SharedEquityIndicator 
Logical Rolename   
ColumnName  SharedEquityIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates the mortgage is for resale-restricted, owner-occupied housing in which the rights, responsibilities, and benefits of residential property ownership are shared between individual homeowners and another party. 
Note 
 

SharedEquityIndicator Logical Attribute Properties 
Logical Attribute Name  SharedEquityIndicator 
Datatype  BIT 
Nullable  NO 

SharedEquityIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SharedEquityIndicator Bound Attachments 
Name  Current Value 

SharedEquityIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SharedEquityIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SharedEquityIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SharedEquityIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SharedEquityIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SignedAuthorizationToRequestTaxRecordsIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  SignedAuthorizationToRequestTaxRecordsIndicator 
Logical Rolename   
ColumnName  SignedAuthorizationToRequestTaxRecordsIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records is present. 
Note 
 

SignedAuthorizationToRequestTaxRecordsIndicator Logical Attribute Properties 
Logical Attribute Name  SignedAuthorizationToRequestTaxRecordsIndicator 
Datatype  BIT 
Nullable  NO 

SignedAuthorizationToRequestTaxRecordsIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SignedAuthorizationToRequestTaxRecordsIndicator Bound Attachments 
Name  Current Value 

SignedAuthorizationToRequestTaxRecordsIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SignedAuthorizationToRequestTaxRecordsIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SignedAuthorizationToRequestTaxRecordsIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SignedAuthorizationToRequestTaxRecordsIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SignedAuthorizationToRequestTaxRecordsIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TaxRecordsObtainedIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  TaxRecordsObtainedIndicator 
Logical Rolename   
ColumnName  TaxRecordsObtainedIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records has been executed by the lender. 
Note 
 

TaxRecordsObtainedIndicator Logical Attribute Properties 
Logical Attribute Name  TaxRecordsObtainedIndicator 
Datatype  BIT 
Nullable  NO 

TaxRecordsObtainedIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

TaxRecordsObtainedIndicator Bound Attachments 
Name  Current Value 

TaxRecordsObtainedIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

TaxRecordsObtainedIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TaxRecordsObtainedIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TaxRecordsObtainedIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TaxRecordsObtainedIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TimelyPaymentRateReductionIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  TimelyPaymentRateReductionIndicator 
Logical Rolename   
ColumnName  TimelyPaymentRateReductionIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Flag indicating if the loan is eligible for a rate reduction if payments are received in a timely manner. 
Note 
 

TimelyPaymentRateReductionIndicator Logical Attribute Properties 
Logical Attribute Name  TimelyPaymentRateReductionIndicator 
Datatype  BIT 
Nullable  NO 

TimelyPaymentRateReductionIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

TimelyPaymentRateReductionIndicator Bound Attachments 
Name  Current Value 

TimelyPaymentRateReductionIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

TimelyPaymentRateReductionIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TimelyPaymentRateReductionIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TimelyPaymentRateReductionIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TimelyPaymentRateReductionIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TotalMortgagedPropertiesCount 
Base Entity  LOAN_DETAIL 
Attribute Name  TotalMortgagedPropertiesCount 
Logical Rolename   
ColumnName  TotalMortgagedPropertiesCount 
RoleName   
Domain  MISMOCount 
Definition  The number of 1-4 unit properties that are financed and owned and/or obligated on by the borrower(s). A jointly owned/obligated property by multiple borrowers would count only once. 
Note 
 

TotalMortgagedPropertiesCount Logical Attribute Properties 
Logical Attribute Name  TotalMortgagedPropertiesCount 
Datatype  INTEGER 
Nullable  NO 

TotalMortgagedPropertiesCount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

TotalMortgagedPropertiesCount Bound Attachments 
Name  Current Value 

TotalMortgagedPropertiesCount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

TotalMortgagedPropertiesCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalMortgagedPropertiesCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalMortgagedPropertiesCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TotalMortgagedPropertiesCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TotalSalesConcessionAmount 
Base Entity  LOAN_DETAIL 
Attribute Name  TotalSalesConcessionAmount 
Logical Rolename   
ColumnName  TotalSalesConcessionAmount 
RoleName   
Domain  MISMOAmount 
Definition  The sum total dollar amount of the value of all sales concessions granted by an interested party including such items as furniture, carpeting, decorator allowances, automobiles, vacations, securities, giveaways or other sales incentives 
Note 
 

TotalSalesConcessionAmount Logical Attribute Properties 
Logical Attribute Name  TotalSalesConcessionAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

TotalSalesConcessionAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

TotalSalesConcessionAmount Bound Attachments 
Name  Current Value 

TotalSalesConcessionAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

TotalSalesConcessionAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalSalesConcessionAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TotalSalesConcessionAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TotalSalesConcessionAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


WarehouseLenderIndicator 
Base Entity  LOAN_DETAIL 
Attribute Name  WarehouseLenderIndicator 
Logical Rolename   
ColumnName  WarehouseLenderIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  An indicator denoting whether a Warehouse Bank is involved in the mortgage loan transaction through a relationship with the lender. 
Note 
 

WarehouseLenderIndicator Logical Attribute Properties 
Logical Attribute Name  WarehouseLenderIndicator 
Datatype  BIT 
Nullable  NO 

WarehouseLenderIndicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

WarehouseLenderIndicator Bound Attachments 
Name  Current Value 

WarehouseLenderIndicator User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

WarehouseLenderIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

WarehouseLenderIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

WarehouseLenderIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

WarehouseLenderIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description