AggregateLoanCurtailmentAmount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | AggregateLoanCurtailmentAmount |
Logical Rolename | |
ColumnName | AggregateLoanCurtailmentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total amount of principal that has been paid from origination to date over and above the scheduled principal amount. |
Note |
AggregateLoanCurtailmentAmount Logical Attribute Properties |
Logical Attribute Name | AggregateLoanCurtailmentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
AggregateLoanCurtailmentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AggregateLoanCurtailmentAmount Bound Attachments |
Name | Current Value |
AggregateLoanCurtailmentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AggregateLoanCurtailmentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AggregateLoanCurtailmentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AggregateLoanCurtailmentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AggregateLoanCurtailmentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestPaidThroughDate |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | InterestPaidThroughDate |
Logical Rolename | |
ColumnName | InterestPaidThroughDate |
RoleName | |
Domain | MISMODate |
Definition | The date through which interest is paid with the current payment. This is the effective date from which interest will be calculated for the application of the next payment. (For example, used for daily simple interest loans.) |
Note |
InterestPaidThroughDate Logical Attribute Properties |
Logical Attribute Name | InterestPaidThroughDate |
Datatype | DATE |
Nullable | NO |
InterestPaidThroughDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestPaidThroughDate Bound Attachments |
Name | Current Value |
InterestPaidThroughDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestPaidThroughDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestPaidThroughDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestPaidThroughDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestPaidThroughDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaidInstallmentDueDate |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | LastPaidInstallmentDueDate |
Logical Rolename | |
ColumnName | LastPaidInstallmentDueDate |
RoleName | |
Domain | MISMODate |
Definition | The due date of last paid installment (DDLPI) that had been collected for the mortgage. |
Note |
LastPaidInstallmentDueDate Logical Attribute Properties |
Logical Attribute Name | LastPaidInstallmentDueDate |
Datatype | DATE |
Nullable | NO |
LastPaidInstallmentDueDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LastPaidInstallmentDueDate Bound Attachments |
Name | Current Value |
LastPaidInstallmentDueDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LastPaidInstallmentDueDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaidInstallmentDueDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaidInstallmentDueDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaidInstallmentDueDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaymentReceivedDate |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | LastPaymentReceivedDate |
Logical Rolename | |
ColumnName | LastPaymentReceivedDate |
RoleName | |
Domain | MISMODate |
Definition | The actual date the last payment by the borrower was received by the lender. |
Note |
LastPaymentReceivedDate Logical Attribute Properties |
Logical Attribute Name | LastPaymentReceivedDate |
Datatype | DATE |
Nullable | NO |
LastPaymentReceivedDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LastPaymentReceivedDate Bound Attachments |
Name | Current Value |
LastPaymentReceivedDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LastPaymentReceivedDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaymentReceivedDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaymentReceivedDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastPaymentReceivedDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NextPaymentDueDate |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | NextPaymentDueDate |
Logical Rolename | |
ColumnName | NextPaymentDueDate |
RoleName | |
Domain | MISMODate |
Definition | Identifies the next payment due date. |
Note |
NextPaymentDueDate Logical Attribute Properties |
Logical Attribute Name | NextPaymentDueDate |
Datatype | DATE |
Nullable | NO |
NextPaymentDueDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NextPaymentDueDate Bound Attachments |
Name | Current Value |
NextPaymentDueDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
NextPaymentDueDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NextPaymentDueDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NextPaymentDueDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NextPaymentDueDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PaymentHistoryPatternText |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | PaymentHistoryPatternText |
Logical Rolename | |
ColumnName | PaymentHistoryPatternText |
RoleName | |
Domain | MISMOString |
Definition | A representation of the history of last twelve payments based on a Twelve month calendar beginning with January. |
Note |
PaymentHistoryPatternText Logical Attribute Properties |
Logical Attribute Name | PaymentHistoryPatternText |
Datatype | VARCHAR(0) |
Nullable | NO |
PaymentHistoryPatternText Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PaymentHistoryPatternText Bound Attachments |
Name | Current Value |
PaymentHistoryPatternText User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PaymentHistoryPatternText Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PaymentHistoryPatternText Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PaymentHistoryPatternText Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PaymentHistoryPatternText Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIMonthsCount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | TotalPITIMonthsCount |
Logical Rolename | |
ColumnName | TotalPITIMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The duration in months of the period for which the Total PITI Received Amount is provided. |
Note |
TotalPITIMonthsCount Logical Attribute Properties |
Logical Attribute Name | TotalPITIMonthsCount |
Datatype | INTEGER |
Nullable | NO |
TotalPITIMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TotalPITIMonthsCount Bound Attachments |
Name | Current Value |
TotalPITIMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TotalPITIMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIReceivedAmount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | TotalPITIReceivedAmount |
Logical Rolename | |
ColumnName | TotalPITIReceivedAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total amount of PITI received within the number of months specified in Total PITI Months Count. |
Note |
TotalPITIReceivedAmount Logical Attribute Properties |
Logical Attribute Name | TotalPITIReceivedAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
TotalPITIReceivedAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TotalPITIReceivedAmount Bound Attachments |
Name | Current Value |
TotalPITIReceivedAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TotalPITIReceivedAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIReceivedAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIReceivedAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TotalPITIReceivedAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPBAmount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | UPBAmount |
Logical Rolename | |
ColumnName | UPBAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The current unpaid principal balance on the loan. |
Note |
UPBAmount Logical Attribute Properties |
Logical Attribute Name | UPBAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
UPBAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UPBAmount Bound Attachments |
Name | Current Value |
UPBAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
UPBAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPBAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPBAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPBAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDatePrincipalPaidAmount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | YearToDatePrincipalPaidAmount |
Logical Rolename | |
ColumnName | YearToDatePrincipalPaidAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Year To Date Total Principal Paid Balance |
Note |
YearToDatePrincipalPaidAmount Logical Attribute Properties |
Logical Attribute Name | YearToDatePrincipalPaidAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
YearToDatePrincipalPaidAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
YearToDatePrincipalPaidAmount Bound Attachments |
Name | Current Value |
YearToDatePrincipalPaidAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
YearToDatePrincipalPaidAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDatePrincipalPaidAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDatePrincipalPaidAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDatePrincipalPaidAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTaxesPaidAmount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | YearToDateTaxesPaidAmount |
Logical Rolename | |
ColumnName | YearToDateTaxesPaidAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Year To Date Total Taxes Paid Balance |
Note |
YearToDateTaxesPaidAmount Logical Attribute Properties |
Logical Attribute Name | YearToDateTaxesPaidAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
YearToDateTaxesPaidAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
YearToDateTaxesPaidAmount Bound Attachments |
Name | Current Value |
YearToDateTaxesPaidAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
YearToDateTaxesPaidAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTaxesPaidAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTaxesPaidAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTaxesPaidAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTotalInterestPaidAmount |
Base Entity | PAYMENT_SUMMARY |
Attribute Name | YearToDateTotalInterestPaidAmount |
Logical Rolename | |
ColumnName | YearToDateTotalInterestPaidAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Year To Date Total Interest Paid Amount |
Note |
YearToDateTotalInterestPaidAmount Logical Attribute Properties |
Logical Attribute Name | YearToDateTotalInterestPaidAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
YearToDateTotalInterestPaidAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
YearToDateTotalInterestPaidAmount Bound Attachments |
Name | Current Value |
YearToDateTotalInterestPaidAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
YearToDateTotalInterestPaidAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTotalInterestPaidAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTotalInterestPaidAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
YearToDateTotalInterestPaidAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |