AlimonyOwedToName |
Base Entity | EXPENSE |
Attribute Name | AlimonyOwedToName |
Logical Rolename | |
ColumnName | AlimonyOwedToName |
RoleName | |
Domain | MISMOString |
Definition | The unstructured name of the person to whom alimony payments are owed by the borrower. Collected on the URLA in Section VI (Liabilities Alimony Owed To). |
Note |
AlimonyOwedToName Logical Attribute Properties |
Logical Attribute Name | AlimonyOwedToName |
Datatype | VARCHAR(0) |
Nullable | NO |
AlimonyOwedToName Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AlimonyOwedToName Bound Attachments |
Name | Current Value |
AlimonyOwedToName User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
AlimonyOwedToName Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AlimonyOwedToName Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AlimonyOwedToName Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AlimonyOwedToName Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SequenceNumber |
Base Entity | EXPENSE |
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 |
ExpenseDescription |
Base Entity | EXPENSE |
Attribute Name | ExpenseDescription |
Logical Rolename | |
ColumnName | ExpenseDescription |
RoleName | |
Domain | MISMOString |
Definition | A text description that further defines the expense. This could be used to describe the job related expenses. |
Note |
ExpenseDescription Logical Attribute Properties |
Logical Attribute Name | ExpenseDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ExpenseDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ExpenseDescription Bound Attachments |
Name | Current Value |
ExpenseDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ExpenseDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseMonthlyPaymentAmount |
Base Entity | EXPENSE |
Attribute Name | ExpenseMonthlyPaymentAmount |
Logical Rolename | |
ColumnName | ExpenseMonthlyPaymentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount of the monthly payment required on borrowers Expense Type. |
Note |
ExpenseMonthlyPaymentAmount Logical Attribute Properties |
Logical Attribute Name | ExpenseMonthlyPaymentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
ExpenseMonthlyPaymentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ExpenseMonthlyPaymentAmount Bound Attachments |
Name | Current Value |
ExpenseMonthlyPaymentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ExpenseMonthlyPaymentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseMonthlyPaymentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseMonthlyPaymentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseMonthlyPaymentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseRemainingTermMonthsCount |
Base Entity | EXPENSE |
Attribute Name | ExpenseRemainingTermMonthsCount |
Logical Rolename | |
ColumnName | ExpenseRemainingTermMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of months the borrower must make payments in order to satisfy the identified expense. |
Note |
ExpenseRemainingTermMonthsCount Logical Attribute Properties |
Logical Attribute Name | ExpenseRemainingTermMonthsCount |
Datatype | INTEGER |
Nullable | NO |
ExpenseRemainingTermMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ExpenseRemainingTermMonthsCount Bound Attachments |
Name | Current Value |
ExpenseRemainingTermMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ExpenseRemainingTermMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseRemainingTermMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseRemainingTermMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseRemainingTermMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseType |
Base Entity | EXPENSE |
Attribute Name | ExpenseType |
Logical Rolename | |
ColumnName | ExpenseType |
RoleName | |
Domain | ExpenseEnum |
Definition | Specifies the general names (types) of items commonly listed as expenses of the borrower in a mortgage loan transaction. |
Note |
ExpenseType Logical Attribute Properties |
Logical Attribute Name | ExpenseType |
Datatype | VARCHAR(0) |
Nullable | YES |
ExpenseType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ExpenseType Reference Value (Bound to Domain) |
Name | ValidationRule158 |
Description | |
Type | By List |
Value | Value Description |
Alimony | Periodic amount paid under terms of divorce decree/agreement. Collected on the URLA in Section VI (Liabilities). |
ChildCare | Periodic costs of providing care for having the borrowers dependents. Collected on the URLA in Section VI (Liabilities - Job Related Expenses.) |
ChildSupport | Periodic amount paid to provide for children after divorce or separation. Collected on the URLA in Section VI (Liabilities - Alimony). |
JobRelatedExpenses | Ongoing obligations incurred by the borrower which are prerequisite to retaining employment (e.g., professional associations, special uniforms or tools, etc.) Collected on the URLA in Section VI (Liabilities - Job Related Expenses) |
Other | Other |
SeparateMaintenanceExpense | Periodic amount paid under terms of separation agreement. Collected on the URLA in Section VI (Liabilities - Alimony.) |
UnionDues | Union membership dues borrower incurs as a condition of remaining employment through union (e.g., a closed shop). Collected on the URLA in Section VI (Liabilities - Job Related Expenses.) |
ExpenseType Bound Attachments |
Name | Current Value |
ExpenseType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ExpenseType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseTypeOtherDescription |
Base Entity | EXPENSE |
Attribute Name | ExpenseTypeOtherDescription |
Logical Rolename | |
ColumnName | ExpenseTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Expense Type. |
Note |
ExpenseTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | ExpenseTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
ExpenseTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ExpenseTypeOtherDescription Bound Attachments |
Name | Current Value |
ExpenseTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ExpenseTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ExpenseTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |