Germany (DE) 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 Germany Postal Matcher attributes.

Attribute

Length

Description

de_gin_alt_pobox_name 10

Contains a PO box name when there is a street name also present on the input record.

de_gin_alt_pobox_number

8

Post office box number.

de_gin_alt_pobox_position

1

Indicates input position on the address line for the PO box.

de_gin_building

30

Contains the input building name.

de_gin_city_name

30

Contains the city name, as identified by the Parser.

de_gin_filler

17

Reserved for future use.

de_gin_house_number

8

Contains the house number that typically is the value following the street name.

de_gin_organization_name

30

Contains the organization name (business name).

de_gin_postal_code

10

Stores the original post code from the input record.

de_gin_record_type

1

Contains the built record type. Values are:

  • 1—Street record
  • 3—PO Box record
  • 4—Error record
  • E—Unknown street pattern review group record
  • F—Foreign record

de_gin_street_name

30

Contains the street name.

de_gin_sub_building

15

Contains the unit type within a building, such as Apt. or Unit.

de_gin_sub_building_value

10

Contains the unit value within a building, such as Apt# or Unit#.

de_gout_area_key 8

Indicates geographic area. The 8-digit field is broken down as follows:

Position 1-2 = Region (Bundeslander)

Position 3 = Administrative District (Regierungsbezirk)

Position 4-5 = District (Kreis)

Position 6-8 = Community (Gemeinde)

Note: The 2-digit region code is returned if Match Level > 1.
de_gout_administrative_district 1 Administrative district code (Regierungsbezirk). Redefinition of de_gout_area_key, position 3.

de_gout_building

30

Stores the output building name.

de_gout_city_name

40

Stores the postal city.

de_gout_city_name_upper

40

Stores the postal city, in uppercase.

de_gout_city_name_uplow

40

Stores the postal city, in mixed case.

de_gout_city_state_changed

1

If Y, indicates that the city name output is different from input.

de_gout_community 3 Community code (Gemeinde). Redefinition of de_gout_area_key, position 6-8.

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

de_gout_delivery_address

50

Stores the reconstructed street address. This value is constructed from the returned street components to provide a usable mailing address.

de_gout_delivery_address_upper

50

Stores the reconstructed street address, in uppercase. This value is constructed from the returned street components to provide a usable mailing address.

de_gout_delivery_address_uplow

50

Stores the reconstructed street address, in mixed case. This value is constructed from the returned street components to provide a usable mailing address.

de_gout_district 2 District code (Kreis). Redefinition of de_gout_area_key, position 4-5.
de_gout_district_changed 1 If Y, indicates that the district name output is different from input.
de_gout_district_name 30 Name of town district.

de_gout_house_number

8

Stores the house number that is typically the value following the street name.

de_gout_lsa_postal_code 5 Large-Scale Address (LSA) code that is the equivalent of a P.O. box postal code. If a P.O. box exists for an input record based on street name, house number and business name, the LSA value is placed in this field.

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

de_gout_multiple_districts 1 If Y, indicates that there are multiple matches having different districts. The Postal Matcher returns a fail level 0 and blanks out the return district field.

de_gout_postal_code

5

Stores the postal code value from the GAV table when there is a match to the street components; otherwise, the original input post code is returned.

de_gout_postal_code_changed

1

If Y, indicates that the postal code output is different from input.

de_gout_record_type

1

Stores the record type.

de_gout_state

2 State code (Bundeslander). Redefinition of de_gout_area_key, position 1-2.

de_gout_street_code

3

A 3-digit code that is used in conjunction with the post code to indicate a street or a street section.

de_gout_street_name 46 Stores the street name.

de_gout_street_name_upper

46

Stores the street name, in uppercase.

de_gout_street_name_changed

1

If Y, indicates that the street name output is different from input.

de_gout_street_components_changed

1

If Y, indicates that the street components output is different from input.

de_gout_street_name_uplow

46

Stores street name, in mixed case.

de_gout_sub_building

15

Stores unit type within a building, such as Apt. or Unit.

de_gout_sub_building_value

10

Stores unit value within a building, such as Apt# or Unit#.