Custom Postal Matcher Attributes - trillium_discovery - trillium_quality - 17.1

Trillium Input/Output Attributes Reference Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Input/Output Attributes Reference Guide
First publish date
2008
Last updated
2024-06-06
Published on
2024-06-06T06:34:44.253206

The Custom Postal Matcher process is used with the following nine countries.

Table 1. Custom Postal Matcher Countries

Code

Country

BE

Belgium

CH

Switzerland

ES

Spain

FR

France

LU

Luxembourg

MY

Malaysia

NL

Netherlands

PT

Portugal

SG

Singapore

The table given below lists the Custom Postal Matcher attributes.

Table 2. Custom Postal Matcher Attributes

Attribute Name

Length

Description

tq_gin_box_indicator

1

Box type indicator identified by the Parser.

tq_gin_box_number

10

Box number.

tq_gin_box_type

20

Box description.

tq_gin_busname

100

Business name identified by the Parser.

tq_gin_city_code

5

City code identified by the Parser.

tq_gin_city_name

30

City name identified by the Parser.

tq_gin_filler

108

Reserved for future use.

tq_gin_filler4

1

Reserved for future use.

tq_gin_house_number

15

House number identified by the Parser.

tq_gin_other1

60

First building name or neighborhood identified by the Parser.

tq_gin_other2

60

Second building name or neighborhood identified by the Parser.

tq_gin_postal_code

15

Postal code identified by the Parser.

tq_gin_record_type

1

Type of record identified by the Parser. Values are:

1 Street record

3 PO Box record

6 PO Box and street

E Unknown street pattern (CDP review code is 026)

F Foreign record

tq_gin_state

30

State or province name identified by the Parser.

tq_gin_state_code

5

State or province code identified by the Parser.

tq_gin_street_direction

12

Street direction identified by the Parser.

tq_gin_street_name

50

Street name identified by the Parser.

tq_gin_street_type

15

Street type identified by the Parser.

tq_gin_sub_building

20

First unit description identified by the Parser.

tq_gin_sub_building_value

10

First unit number identified by the Parser.

tq_gin_sub_building2

20

Second unit description identified by the Parser.

tq_gin_sub_building2_value

10

Second unit number identified by the Parser.

tq_gin_unit1_indicator

1

First unit type indicator identified by the Parser.

tq_gin_unit2_indicator

1

Second unit type indicator Identified by Parser.

tq_gout_box_indicator

1

Box type returned from the Postal Matcher.

tq_gout_box_number

10

Box number returned.

tq_gout_boxno_std

10

The return box number.

tq_gout_bus_name

100

Business name returned.

tq_gout_business_name_changed

1

Indicates change made to the business name returned. (A value of X means that the input business name does not match a business name in the GAV table.)

tq_gout_city_changed

1

Indicates change made to city returned.

tq_gout_completion_code

1

Return code.

  • 0 = Incomplete Address. Not matched to GAV table. Check the Match Level Code for more information.
  • 1 = Matched Address.

tq_gout_delivery_address

120

Re-constructed, returned delivery address.

tq_gout_delivery_address_2

120

France - Stores the secondary address if a dual address is detected (for example, a CEDEX record).

Note: To use this attribute you must add it manually using the Schema Editor.

tq_gout_dwelling_1_changed

1

Indicates change made to primary dwelling returned.

tq_gout_dwelling_2_changed

1

Indicates change made to secondary dwelling returned.

tq_gout_ext_key_1

15

France - The first five digits are Media Post's Locality INSEE Code and the rest is filler.

tq_gout_ext_key_2

15

Not used.

tq_gout_ext_key_3

15

France - Media Post's Street reference number.

tq_gout_house_number

20

House number returned.

tq_gout_hsno_std

15

Standard house number returned.

tq_gout_match_level

1

Contains the numeric code to identify the level at which the address matched, or failed to match, the GAV tables.

tq_gout_neighborhood_1_changed

1

Indicates change made to neighborhood 1 returned.

tq_gout_neighborhood_2_changed

1

Indicates change made to neighborhood 2 returned.

tq_gout_other1

80

First neighborhood/building name returned.

tq_gout_other2

80

Second neighborhood/building name returned.

tq_gout_postal_city

50

Corrected city name returned.

tq_gout_postal_code

15

Postal code returned.

tq_gout_postal_code_changed

1

Indicates change made to the postal code returned.

tq_gout_province_changed

1

Indicates change made to province returned.

tq_gout_record_type

1

Record type returned. Values are:

1 Street record

3 PO Box record

6 PO Box and street

E Pattern Error

F Foreign record

tq_gout_state

30

Corrected Province/State name returned.

tq_gout_street_direction

12

Corrected street direction returned.

tq_gout_street_direction_changed

1

Indicates change made to street direction returned.

tq_gout_street_name

100

Corrected street name returned.

tq_gout_street_name_changed

1

Indicates change made to street name returned.

tq_gout_street_type

15

Corrected street type returned.

tq_gout_street_type_pt

15

Street type. (Portugal only)

tq_gout_street_type_changed

1

Indicates change made to street type returned.

tq_gout_streetnm_pt

80

Street name, without the type. (Portugal only)

tq_gout_sub_building

20

First unit description identified by the Parser.

tq_gout_sub_building_value

10

First unit number returned.

tq_gout_sub_building2

20

First unit description identified by the Parser.

tq_gout_sub_building2_value

10

Second unit number returned.

tq_gout_unit1_indicator

1

First unit type returned.

tq_gout_unit1_number

10

The returned unit1 number.

tq_gout_unit2_indicator

1

Second unit type returned.

tq_gout_unit2_number

10

The returned unit2 number.