OPTIONAL_PRODUCT 
EntityType  Dependent 
Logical Entity Name  OPTIONAL_PRODUCT 
Default Table Name  DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/OPTIONAL_PRODUCTS/OPTIONAL_PRODUCT 
Definition  Information specific to life, accident, health and other insurance, or other optional product, paid through the mortgage payment. 
Note 
 

OPTIONAL_PRODUCT Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
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. 
OptionalProductCancellationReasonType  OptionalProductCancellationReasonEnum  VARCHAR(0)  YES  Indicates the reason for cancellation of the associated optional product.
 
OptionalProductCancellationReasonTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when Other is selected for Optional Product Cancellation Reason Type. 
OptionalProductChangeType  OptionalProductChangeEnum  VARCHAR(0)  YES  Indicates the type of change to the associated optional product.
 
OptionalProductChangeTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free form text field used to collect additional information when other is selected for Optional Product Change Type. 
OptionalProductEffectiveDate  MISMODate  DATE  NO  Indicates the type of change to the associated optional product. 
OptionalProductExpirationDate  MISMODate  DATE  NO  The scheduled termination date, if any, of an optional product plan or agreement. 
OptionalProductPayeeIdentifier  MISMOIdentifier  VARCHAR(0)  NO  The payee code for the company that sells the optional product. The Optional Product Premiums will be paid to this payee. 
OptionalProductPaymentAmount  MISMOAmount  DECIMAL(0, 2)  NO  The amount currently collected with the mortgagors periodic mortgage payment for the optional product. 
OptionalProductPendingChangeEffectiveDate  MISMODate  DATE  NO  The due date of the pending add, change modification, or delete cancellation to the optional product payment plan. 
OptionalProductPendingPaymentAmount  MISMOAmount  DECIMAL(0, 2)  NO  The pending amount for the optional product to be collected with the mortgagors periodic mortgage payment. 
OptionalProductPlanType  OptionalProductPlanEnum  VARCHAR(0)  YES  The type of product purchased by the borrower from a third party, where the servicer collects funds from the borrower, normally included with the periodic mortgage payment, and remits funds to the third party.
 
OptionalProductPlanTypeOtherDescription  MISMOString  VARCHAR(0)  NO  A free-form text field to describe an optional product that is not one of the enumerated type values. 
OptionalProductProviderAccountIdentifier  MISMOIdentifier  VARCHAR(0)  NO  An account identifier used by the product provider to identify this account in its own systems. For an optional insurance plan this would be the insurance plan certificate numbers assigned by the insurance company 
OptionalProductProvidersPlanIdentifier  MISMOIdentifier  VARCHAR(0)  NO  A code provided by the third party that identifies the optional product, and that can be used by the servicer and the third party for reconciling activity related to a specific product. 
OptionalProductRemittanceDueDate  MISMODate  DATE  NO  Due date of next remittance payment due to the provider (may be different from mortgage due date). 
OptionalProductRemittancePerYearCount  MISMOCount  INTEGER  NO  How often, described as number of times per year, that funds are remitted to the third-party. 

OPTIONAL_PRODUCT Keys 
Key Name  Key Type  Keys 

OPTIONAL_PRODUCT Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
OPTIONAL_PRODUCTS  Identifying  One To Zero or More          NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

OPTIONAL_PRODUCT Check Constraints 
Check Constraint Name  CheckConstraint 

OPTIONAL_PRODUCT Bound Attachments 
Name  Current Value 

OPTIONAL_PRODUCT User-Defined Mappings 
Model  Name  Description 

OPTIONAL_PRODUCT Data Movement Rules 
Name  Type  Rule Text/Value