ESCROW_DETAIL

ESCROW_DETAIL

EntityType	Dependent
Logical Entity Name	ESCROW_DETAIL
Default Table Name	DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/ESCROW/ESCROW_DETAIL
Definition
Note

ESCROW_DETAIL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

EscrowAccountInitialBalanceAmount MISMOAmount DECIMAL(0, 2) NO The initial total of all escrow amounts collected to establish the escrow account.

EscrowAccountMinimumBalanceAmount MISMOAmount DECIMAL(0, 2) NO The lowest escrow balance target amount determined by the allowable cushion.

EscrowAccountShortageAmount MISMOAmount DECIMAL(0, 2) NO Amount the escrow account is or is anticipated to be short. (As determined by the originator of the modification.)

EscrowAccountShortageRepaymentPeriodYearsCount MISMOCount INTEGER NO The number of years over which the Escrow Account Shortage Amount may be repaid.

EscrowAggregateAccountingAdjustmentAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount of any adjustment made to total escrow account based on Regulation X requirements. This must be a negative number or 0.

EscrowBalanceAmount MISMOAmount DECIMAL(0, 2) NO Escrow balance on the loan net of any escrow advances. May be a negative amount.

EscrowCompletionFundsBalanceAmount MISMOAmount DECIMAL(0, 2) NO 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.

EscrowCushionNumberOfMonthsCount MISMOCount INTEGER NO 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.

EscrowHoldbackAmount MISMOAmount DECIMAL(0, 2) NO Amount held back at closing by the lender or escrow agent until a particular condition has been met.

GFEDisclosedInitialEscrowBalanceAmount MISMOAmount DECIMAL(0, 2) NO The initial escrow account deposit amount, as reflected on a single instance of the GFE.

InitialEscrowDepositIncludesAllInsuranceIndicator MISMOIndicator BIT NO 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

InitialEscrowDepositIncludesAllPropertyTaxesIndicator MISMOIndicator BIT NO 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

InitialEscrowDepositIncludesOtherDescription MISMOString VARCHAR(0) NO 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.

InitialEscrowProjectionStatementDate MISMODate DATE NO Identifies the date that the initial escrow statement was given to the borrower.

InterestOnEscrowAccruedAmount MISMOAmount DECIMAL(0, 2) NO Identifies Interest on Escrow accrued not yet posted amount.

InterestOnEscrowAccruedThroughDate MISMODate DATE NO Identifies date thru which interest on escrow has accrued

InterestOnEscrowBackupWithholdingIndicator MISMOIndicator BIT NO Flag to indicate if interest on escrow s/b withheld due to IRS notification.

InterestOnEscrowIndicator MISMOIndicator BIT NO Identifies if interest is paid on for an Escrow Account of the borrower.

InterestOnEscrowYearToDatePostedAmount MISMOAmount DECIMAL(0, 2) NO Identifies the dollar amount of interest on escrow posted for the current year.

InterestOnRestrictedEscrowIndicator MISMOIndicator BIT NO Identifies if interest is paid on restricted escrow

LastEscrowAnalysisDate MISMODate DATE NO Identifies the date of last Escrow Analysis

LastInterestOnEscrowPostedDate MISMODate DATE NO Identifies the date for which interest on escrow was last posted to the account

MIEscrowIncludedInAggregateIndicator MISMOIndicator BIT NO Indicates whether Private Mortgage Insurance Escrow is to be included in the cushion for Aggregate Accounting.

RestrictedEscrowBalanceAmount MISMOAmount DECIMAL(0, 2) NO Loss Draft Funds Balance

ESCROW_DETAIL Keys

Key Name Key Type Keys

ESCROW_DETAIL Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

ESCROW Identifying One to Zero or One NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

ESCROW_DETAIL Check Constraints

Check Constraint Name CheckConstraint

ESCROW_DETAIL Bound Attachments

Name Current Value

ESCROW_DETAIL User-Defined Mappings

Model Name Description

ESCROW_DETAIL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
EscrowAccountInitialBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The initial total of all escrow amounts collected to establish the escrow account.
EscrowAccountMinimumBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The lowest escrow balance target amount determined by the allowable cushion.
EscrowAccountShortageAmount	MISMOAmount	DECIMAL(0, 2)	NO	Amount the escrow account is or is anticipated to be short. (As determined by the originator of the modification.)
EscrowAccountShortageRepaymentPeriodYearsCount	MISMOCount	INTEGER	NO	The number of years over which the Escrow Account Shortage Amount may be repaid.
EscrowAggregateAccountingAdjustmentAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount of any adjustment made to total escrow account based on Regulation X requirements. This must be a negative number or 0.
EscrowBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	Escrow balance on the loan net of any escrow advances. May be a negative amount.
EscrowCompletionFundsBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	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.
EscrowCushionNumberOfMonthsCount	MISMOCount	INTEGER	NO	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.
EscrowHoldbackAmount	MISMOAmount	DECIMAL(0, 2)	NO	Amount held back at closing by the lender or escrow agent until a particular condition has been met.
GFEDisclosedInitialEscrowBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The initial escrow account deposit amount, as reflected on a single instance of the GFE.
InitialEscrowDepositIncludesAllInsuranceIndicator	MISMOIndicator	BIT	NO	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
InitialEscrowDepositIncludesAllPropertyTaxesIndicator	MISMOIndicator	BIT	NO	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
InitialEscrowDepositIncludesOtherDescription	MISMOString	VARCHAR(0)	NO	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.
InitialEscrowProjectionStatementDate	MISMODate	DATE	NO	Identifies the date that the initial escrow statement was given to the borrower.
InterestOnEscrowAccruedAmount	MISMOAmount	DECIMAL(0, 2)	NO	Identifies Interest on Escrow accrued not yet posted amount.
InterestOnEscrowAccruedThroughDate	MISMODate	DATE	NO	Identifies date thru which interest on escrow has accrued
InterestOnEscrowBackupWithholdingIndicator	MISMOIndicator	BIT	NO	Flag to indicate if interest on escrow s/b withheld due to IRS notification.
InterestOnEscrowIndicator	MISMOIndicator	BIT	NO	Identifies if interest is paid on for an Escrow Account of the borrower.
InterestOnEscrowYearToDatePostedAmount	MISMOAmount	DECIMAL(0, 2)	NO	Identifies the dollar amount of interest on escrow posted for the current year.
InterestOnRestrictedEscrowIndicator	MISMOIndicator	BIT	NO	Identifies if interest is paid on restricted escrow
LastEscrowAnalysisDate	MISMODate	DATE	NO	Identifies the date of last Escrow Analysis
LastInterestOnEscrowPostedDate	MISMODate	DATE	NO	Identifies the date for which interest on escrow was last posted to the account
MIEscrowIncludedInAggregateIndicator	MISMOIndicator	BIT	NO	Indicates whether Private Mortgage Insurance Escrow is to be included in the cushion for Aggregate Accounting.
RestrictedEscrowBalanceAmount	MISMOAmount	DECIMAL(0, 2)	NO	Loss Draft Funds Balance

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
ESCROW	Identifying	One to Zero or One					NO