URLA_DETAIL

URLA_DETAIL

EntityType	Dependent
Logical Entity Name	URLA_DETAIL
Default Table Name	DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/DOCUMENT_SPECIFIC_DATA_SETS/DOCUMENT_SPECIFIC_DATA_SET/URLA/URLA_DETAIL
Definition
Note

URLA_DETAIL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

AdditionalBorrowerAssetsConsideredIndicator MISMOIndicator BIT NO A text field used to specify the Unplatted Description Type when "Other" is selected from the enumerated list.

AdditionalBorrowerAssetsNotConsideredIndicator MISMOIndicator BIT NO The income or assets of a person other than the borrower (including the spouse of the borrower ) will be used as a basis for loan qualification.

AlterationsImprovementsAndRepairsAmount MISMOAmount DECIMAL(0, 2) NO The income or assets of the borrowers spouse will not be used as a basis for loan qualification, but his or her liabilities must be considered because the borrower resides in a community property state, the security property is located in a community prop

ApplicationSignedByLoanOriginatorDate MISMODate DATE NO The cost of any alterations, improvements, repairs and rehabilitation to be made on the subject property. Collected on the URLA in Section VII line b.

ARMTypeDescription MISMOString VARCHAR(0) NO The date on which the Loan Originator obtained HMDA information and signed the loan application. Collected on the URLA in Section X (Interviewers Signature Date).

ApplicationTakenMethodType ApplicationTakenMethodEnum VARCHAR(0) YES A free-form text field used to collect additional information or a description of the ARM program. Collected on the URLA in Section I (Amortization Type:ARM).

BorrowerPaidDiscountPointsTotalAmount MISMOAmount DECIMAL(0, 2) NO The total dollar amount of discount points that are paid by the borrower. Collected on the URLA in Section VII line h.

BorrowerRequestedInterestRatePercent MISMOPercent DECIMAL(0, 2) NO The interest rate that is being requested on the loan application. Collected on the URLA in Section I (Interest Rate).

BorrowerRequestedLoanAmount MISMOAmount DECIMAL(0, 2) NO The total dollar amount of the mortgage note being originated that is being requested by the borrower. This amount may include financed PMI, MIP and Funding Fees. It is collected on the URLA in Section I (Amount) and in Section VII line o.

EstimatedClosingCostsAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount of the estimated loan fees, title fees, appraisal fees and other closing costs associated with the subject transaction excluding discount points. Collected on the URLA in Section VII line f.

LenderRegistrationIdentifier MISMOIdentifier VARCHAR(0) NO A tracking number assigned by the wholesale lender to identify the loan for pipeline management.

MIAndFundingFeeFinancedAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount of private mortgage insurance premium, FHA up-front MI Premium or VA funding fee that is rolled into loan amount. Used if PMI / MIP / VA funding fee will be added to loan amount. Collected on the URLA in Section VII line n.

MIAndFundingFeeTotalAmount MISMOAmount DECIMAL(0, 2) NO The total amount paid to initiate private mortgage insurance, FHA up-front MI premium or the VA funding fee. Collected on the URLA in Section VII line g.

PrepaidItemsEstimatedAmount MISMOAmount DECIMAL(0, 2) NO The dollar amount of escrow / impound to be held by the lender, which is to be collected at closing for future payment of taxes, insurance or other obligations on the subject property. Collected on the URLA in Section VII line e.

PurchasePriceAmount MISMOAmount DECIMAL(0, 2) NO The total dollar amount paid by the borrower for the property pledged as security for the mortgage. The purchase price is presented on the offer to purchase.

PurchasePriceNetAmount MISMOAmount DECIMAL(0, 2) NO The result of subtracting financing and sales concession amounts above those allowed by guidelines from the Purchase Price Amount of the subject property. CALCULATED RESULTS FIELD

RefinanceImprovementCostsAmount MISMOAmount DECIMAL(0, 2) NO The total dollar amount of improvements either made or to be made at time of refinance. Collected on the URLA in Section II Describe Improvements Costs.

RefinanceImprovementsType RefinanceImprovementsEnum VARCHAR(0) YES Specifies whether the improvements associated with a refinance have been made to the property or if they are planned. Collected on the URLA in Section II (Refinance - Describe Improvements - Check Box.)

RefinanceIncludingDebtsToBePaidOffAmount MISMOAmount DECIMAL(0, 2) NO The total amount of all debt to be repaid with funds from refinancing the mortgage loan on the subject property. Collected on the URLA in Section VII line d.

RefinanceProposedImprovementsDescription MISMOString VARCHAR(0) NO A free-form text field used to capture additional information text entries on the URLA associated with the improvements to be made on property being refinanced. Collected on the URLA in Section II (Refinance - Describe Improvements To Be Made).

RefundableApplicationFeeIndicator MISMOIndicator BIT NO Indicates whether the Application Fee is refundable.

RequiredDepositIndicator MISMOIndicator BIT NO Indicates whether a deposit balance is required to be maintained at an account at the lending institution as a condition of the loan. This does not affect the Annual Percentage Rate or any fees. This is disclosed on the Truth in Lending Disclosure. Move t

SellerPaidClosingCostsAmount MISMOAmount DECIMAL(0, 2) NO The estimated closing costs that the seller of the subject property will pay. Collected on the URLA in Section VII line k.

URLA_DETAIL Keys

Key Name Key Type Keys

URLA_DETAIL Relationships

Parent Relationships:

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

URLA Identifying One to Zero or One NO

Child Relationships:

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

URLA_DETAIL Check Constraints

Check Constraint Name CheckConstraint

URLA_DETAIL Bound Attachments

Name Current Value

URLA_DETAIL User-Defined Mappings

Model Name Description

URLA_DETAIL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
AdditionalBorrowerAssetsConsideredIndicator	MISMOIndicator	BIT	NO	A text field used to specify the Unplatted Description Type when "Other" is selected from the enumerated list.
AdditionalBorrowerAssetsNotConsideredIndicator	MISMOIndicator	BIT	NO	The income or assets of a person other than the borrower (including the spouse of the borrower ) will be used as a basis for loan qualification.
AlterationsImprovementsAndRepairsAmount	MISMOAmount	DECIMAL(0, 2)	NO	The income or assets of the borrowers spouse will not be used as a basis for loan qualification, but his or her liabilities must be considered because the borrower resides in a community property state, the security property is located in a community prop
ApplicationSignedByLoanOriginatorDate	MISMODate	DATE	NO	The cost of any alterations, improvements, repairs and rehabilitation to be made on the subject property. Collected on the URLA in Section VII line b.
ARMTypeDescription	MISMOString	VARCHAR(0)	NO	The date on which the Loan Originator obtained HMDA information and signed the loan application. Collected on the URLA in Section X (Interviewers Signature Date).
ApplicationTakenMethodType	ApplicationTakenMethodEnum	VARCHAR(0)	YES	A free-form text field used to collect additional information or a description of the ARM program. Collected on the URLA in Section I (Amortization Type:ARM).
BorrowerPaidDiscountPointsTotalAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total dollar amount of discount points that are paid by the borrower. Collected on the URLA in Section VII line h.
BorrowerRequestedInterestRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The interest rate that is being requested on the loan application. Collected on the URLA in Section I (Interest Rate).
BorrowerRequestedLoanAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total dollar amount of the mortgage note being originated that is being requested by the borrower. This amount may include financed PMI, MIP and Funding Fees. It is collected on the URLA in Section I (Amount) and in Section VII line o.
EstimatedClosingCostsAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount of the estimated loan fees, title fees, appraisal fees and other closing costs associated with the subject transaction excluding discount points. Collected on the URLA in Section VII line f.
LenderRegistrationIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A tracking number assigned by the wholesale lender to identify the loan for pipeline management.
MIAndFundingFeeFinancedAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount of private mortgage insurance premium, FHA up-front MI Premium or VA funding fee that is rolled into loan amount. Used if PMI / MIP / VA funding fee will be added to loan amount. Collected on the URLA in Section VII line n.
MIAndFundingFeeTotalAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total amount paid to initiate private mortgage insurance, FHA up-front MI premium or the VA funding fee. Collected on the URLA in Section VII line g.
PrepaidItemsEstimatedAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar amount of escrow / impound to be held by the lender, which is to be collected at closing for future payment of taxes, insurance or other obligations on the subject property. Collected on the URLA in Section VII line e.
PurchasePriceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total dollar amount paid by the borrower for the property pledged as security for the mortgage. The purchase price is presented on the offer to purchase.
PurchasePriceNetAmount	MISMOAmount	DECIMAL(0, 2)	NO	The result of subtracting financing and sales concession amounts above those allowed by guidelines from the Purchase Price Amount of the subject property. CALCULATED RESULTS FIELD
RefinanceImprovementCostsAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total dollar amount of improvements either made or to be made at time of refinance. Collected on the URLA in Section II Describe Improvements Costs.
RefinanceImprovementsType	RefinanceImprovementsEnum	VARCHAR(0)	YES	Specifies whether the improvements associated with a refinance have been made to the property or if they are planned. Collected on the URLA in Section II (Refinance - Describe Improvements - Check Box.)
RefinanceIncludingDebtsToBePaidOffAmount	MISMOAmount	DECIMAL(0, 2)	NO	The total amount of all debt to be repaid with funds from refinancing the mortgage loan on the subject property. Collected on the URLA in Section VII line d.
RefinanceProposedImprovementsDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture additional information text entries on the URLA associated with the improvements to be made on property being refinanced. Collected on the URLA in Section II (Refinance - Describe Improvements To Be Made).
RefundableApplicationFeeIndicator	MISMOIndicator	BIT	NO	Indicates whether the Application Fee is refundable.
RequiredDepositIndicator	MISMOIndicator	BIT	NO	Indicates whether a deposit balance is required to be maintained at an account at the lending institution as a condition of the loan. This does not affect the Annual Percentage Rate or any fees. This is disclosed on the Truth in Lending Disclosure. Move t
SellerPaidClosingCostsAmount	MISMOAmount	DECIMAL(0, 2)	NO	The estimated closing costs that the seller of the subject property will pay. Collected on the URLA in Section VII line k.

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