EscrowAnnualPaymentAmount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowAnnualPaymentAmount |
Logical Rolename | |
ColumnName | EscrowAnnualPaymentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The amount of the annual payment for the Escrow Item Type. |
Note |
EscrowAnnualPaymentAmount Logical Attribute Properties |
Logical Attribute Name | EscrowAnnualPaymentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowAnnualPaymentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowAnnualPaymentAmount Bound Attachments |
Name | Current Value |
EscrowAnnualPaymentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowAnnualPaymentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAnnualPaymentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAnnualPaymentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowAnnualPaymentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCollectedNumberOfMonthsCount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowCollectedNumberOfMonthsCount |
Logical Rolename | |
ColumnName | EscrowCollectedNumberOfMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of months escrow to be collected at closing for the Escrow Item Type. |
Note |
EscrowCollectedNumberOfMonthsCount Logical Attribute Properties |
Logical Attribute Name | EscrowCollectedNumberOfMonthsCount |
Datatype | INTEGER |
Nullable | NO |
EscrowCollectedNumberOfMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowCollectedNumberOfMonthsCount Bound Attachments |
Name | Current Value |
EscrowCollectedNumberOfMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowCollectedNumberOfMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCollectedNumberOfMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCollectedNumberOfMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowCollectedNumberOfMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowInsurancePolicyIdentifier |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowInsurancePolicyIdentifier |
Logical Rolename | |
ColumnName | EscrowInsurancePolicyIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | The identifier assigned to the insurance policy by the issuing company. |
Note |
EscrowInsurancePolicyIdentifier Logical Attribute Properties |
Logical Attribute Name | EscrowInsurancePolicyIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
EscrowInsurancePolicyIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowInsurancePolicyIdentifier Bound Attachments |
Name | Current Value |
EscrowInsurancePolicyIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowInsurancePolicyIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowInsurancePolicyIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowInsurancePolicyIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowInsurancePolicyIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemCategoryType |
Logical Rolename | |
ColumnName | EscrowItemCategoryType |
RoleName | |
Domain | EscrowItemCategoryEnum |
Definition | Identifies the category of the escrow item type. |
Note |
EscrowItemCategoryType Logical Attribute Properties |
Logical Attribute Name | EscrowItemCategoryType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowItemCategoryType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemCategoryType Reference Value (Bound to Domain) |
Name | ValidationRule147 |
Description | |
Type | By List |
Value | Value Description |
Insurance | Mortgage-related insurance against loss of or damage to the property, or against liability arising out of the ownership or use of the property. |
Other | Other |
Tax | Taxes imposed upon owners of the property. |
EscrowItemCategoryType Bound Attachments |
Name | Current Value |
EscrowItemCategoryType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemCategoryType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryTypeOtherDescription |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemCategoryTypeOtherDescription |
Logical Rolename | |
ColumnName | EscrowItemCategoryTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free-form text field used to collect additional information when Other is selected for Escrow Item Category Type. |
Note |
EscrowItemCategoryTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | EscrowItemCategoryTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
EscrowItemCategoryTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemCategoryTypeOtherDescription Bound Attachments |
Name | Current Value |
EscrowItemCategoryTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemCategoryTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemCategoryTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemLastDisbursementDate |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemLastDisbursementDate |
Logical Rolename | |
ColumnName | EscrowItemLastDisbursementDate |
RoleName | |
Domain | MISMODate |
Definition | Specifies the last disbursement date for the selected escrow item. |
Note |
EscrowItemLastDisbursementDate Logical Attribute Properties |
Logical Attribute Name | EscrowItemLastDisbursementDate |
Datatype | DATE |
Nullable | NO |
EscrowItemLastDisbursementDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemLastDisbursementDate Bound Attachments |
Name | Current Value |
EscrowItemLastDisbursementDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemLastDisbursementDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemLastDisbursementDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemLastDisbursementDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemLastDisbursementDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextDisbursementDueDate |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemNextDisbursementDueDate |
Logical Rolename | |
ColumnName | EscrowItemNextDisbursementDueDate |
RoleName | |
Domain | MISMODate |
Definition | Specifies the due date of the next disbursement for the selected escrow item. |
Note |
EscrowItemNextDisbursementDueDate Logical Attribute Properties |
Logical Attribute Name | EscrowItemNextDisbursementDueDate |
Datatype | DATE |
Nullable | NO |
EscrowItemNextDisbursementDueDate Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemNextDisbursementDueDate Bound Attachments |
Name | Current Value |
EscrowItemNextDisbursementDueDate User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemNextDisbursementDueDate Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextDisbursementDueDate Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextDisbursementDueDate Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextDisbursementDueDate Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextProjectedDisbursementAmount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemNextProjectedDisbursementAmount |
Logical Rolename | |
ColumnName | EscrowItemNextProjectedDisbursementAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Specifies the projected amount of the next disbursement due on this escrow item. |
Note |
EscrowItemNextProjectedDisbursementAmount Logical Attribute Properties |
Logical Attribute Name | EscrowItemNextProjectedDisbursementAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowItemNextProjectedDisbursementAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemNextProjectedDisbursementAmount Bound Attachments |
Name | Current Value |
EscrowItemNextProjectedDisbursementAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemNextProjectedDisbursementAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextProjectedDisbursementAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextProjectedDisbursementAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemNextProjectedDisbursementAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemType |
Logical Rolename | |
ColumnName | EscrowItemType |
RoleName | |
Domain | EscrowItemEnum |
Definition | Specifies the type of Escrow Item. |
Note |
EscrowItemType Logical Attribute Properties |
Logical Attribute Name | EscrowItemType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowItemType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemType Reference Value (Bound to Domain) |
Name | ValidationRule148 |
Description | |
Type | By List |
Value | Value Description |
AnnualCityBondAuthorityTax | AnnualCityBondAuthorityTax |
AnnualCountyBondAuthorityTax | AnnualCountyBondAuthorityTax |
AssessmentDistrictTax | AssessmentDistrictTax |
BondAuthorityTax | BondAuthorityTax |
BoroughPropertyTax | BoroughPropertyTax |
BoroughTax | BoroughTax |
CentralAppraisalTaxingAuthorityTax | CentralAppraisalTaxingAuthorityTax |
CentralCollectionTaxingAuthorityTax | CentralCollectionTaxingAuthorityTax |
CityAndSchoolTax | CityAndSchoolTax |
CityPropertyTax | CityPropertyTax |
CityTax | CityTax |
CountyCollectedByOtherTaxingAuthorityTax | CountyCollectedByOtherTaxingAuthorityTax |
CountyPropertyTax | CountyPropertyTax |
CountyTax | CountyTax |
DistrictPropertyTax | DistrictPropertyTax |
EarthquakeInsurance | EarthquakeInsurance |
FireOrPoliceTax | FireOrPoliceTax |
FloodInsurance | FloodInsurance |
HazardInsurance | HazardInsurance |
HomeownersAssociationTax | HomeownersAssociationTax |
HospitalsTax | HospitalsTax |
JuniorCollegesTax | JuniorCollegesTax |
MobileHomeAuthorityTax | MobileHomeAuthorityTax |
MortgageInsurance | MortgageInsurance |
Other | Other |
OtherBondAuthorityTax | OtherBondAuthorityTax |
OtherCombinationCollectionTax | OtherCombinationCollectionTax |
OtherMunicipalityTax | OtherMunicipalityTax |
OtherMunicipalServicesTax | OtherMunicipalServicesTax |
OtherSchoolsTax | OtherSchoolsTax |
OtherSpecialApplicationsTax | OtherSpecialApplicationsTax |
OtherSpecialDistrictsTax | OtherSpecialDistrictsTax |
OtherTax | OtherTax |
PestInsurance | PestInsurance |
ReclamationDistrictTax | ReclamationDistrictTax |
RoadsOrBridgesTax | RoadsOrBridgesTax |
SanitationTax | SanitationTax |
SchoolPropertyTax | SchoolPropertyTax |
SchoolDistrictTax | SchoolDistrictTax |
SemiannualCityBondAuthorityTax | SemiannualCityBondAuthorityTax |
SemiannualCountyBondAuthorityTax | SemiannualCountyBondAuthorityTax |
SpecialDistrictTax | SpecialDistrictTax |
StateAndCountyTax | StateAndCountyTax |
StatePropertyTax | StatePropertyTax |
StateTaxingAuthorityTax | StateTaxingAuthorityTax |
StormInsurance | StormInsurance |
TownPropertyTax | TownPropertyTax |
TownshipAndCountyTax | TownshipAndCountyTax |
TownshipPropertyTax | TownshipPropertyTax |
TownshipTax | TownshipTax |
TownTax | TownTax |
UnsecuredCountyTaxes | UnsecuredCountyTaxes |
UtilityDistrictTax | UtilityDistrictTax |
VillagePropertyTax | VillagePropertyTax |
VillageTax | VillageTax |
WaterControlTax | WaterControlTax |
WaterOrSewerDistrictTax | WaterOrSewerDistrictTax |
WindstormInsurance | WindstormInsurance |
EscrowItemType Bound Attachments |
Name | Current Value |
EscrowItemType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemTypeOtherDescription |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowItemTypeOtherDescription |
Logical Rolename | |
ColumnName | EscrowItemTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field to collect additional information when Other is selected for Escrow Item Type. |
Note |
EscrowItemTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | EscrowItemTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
EscrowItemTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowItemTypeOtherDescription Bound Attachments |
Name | Current Value |
EscrowItemTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowItemTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowItemTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentAmount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowMonthlyPaymentAmount |
Logical Rolename | |
ColumnName | EscrowMonthlyPaymentAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The monthly payment amount for the escrow item. |
Note |
EscrowMonthlyPaymentAmount Logical Attribute Properties |
Logical Attribute Name | EscrowMonthlyPaymentAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowMonthlyPaymentAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowMonthlyPaymentAmount Bound Attachments |
Name | Current Value |
EscrowMonthlyPaymentAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowMonthlyPaymentAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentRoundingType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowMonthlyPaymentRoundingType |
Logical Rolename | |
ColumnName | EscrowMonthlyPaymentRoundingType |
RoleName | |
Domain | EscrowMonthlyPaymentRoundingEnum |
Definition | Defines the rounding method applied to the escrow payment. |
Note |
EscrowMonthlyPaymentRoundingType Logical Attribute Properties |
Logical Attribute Name | EscrowMonthlyPaymentRoundingType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowMonthlyPaymentRoundingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowMonthlyPaymentRoundingType Reference Value (Bound to Domain) |
Name | ValidationRule149 |
Description | |
Type | By List |
Value | Value Description |
Down | Down |
None | None |
Up | Up |
EscrowMonthlyPaymentRoundingType Bound Attachments |
Name | Current Value |
EscrowMonthlyPaymentRoundingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowMonthlyPaymentRoundingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentRoundingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentRoundingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowMonthlyPaymentRoundingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaidByType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPaidByType |
Logical Rolename | |
ColumnName | EscrowPaidByType |
RoleName | |
Domain | EscrowPaidByEnum |
Definition | The type of Party responsible for payment of the escrow item. |
Note |
EscrowPaidByType Logical Attribute Properties |
Logical Attribute Name | EscrowPaidByType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowPaidByType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPaidByType Reference Value (Bound to Domain) |
Name | ValidationRule150 |
Description | |
Type | By List |
Value | Value Description |
Buyer | Buyer |
LenderPremium | LenderPremium |
Seller | Seller |
EscrowPaidByType Bound Attachments |
Name | Current Value |
EscrowPaidByType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPaidByType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaidByType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaidByType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaidByType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPaymentFrequencyType |
Logical Rolename | |
ColumnName | EscrowPaymentFrequencyType |
RoleName | |
Domain | EscrowPaymentFrequencyEnum |
Definition | Payment period covered by escrow item. If item were paid once a year the payment frequency type would be annual. |
Note |
EscrowPaymentFrequencyType Logical Attribute Properties |
Logical Attribute Name | EscrowPaymentFrequencyType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowPaymentFrequencyType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPaymentFrequencyType Reference Value (Bound to Domain) |
Name | ValidationRule151 |
Description | |
Type | By List |
Value | Value Description |
Annual | Annual |
Monthly | Monthly |
Other | Other |
Quarterly | Quarterly |
SemiAnnual | SemiAnnual |
Unequal | Unequal |
EscrowPaymentFrequencyType Bound Attachments |
Name | Current Value |
EscrowPaymentFrequencyType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPaymentFrequencyType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyTypeOtherDescription |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPaymentFrequencyTypeOtherDescription |
Logical Rolename | |
ColumnName | EscrowPaymentFrequencyTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | When Other is specified as the Payment Frequency Type, this data element contains the description. |
Note |
EscrowPaymentFrequencyTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | EscrowPaymentFrequencyTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
EscrowPaymentFrequencyTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPaymentFrequencyTypeOtherDescription Bound Attachments |
Name | Current Value |
EscrowPaymentFrequencyTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPaymentFrequencyTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPaymentFrequencyTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumAmount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPremiumAmount |
Logical Rolename | |
ColumnName | EscrowPremiumAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount of the escrow premium for the escrow item type. |
Note |
EscrowPremiumAmount Logical Attribute Properties |
Logical Attribute Name | EscrowPremiumAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowPremiumAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPremiumAmount Bound Attachments |
Name | Current Value |
EscrowPremiumAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPremiumAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumDurationMonthsCount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPremiumDurationMonthsCount |
Logical Rolename | |
ColumnName | EscrowPremiumDurationMonthsCount |
RoleName | |
Domain | MISMOCount |
Definition | The number of months covered by the related premium. |
Note |
EscrowPremiumDurationMonthsCount Logical Attribute Properties |
Logical Attribute Name | EscrowPremiumDurationMonthsCount |
Datatype | INTEGER |
Nullable | NO |
EscrowPremiumDurationMonthsCount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPremiumDurationMonthsCount Bound Attachments |
Name | Current Value |
EscrowPremiumDurationMonthsCount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPremiumDurationMonthsCount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumDurationMonthsCount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumDurationMonthsCount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumDurationMonthsCount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaidByType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPremiumPaidByType |
Logical Rolename | |
ColumnName | EscrowPremiumPaidByType |
RoleName | |
Domain | EscrowPremiumPaidByEnum |
Definition | The type of party responsible for the payment of the escrow premium amount. |
Note |
EscrowPremiumPaidByType Logical Attribute Properties |
Logical Attribute Name | EscrowPremiumPaidByType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowPremiumPaidByType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPremiumPaidByType Reference Value (Bound to Domain) |
Name | ValidationRule152 |
Description | |
Type | By List |
Value | Value Description |
Buyer | Buyer |
Lender | Lender |
Seller | Seller |
EscrowPremiumPaidByType Bound Attachments |
Name | Current Value |
EscrowPremiumPaidByType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPremiumPaidByType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaidByType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaidByType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaidByType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaymentType |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowPremiumPaymentType |
Logical Rolename | |
ColumnName | EscrowPremiumPaymentType |
RoleName | |
Domain | EscrowPremiumPaymentEnum |
Definition | The payment method of the premium for the escrow item. Paid Outside of Closing (POC), Waived or Collect at Closing. |
Note |
EscrowPremiumPaymentType Logical Attribute Properties |
Logical Attribute Name | EscrowPremiumPaymentType |
Datatype | VARCHAR(0) |
Nullable | YES |
EscrowPremiumPaymentType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowPremiumPaymentType Reference Value (Bound to Domain) |
Name | ValidationRule153 |
Description | |
Type | By List |
Value | Value Description |
CollectAtClosing | CollectAtClosing |
PaidOutsideOfClosing | PaidOutsideOfClosing |
Waived | Waived |
EscrowPremiumPaymentType Bound Attachments |
Name | Current Value |
EscrowPremiumPaymentType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowPremiumPaymentType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaymentType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaymentType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowPremiumPaymentType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowSpecifiedHUD1LineNumberValue |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowSpecifiedHUD1LineNumberValue |
Logical Rolename | |
ColumnName | EscrowSpecifiedHUD1LineNumberValue |
RoleName | |
Domain | MISMOValue |
Definition | The line number on the HUD-1 where the Escrow Item is to be disclosed. FORM SPECIFIC FIELD |
Note |
EscrowSpecifiedHUD1LineNumberValue Logical Attribute Properties |
Logical Attribute Name | EscrowSpecifiedHUD1LineNumberValue |
Datatype | VARCHAR(0) |
Nullable | NO |
EscrowSpecifiedHUD1LineNumberValue Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowSpecifiedHUD1LineNumberValue Bound Attachments |
Name | Current Value |
EscrowSpecifiedHUD1LineNumberValue User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowSpecifiedHUD1LineNumberValue Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowSpecifiedHUD1LineNumberValue Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowSpecifiedHUD1LineNumberValue Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowSpecifiedHUD1LineNumberValue Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowTotalDisbursementAmount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | EscrowTotalDisbursementAmount |
Logical Rolename | |
ColumnName | EscrowTotalDisbursementAmount |
RoleName | |
Domain | MISMOAmount |
Definition | Total amount disbursed for the escrow item from closing to the current date. |
Note |
EscrowTotalDisbursementAmount Logical Attribute Properties |
Logical Attribute Name | EscrowTotalDisbursementAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
EscrowTotalDisbursementAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EscrowTotalDisbursementAmount Bound Attachments |
Name | Current Value |
EscrowTotalDisbursementAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
EscrowTotalDisbursementAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowTotalDisbursementAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowTotalDisbursementAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EscrowTotalDisbursementAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedEscrowPremiumAmount |
Base Entity | ESCROW_ITEM_DETAIL |
Attribute Name | GFEDisclosedEscrowPremiumAmount |
Logical Rolename | |
ColumnName | GFEDisclosedEscrowPremiumAmount |
RoleName | |
Domain | MISMOAmount |
Definition | The dollar amount of the premium for an escrow item type, as reflected on a single instance of the GFE. |
Note |
GFEDisclosedEscrowPremiumAmount Logical Attribute Properties |
Logical Attribute Name | GFEDisclosedEscrowPremiumAmount |
Datatype | DECIMAL(0, 2) |
Nullable | NO |
GFEDisclosedEscrowPremiumAmount Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
GFEDisclosedEscrowPremiumAmount Bound Attachments |
Name | Current Value |
GFEDisclosedEscrowPremiumAmount User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
GFEDisclosedEscrowPremiumAmount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedEscrowPremiumAmount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedEscrowPremiumAmount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GFEDisclosedEscrowPremiumAmount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |