| ArmsLengthIndicator |
| Base Entity | SALES_HISTORY |
| Attribute Name | ArmsLengthIndicator |
| Logical Rolename | |
| ColumnName | ArmsLengthIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that this is an Arms Length Transaction. An Arms length transaction is between a willing buyer and a willing seller with no undue influence on either party and there is no relationship between the parties except that of the specific transaction. |
| Note |
| ArmsLengthIndicator Logical Attribute Properties |
| Logical Attribute Name | ArmsLengthIndicator |
| Datatype | BIT |
| Nullable | NO |
| ArmsLengthIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ArmsLengthIndicator Bound Attachments |
| Name | Current Value |
| ArmsLengthIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ArmsLengthIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | SALES_HISTORY |
| 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 |
| OwnershipTransferDate |
| Base Entity | SALES_HISTORY |
| Attribute Name | OwnershipTransferDate |
| Logical Rolename | |
| ColumnName | OwnershipTransferDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date of the transfer of ownership of real property as recognized in the jurisdiction in which it is located. |
| Note |
| OwnershipTransferDate Logical Attribute Properties |
| Logical Attribute Name | OwnershipTransferDate |
| Datatype | DATE |
| Nullable | NO |
| OwnershipTransferDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OwnershipTransferDate Bound Attachments |
| Name | Current Value |
| OwnershipTransferDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OwnershipTransferDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionAmount |
| Base Entity | SALES_HISTORY |
| Attribute Name | OwnershipTransferTransactionAmount |
| Logical Rolename | |
| ColumnName | OwnershipTransferTransactionAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The amount of transaction (typically the sale price) related to the transfer of ownership of real property as recognized in the jurisdiction in which it is located. |
| Note |
| OwnershipTransferTransactionAmount Logical Attribute Properties |
| Logical Attribute Name | OwnershipTransferTransactionAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| OwnershipTransferTransactionAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OwnershipTransferTransactionAmount Bound Attachments |
| Name | Current Value |
| OwnershipTransferTransactionAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OwnershipTransferTransactionAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionType |
| Base Entity | SALES_HISTORY |
| Attribute Name | OwnershipTransferTransactionType |
| Logical Rolename | |
| ColumnName | OwnershipTransferTransactionType |
| RoleName | |
| Domain | OwnershipTransferTransactionEnum |
| Definition | The type of ownership transfer of real property as recognized in the jurisdiction in which it is located. |
| Note |
| OwnershipTransferTransactionType Logical Attribute Properties |
| Logical Attribute Name | OwnershipTransferTransactionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| OwnershipTransferTransactionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OwnershipTransferTransactionType Reference Value (Bound to Domain) |
| Name | ValidationRule345 |
| Description | |
| Type | By List |
| Value | Value Description |
| CashSale | CashSale |
| DeedTransferOnly | DeedTransferOnly |
| Other | Other |
| OwnershipTransferTransactionType Bound Attachments |
| Name | Current Value |
| OwnershipTransferTransactionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OwnershipTransferTransactionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionTypeOtherDescription |
| Base Entity | SALES_HISTORY |
| Attribute Name | OwnershipTransferTransactionTypeOtherDescription |
| Logical Rolename | |
| ColumnName | OwnershipTransferTransactionTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Ownership Transfer Transaction Type. |
| Note |
| OwnershipTransferTransactionTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | OwnershipTransferTransactionTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| OwnershipTransferTransactionTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OwnershipTransferTransactionTypeOtherDescription Bound Attachments |
| Name | Current Value |
| OwnershipTransferTransactionTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OwnershipTransferTransactionTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OwnershipTransferTransactionTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleType |
| Base Entity | SALES_HISTORY |
| Attribute Name | SaleType |
| Logical Rolename | |
| ColumnName | SaleType |
| RoleName | |
| Domain | SaleEnum |
| Definition | Quantifies the type of sales transaction for the property as indicated from the analysis of the sales contract. |
| Note |
| SaleType Logical Attribute Properties |
| Logical Attribute Name | SaleType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| SaleType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SaleType Reference Value (Bound to Domain) |
| Name | ValidationRule437 |
| Description | |
| Type | By List |
| Value | Value Description |
| CourtOrderedNonForeclosureSale | A sale in which a judge has ordered the sale of the property as a dispute resolution. Usually two people own it, one wants to sell, the other does not. The one wanting to sell always wins if the other refuses to buy them out. This could be a divorce or it could be an inherited property with multiple siblings. |
| EstateSale | The most common reason for an estate sale is the death of the property owner, and the consequent need to quickly liquidate the belongings of the deceased. An estate sale may also occur because the property owner will be moving into a situation where he will be unable to keep his property—for example, a move to an assisted living facility, a retirement community, a rest home, or other living quarters. |
| Other | Other |
| RelocationSale | A property being sold as a part of an relocation program paid by an employer to assist an employee in liquidating a home. |
| REOPostForeclosureSale | The sale of a property from inventory that has been foreclosed and taken possession of by the lien holder. |
| ShortSale | A sale of property in which the lien holder accepts less than the debt or obligation against the property. |
| TrusteeJudicialForeclosureSale | A judicial foreclosure process using a trustee. A Trustee Sale is a public auction that is open to all bidders and the property is usually awarded to the highest bidder who meets all the criteria set by the Trustee. A trustee is an entity or company chosen to administer the assets of the beneficiary and facilitate the foreclosure process. Once underway, a judicial foreclosure can only be stopped by payment in full. |
| TrusteeNonJudicialForeclosureSale | A non-judicial foreclosure process. In a trustee sale, the lender files a Notice of Default and a notice is posted on the property indicating a trustee sale will be held at least 90 days later, generally but not always at the county courthouse steps. Unlike a foreclosure where the homeowners lone recourse is to redeem the full amount of the loan, an owner can stop a trustee sale simply by getting current on his or her mortgage payments plus any interest and fees that have been added along the way. A homeowner can do this at any time up to the posted time of the trustee sale and the entire process comes to a halt. |
| SaleType Bound Attachments |
| Name | Current Value |
| SaleType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SaleType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleTypeOtherDescription |
| Base Entity | SALES_HISTORY |
| Attribute Name | SaleTypeOtherDescription |
| Logical Rolename | |
| ColumnName | SaleTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additioal information when Other is selected for the ListingStatusType. |
| Note |
| SaleTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | SaleTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SaleTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SaleTypeOtherDescription Bound Attachments |
| Name | Current Value |
| SaleTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SaleTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SaleTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |