AddressAdditionalLineText 
Base Entity  ADDRESS 
Attribute Name  AddressAdditionalLineText 
Logical Rolename   
ColumnName  AddressAdditionalLineText 
RoleName   
Domain  MISMOString 
Definition  Address information that cannot be contained in the Address Line Text. 
Note 
 

AddressAdditionalLineText Logical Attribute Properties 
Logical Attribute Name  AddressAdditionalLineText 
Datatype  VARCHAR(0) 
Nullable  NO 

AddressAdditionalLineText Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressAdditionalLineText Bound Attachments 
Name  Current Value 

AddressAdditionalLineText User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressAdditionalLineText Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressAdditionalLineText Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressAdditionalLineText Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressAdditionalLineText Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  ADDRESS 
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 


AddressLineText 
Base Entity  ADDRESS 
Attribute Name  AddressLineText 
Logical Rolename   
ColumnName  AddressLineText 
RoleName   
Domain  MISMOString 
Definition  The address with the address number, pre-directional, street name, post-directional, address unit designators and address unit value. 
Note 
 

AddressLineText Logical Attribute Properties 
Logical Attribute Name  AddressLineText 
Datatype  VARCHAR(0) 
Nullable  NO 

AddressLineText Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressLineText Bound Attachments 
Name  Current Value 

AddressLineText User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressLineText Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressLineText Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressLineText Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressLineText Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AddressType 
Base Entity  ADDRESS 
Attribute Name  AddressType 
Logical Rolename   
ColumnName  AddressType 
RoleName   
Domain  AddressEnum 
Definition  Specifies the type of address.  
Note 
 

AddressType Logical Attribute Properties 
Logical Attribute Name  AddressType 
Datatype  VARCHAR(0) 
Nullable  YES 

AddressType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressType Reference Value (Bound to Domain) 
Name  ValidationRule9 
Description   
Type  By List 
Value  Value Description 
Mailing  Mailing 
Other  Other 
Primary  Primary 
Current  Current 

AddressType Bound Attachments 
Name  Current Value 

AddressType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AddressTypeOtherDescription 
Base Entity  ADDRESS 
Attribute Name  AddressTypeOtherDescription 
Logical Rolename   
ColumnName  AddressTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to collect additional information when Other is selected for Address Type. 
Note 
 

AddressTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  AddressTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

AddressTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressTypeOtherDescription Bound Attachments 
Name  Current Value 

AddressTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AddressUnitDesignatorType 
Base Entity  ADDRESS 
Attribute Name  AddressUnitDesignatorType 
Logical Rolename   
ColumnName  AddressUnitDesignatorType 
RoleName   
Domain  AddressUnitDesignatorEnum 
Definition  An additional address designation that further defines the delivery location. Example: Apartment, Building, Condo, Suite, Room, Mail Stop, Unit, etc. This list is based on the USPS Publication 28 on Postal Addressing Standards with the addition of Condo based on mortgage industry need.  
Note 
 

AddressUnitDesignatorType Logical Attribute Properties 
Logical Attribute Name  AddressUnitDesignatorType 
Datatype  VARCHAR(0) 
Nullable  YES 

AddressUnitDesignatorType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressUnitDesignatorType Reference Value (Bound to Domain) 
Name  ValidationRule10 
Description   
Type  By List 
Value  Value Description 
Apartment  Apartment 
Basement  Basement 
Building  Building 
Condo  Condo 
Department  Department 
Floor  Floor 
Front  Front 
Hanger  Hanger 
Key  Key 
Lobby  Lobby 
Lot  Lot 
Lower  Lower 
Office  Office 
Other  Other 
Penthouse  Penthouse 
Pier  Pier 
Rear  Rear 
Room  Room 
Side  Side 
Space  Space 
Stop  Stop 
Suite  Suite 
Trailer  Trailer 
Unit  Unit 
Upper  Upper 

AddressUnitDesignatorType Bound Attachments 
Name  Current Value 

AddressUnitDesignatorType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressUnitDesignatorType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitDesignatorType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitDesignatorType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitDesignatorType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AddressUnitDesignatorTypeOtherDescription 
Base Entity  ADDRESS 
Attribute Name  AddressUnitDesignatorTypeOtherDescription 
Logical Rolename   
ColumnName  AddressUnitDesignatorTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  The description of the Address Unit Designator Type when Other is selected as the option from the enumerated list. 
Note 
 

AddressUnitDesignatorTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  AddressUnitDesignatorTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

AddressUnitDesignatorTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressUnitDesignatorTypeOtherDescription Bound Attachments 
Name  Current Value 

AddressUnitDesignatorTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressUnitDesignatorTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitDesignatorTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitDesignatorTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitDesignatorTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AddressUnitIdentifier 
Base Entity  ADDRESS 
Attribute Name  AddressUnitIdentifier 
Logical Rolename   
ColumnName  AddressUnitIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  The identifier value associated with the Secondary Address Unit Designator. Example: 123, C, B1C, etc. 
Note 
 

AddressUnitIdentifier Logical Attribute Properties 
Logical Attribute Name  AddressUnitIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

AddressUnitIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AddressUnitIdentifier Bound Attachments 
Name  Current Value 

AddressUnitIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

AddressUnitIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AddressUnitIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CarrierRouteCode 
Base Entity  ADDRESS 
Attribute Name  CarrierRouteCode 
Logical Rolename   
ColumnName  CarrierRouteCode 
RoleName   
Domain  MISMOCode 
Definition  A postal carrier route code is a part of the complete carrier route. The carrier route code is 4 characters consisting of 1 letter for the type of carrier route and 3 digits for the carrier route. The complete carrier route identifies a group of addresse 
Note 
 

CarrierRouteCode Logical Attribute Properties 
Logical Attribute Name  CarrierRouteCode 
Datatype  VARCHAR(0) 
Nullable  NO 

CarrierRouteCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CarrierRouteCode Bound Attachments 
Name  Current Value 

CarrierRouteCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CarrierRouteCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CarrierRouteCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CarrierRouteCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CarrierRouteCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CityName 
Base Entity  ADDRESS 
Attribute Name  CityName 
Logical Rolename   
ColumnName  CityName 
RoleName   
Domain  MISMOString 
Definition  The name of the city. 
Note 
 

CityName Logical Attribute Properties 
Logical Attribute Name  CityName 
Datatype  VARCHAR(0) 
Nullable  NO 

CityName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CityName Bound Attachments 
Name  Current Value 

CityName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CityName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CityName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CityName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CityName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CountryCode 
Base Entity  ADDRESS 
Attribute Name  CountryCode 
Logical Rolename   
ColumnName  CountryCode 
RoleName   
Domain  MISMOCode 
Definition  The two-character representation of the country. 
Note 
 

CountryCode Logical Attribute Properties 
Logical Attribute Name  CountryCode 
Datatype  VARCHAR(0) 
Nullable  NO 

CountryCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CountryCode Bound Attachments 
Name  Current Value 

CountryCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CountryCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountryCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountryCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CountryCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CountryName 
Base Entity  ADDRESS 
Attribute Name  CountryName 
Logical Rolename   
ColumnName  CountryName 
RoleName   
Domain  MISMOString 
Definition  The name of the country. 
Note 
 

CountryName Logical Attribute Properties 
Logical Attribute Name  CountryName 
Datatype  VARCHAR(0) 
Nullable  NO 

CountryName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CountryName Bound Attachments 
Name  Current Value 

CountryName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CountryName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountryName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountryName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CountryName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CountyCode 
Base Entity  ADDRESS 
Attribute Name  CountyCode 
Logical Rolename   
ColumnName  CountyCode 
RoleName   
Domain  MISMOCode 
Definition  Code identifying the county within a state. (Designator Code based on FIPS Publication 6-4) 
Note 
 

CountyCode Logical Attribute Properties 
Logical Attribute Name  CountyCode 
Datatype  VARCHAR(0) 
Nullable  NO 

CountyCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CountyCode Bound Attachments 
Name  Current Value 

CountyCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CountyCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountyCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountyCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CountyCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CountyName 
Base Entity  ADDRESS 
Attribute Name  CountyName 
Logical Rolename   
ColumnName  CountyName 
RoleName   
Domain  MISMOString 
Definition  The name of the county within a state. (Designator Name based on FIPS Publication 6-4) 
Note 
 

CountyName Logical Attribute Properties 
Logical Attribute Name  CountyName 
Datatype  VARCHAR(0) 
Nullable  NO 

CountyName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CountyName Bound Attachments 
Name  Current Value 

CountyName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

CountyName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountyName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CountyName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CountyName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DeliveryPointBarCodeCheckValue 
Base Entity  ADDRESS 
Attribute Name  DeliveryPointBarCodeCheckValue 
Logical Rolename   
ColumnName  DeliveryPointBarCodeCheckValue 
RoleName   
Domain  MISMOValue 
Definition  A check digit calculated using the MOD 10 method on the total of all 10 digits that make up the bar code for use in the Delivery Point Bar Code (DPBC). The DPBC is an 11 digit (plus check digit) barcode, containing the ZIP Code, ZIP+4 Code, and the delive 
Note 
 

DeliveryPointBarCodeCheckValue Logical Attribute Properties 
Logical Attribute Name  DeliveryPointBarCodeCheckValue 
Datatype  VARCHAR(0) 
Nullable  NO 

DeliveryPointBarCodeCheckValue Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DeliveryPointBarCodeCheckValue Bound Attachments 
Name  Current Value 

DeliveryPointBarCodeCheckValue User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

DeliveryPointBarCodeCheckValue Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DeliveryPointBarCodeCheckValue Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DeliveryPointBarCodeCheckValue Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DeliveryPointBarCodeCheckValue Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DeliveryPointBarCodeValue 
Base Entity  ADDRESS 
Attribute Name  DeliveryPointBarCodeValue 
Logical Rolename   
ColumnName  DeliveryPointBarCodeValue 
RoleName   
Domain  MISMOValue 
Definition  A code maintained by the USPS representing a delivery point (DP) which is a single mailbox or other place at which mail is delivered. This may be appended to the combination of zip code and zip+4 code for the purposes of creating a barcode. 
Note 
 

DeliveryPointBarCodeValue Logical Attribute Properties 
Logical Attribute Name  DeliveryPointBarCodeValue 
Datatype  VARCHAR(0) 
Nullable  NO 

DeliveryPointBarCodeValue Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DeliveryPointBarCodeValue Bound Attachments 
Name  Current Value 

DeliveryPointBarCodeValue User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

DeliveryPointBarCodeValue Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DeliveryPointBarCodeValue Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DeliveryPointBarCodeValue Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DeliveryPointBarCodeValue Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MailStopCode 
Base Entity  ADDRESS 
Attribute Name  MailStopCode 
Logical Rolename   
ColumnName  MailStopCode 
RoleName   
Domain  MISMOCode 
Definition  Uniquely identifies an individual or office within a private company for the purposes of internal mail distribution. USPS calls this a MailStop Code (MSC). 
Note 
 

MailStopCode Logical Attribute Properties 
Logical Attribute Name  MailStopCode 
Datatype  VARCHAR(0) 
Nullable  NO 

MailStopCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MailStopCode Bound Attachments 
Name  Current Value 

MailStopCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

MailStopCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MailStopCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MailStopCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MailStopCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PlusFourZipCode 
Base Entity  ADDRESS 
Attribute Name  PlusFourZipCode 
Logical Rolename   
ColumnName  PlusFourZipCode 
RoleName   
Domain  MISMOCode 
Definition  This is the additional four digits in the code 
Note 
 

PlusFourZipCode Logical Attribute Properties 
Logical Attribute Name  PlusFourZipCode 
Datatype  VARCHAR(0) 
Nullable  NO 

PlusFourZipCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PlusFourZipCode Bound Attachments 
Name  Current Value 

PlusFourZipCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PlusFourZipCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PlusFourZipCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PlusFourZipCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PlusFourZipCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PostalCode 
Base Entity  ADDRESS 
Attribute Name  PostalCode 
Logical Rolename   
ColumnName  PostalCode 
RoleName   
Domain  MISMOCode 
Definition  The postal code (ZIP Code in the US) for the address. ZIP Code may be either 5 or 9 digits. 
Note 
 

PostalCode Logical Attribute Properties 
Logical Attribute Name  PostalCode 
Datatype  VARCHAR(0) 
Nullable  NO 

PostalCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PostalCode Bound Attachments 
Name  Current Value 

PostalCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PostalCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PostalCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PostalCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PostalCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PostOfficeBoxIdentifier 
Base Entity  ADDRESS 
Attribute Name  PostOfficeBoxIdentifier 
Logical Rolename   
ColumnName  PostOfficeBoxIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  The identifier of the locked box located in the post office lobby or other authorized place that customers may rent for delivery of mail. 
Note 
 

PostOfficeBoxIdentifier Logical Attribute Properties 
Logical Attribute Name  PostOfficeBoxIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

PostOfficeBoxIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PostOfficeBoxIdentifier Bound Attachments 
Name  Current Value 

PostOfficeBoxIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PostOfficeBoxIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PostOfficeBoxIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PostOfficeBoxIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PostOfficeBoxIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RuralRouteIdentifier 
Base Entity  ADDRESS 
Attribute Name  RuralRouteIdentifier 
Logical Rolename   
ColumnName  RuralRouteIdentifier 
RoleName   
Domain  MISMOIdentifier 
Definition  An address for mail that is to be delivered to rural delivery route including both the rural route identifier and the box identifier. 
Note 
 

RuralRouteIdentifier Logical Attribute Properties 
Logical Attribute Name  RuralRouteIdentifier 
Datatype  VARCHAR(0) 
Nullable  NO 

RuralRouteIdentifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RuralRouteIdentifier Bound Attachments 
Name  Current Value 

RuralRouteIdentifier User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

RuralRouteIdentifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RuralRouteIdentifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RuralRouteIdentifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RuralRouteIdentifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StateCode 
Base Entity  ADDRESS 
Attribute Name  StateCode 
Logical Rolename   
ColumnName  StateCode 
RoleName   
Domain  MISMOCode 
Definition  The two-character representation of the US state, US Territory, Canadian Province, Military APO FPO, or Territory. 
Note 
 

StateCode Logical Attribute Properties 
Logical Attribute Name  StateCode 
Datatype  VARCHAR(0) 
Nullable  NO 

StateCode Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StateCode Bound Attachments 
Name  Current Value 

StateCode User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StateCode Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StateCode Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StateCode Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StateCode Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StateName 
Base Entity  ADDRESS 
Attribute Name  StateName 
Logical Rolename   
ColumnName  StateName 
RoleName   
Domain  MISMOString 
Definition  The name of the US state, US Territory, Canadian Province, Military APO FPO, or Territory. 
Note 
 

StateName Logical Attribute Properties 
Logical Attribute Name  StateName 
Datatype  VARCHAR(0) 
Nullable  NO 

StateName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StateName Bound Attachments 
Name  Current Value 

StateName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StateName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StateName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StateName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StateName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StreetName 
Base Entity  ADDRESS 
Attribute Name  StreetName 
Logical Rolename   
ColumnName  StreetName 
RoleName   
Domain  MISMOString 
Definition  The official name of a street assigned by a local governing authority. 
Note 
 

StreetName Logical Attribute Properties 
Logical Attribute Name  StreetName 
Datatype  VARCHAR(0) 
Nullable  NO 

StreetName Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StreetName Bound Attachments 
Name  Current Value 

StreetName User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StreetName Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetName Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetName Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StreetName Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StreetPostDirectionalText 
Base Entity  ADDRESS 
Attribute Name  StreetPostDirectionalText 
Logical Rolename   
ColumnName  StreetPostDirectionalText 
RoleName   
Domain  MISMOString 
Definition  The directional symbol that represents the sector of a city where a street address is located. Example: E, W, N, S, NE, NW, SE, SW. 
Note 
 

StreetPostDirectionalText Logical Attribute Properties 
Logical Attribute Name  StreetPostDirectionalText 
Datatype  VARCHAR(0) 
Nullable  NO 

StreetPostDirectionalText Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StreetPostDirectionalText Bound Attachments 
Name  Current Value 

StreetPostDirectionalText User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StreetPostDirectionalText Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPostDirectionalText Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPostDirectionalText Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPostDirectionalText Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StreetPreDirectionalText 
Base Entity  ADDRESS 
Attribute Name  StreetPreDirectionalText 
Logical Rolename   
ColumnName  StreetPreDirectionalText 
RoleName   
Domain  MISMOString 
Definition  The street vector or the direction the street has taken from some arbitrary starting point. Example: E, W, N, S, NE, NW, SE, SW. 
Note 
 

StreetPreDirectionalText Logical Attribute Properties 
Logical Attribute Name  StreetPreDirectionalText 
Datatype  VARCHAR(0) 
Nullable  NO 

StreetPreDirectionalText Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StreetPreDirectionalText Bound Attachments 
Name  Current Value 

StreetPreDirectionalText User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StreetPreDirectionalText Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPreDirectionalText Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPreDirectionalText Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPreDirectionalText Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StreetPrimaryNumberText 
Base Entity  ADDRESS 
Attribute Name  StreetPrimaryNumberText 
Logical Rolename   
ColumnName  StreetPrimaryNumberText 
RoleName   
Domain  MISMOString 
Definition  The number assigned to a building or land parcel along the street to identify location and ensure accurate mail delivery. 
Note 
 

StreetPrimaryNumberText Logical Attribute Properties 
Logical Attribute Name  StreetPrimaryNumberText 
Datatype  VARCHAR(0) 
Nullable  NO 

StreetPrimaryNumberText Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StreetPrimaryNumberText Bound Attachments 
Name  Current Value 

StreetPrimaryNumberText User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StreetPrimaryNumberText Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPrimaryNumberText Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPrimaryNumberText Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StreetPrimaryNumberText Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


StreetSuffixText 
Base Entity  ADDRESS 
Attribute Name  StreetSuffixText 
Logical Rolename   
ColumnName  StreetSuffixText 
RoleName   
Domain  MISMOString 
Definition  The trailing designator in a street address or the appropriate abbreviation. Example: Drive, Way, Court, Street, etc. 
Note 
 

StreetSuffixText Logical Attribute Properties 
Logical Attribute Name  StreetSuffixText 
Datatype  VARCHAR(0) 
Nullable  NO 

StreetSuffixText Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

StreetSuffixText Bound Attachments 
Name  Current Value 

StreetSuffixText User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

StreetSuffixText Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetSuffixText Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

StreetSuffixText Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

StreetSuffixText Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description