PROJECT_DETAIL

PROJECT_DETAIL

EntityType	Dependent
Logical Entity Name	PROJECT_DETAIL
Default Table Name	DEAL/SERVICES/SERVICE/TITLE/TITLE_RESPONSE/PROPERTY/PROJECT/PROJECT_DETAIL
Definition
Note

PROJECT_DETAIL Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

AdditionalProjectConsiderationsType AdditionalProjectConsiderationsEnum VARCHAR(0) YES Describes the specific ownership or use of the project.

AdditionalProjectConsiderationsTypeOtherDescription MISMOString VARCHAR(0) NO A free form text field used to collect additional information when Other is selected for Additional Project Considerations Type.

CondominiumProjectStatusType CondominiumProjectStatusEnum VARCHAR(0) YES Specifies the current state of the condominium project.

FNMCondominiumProjectManagerProjectIdentifier MISMOIdentifier VARCHAR(0) NO The unique identifier of a property development project to which individual properties belong assigned by the Fannie Mae Condo Project Manager (CPM) system.

ProjectAmenityImprovementsCompletedIndicator MISMOIndicator BIT NO Indicates whether construction on the project amenities such as pool and clubhouse have been completed.

ProjectAttachmentType ProjectAttachmentEnum VARCHAR(0) YES Specifies the type of physical attachment, if any, between the dwelling units in the project.

ProjectClassificationIdentifier MISMOIdentifier VARCHAR(0) NO Identifies the type of project or condominium classification for the subject property and its associated review.

ProjectContainsMultipleDwellingUnitsDataSourceDescription MISMOString VARCHAR(0) NO A free-form text field used to describe the source of the information used to set the Project Contains Multiple Dwelling Units Indicator.

ProjectContainsMultipleDwellingUnitsIndicator MISMOIndicator BIT NO Indicates that the project contains multiple dwelling-units.

ProjectDesignType ProjectDesignEnum VARCHAR(0) YES This field specifies the type of design for the multiple unit buildings in a project.

ProjectDesignTypeOtherDescription MISMOString VARCHAR(0) NO A free-form text field used to describe the design if Other is selected as the Project Design Type.

ProjectDwellingUnitCount MISMOCount INTEGER NO Total number of individual dwelling units in the project.

ProjectDwellingUnitsSoldCount MISMOCount INTEGER NO The number of units in a building, project or development that have been sold to date.

ProjectEligibilityDeterminationType ProjectEligibilityDeterminationEnum VARCHAR(0) YES Specifies the level of review performed to determine that a project meets eligibility guidelines for purchase by the investor.

ProjectLegalStructureType ProjectLegalStructureEnum VARCHAR(0) YES Specifies the form of ownership that defines the quality and quantity of ownership and rights to the individual unit owner.

ProjectName MISMOString VARCHAR(0) NO The name of the project in which subject property is located (e.g., the name of the condominium or cooperative).

PUDIndicator MISMOIndicator BIT NO 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

ProjectPrimaryUsageType ProjectPrimaryUsageEnum VARCHAR(0) YES Specifies the primary type of occupancy of the Project.

TwoToFourUnitCondominiumProjectIndicator MISMOIndicator BIT NO When true, indicates that the condominium project comprised of at least 2 but no more than 4 one unit dwellings.

PROJECT_DETAIL Keys

Key Name Key Type Keys

PROJECT_DETAIL Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

PROJECT Identifying One to Zero or One NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

PROJECT_DETAIL Check Constraints

Check Constraint Name CheckConstraint

PROJECT_DETAIL Bound Attachments

Name Current Value

PROJECT_DETAIL User-Defined Mappings

Model Name Description

PROJECT_DETAIL Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
AdditionalProjectConsiderationsType	AdditionalProjectConsiderationsEnum	VARCHAR(0)	YES	Describes the specific ownership or use of the project.
AdditionalProjectConsiderationsTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Additional Project Considerations Type.
CondominiumProjectStatusType	CondominiumProjectStatusEnum	VARCHAR(0)	YES	Specifies the current state of the condominium project.
FNMCondominiumProjectManagerProjectIdentifier	MISMOIdentifier	VARCHAR(0)	NO	The unique identifier of a property development project to which individual properties belong assigned by the Fannie Mae Condo Project Manager (CPM) system.
ProjectAmenityImprovementsCompletedIndicator	MISMOIndicator	BIT	NO	Indicates whether construction on the project amenities such as pool and clubhouse have been completed.
ProjectAttachmentType	ProjectAttachmentEnum	VARCHAR(0)	YES	Specifies the type of physical attachment, if any, between the dwelling units in the project.
ProjectClassificationIdentifier	MISMOIdentifier	VARCHAR(0)	NO	Identifies the type of project or condominium classification for the subject property and its associated review.
ProjectContainsMultipleDwellingUnitsDataSourceDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the source of the information used to set the Project Contains Multiple Dwelling Units Indicator.
ProjectContainsMultipleDwellingUnitsIndicator	MISMOIndicator	BIT	NO	Indicates that the project contains multiple dwelling-units.
ProjectDesignType	ProjectDesignEnum	VARCHAR(0)	YES	This field specifies the type of design for the multiple unit buildings in a project.
ProjectDesignTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the design if Other is selected as the Project Design Type.
ProjectDwellingUnitCount	MISMOCount	INTEGER	NO	Total number of individual dwelling units in the project.
ProjectDwellingUnitsSoldCount	MISMOCount	INTEGER	NO	The number of units in a building, project or development that have been sold to date.
ProjectEligibilityDeterminationType	ProjectEligibilityDeterminationEnum	VARCHAR(0)	YES	Specifies the level of review performed to determine that a project meets eligibility guidelines for purchase by the investor.
ProjectLegalStructureType	ProjectLegalStructureEnum	VARCHAR(0)	YES	Specifies the form of ownership that defines the quality and quantity of ownership and rights to the individual unit owner.
ProjectName	MISMOString	VARCHAR(0)	NO	The name of the project in which subject property is located (e.g., the name of the condominium or cooperative).
PUDIndicator	MISMOIndicator	BIT	NO	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
ProjectPrimaryUsageType	ProjectPrimaryUsageEnum	VARCHAR(0)	YES	Specifies the primary type of occupancy of the Project.
TwoToFourUnitCondominiumProjectIndicator	MISMOIndicator	BIT	NO	When true, indicates that the condominium project comprised of at least 2 but no more than 4 one unit dwellings.

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
PROJECT	Identifying	One to Zero or One					NO