IM Relationship Resolution Information Center, Version 4.2

ADDRESS data segment definitions

The ADDRESS data segment contains identity address information.

Many of these tags are derived by the system and are not required to make use of the address in the source system. Those tags that should be considered minimally required are: ADDR_TYPE, ADDR1, CITY, STATE, POSTAL_CODE, and country.

The parsing algorithm is to some degree configurable to allow new understanding or customer specific needs to be leveraged without updates of the software. These configurations can be configured by adding or removing values in/from the DQM_ADDRESS_PART table.

If an implementation is to rely on pre-cleansing/parsing of the addresses prior to Relationship Resolution ingestion, then those tags that would normally be populated by the system must be provided to ensure that the proper use of the data can be made. The following tags should be populated so that the Relationship Resolution process can make use of the already corrected data: BUILDING_NUM, STREET_NAME, SEC_UNIT_RANGE, PO_BOX_NUM, RRHC_TYPE, RRHC_BOX, RRHC_BOX_NUM, STATE_CODE, COUNTRY_CODE, LATITUDE, and LONGITUDE. This will ensure that the process has the appropriate data to us during resolution.

Tag Name Field Type Data Type Required Explanation
ADDR_TYPE   Char(1) Yes A classification for the type of the address. Valid values are:
  • H - Home
  • B - Business
  • O - Other
COMPANY_NAME   Char(100) No The name of the company.
JOB_TITLE   Char(50) No The job title of the identity associated with the address.
ADDR1 Key Attribute Char(120) Yes The first address line Generally represented as: number, name, directional, suffix. For example, 5555 55th Street NE.
ADDR2 Key Attribute Char(120) No The second address line Generally represented as: secondary unit type and number. For example, Suite 55.
ADDR3 Key Attribute Char(120) No The third address line.
CITY Key Attribute Char(100) No The name of the city that is associated with the address.
STATE Key Attribute Char(100) No The name of the state that is associated with the address.
POSTAL_CODE Key Attribute Char(20) No The postal code that is associated with the address.
COUNTRY   Char(100) No The country code or name of the country that is associated with the address.
CARE_OF   Char(100) No Information identifying non-postal delivery instructions
ADDR_LEFTOVRS   Char(120) No Unidentified words in the original address
DELIV_PROB   Char(1) No A number from 0-9 that represents how likely that the original address is deliverable
BUILDING_NUM   Char No A number identifying the specific building on the street in the address.
PRE_DIRECTIONAL   Char(2) No A directional found before the street name in the address. For example, NE stands for north east.
STREET_NAME   Char No Name of the street in the address.
STREET_SUFFIX   Char No Street suffix that is used to fully qualify the street. For example, Street, Avenue, and so on.
POST_DIRECTIONAL   Char(2) No A directional found after the suffix in the address. For example, NE stands for north east.
SEC_UNIT_TYPE   Char No A unit type used to describe the address. For example, Apt, Floor, Level, Unit, and so on.
SEC_UNIT_RANGE   Char No A number used to identify the unit type within the building.
PO_BOX_NUM   Char No A post office box number.
RRHC_TYPE   Char No The type of rural route designator.
RRHC_NUM   Char No A unique number identifying the rural route.
RRHC_BOX_NUM   Char No A unique number within the route identifying the specific delivery box
STATE_CODE   Char(50) No A two digit state code. For example, NJ stands for New Jersey.
COUNTRY_CODE   Char(6) No A two character ISO country code. For example GB stands for The United Kingdom, Great Britain.
COUNTRY_CODE3   Char(3) No A three character ISO country code. For example GBR stands for The United Kingdom, Great Britain.
DPBC   Char(20) No Delivery point bar code. This is the encoding the United State Postal Service puts on the barcode for US mail.
CARRIER_ROUTE   Char(20) No The United State Postal Service mail carrier route identifier.
LOT_CODE   Char(20) No The United State Postal Service mail carrier lot identifier.
ADDR_STAT   Char(2) No The usability status of this address. This value is based on a "bad address" or "mail return" flag in the source system. Valid values are:
  • V - Valid
  • I - Invalid
  • U - Unknown
ADDR_STAT_DT   Date No The date that the address status was applied.
LATITUDE   Char(10) No The latitude value for this address.
LONGITUDE   Char(10) No The longitude value for this address.
VALID_FROM_DT   Date No The date that the address information became valid.
VALID_THRU_DT   Date No The date that the address information is expired or will expire.
CLEANSED_TYPE   Char No The type of address cleansing that has been performed. Valid values are:
  • INT - International
  • CAN - Canadian
  • US - United States
  • NONE - None
CLEANSED_STATUS   Char No The outcome of the cleansing attempt. Valid values are:
  • CLEANSED
  • PARSED
  • DISABLED
  • NONE
PREFIX1   Char No Additional address information. Used to foreign addresses.
PREFIX2   Char No Additional address information. Used to foreign addresses.
PREFIX3   Char No Additional address information. Used to foreign addresses.
LOAD_ACTION   Char(1) No The action to take when loading the segment. Valid values are:
A
Add.
C
Change.
D
Soft delete.
F
Hard delete.
Note: Using a LOAD_ACTION value of F will the data to be permanently deleted.


Feedback

Last updated: 2009