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 |