PROJECT_ANALYSIS Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
CharacteristicsAffectMarketabilityDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the characteristics that affect marketability
OwnersWithinProjectMoreThanTwoMonthsDelinquentCount	MISMOCount	INTEGER	NO	The count of owners within project (i.e. of a cooperative) that are more than two (2) months delinquent in payment.
ProjectAnalysisAdditionalFacilitiesFeeAmount	MISMOAmount	DECIMAL(0, 2)	NO	Identifies any other facility related charges that are not included in standard project fee (e.g. HOA fees).
ProjectAnalysisAdditionalFacilitiesFeeDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the conditions, extent, and terms of the additional fee not included in the standard project fee (e.g. HOA fee).
ProjectAnalysisAdditionalFacilitiesFeeIndicator	MISMOIndicator	BIT	NO	Indicates that the project does impose an additional fee beyond the standard project fee.
ProjectAnalysisAdequacyOfBudgetType	ProjectAnalysisAdequacyOfBudgetEnum	VARCHAR(0)	YES	Identifies the assessment, by the reviewer, if the operating budget of the project is adequate for its immediate as well as long-term needs.
ProjectAnalysisAdequacyOfManagementType	ProjectAnalysisAdequacyOfManagementEnum	VARCHAR(0)	YES	Identifies the assessment by the reviewer if the management of the project as well as its rules and regulations are adequate to protect its operations and future value.
ProjectAnalysisBudgetAnalysisCommentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the results of analyzing the project budget.
ProjectAnalysisBudgetAnalyzedIndicator	MISMOIndicator	BIT	NO	Indicates that the appraiser analyzed the budget of the project.
ProjectAnalysisCharacteristicsAffectMarketabilityIndicator	MISMOIndicator	BIT	NO	Indicates that the characteristics described in the Project Analysis affect marketability.
ProjectAnalysisCompetitiveProjectComparisonDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the differences, relative values, and effect of competitive projects.
ProjectAnalysisCompetitiveProjectComparisonType	ProjectAnalysisCompetitiveProjectComparisonEnum	VARCHAR(0)	YES	Specifies the type of competition the project faces.
ProjectAnalysisGroundRentAmount	MISMOAmount	DECIMAL(0, 2)	NO	Identifies the annual ground rent amount for the project unit.
ProjectAnalysisGroundRentDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing the ground rent.
ProjectAnalysisGroundRentIndicator	MISMOIndicator	BIT	NO	Indicates that the project is subject to ground rents.
ProjectAnalysisSpecialCharacteristicsDescription	MISMOString	VARCHAR(0)	NO	A free-form text field describing any special, atypical, or unusual characteristics of the project.
ProjectAnalysisSpecialCharacteristicsIndicator	MISMOIndicator	BIT	NO	Indicates that the project has special, atypical, or unusual characteristics.
ProjectConditionAndQualityDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to describe the condition of the project.

PROJECT_ANALYSIS Keys

Key Name

Key Type

Keys

PROJECT_ANALYSIS 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_ANALYSIS Check Constraints

Check Constraint Name

CheckConstraint

PROJECT_ANALYSIS Bound Attachments

Name	Current Value

PROJECT_ANALYSIS User-Defined Mappings

Model

Name

Description

PROJECT_ANALYSIS Data Movement Rules

Name

Type

Rule Text/Value