SequenceNumber |
Base Entity | OFF_SITE_IMPROVEMENT |
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 |
ConditionRatingType |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | ConditionRatingType |
Logical Rolename | |
ColumnName | ConditionRatingType |
RoleName | |
Domain | ConditionRatingEnum |
Definition | A rating of the quality of the identified component. |
Note |
ConditionRatingType Logical Attribute Properties |
Logical Attribute Name | ConditionRatingType |
Datatype | VARCHAR(0) |
Nullable | YES |
ConditionRatingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ConditionRatingType Reference Value (Bound to Domain) |
Name | ValidationRule63 |
Description | |
Type | By List |
Value | Value Description |
Average | Average |
Excellent | Excellent |
Fair | Fair |
Good | Good |
Poor | Poor |
ConditionRatingType Bound Attachments |
Name | Current Value |
ConditionRatingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ConditionRatingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConditionRatingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ConditionRatingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConditionRatingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementDescription |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | OffSiteImprovementDescription |
Logical Rolename | |
ColumnName | OffSiteImprovementDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe in detail the off site improvement specified by the Off Site Improvement Type. |
Note |
OffSiteImprovementDescription Logical Attribute Properties |
Logical Attribute Name | OffSiteImprovementDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
OffSiteImprovementDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OffSiteImprovementDescription Bound Attachments |
Name | Current Value |
OffSiteImprovementDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
OffSiteImprovementDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementOwnershipType |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | OffSiteImprovementOwnershipType |
Logical Rolename | |
ColumnName | OffSiteImprovementOwnershipType |
RoleName | |
Domain | OffSiteImprovementOwnershipEnum |
Definition | Specifies the ownership or responsibility type of an off site improvement feature such as a public or private road |
Note |
OffSiteImprovementOwnershipType Logical Attribute Properties |
Logical Attribute Name | OffSiteImprovementOwnershipType |
Datatype | VARCHAR(0) |
Nullable | YES |
OffSiteImprovementOwnershipType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OffSiteImprovementOwnershipType Reference Value (Bound to Domain) |
Name | ValidationRule338 |
Description | |
Type | By List |
Value | Value Description |
Private | Private |
Public | Public |
Unknown | Unknown |
OffSiteImprovementOwnershipType Bound Attachments |
Name | Current Value |
OffSiteImprovementOwnershipType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
OffSiteImprovementOwnershipType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementOwnershipType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementOwnershipType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementOwnershipType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityNotTypicalDescription |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | OffSiteImprovementsUtilityNotTypicalDescription |
Logical Rolename | |
ColumnName | OffSiteImprovementsUtilityNotTypicalDescription |
RoleName | |
Domain | MISMOString |
Definition | Describes how the utilities for the off site improvements differ from what is typical for the market area. |
Note |
OffSiteImprovementsUtilityNotTypicalDescription Logical Attribute Properties |
Logical Attribute Name | OffSiteImprovementsUtilityNotTypicalDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
OffSiteImprovementsUtilityNotTypicalDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OffSiteImprovementsUtilityNotTypicalDescription Bound Attachments |
Name | Current Value |
OffSiteImprovementsUtilityNotTypicalDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
OffSiteImprovementsUtilityNotTypicalDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityNotTypicalDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityNotTypicalDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityNotTypicalDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityTypicalIndicator |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | OffSiteImprovementsUtilityTypicalIndicator |
Logical Rolename | |
ColumnName | OffSiteImprovementsUtilityTypicalIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the utilities for the off site improvements are typical for the market area. |
Note |
OffSiteImprovementsUtilityTypicalIndicator Logical Attribute Properties |
Logical Attribute Name | OffSiteImprovementsUtilityTypicalIndicator |
Datatype | BIT |
Nullable | NO |
OffSiteImprovementsUtilityTypicalIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OffSiteImprovementsUtilityTypicalIndicator Bound Attachments |
Name | Current Value |
OffSiteImprovementsUtilityTypicalIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
OffSiteImprovementsUtilityTypicalIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityTypicalIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityTypicalIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementsUtilityTypicalIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementType |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | OffSiteImprovementType |
Logical Rolename | |
ColumnName | OffSiteImprovementType |
RoleName | |
Domain | OffSiteImprovementEnum |
Definition | Used to specify a particular off site improvement feature of the property |
Note |
OffSiteImprovementType Logical Attribute Properties |
Logical Attribute Name | OffSiteImprovementType |
Datatype | VARCHAR(0) |
Nullable | YES |
OffSiteImprovementType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OffSiteImprovementType Reference Value (Bound to Domain) |
Name | ValidationRule337 |
Description | |
Type | By List |
Value | Value Description |
Alley | Alley |
CurbGutter | CurbGutter |
Gated | Gated |
Other | Other |
Sidewalk | Sidewalk |
Street | Street |
StreetAccess | StreetAccess |
StreetLighting | StreetLighting |
StreetMaintenance | StreetMaintenance |
StreetSurface | StreetSurface |
OffSiteImprovementType Bound Attachments |
Name | Current Value |
OffSiteImprovementType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
OffSiteImprovementType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementTypeOtherDescription |
Base Entity | OFF_SITE_IMPROVEMENT |
Attribute Name | OffSiteImprovementTypeOtherDescription |
Logical Rolename | |
ColumnName | OffSiteImprovementTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe the off site improvement if Other is selected as the Property Off Site Improvements Features Type. |
Note |
OffSiteImprovementTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | OffSiteImprovementTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
OffSiteImprovementTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OffSiteImprovementTypeOtherDescription Bound Attachments |
Name | Current Value |
OffSiteImprovementTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
OffSiteImprovementTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OffSiteImprovementTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |