Custom Postal Matcher Attributes - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

This table lists the Custom Postal Matcher attributes.

Attribute

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_boxno_std

10

Box number returned.

tq_gout_box_number

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 postal file. Check the Match Level Code for more information.

1—Matched Address.

tq_gout_delivery_address

120

Reconstructed, returned delivery address.

tq_gout_delivery_address_2 120

France only. 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 only. 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 Global Address Verification (GAV) tables. See Match Level Codes for details.

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

Portugal only. Street type.

tq_gout_street_type_changed

1

Indicates change made to street type returned.

tq_gout_streetnm_pt

80

Portugal only. Street name, without the type.

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.