STATUS_CHANGE_EVENT Attribute Details

InvestorReportingActionDate

Base Entity	STATUS_CHANGE_EVENT
Attribute Name	InvestorReportingActionDate
Logical Rolename
ColumnName	InvestorReportingActionDate
RoleName
Domain	MISMODate
Definition	The actual date associated with the reported Investor Reporting Action Type.
Note

InvestorReportingActionDate Logical Attribute Properties

Logical Attribute Name InvestorReportingActionDate

Datatype DATE

Nullable NO

InvestorReportingActionDate Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

InvestorReportingActionDate Bound Attachments

Name Current Value

InvestorReportingActionDate User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

InvestorReportingActionDate Direct Source Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionDate Secondary Source Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionDate Direct Target Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionDate Secondary Target Mappings

Columns Transformation Logic Transformation Description

SequenceNumber

Base Entity	STATUS_CHANGE_EVENT
Attribute Name	SequenceNumber
Logical Rolename
ColumnName	SequenceNumber
RoleName
Domain	XSD:Integer
Definition	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
Note

SequenceNumber Logical Attribute Properties

Logical Attribute Name SequenceNumber

Datatype INTEGER

Nullable YES

SequenceNumber Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

SequenceNumber Bound Attachments

Name Current Value

SequenceNumber User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

SequenceNumber Direct Source Mappings

Columns Transformation Logic Transformation Description

SequenceNumber Secondary Source Mappings

Columns Transformation Logic Transformation Description

SequenceNumber Direct Target Mappings

Columns Transformation Logic Transformation Description

SequenceNumber Secondary Target Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionType

Base Entity	STATUS_CHANGE_EVENT
Attribute Name	InvestorReportingActionType
Logical Rolename
ColumnName	InvestorReportingActionType
RoleName
Domain	InvestorReportingActionEnum
Definition	The Reporting System status of the loan as reported to the investor.
Note

InvestorReportingActionType Logical Attribute Properties

Logical Attribute Name InvestorReportingActionType

Datatype VARCHAR(0)

Nullable YES

InvestorReportingActionType Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

InvestorReportingActionType Reference Value (Bound to Domain)

Name ValidationRule237

Description

Type By List

Value Value Description

ExerciseSkipPay A change in loan status due to a borrower request to exercise the skip payment feature.

ForeclosureLiquidatedHeldForSale A change in loan status due to the foreclosure sale of the borrowers property to pay off a defaulted loan. The property is currently held for sale.

ForeclosureLiquidatedPendingConveyance A change in loan status due to the foreclosure sale of the borrowers property to pay off a defaulted loan. The property is awaiting conveyance to purchaser.

ForeclosureLiquidatedThirdPartySale A change in loan status due to the foreclosure sale of the borrowers property to pay off a defaulted loan. Property has been sold and conveyed to someone other than the mortgagee or mortgagor.

Inactive Inactive

LiquidatedHeldForSale LiquidatedHeldForSale

MICancellationAutomaticTermination A change in loan status due to automatic mortgage insurance cancellation provisions.

MICancellationBasedOnCurrentPropertyValue A change in loan status due to mortgage insurance cancellation based on current property value.

MICancellationBasedOnMandatoryTermination A change in loan status due to mandatory mortgage insurance cancellation.

MICancellationBasedOnOriginalPropertyValue A change in loan status due to mortgage insurance cancellation based on original property value.

Other Other

PaidInFullAtMaturity The loan is paid in full at the loans maturity date where the last payment has been received.

PaidInFullPriorToMaturity The loan is paid in full and the action date is prior to the loans maturity date.

Payoff A change in the mortgages interest rate or PI Payment related to an Adjustable Rate Mortgage contract.

Repurchase A repurchase due to the fact that the loan does not meet or no longer meets the contract parameters (a quality control issue).

RepurchaseDueToARMConversionToFixedRate A repurchase due to the fact that the loan characteristics are being modified so that the loan no longer meets the ARM contract parameters. Loan is often repurchased by the Investor after the modification under a different contract.

InvestorReportingActionType Bound Attachments

Name Current Value

InvestorReportingActionType User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

InvestorReportingActionType Direct Source Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionType Secondary Source Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionType Direct Target Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionType Secondary Target Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionTypeOtherDescription

Base Entity	STATUS_CHANGE_EVENT
Attribute Name	InvestorReportingActionTypeOtherDescription
Logical Rolename
ColumnName	InvestorReportingActionTypeOtherDescription
RoleName
Domain	MISMOString
Definition	A free-form text field used to capture the Investor Reporting Action type if Other is selected as the Investor Reporting Action type.
Note

InvestorReportingActionTypeOtherDescription Logical Attribute Properties

Logical Attribute Name InvestorReportingActionTypeOtherDescription

Datatype VARCHAR(0)

Nullable NO

InvestorReportingActionTypeOtherDescription Domain Restrictions

CheckConstraint

Check Constraint Name

Bound Rule

Declared Default

Bound Default

InvestorReportingActionTypeOtherDescription Bound Attachments

Name Current Value

InvestorReportingActionTypeOtherDescription User-Defined Mappings

Model Name RoleName Parent Entity Datatype Domain Description

InvestorReportingActionTypeOtherDescription Direct Source Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionTypeOtherDescription Secondary Source Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionTypeOtherDescription Direct Target Mappings

Columns Transformation Logic Transformation Description

InvestorReportingActionTypeOtherDescription Secondary Target Mappings

Columns Transformation Logic Transformation Description

Logical Attribute Name	InvestorReportingActionDate
Datatype	DATE
Nullable	NO

CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Value	Value Description
ExerciseSkipPay	A change in loan status due to a borrower request to exercise the skip payment feature.
ForeclosureLiquidatedHeldForSale	A change in loan status due to the foreclosure sale of the borrowers property to pay off a defaulted loan. The property is currently held for sale.
ForeclosureLiquidatedPendingConveyance	A change in loan status due to the foreclosure sale of the borrowers property to pay off a defaulted loan. The property is awaiting conveyance to purchaser.
ForeclosureLiquidatedThirdPartySale	A change in loan status due to the foreclosure sale of the borrowers property to pay off a defaulted loan. Property has been sold and conveyed to someone other than the mortgagee or mortgagor.
Inactive	Inactive
LiquidatedHeldForSale	LiquidatedHeldForSale
MICancellationAutomaticTermination	A change in loan status due to automatic mortgage insurance cancellation provisions.
MICancellationBasedOnCurrentPropertyValue	A change in loan status due to mortgage insurance cancellation based on current property value.
MICancellationBasedOnMandatoryTermination	A change in loan status due to mandatory mortgage insurance cancellation.
MICancellationBasedOnOriginalPropertyValue	A change in loan status due to mortgage insurance cancellation based on original property value.
Other	Other
PaidInFullAtMaturity	The loan is paid in full at the loans maturity date where the last payment has been received.
PaidInFullPriorToMaturity	The loan is paid in full and the action date is prior to the loans maturity date.
Payoff	A change in the mortgages interest rate or PI Payment related to an Adjustable Rate Mortgage contract.
Repurchase	A repurchase due to the fact that the loan does not meet or no longer meets the contract parameters (a quality control issue).
RepurchaseDueToARMConversionToFixedRate	A repurchase due to the fact that the loan characteristics are being modified so that the loan no longer meets the ARM contract parameters. Loan is often repurchased by the Investor after the modification under a different contract.