MI_REQUEST_DETAIL Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
InvestorProgramNameType	InvestorProgramNameEnum	VARCHAR(0)	YES	To identify loans originated for specific investor programs.
InvestorProgramNameTypeOtherDescription	MISMOString	VARCHAR(0)	NO	When Other is specified in Investor Program Name Type, this element contains the description.
MICompanyNameType	MICompanyNameEnum	VARCHAR(0)	YES	To convey the private MI company short/common name from whom the private mortgage insurance coverage was obtained.
MICompanyNameTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the mortgage insurance company name if Other is selected as the mortgage insurance company name.
MIRequestType	MIRequestEnum	VARCHAR(0)	YES	To distinguish an original request application for private mortgage insurance from any subsequent requests for the same loan, and from the MIs response to the order.
MIRequestTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to capture the description of the type of MI Request if Other is selected as the MIRequestType.

MI_REQUEST_DETAIL Keys

Key Name

Key Type

Keys

MI_REQUEST_DETAIL Relationships

Parent Relationships:

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

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

MI_REQUEST_DETAIL Check Constraints

Check Constraint Name

CheckConstraint

MI_REQUEST_DETAIL Bound Attachments

Name	Current Value

MI_REQUEST_DETAIL User-Defined Mappings

Model

Name

Description

MI_REQUEST_DETAIL Data Movement Rules

Name

Type

Rule Text/Value