PropertyTaxAssessmentEndYear |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxAssessmentEndYear |
Logical Rolename | |
ColumnName | PropertyTaxAssessmentEndYear |
RoleName | |
Domain | MISMOYear |
Definition | The end of year of the assessment (tax authority valuation) used for this tax year. |
Note |
PropertyTaxAssessmentEndYear Logical Attribute Properties |
Logical Attribute Name | PropertyTaxAssessmentEndYear |
Datatype | DATE |
Nullable | NO |
PropertyTaxAssessmentEndYear Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxAssessmentEndYear Bound Attachments |
Name | Current Value |
PropertyTaxAssessmentEndYear User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxAssessmentEndYear Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentEndYear Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentEndYear Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentEndYear Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentStartYear |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxAssessmentStartYear |
Logical Rolename | |
ColumnName | PropertyTaxAssessmentStartYear |
RoleName | |
Domain | MISMOYear |
Definition | The start year of the assessment (tax authority valuation) used for this tax year. |
Note |
PropertyTaxAssessmentStartYear Logical Attribute Properties |
Logical Attribute Name | PropertyTaxAssessmentStartYear |
Datatype | DATE |
Nullable | NO |
PropertyTaxAssessmentStartYear Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxAssessmentStartYear Bound Attachments |
Name | Current Value |
PropertyTaxAssessmentStartYear User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxAssessmentStartYear Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentStartYear Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentStartYear Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAssessmentStartYear Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAtypicalCommentDescription |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxAtypicalCommentDescription |
Logical Rolename | |
ColumnName | PropertyTaxAtypicalCommentDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to describe atypical taxes or special assessments. |
Note |
PropertyTaxAtypicalCommentDescription Logical Attribute Properties |
Logical Attribute Name | PropertyTaxAtypicalCommentDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyTaxAtypicalCommentDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxAtypicalCommentDescription Bound Attachments |
Name | Current Value |
PropertyTaxAtypicalCommentDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxAtypicalCommentDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAtypicalCommentDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAtypicalCommentDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxAtypicalCommentDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCertificateDate |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxCertificateDate |
Logical Rolename | |
ColumnName | PropertyTaxCertificateDate |
RoleName | |
Domain | MISMODate |
Definition | This is the date the tax certificate was issued signifying the assessment cutoff date for the upcoming year, e.g. the cert date in CA is always the first of the year. Other states may vary. |
Note |
PropertyTaxCertificateDate Logical Attribute Properties |
Logical Attribute Name | PropertyTaxCertificateDate |
Datatype | DATE |
Nullable | NO |
PropertyTaxCertificateDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxCertificateDate Bound Attachments |
Name | Current Value |
PropertyTaxCertificateDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxCertificateDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCertificateDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCertificateDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCertificateDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCountyRateAreaIdentifier |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxCountyRateAreaIdentifier |
Logical Rolename | |
ColumnName | PropertyTaxCountyRateAreaIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | The tax area or region identifier used by the county tax authority for this tax year (Property Tax Year Identifier). |
Note |
PropertyTaxCountyRateAreaIdentifier Logical Attribute Properties |
Logical Attribute Name | PropertyTaxCountyRateAreaIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyTaxCountyRateAreaIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxCountyRateAreaIdentifier Bound Attachments |
Name | Current Value |
PropertyTaxCountyRateAreaIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxCountyRateAreaIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCountyRateAreaIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCountyRateAreaIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxCountyRateAreaIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxDelinquentIndicator |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxDelinquentIndicator |
Logical Rolename | |
ColumnName | PropertyTaxDelinquentIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the owner is delinquent on taxes from a taxing authority or jurisdiction. |
Note |
PropertyTaxDelinquentIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyTaxDelinquentIndicator |
Datatype | BIT |
Nullable | NO |
PropertyTaxDelinquentIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxDelinquentIndicator Bound Attachments |
Name | Current Value |
PropertyTaxDelinquentIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxDelinquentIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxDelinquentIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxDelinquentIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxDelinquentIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxEndYear |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxEndYear |
Logical Rolename | |
ColumnName | PropertyTaxEndYear |
RoleName | |
Domain | MISMOYear |
Definition | The end year of the Subject property tax year for the information. |
Note |
PropertyTaxEndYear Logical Attribute Properties |
Logical Attribute Name | PropertyTaxEndYear |
Datatype | DATE |
Nullable | NO |
PropertyTaxEndYear Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxEndYear Bound Attachments |
Name | Current Value |
PropertyTaxEndYear User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxEndYear Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxEndYear Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxEndYear Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxEndYear Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxExemptionIndicator |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxExemptionIndicator |
Logical Rolename | |
ColumnName | PropertyTaxExemptionIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the subject property has a tax exemption for this tax year (Property Tax Year Identifier). See Property Tax Exemption. |
Note |
PropertyTaxExemptionIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyTaxExemptionIndicator |
Datatype | BIT |
Nullable | NO |
PropertyTaxExemptionIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxExemptionIndicator Bound Attachments |
Name | Current Value |
PropertyTaxExemptionIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxExemptionIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxExemptionIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxExemptionIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxExemptionIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxImprovementValueAmount |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxImprovementValueAmount |
Logical Rolename | |
ColumnName | PropertyTaxImprovementValueAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The taxable value of the structure or structures on the property as separate from the land itself for this tax year (Property Tax Year Identifier). |
Note |
PropertyTaxImprovementValueAmount Logical Attribute Properties |
Logical Attribute Name | PropertyTaxImprovementValueAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxImprovementValueAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxImprovementValueAmount Bound Attachments |
Name | Current Value |
PropertyTaxImprovementValueAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxImprovementValueAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxImprovementValueAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxImprovementValueAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxImprovementValueAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxLandValueAmount |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxLandValueAmount |
Logical Rolename | |
ColumnName | PropertyTaxLandValueAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The taxable value of the property land without improvements for this tax year (Property Tax Year Identifier) |
Note |
PropertyTaxLandValueAmount Logical Attribute Properties |
Logical Attribute Name | PropertyTaxLandValueAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxLandValueAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxLandValueAmount Bound Attachments |
Name | Current Value |
PropertyTaxLandValueAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxLandValueAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxLandValueAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxLandValueAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxLandValueAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalAssessedValueAmount |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxTotalAssessedValueAmount |
Logical Rolename | |
ColumnName | PropertyTaxTotalAssessedValueAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Combined value of the assessed land and improvements of the property (I.e. structures) for this tax year (Property Tax Year Identifier) |
Note |
PropertyTaxTotalAssessedValueAmount Logical Attribute Properties |
Logical Attribute Name | PropertyTaxTotalAssessedValueAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxTotalAssessedValueAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxTotalAssessedValueAmount Bound Attachments |
Name | Current Value |
PropertyTaxTotalAssessedValueAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxTotalAssessedValueAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalAssessedValueAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalAssessedValueAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalAssessedValueAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalSpecialTaxAmount |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxTotalSpecialTaxAmount |
Logical Rolename | |
ColumnName | PropertyTaxTotalSpecialTaxAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total of all of the special real estate taxes of the property for this tax year (Property Tax Year Identifier) across all tax jurisdictions and authorities. This is the amount assessed for the tax year, not the amount paid. (see Property Tax Special). |
Note |
PropertyTaxTotalSpecialTaxAmount Logical Attribute Properties |
Logical Attribute Name | PropertyTaxTotalSpecialTaxAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxTotalSpecialTaxAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxTotalSpecialTaxAmount Bound Attachments |
Name | Current Value |
PropertyTaxTotalSpecialTaxAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxTotalSpecialTaxAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalSpecialTaxAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalSpecialTaxAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalSpecialTaxAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxableValueAmount |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxTotalTaxableValueAmount |
Logical Rolename | |
ColumnName | PropertyTaxTotalTaxableValueAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Combined total taxable value of the land and improvements of the property for this tax year (Property Tax Year Identifier) across all tax jurisdictions and authorities. This value is the total value less the exemption and any other adjustments. |
Note |
PropertyTaxTotalTaxableValueAmount Logical Attribute Properties |
Logical Attribute Name | PropertyTaxTotalTaxableValueAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxTotalTaxableValueAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxTotalTaxableValueAmount Bound Attachments |
Name | Current Value |
PropertyTaxTotalTaxableValueAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxTotalTaxableValueAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxableValueAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxableValueAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxableValueAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxAmount |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxTotalTaxAmount |
Logical Rolename | |
ColumnName | PropertyTaxTotalTaxAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The total of all of the real estate taxes of the property for this tax year (Property Tax Year Identifier) across all tax jurisdictions and authorities. This is the amount assessed for the tax year, not the amount paid. This amount includes all special ta |
Note |
PropertyTaxTotalTaxAmount Logical Attribute Properties |
Logical Attribute Name | PropertyTaxTotalTaxAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxTotalTaxAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxTotalTaxAmount Bound Attachments |
Name | Current Value |
PropertyTaxTotalTaxAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxTotalTaxAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTotalTaxAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxToValueRatePercent |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxToValueRatePercent |
Logical Rolename | |
ColumnName | PropertyTaxToValueRatePercent |
RoleName | |
Domain | MISMOPercent |
Definition | The ratio of the property value (Property Tax Total Taxable Value Amount) to this year tax amounts (Property Tax Real Estate Total Tax Amount). For example, a $500,000 property paying $2,500 |
Note |
PropertyTaxToValueRatePercent Logical Attribute Properties |
Logical Attribute Name | PropertyTaxToValueRatePercent |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
PropertyTaxToValueRatePercent Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxToValueRatePercent Bound Attachments |
Name | Current Value |
PropertyTaxToValueRatePercent User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxToValueRatePercent Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxToValueRatePercent Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxToValueRatePercent Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxToValueRatePercent Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTypicalTaxIndicator |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxTypicalTaxIndicator |
Logical Rolename | |
ColumnName | PropertyTaxTypicalTaxIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the real estate taxes of the subject property are typical for the area and type of property. |
Note |
PropertyTaxTypicalTaxIndicator Logical Attribute Properties |
Logical Attribute Name | PropertyTaxTypicalTaxIndicator |
Datatype | BIT |
Nullable | NO |
PropertyTaxTypicalTaxIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxTypicalTaxIndicator Bound Attachments |
Name | Current Value |
PropertyTaxTypicalTaxIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxTypicalTaxIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTypicalTaxIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTypicalTaxIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxTypicalTaxIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxYearIdentifier |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | PropertyTaxYearIdentifier |
Logical Rolename | |
ColumnName | PropertyTaxYearIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | The tax year of the subject property associated with the information provided. |
Note |
PropertyTaxYearIdentifier Logical Attribute Properties |
Logical Attribute Name | PropertyTaxYearIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
PropertyTaxYearIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PropertyTaxYearIdentifier Bound Attachments |
Name | Current Value |
PropertyTaxYearIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
PropertyTaxYearIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxYearIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxYearIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PropertyTaxYearIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityAccountBillIdentifier |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxAuthorityAccountBillIdentifier |
Logical Rolename | |
ColumnName | TaxAuthorityAccountBillIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | A number assigned by the taxing authority to identify the tax bill (parcel number, account number, etc.) This may not be the same as the City, State or County Assessor Parcel Identifier. |
Note |
TaxAuthorityAccountBillIdentifier Logical Attribute Properties |
Logical Attribute Name | TaxAuthorityAccountBillIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
TaxAuthorityAccountBillIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxAuthorityAccountBillIdentifier Bound Attachments |
Name | Current Value |
TaxAuthorityAccountBillIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxAuthorityAccountBillIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityAccountBillIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityAccountBillIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityAccountBillIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityType |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxAuthorityType |
Logical Rolename | |
ColumnName | TaxAuthorityType |
RoleName | |
Domain | TaxAuthorityEnum |
Definition | Identifies the type of tax to be paid |
Note |
TaxAuthorityType Logical Attribute Properties |
Logical Attribute Name | TaxAuthorityType |
Datatype | VARCHAR(0) |
Nullable | YES |
TaxAuthorityType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxAuthorityType Reference Value (Bound to Domain) |
Name | ValidationRule467 |
Description | |
Type | By List |
Value | Value Description |
AnnualCityBondAuthorityTax | AnnualCityBondAuthorityTax |
AnnualCountyBondAuthorityTax | AnnualCountyBondAuthorityTax |
AssessmentDistrictTax | AssessmentDistrictTax |
BondAuthorityTax | BondAuthorityTax |
BoroughTax | BoroughTax |
CentralAppraisalTaxingAuthorityTax | CentralAppraisalTaxingAuthorityTax |
CentralCollectionTaxingAuthorityTax | CentralCollectionTaxingAuthorityTax |
CityAndSchoolTax | CityAndSchoolTax |
CityTax | CityTax |
CombinationCollectionTax | CombinationCollectionTax |
CountyCollectedByOtherTaxingAuthorityTax | CountyCollectedByOtherTaxingAuthorityTax |
CountyTax | CountyTax |
FireOrPoliceTax | FireOrPoliceTax |
HomeownersAssociationTax | HomeownersAssociationTax |
HospitalsTax | HospitalsTax |
JuniorCollegesTax | JuniorCollegesTax |
MobileHomeAuthorityTax | MobileHomeAuthorityTax |
MunicipalServicesTax | MunicipalServicesTax |
MunicipalityTax | MunicipalityTax |
Other | Other |
ReclamationDistrictTax | ReclamationDistrictTax |
RoadsOrBridgesTax | RoadsOrBridgesTax |
SanitationTax | SanitationTax |
SchoolDistrictTax | SchoolDistrictTax |
SemiannualCityBondAuthorityTax | SemiannualCityBondAuthorityTax |
SemiannualCountyBondAuthorityTax | SemiannualCountyBondAuthorityTax |
SpecialApplicationsTax | SpecialApplicationsTax |
SpecialDistrictTax | SpecialDistrictTax |
StateAndCountyTax | StateAndCountyTax |
StateTaxingAuthorityTax | StateTaxingAuthorityTax |
TownshipAndCountyTax | TownshipAndCountyTax |
TownshipTax | TownshipTax |
TownTax | TownTax |
UnsecuredCountyTaxes | UnsecuredCountyTaxes |
UtilityDistrictTax | UtilityDistrictTax |
VillageTax | VillageTax |
WaterControlTax | WaterControlTax |
WaterOrSewerDistrictTax | WaterOrSewerDistrictTax |
TaxAuthorityType Bound Attachments |
Name | Current Value |
TaxAuthorityType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxAuthorityType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityTypeOtherDescription |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxAuthorityTypeOtherDescription |
Logical Rolename | |
ColumnName | TaxAuthorityTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to capture the Tax Authority Type if Other is selected as the Tax Authority Type. |
Note |
TaxAuthorityTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | TaxAuthorityTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
TaxAuthorityTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxAuthorityTypeOtherDescription Bound Attachments |
Name | Current Value |
TaxAuthorityTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxAuthorityTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxAuthorityTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractIdentifier |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxContractIdentifier |
Logical Rolename | |
ColumnName | TaxContractIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | The contract number assigned to the loan by the tax service |
Note |
TaxContractIdentifier Logical Attribute Properties |
Logical Attribute Name | TaxContractIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
TaxContractIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxContractIdentifier Bound Attachments |
Name | Current Value |
TaxContractIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxContractIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractLifeOfLoanIndicator |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxContractLifeOfLoanIndicator |
Logical Rolename | |
ColumnName | TaxContractLifeOfLoanIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates if the tax contract is transferable with the loan. |
Note |
TaxContractLifeOfLoanIndicator Logical Attribute Properties |
Logical Attribute Name | TaxContractLifeOfLoanIndicator |
Datatype | BIT |
Nullable | NO |
TaxContractLifeOfLoanIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxContractLifeOfLoanIndicator Bound Attachments |
Name | Current Value |
TaxContractLifeOfLoanIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxContractLifeOfLoanIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractLifeOfLoanIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractLifeOfLoanIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractLifeOfLoanIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractOrderDate |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxContractOrderDate |
Logical Rolename | |
ColumnName | TaxContractOrderDate |
RoleName | |
Domain | MISMODate |
Definition | The date the request for a tax contract was submitted. |
Note |
TaxContractOrderDate Logical Attribute Properties |
Logical Attribute Name | TaxContractOrderDate |
Datatype | DATE |
Nullable | NO |
TaxContractOrderDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxContractOrderDate Bound Attachments |
Name | Current Value |
TaxContractOrderDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxContractOrderDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractOrderDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractOrderDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractOrderDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractSuffixIdentifier |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxContractSuffixIdentifier |
Logical Rolename | |
ColumnName | TaxContractSuffixIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | Sub identification number to identify each parcel associated with the property under contract. |
Note |
TaxContractSuffixIdentifier Logical Attribute Properties |
Logical Attribute Name | TaxContractSuffixIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
TaxContractSuffixIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxContractSuffixIdentifier Bound Attachments |
Name | Current Value |
TaxContractSuffixIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxContractSuffixIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractSuffixIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractSuffixIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxContractSuffixIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxEscrowedIndicator |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxEscrowedIndicator |
Logical Rolename | |
ColumnName | TaxEscrowedIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates if monies for this tax item are escrowed. |
Note |
TaxEscrowedIndicator Logical Attribute Properties |
Logical Attribute Name | TaxEscrowedIndicator |
Datatype | BIT |
Nullable | NO |
TaxEscrowedIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxEscrowedIndicator Bound Attachments |
Name | Current Value |
TaxEscrowedIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxEscrowedIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxEscrowedIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxEscrowedIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxEscrowedIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxItemExemptionIndicator |
Base Entity | PROPERTY_TAX_DETAIL |
Attribute Name | TaxItemExemptionIndicator |
Logical Rolename | |
ColumnName | TaxItemExemptionIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates whether the mortgagor has an exemption for payment of this tax item. |
Note |
TaxItemExemptionIndicator Logical Attribute Properties |
Logical Attribute Name | TaxItemExemptionIndicator |
Datatype | BIT |
Nullable | NO |
TaxItemExemptionIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TaxItemExemptionIndicator Bound Attachments |
Name | Current Value |
TaxItemExemptionIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
TaxItemExemptionIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxItemExemptionIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TaxItemExemptionIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TaxItemExemptionIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |