| AdditionalProjectConsiderationsType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | AdditionalProjectConsiderationsType |
| Logical Rolename | |
| ColumnName | AdditionalProjectConsiderationsType |
| RoleName | |
| Domain | AdditionalProjectConsiderationsEnum |
| Definition | Describes the specific ownership or use of the project. |
| Note |
| AdditionalProjectConsiderationsType Logical Attribute Properties |
| Logical Attribute Name | AdditionalProjectConsiderationsType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| AdditionalProjectConsiderationsType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdditionalProjectConsiderationsType Reference Value (Bound to Domain) |
| Name | ValidationRule8 |
| Description | |
| Type | By List |
| Value | Value Description |
| CondoHotel | CondoHotel |
| Other | Other |
| Timeshare | Timeshare |
| AdditionalProjectConsiderationsType Bound Attachments |
| Name | Current Value |
| AdditionalProjectConsiderationsType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdditionalProjectConsiderationsType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsTypeOtherDescription |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | AdditionalProjectConsiderationsTypeOtherDescription |
| Logical Rolename | |
| ColumnName | AdditionalProjectConsiderationsTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Additional Project Considerations Type. |
| Note |
| AdditionalProjectConsiderationsTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | AdditionalProjectConsiderationsTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AdditionalProjectConsiderationsTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AdditionalProjectConsiderationsTypeOtherDescription Bound Attachments |
| Name | Current Value |
| AdditionalProjectConsiderationsTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AdditionalProjectConsiderationsTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AdditionalProjectConsiderationsTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CondominiumProjectStatusType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | CondominiumProjectStatusType |
| Logical Rolename | |
| ColumnName | CondominiumProjectStatusType |
| RoleName | |
| Domain | CondominiumProjectStatusEnum |
| Definition | Specifies the current state of the condominium project. |
| Note |
| CondominiumProjectStatusType Logical Attribute Properties |
| Logical Attribute Name | CondominiumProjectStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| CondominiumProjectStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CondominiumProjectStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule64 |
| Description | |
| Type | By List |
| Value | Value Description |
| Established | A condominium project that is 100% complete, and not subject to additional phasing, and at least 90% of the total number of units have been conveyed to unit owners, and the unit owners control the home owners association. |
| New | A condominium project that is not 100% complete, or subject to additional phasing, or less than 90% of the total number of units have conveyed to unit owners, or the unit owners do not control the home owners association. |
| CondominiumProjectStatusType Bound Attachments |
| Name | Current Value |
| CondominiumProjectStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CondominiumProjectStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CondominiumProjectStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CondominiumProjectStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CondominiumProjectStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCondominiumProjectManagerProjectIdentifier |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | FNMCondominiumProjectManagerProjectIdentifier |
| Logical Rolename | |
| ColumnName | FNMCondominiumProjectManagerProjectIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The unique identifier of a property development project to which individual properties belong assigned by the Fannie Mae Condo Project Manager (CPM) system. |
| Note |
| FNMCondominiumProjectManagerProjectIdentifier Logical Attribute Properties |
| Logical Attribute Name | FNMCondominiumProjectManagerProjectIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FNMCondominiumProjectManagerProjectIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FNMCondominiumProjectManagerProjectIdentifier Bound Attachments |
| Name | Current Value |
| FNMCondominiumProjectManagerProjectIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FNMCondominiumProjectManagerProjectIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCondominiumProjectManagerProjectIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCondominiumProjectManagerProjectIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FNMCondominiumProjectManagerProjectIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAmenityImprovementsCompletedIndicator |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectAmenityImprovementsCompletedIndicator |
| Logical Rolename | |
| ColumnName | ProjectAmenityImprovementsCompletedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether construction on the project amenities such as pool and clubhouse have been completed. |
| Note |
| ProjectAmenityImprovementsCompletedIndicator Logical Attribute Properties |
| Logical Attribute Name | ProjectAmenityImprovementsCompletedIndicator |
| Datatype | BIT |
| Nullable | NO |
| ProjectAmenityImprovementsCompletedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectAmenityImprovementsCompletedIndicator Bound Attachments |
| Name | Current Value |
| ProjectAmenityImprovementsCompletedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectAmenityImprovementsCompletedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAmenityImprovementsCompletedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAmenityImprovementsCompletedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAmenityImprovementsCompletedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAttachmentType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectAttachmentType |
| Logical Rolename | |
| ColumnName | ProjectAttachmentType |
| RoleName | |
| Domain | ProjectAttachmentEnum |
| Definition | Specifies the type of physical attachment, if any, between the dwelling units in the project. |
| Note |
| ProjectAttachmentType Logical Attribute Properties |
| Logical Attribute Name | ProjectAttachmentType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ProjectAttachmentType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectAttachmentType Reference Value (Bound to Domain) |
| Name | ValidationRule386 |
| Description | |
| Type | By List |
| Value | Value Description |
| Attached | Attached |
| Detached | Detached |
| ProjectAttachmentType Bound Attachments |
| Name | Current Value |
| ProjectAttachmentType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectAttachmentType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAttachmentType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAttachmentType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectAttachmentType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectClassificationIdentifier |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectClassificationIdentifier |
| Logical Rolename | |
| ColumnName | ProjectClassificationIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifies the type of project or condominium classification for the subject property and its associated review. |
| Note |
| ProjectClassificationIdentifier Logical Attribute Properties |
| Logical Attribute Name | ProjectClassificationIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProjectClassificationIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectClassificationIdentifier Bound Attachments |
| Name | Current Value |
| ProjectClassificationIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectClassificationIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectClassificationIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectClassificationIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectClassificationIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectContainsMultipleDwellingUnitsDataSourceDescription |
| Logical Rolename | |
| ColumnName | ProjectContainsMultipleDwellingUnitsDataSourceDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe the source of the information used to set the Project Contains Multiple Dwelling Units Indicator. |
| Note |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Logical Attribute Properties |
| Logical Attribute Name | ProjectContainsMultipleDwellingUnitsDataSourceDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Bound Attachments |
| Name | Current Value |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsDataSourceDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsIndicator |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectContainsMultipleDwellingUnitsIndicator |
| Logical Rolename | |
| ColumnName | ProjectContainsMultipleDwellingUnitsIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the project contains multiple dwelling-units. |
| Note |
| ProjectContainsMultipleDwellingUnitsIndicator Logical Attribute Properties |
| Logical Attribute Name | ProjectContainsMultipleDwellingUnitsIndicator |
| Datatype | BIT |
| Nullable | NO |
| ProjectContainsMultipleDwellingUnitsIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectContainsMultipleDwellingUnitsIndicator Bound Attachments |
| Name | Current Value |
| ProjectContainsMultipleDwellingUnitsIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectContainsMultipleDwellingUnitsIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectContainsMultipleDwellingUnitsIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectDesignType |
| Logical Rolename | |
| ColumnName | ProjectDesignType |
| RoleName | |
| Domain | ProjectDesignEnum |
| Definition | This field specifies the type of design for the multiple unit buildings in a project. |
| Note |
| ProjectDesignType Logical Attribute Properties |
| Logical Attribute Name | ProjectDesignType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ProjectDesignType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectDesignType Reference Value (Bound to Domain) |
| Name | ValidationRule387 |
| Description | |
| Type | By List |
| Value | Value Description |
| GardenProject | GardenProject |
| HighriseProject | HighriseProject |
| MidriseProject | MidriseProject |
| Other | Other |
| TownhouseRowhouse | One in a row of identical houses or having common wall. Attached to another unit via common wall (e.g., a brownstone.) |
| ProjectDesignType Bound Attachments |
| Name | Current Value |
| ProjectDesignType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectDesignType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignTypeOtherDescription |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectDesignTypeOtherDescription |
| Logical Rolename | |
| ColumnName | ProjectDesignTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe the design if Other is selected as the Project Design Type. |
| Note |
| ProjectDesignTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | ProjectDesignTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProjectDesignTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectDesignTypeOtherDescription Bound Attachments |
| Name | Current Value |
| ProjectDesignTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectDesignTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDesignTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitCount |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectDwellingUnitCount |
| Logical Rolename | |
| ColumnName | ProjectDwellingUnitCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | Total number of individual dwelling units in the project. |
| Note |
| ProjectDwellingUnitCount Logical Attribute Properties |
| Logical Attribute Name | ProjectDwellingUnitCount |
| Datatype | INTEGER |
| Nullable | NO |
| ProjectDwellingUnitCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectDwellingUnitCount Bound Attachments |
| Name | Current Value |
| ProjectDwellingUnitCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectDwellingUnitCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitsSoldCount |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectDwellingUnitsSoldCount |
| Logical Rolename | |
| ColumnName | ProjectDwellingUnitsSoldCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of units in a building, project or development that have been sold to date. |
| Note |
| ProjectDwellingUnitsSoldCount Logical Attribute Properties |
| Logical Attribute Name | ProjectDwellingUnitsSoldCount |
| Datatype | INTEGER |
| Nullable | NO |
| ProjectDwellingUnitsSoldCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectDwellingUnitsSoldCount Bound Attachments |
| Name | Current Value |
| ProjectDwellingUnitsSoldCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectDwellingUnitsSoldCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitsSoldCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitsSoldCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectDwellingUnitsSoldCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectEligibilityDeterminationType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectEligibilityDeterminationType |
| Logical Rolename | |
| ColumnName | ProjectEligibilityDeterminationType |
| RoleName | |
| Domain | ProjectEligibilityDeterminationEnum |
| Definition | Specifies the level of review performed to determine that a project meets eligibility guidelines for purchase by the investor. |
| Note |
| ProjectEligibilityDeterminationType Logical Attribute Properties |
| Logical Attribute Name | ProjectEligibilityDeterminationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ProjectEligibilityDeterminationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectEligibilityDeterminationType Reference Value (Bound to Domain) |
| Name | ValidationRule388 |
| Description | |
| Type | By List |
| Value | Value Description |
| FullReview | FullReview |
| LimitedReview | LimitedReview |
| ProjectEligibilityReviewService | Fannie Mae Project Eligibility Review Service, aka PERS |
| ProjectEligibilityDeterminationType Bound Attachments |
| Name | Current Value |
| ProjectEligibilityDeterminationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectEligibilityDeterminationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectEligibilityDeterminationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectEligibilityDeterminationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectEligibilityDeterminationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectLegalStructureType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectLegalStructureType |
| Logical Rolename | |
| ColumnName | ProjectLegalStructureType |
| RoleName | |
| Domain | ProjectLegalStructureEnum |
| Definition | Specifies the form of ownership that defines the quality and quantity of ownership and rights to the individual unit owner. |
| Note |
| ProjectLegalStructureType Logical Attribute Properties |
| Logical Attribute Name | ProjectLegalStructureType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ProjectLegalStructureType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectLegalStructureType Reference Value (Bound to Domain) |
| Name | ValidationRule390 |
| Description | |
| Type | By List |
| Value | Value Description |
| CommonInterestApartment | Any project or building that is owned by several owners as tenants in common or by a home owners association in which individuals have an undivided interest in a residential apartment building and land, and are the rights of exclusive occupancy of a specific apartment in the building. |
| Condominium | A project that is legally formed as a condominium under the Condominium-Enabling Legislation of the state in which the project is located. |
| Cooperative | A project in which a corporation or business trust holds title to the property and issues shares of stock as evidence of ownership in the corporation or business trust. The corporation or business trust grants occupancy rights to the shareholder tenants through proprietary leases. |
| ProjectLegalStructureType Bound Attachments |
| Name | Current Value |
| ProjectLegalStructureType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectLegalStructureType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectLegalStructureType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectLegalStructureType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectLegalStructureType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectName |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectName |
| Logical Rolename | |
| ColumnName | ProjectName |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the project in which subject property is located (e.g., the name of the condominium or cooperative). |
| Note |
| ProjectName Logical Attribute Properties |
| Logical Attribute Name | ProjectName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ProjectName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectName Bound Attachments |
| Name | Current Value |
| ProjectName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUDIndicator |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | PUDIndicator |
| Logical Rolename | |
| ColumnName | PUDIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the project in which the subject property is located is a Planned Unit Development (PUD). A comprehensive development plan for a large land area. A PUD usually includes residences, roads, schools, recreational facilities, commercial, office |
| Note |
| PUDIndicator Logical Attribute Properties |
| Logical Attribute Name | PUDIndicator |
| Datatype | BIT |
| Nullable | NO |
| PUDIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUDIndicator Bound Attachments |
| Name | Current Value |
| PUDIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PUDIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUDIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUDIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUDIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectPrimaryUsageType |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | ProjectPrimaryUsageType |
| Logical Rolename | |
| ColumnName | ProjectPrimaryUsageType |
| RoleName | |
| Domain | ProjectPrimaryUsageEnum |
| Definition | Specifies the primary type of occupancy of the Project. |
| Note |
| ProjectPrimaryUsageType Logical Attribute Properties |
| Logical Attribute Name | ProjectPrimaryUsageType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ProjectPrimaryUsageType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ProjectPrimaryUsageType Reference Value (Bound to Domain) |
| Name | ValidationRule382 |
| Description | |
| Type | By List |
| Value | Value Description |
| Investment | A home owned for the purpose of generating income by renting the property. |
| PrimaryResidence | Residence that the owner physically occupies and uses as his or her principal residence. |
| SecondHome | A property occupied by the owner for a portion of the year and is not the primary residence. |
| ProjectPrimaryUsageType Bound Attachments |
| Name | Current Value |
| ProjectPrimaryUsageType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ProjectPrimaryUsageType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectPrimaryUsageType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectPrimaryUsageType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ProjectPrimaryUsageType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TwoToFourUnitCondominiumProjectIndicator |
| Base Entity | PROJECT_DETAIL |
| Attribute Name | TwoToFourUnitCondominiumProjectIndicator |
| Logical Rolename | |
| ColumnName | TwoToFourUnitCondominiumProjectIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the condominium project comprised of at least 2 but no more than 4 one unit dwellings. |
| Note |
| TwoToFourUnitCondominiumProjectIndicator Logical Attribute Properties |
| Logical Attribute Name | TwoToFourUnitCondominiumProjectIndicator |
| Datatype | BIT |
| Nullable | NO |
| TwoToFourUnitCondominiumProjectIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TwoToFourUnitCondominiumProjectIndicator Bound Attachments |
| Name | Current Value |
| TwoToFourUnitCondominiumProjectIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TwoToFourUnitCondominiumProjectIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TwoToFourUnitCondominiumProjectIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TwoToFourUnitCondominiumProjectIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TwoToFourUnitCondominiumProjectIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |