FLOOD_REQUEST_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
BorrowerFloodAcknowledgementLetterIndicator	MISMOIndicator	BIT	NO	Indicates if a Borrower Acknowledgement Letter needs to be processed with the order.
FEMAAdditionalLenderDescription	MISMOString	VARCHAR(0)	NO	Additional information for the lender in Box 1 of the FEMA form. FORM SPECIFIC FIELD
FloodCertificationIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The certification number assigned by the compliance company when an order is received from the submitting / requesting party.
FloodInsuranceAmount	MISMOAmount	DECIMAL(0, 2)	NO	The minimal Federal requirement for flood insurance coverage, the lesser of: the outstanding principal loan balance; the value of the improved property, mobile home and/or personal property used to secure the loan; or the maximum statutory limit of flood
FloodRequestActionType	FloodRequestActionEnum	VARCHAR(0)	YES	Describes the type of action to be performed for the request in question.
FloodRequestCommentText	MISMOString	VARCHAR(0)	NO	Comments for the flood request in question.
FloodRequestRushIndicator	MISMOIndicator	BIT	NO	Indicates that this order has a high priority in need for completion.
FloodTransactionIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A unique tracking identifier assigned by the sender which is typically returned to the sender in the resulting response.
NewServicerAccountIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The vendor account code assigned to the Lender who receives the transfer.
OrderingSystemName	MISMOString	VARCHAR(0)	NO	The name of the system that originated the order.
OrderingSystemVersionIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The version of the system that originated the order.
OriginalFloodDeterminationLoanIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The loan number assigned to the original flood determination order. Used for identifying a loan that has been previously certified (e.g., refi, second, servicing transfer, etc.)

FLOOD_REQUEST_DETAIL Keys

Key Name

Key Type

Keys

FLOOD_REQUEST_DETAIL Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

FLOOD_REQUEST_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

FLOOD_REQUEST_DETAIL Bound Attachments

Name	Current Value

FLOOD_REQUEST_DETAIL User-Defined Mappings

Model

Name

Description

FLOOD_REQUEST_DETAIL Data Movement Rules

Name

Type

Rule Text/Value