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 ingesting the identity records, 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 entity 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. Populating those tags ensures that the entity and relationship resolution process has the appropriate data to use 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
include the following:
|
|
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:
|
|
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:
|
|
CLEANSED_STATUS | Char | No | The outcome of the cleansing attempt. Valid values are:
|
|
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:
|