EscrowAccountInitialBalanceAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowAccountInitialBalanceAmount |
Logical Rolename | |
ColumnName | EscrowAccountInitialBalanceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The initial total of all escrow amounts collected to establish the escrow account. |
Note |
EscrowAccountInitialBalanceAmount Logical Attribute Properties |
Logical Attribute Name | EscrowAccountInitialBalanceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowAccountInitialBalanceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowAccountInitialBalanceAmount Bound Attachments |
Name | Current Value |
EscrowAccountInitialBalanceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowAccountInitialBalanceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountInitialBalanceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountInitialBalanceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountInitialBalanceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountMinimumBalanceAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowAccountMinimumBalanceAmount |
Logical Rolename | |
ColumnName | EscrowAccountMinimumBalanceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The lowest escrow balance target amount determined by the allowable cushion. |
Note |
EscrowAccountMinimumBalanceAmount Logical Attribute Properties |
Logical Attribute Name | EscrowAccountMinimumBalanceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowAccountMinimumBalanceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowAccountMinimumBalanceAmount Bound Attachments |
Name | Current Value |
EscrowAccountMinimumBalanceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowAccountMinimumBalanceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountMinimumBalanceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountMinimumBalanceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountMinimumBalanceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowAccountShortageAmount |
Logical Rolename | |
ColumnName | EscrowAccountShortageAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Amount the escrow account is or is anticipated to be short. (As determined by the originator of the modification.) |
Note |
EscrowAccountShortageAmount Logical Attribute Properties |
Logical Attribute Name | EscrowAccountShortageAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowAccountShortageAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowAccountShortageAmount Bound Attachments |
Name | Current Value |
EscrowAccountShortageAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowAccountShortageAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageRepaymentPeriodYearsCount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowAccountShortageRepaymentPeriodYearsCount |
Logical Rolename | |
ColumnName | EscrowAccountShortageRepaymentPeriodYearsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of years over which the Escrow Account Shortage Amount may be repaid. |
Note |
EscrowAccountShortageRepaymentPeriodYearsCount Logical Attribute Properties |
Logical Attribute Name | EscrowAccountShortageRepaymentPeriodYearsCount |
Datatype | INTEGER |
Nullable | NO |
EscrowAccountShortageRepaymentPeriodYearsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowAccountShortageRepaymentPeriodYearsCount Bound Attachments |
Name | Current Value |
EscrowAccountShortageRepaymentPeriodYearsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowAccountShortageRepaymentPeriodYearsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageRepaymentPeriodYearsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageRepaymentPeriodYearsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAccountShortageRepaymentPeriodYearsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAggregateAccountingAdjustmentAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowAggregateAccountingAdjustmentAmount |
Logical Rolename | |
ColumnName | EscrowAggregateAccountingAdjustmentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount of any adjustment made to total escrow account based on Regulation X requirements. This must be a negative number or 0. |
Note |
EscrowAggregateAccountingAdjustmentAmount Logical Attribute Properties |
Logical Attribute Name | EscrowAggregateAccountingAdjustmentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowAggregateAccountingAdjustmentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowAggregateAccountingAdjustmentAmount Bound Attachments |
Name | Current Value |
EscrowAggregateAccountingAdjustmentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowAggregateAccountingAdjustmentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAggregateAccountingAdjustmentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAggregateAccountingAdjustmentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAggregateAccountingAdjustmentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowBalanceAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowBalanceAmount |
Logical Rolename | |
ColumnName | EscrowBalanceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Escrow balance on the loan net of any escrow advances. May be a negative amount. |
Note |
EscrowBalanceAmount Logical Attribute Properties |
Logical Attribute Name | EscrowBalanceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowBalanceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowBalanceAmount Bound Attachments |
Name | Current Value |
EscrowBalanceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowBalanceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowBalanceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowBalanceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowBalanceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCompletionFundsBalanceAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowCompletionFundsBalanceAmount |
Logical Rolename | |
ColumnName | EscrowCompletionFundsBalanceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of the FHA 203K or rehab funds held in escrow required for the completion of the rehabilitation or repair of the subject property. |
Note |
EscrowCompletionFundsBalanceAmount Logical Attribute Properties |
Logical Attribute Name | EscrowCompletionFundsBalanceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowCompletionFundsBalanceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowCompletionFundsBalanceAmount Bound Attachments |
Name | Current Value |
EscrowCompletionFundsBalanceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowCompletionFundsBalanceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCompletionFundsBalanceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCompletionFundsBalanceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCompletionFundsBalanceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCushionNumberOfMonthsCount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowCushionNumberOfMonthsCount |
Logical Rolename | |
ColumnName | EscrowCushionNumberOfMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | Denotes the maximum number of monthly escrow collections allowed to be held as the projected lowest balance in the escrow account for the projection year. Escrow cushion months will have a value of 0, 1 or 2. |
Note |
EscrowCushionNumberOfMonthsCount Logical Attribute Properties |
Logical Attribute Name | EscrowCushionNumberOfMonthsCount |
Datatype | INTEGER |
Nullable | NO |
EscrowCushionNumberOfMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowCushionNumberOfMonthsCount Bound Attachments |
Name | Current Value |
EscrowCushionNumberOfMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowCushionNumberOfMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCushionNumberOfMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCushionNumberOfMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCushionNumberOfMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowHoldbackAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | EscrowHoldbackAmount |
Logical Rolename | |
ColumnName | EscrowHoldbackAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Amount held back at closing by the lender or escrow agent until a particular condition has been met. |
Note |
EscrowHoldbackAmount Logical Attribute Properties |
Logical Attribute Name | EscrowHoldbackAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowHoldbackAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowHoldbackAmount Bound Attachments |
Name | Current Value |
EscrowHoldbackAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowHoldbackAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowHoldbackAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowHoldbackAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowHoldbackAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedInitialEscrowBalanceAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | GFEDisclosedInitialEscrowBalanceAmount |
Logical Rolename | |
ColumnName | GFEDisclosedInitialEscrowBalanceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The initial escrow account deposit amount, as reflected on a single instance of the GFE. |
Note |
GFEDisclosedInitialEscrowBalanceAmount Logical Attribute Properties |
Logical Attribute Name | GFEDisclosedInitialEscrowBalanceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GFEDisclosedInitialEscrowBalanceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFEDisclosedInitialEscrowBalanceAmount Bound Attachments |
Name | Current Value |
GFEDisclosedInitialEscrowBalanceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFEDisclosedInitialEscrowBalanceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedInitialEscrowBalanceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedInitialEscrowBalanceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedInitialEscrowBalanceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllInsuranceIndicator |
Base Entity | ESCROW_DETAIL |
Attribute Name | InitialEscrowDepositIncludesAllInsuranceIndicator |
Logical Rolename | |
ColumnName | InitialEscrowDepositIncludesAllInsuranceIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates that the initial escrow account deposit amount includes amounts deposited for the purpose of paying future recurring charges for all types of insurances required on the subject property, as reflected on a single instance of the GFE. F |
Note |
InitialEscrowDepositIncludesAllInsuranceIndicator Logical Attribute Properties |
Logical Attribute Name | InitialEscrowDepositIncludesAllInsuranceIndicator |
Datatype | BIT |
Nullable | NO |
InitialEscrowDepositIncludesAllInsuranceIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InitialEscrowDepositIncludesAllInsuranceIndicator Bound Attachments |
Name | Current Value |
InitialEscrowDepositIncludesAllInsuranceIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InitialEscrowDepositIncludesAllInsuranceIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllInsuranceIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllInsuranceIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllInsuranceIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator |
Base Entity | ESCROW_DETAIL |
Attribute Name | InitialEscrowDepositIncludesAllPropertyTaxesIndicator |
Logical Rolename | |
ColumnName | InitialEscrowDepositIncludesAllPropertyTaxesIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true, indicates that the initial escrow account deposit amount includes amounts deposited for the purpose of paying future recurring charges for all types of property taxes required on the subject property, as reflected on a single instance of the GF |
Note |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Logical Attribute Properties |
Logical Attribute Name | InitialEscrowDepositIncludesAllPropertyTaxesIndicator |
Datatype | BIT |
Nullable | NO |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Bound Attachments |
Name | Current Value |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesAllPropertyTaxesIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesOtherDescription |
Base Entity | ESCROW_DETAIL |
Attribute Name | InitialEscrowDepositIncludesOtherDescription |
Logical Rolename | |
ColumnName | InitialEscrowDepositIncludesOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | Specifies the other escrow items for which payment will be covered by the initial escrow account deposit amount, as reflected on a single instance of the GFE. |
Note |
InitialEscrowDepositIncludesOtherDescription Logical Attribute Properties |
Logical Attribute Name | InitialEscrowDepositIncludesOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
InitialEscrowDepositIncludesOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InitialEscrowDepositIncludesOtherDescription Bound Attachments |
Name | Current Value |
InitialEscrowDepositIncludesOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InitialEscrowDepositIncludesOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowDepositIncludesOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowProjectionStatementDate |
Base Entity | ESCROW_DETAIL |
Attribute Name | InitialEscrowProjectionStatementDate |
Logical Rolename | |
ColumnName | InitialEscrowProjectionStatementDate |
RoleName | |
Domain | MISMODate |
Definition | Identifies the date that the initial escrow statement was given to the borrower. |
Note |
InitialEscrowProjectionStatementDate Logical Attribute Properties |
Logical Attribute Name | InitialEscrowProjectionStatementDate |
Datatype | DATE |
Nullable | NO |
InitialEscrowProjectionStatementDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InitialEscrowProjectionStatementDate Bound Attachments |
Name | Current Value |
InitialEscrowProjectionStatementDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InitialEscrowProjectionStatementDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowProjectionStatementDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowProjectionStatementDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InitialEscrowProjectionStatementDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | InterestOnEscrowAccruedAmount |
Logical Rolename | |
ColumnName | InterestOnEscrowAccruedAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Identifies Interest on Escrow accrued not yet posted amount. |
Note |
InterestOnEscrowAccruedAmount Logical Attribute Properties |
Logical Attribute Name | InterestOnEscrowAccruedAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
InterestOnEscrowAccruedAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestOnEscrowAccruedAmount Bound Attachments |
Name | Current Value |
InterestOnEscrowAccruedAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestOnEscrowAccruedAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedThroughDate |
Base Entity | ESCROW_DETAIL |
Attribute Name | InterestOnEscrowAccruedThroughDate |
Logical Rolename | |
ColumnName | InterestOnEscrowAccruedThroughDate |
RoleName | |
Domain | MISMODate |
Definition | Identifies date thru which interest on escrow has accrued |
Note |
InterestOnEscrowAccruedThroughDate Logical Attribute Properties |
Logical Attribute Name | InterestOnEscrowAccruedThroughDate |
Datatype | DATE |
Nullable | NO |
InterestOnEscrowAccruedThroughDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestOnEscrowAccruedThroughDate Bound Attachments |
Name | Current Value |
InterestOnEscrowAccruedThroughDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestOnEscrowAccruedThroughDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedThroughDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedThroughDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowAccruedThroughDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowBackupWithholdingIndicator |
Base Entity | ESCROW_DETAIL |
Attribute Name | InterestOnEscrowBackupWithholdingIndicator |
Logical Rolename | |
ColumnName | InterestOnEscrowBackupWithholdingIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Flag to indicate if interest on escrow s/b withheld due to IRS notification. |
Note |
InterestOnEscrowBackupWithholdingIndicator Logical Attribute Properties |
Logical Attribute Name | InterestOnEscrowBackupWithholdingIndicator |
Datatype | BIT |
Nullable | NO |
InterestOnEscrowBackupWithholdingIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestOnEscrowBackupWithholdingIndicator Bound Attachments |
Name | Current Value |
InterestOnEscrowBackupWithholdingIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestOnEscrowBackupWithholdingIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowBackupWithholdingIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowBackupWithholdingIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowBackupWithholdingIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowIndicator |
Base Entity | ESCROW_DETAIL |
Attribute Name | InterestOnEscrowIndicator |
Logical Rolename | |
ColumnName | InterestOnEscrowIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Identifies if interest is paid on for an Escrow Account of the borrower. |
Note |
InterestOnEscrowIndicator Logical Attribute Properties |
Logical Attribute Name | InterestOnEscrowIndicator |
Datatype | BIT |
Nullable | NO |
InterestOnEscrowIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestOnEscrowIndicator Bound Attachments |
Name | Current Value |
InterestOnEscrowIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestOnEscrowIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowYearToDatePostedAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | InterestOnEscrowYearToDatePostedAmount |
Logical Rolename | |
ColumnName | InterestOnEscrowYearToDatePostedAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Identifies the dollar amount of interest on escrow posted for the current year. |
Note |
InterestOnEscrowYearToDatePostedAmount Logical Attribute Properties |
Logical Attribute Name | InterestOnEscrowYearToDatePostedAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
InterestOnEscrowYearToDatePostedAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestOnEscrowYearToDatePostedAmount Bound Attachments |
Name | Current Value |
InterestOnEscrowYearToDatePostedAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestOnEscrowYearToDatePostedAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowYearToDatePostedAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowYearToDatePostedAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnEscrowYearToDatePostedAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnRestrictedEscrowIndicator |
Base Entity | ESCROW_DETAIL |
Attribute Name | InterestOnRestrictedEscrowIndicator |
Logical Rolename | |
ColumnName | InterestOnRestrictedEscrowIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Identifies if interest is paid on restricted escrow |
Note |
InterestOnRestrictedEscrowIndicator Logical Attribute Properties |
Logical Attribute Name | InterestOnRestrictedEscrowIndicator |
Datatype | BIT |
Nullable | NO |
InterestOnRestrictedEscrowIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
InterestOnRestrictedEscrowIndicator Bound Attachments |
Name | Current Value |
InterestOnRestrictedEscrowIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
InterestOnRestrictedEscrowIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnRestrictedEscrowIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnRestrictedEscrowIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
InterestOnRestrictedEscrowIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastEscrowAnalysisDate |
Base Entity | ESCROW_DETAIL |
Attribute Name | LastEscrowAnalysisDate |
Logical Rolename | |
ColumnName | LastEscrowAnalysisDate |
RoleName | |
Domain | MISMODate |
Definition | Identifies the date of last Escrow Analysis |
Note |
LastEscrowAnalysisDate Logical Attribute Properties |
Logical Attribute Name | LastEscrowAnalysisDate |
Datatype | DATE |
Nullable | NO |
LastEscrowAnalysisDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LastEscrowAnalysisDate Bound Attachments |
Name | Current Value |
LastEscrowAnalysisDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LastEscrowAnalysisDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastEscrowAnalysisDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastEscrowAnalysisDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastEscrowAnalysisDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastInterestOnEscrowPostedDate |
Base Entity | ESCROW_DETAIL |
Attribute Name | LastInterestOnEscrowPostedDate |
Logical Rolename | |
ColumnName | LastInterestOnEscrowPostedDate |
RoleName | |
Domain | MISMODate |
Definition | Identifies the date for which interest on escrow was last posted to the account |
Note |
LastInterestOnEscrowPostedDate Logical Attribute Properties |
Logical Attribute Name | LastInterestOnEscrowPostedDate |
Datatype | DATE |
Nullable | NO |
LastInterestOnEscrowPostedDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LastInterestOnEscrowPostedDate Bound Attachments |
Name | Current Value |
LastInterestOnEscrowPostedDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
LastInterestOnEscrowPostedDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastInterestOnEscrowPostedDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LastInterestOnEscrowPostedDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LastInterestOnEscrowPostedDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator |
Base Entity | ESCROW_DETAIL |
Attribute Name | MIEscrowIncludedInAggregateIndicator |
Logical Rolename | |
ColumnName | MIEscrowIncludedInAggregateIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether Private Mortgage Insurance Escrow is to be included in the cushion for Aggregate Accounting. |
Note |
MIEscrowIncludedInAggregateIndicator Logical Attribute Properties |
Logical Attribute Name | MIEscrowIncludedInAggregateIndicator |
Datatype | BIT |
Nullable | NO |
MIEscrowIncludedInAggregateIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIEscrowIncludedInAggregateIndicator Bound Attachments |
Name | Current Value |
MIEscrowIncludedInAggregateIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MIEscrowIncludedInAggregateIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIEscrowIncludedInAggregateIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RestrictedEscrowBalanceAmount |
Base Entity | ESCROW_DETAIL |
Attribute Name | RestrictedEscrowBalanceAmount |
Logical Rolename | |
ColumnName | RestrictedEscrowBalanceAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Loss Draft Funds Balance |
Note |
RestrictedEscrowBalanceAmount Logical Attribute Properties |
Logical Attribute Name | RestrictedEscrowBalanceAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
RestrictedEscrowBalanceAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RestrictedEscrowBalanceAmount Bound Attachments |
Name | Current Value |
RestrictedEscrowBalanceAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
RestrictedEscrowBalanceAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RestrictedEscrowBalanceAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RestrictedEscrowBalanceAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RestrictedEscrowBalanceAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |