AUTOMATED_UNDERWRITING Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
AutomatedUnderwritingCaseIdentifier	MISMOIdentifier	VARCHAR(0)	NO	A unique identifier assigned by the underwriting system to the underwriting case for a specific loan application.
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
AutomatedUnderwritingDecisionDatetime	MISMODatetime	TIMESTAMP/DATE	NO	The date and time of the underwriting decision.
AutomatedUnderwritingEvaluationStatusDescription	MISMOString	VARCHAR(0)	NO	The status of the Automated Underwriting Certificate Request.
AutomatedUnderwritingMethodVersionIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Specifies the version of the Automated underwriting system used to underwrite the loan. Move from Underwriting Detail to Automated Underwriting.
AutomatedUnderwritingProcessDescription	MISMOString	VARCHAR(0)	NO	A free form text description of the automated underwriting process or procedure used on the loan.
AutomatedUnderwritingRecommendationDescription	MISMOString	VARCHAR(0)	NO	The loan approval recommendation determined by the Automated Underwriting system.
AutomatedUnderwritingSystemDocumentWaiverIndicator	MISMOIndicator	BIT	NO	When a returned AU system recommendation indicates that some or all of the loan information is not required to be formally documented in the loan submission package, e.g., no requirement to provide a wage statement, tax returns, etc. A loan of this type
AutomatedUnderwritingSystemResultValue	MISMOValue	VARCHAR(0)	NO	The result of the private automated underwriting evaluation system.
AutomatedUnderwritingSystemType	AutomatedUnderwritingSystemEnum	VARCHAR(0)	YES	The type of automated underwriting system used to evaluate the loan.
AutomatedUnderwritingSystemTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to collect additional information when Other is selected for Automated Underwriting System Type.
DesktopUnderwriterRecommendationType	DesktopUnderwriterRecommendationEnum	VARCHAR(0)	YES	To convey the DU recommendation.
FREPurchaseEligibilityType	FREPurchaseEligibilityEnum	VARCHAR(0)	YES	To convey the Freddie Mac purchase eligibility.
LoanProspectorCreditRiskClassificationDescription	MISMOString	VARCHAR(0)	NO	The Loan Prospector credit risk classification for a loan.
LoanProspectorDocumentationClassificationDescription	MISMOString	VARCHAR(0)	NO	The Loan Prospector documentation classification for the loan.

AUTOMATED_UNDERWRITING Keys

Key Name

Key Type

Keys

AUTOMATED_UNDERWRITING Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
AUTOMATED_UNDERWRITINGS	Identifying	One To Zero or More					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

AUTOMATED_UNDERWRITING Check Constraints

Check Constraint Name

CheckConstraint

AUTOMATED_UNDERWRITING Bound Attachments

Name	Current Value

AUTOMATED_UNDERWRITING User-Defined Mappings

Model

Name

Description

AUTOMATED_UNDERWRITING Data Movement Rules

Name

Type

Rule Text/Value