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. |