Custom Country Base Data Fields - trillium_discovery - trillium_quality - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

The following countries are all included as part of the Custom Postal Matcher: 

Belgium (BE) Portugal (PT)
France (FR) Singapore (SG)
Luxembourg (LU) Spain (ES)
Malaysia (MY) Switzerland (CH)
Netherlands (NL)

 

The data available varies by country.

Field

Description

PC

Post code value from the GAV table where there is a match to the street components, otherwise the original match is returned.

STATE

State Name

POSTAL_CITY

Postal City Name

STREET

Street Name

TYPE

Street Type (Ave., Rd., etc.)

DIR

Street Direction (N, S, W or E)

STREET_LOW

Low numbered addresses for the street range

STREET_HIGH

High numbered addresses for the street range

BOX_LOW

Box number range, low value

BOX_HIGH

Box number range, high value

ADDR_PARITY

Code that identifies the side or sides of a street for which a given address range is applicable. For street, highrise, firm and multi-carrier records:

 

B=Both sides of street

E=Even side (even-numbered addresses in the range)

O=Odd side (odd numbered addresses in the range)

UNIT

Unit Type (Apt., Unit, etc.)

UNIT_LOW

Low numbered units for the unit range

UNIT_HIGH

Low numbered units for the unit range

UNIT2

Secondary Unit Number information

UNIT_LOW2

Secondary unit number range, low value

UNIT_HIGH2

Secondary unit number range, high value

BUSNAME

Business Name

FLOOR

Floor

FLOOR_NUM

Floor Number

OTHER Country specific fields: Neighborhood, building, barrio, etc.

OTHER2

Country specific fields

UNIT1_IND

Primary unit type indicator (apt, unit, suite, etc.)

UNIT2_IND

Secondary unit type indicator (apt, unit, suite, etc.)

STREET_OUT

Street name, formatted for output

TYPE_OUT

Street type, formatted for output

BOX_OUT

Box type, formatted for output

OTHER_OUT

"Other" information, formatted for output

OTHER2_OUT

"Other2" information, formatted for output

BUSNAME_OUT

Business name, formatted for output

DIR_OUT

Street direction, formatted for output

STATE_OUT

State name, formatted for output

CITY_OUT

City name, formatted for output

POSTAL_OUT

Postal code, formatted for output

EXTERNAL1

Country based external key (delivery point id, secondary postal code, etc)

EXTERNAL2

Country based external key (delivery point id, secondary postal code, etc)

EXTERNAL3

Country based external key (delivery point id, secondary postal code, etc)

BOXNO_OUT

Box Number, formatted for output

HSNO_OUT

House number, formatted for output

UNIT1NO_OUT

Primary unit number, formatted for output

UNIT2NO_OUT

Secondary unit number, formatted for output