United Kingdom (GB) 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 attributes for the United Kingdom Postal Matcher.

Attribute

Length

Description

gb_gin_building

30

Contains the building or house name.

gb_gin_county_posttown_code

10

Contains the county or post town code.

gb_gin_dpnd_locality_code

5

Contains the double-dependent locality code.

gb_gin_dpnd_thorough_name

30

Contains the dependent thoroughfare name, direction.

gb_gin_dpnd_thorough_desc

15

Contains the dependent thoroughfare description (type).

gb_gin_house_number

10

Contains the house number.

gb_gin_locality_code

5

Contains the locality code.

gb_gin_organization_name

30

Contains the organization name.

gb_gin_pobox

6

Contains the PO Box number.

gb_gin_postal_code

8

Contains the postal code.

gb_gin_record_type

1

Contains the predefined record type.

  • 1 - Street Record
  • 3 - PO Box Record
  • 4 - Error Record. Record does not conform to any of the other types.
  • 5 - House Record
  • 6 - Building/Postal Record

gb_gin_sub_building

30

Contains the type and value: for example, Flat or Flat#.

gb_gin_sub_building_value

10

Contains the value only (1).

gb_gin_thorough_name

30

Contains the thoroughfare name, direction.

gb_gin_thorough_desc

15

Contains the descriptor (type).

gb_gout_building

50

Stores the building or house name.

gb_gout_building_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and the building name changed from the original input.

gb_gout_completion_code

1

Return code.

0 = Incomplete Address. Not matched to GAV file. Check the Match Level Code for more information.

1 = Matched Address.

gb_gout_county_code

5

Stores the county code.

gb_gout_county_name

30

Stores the county name.

Note: Royal Mail no longer includes county name in the GAV tables it provides. County names that are available pre-date 1996.
gb_gout_delivery_address 100

Stores the first line of delivery address. It is built using the following attributes:

gb_gout_house_number + gb_gout_thorough_name + gb_gout_thorough_desc

OR

gb_gout_thorough_name + gb_gout_pobox (or gb_gout_house_number if gb_gout_pobox is empty)

gb_gout_delivery_address_2 100

Stores the second line of delivery address. It is built using the following attributes:

gb_gout_sub_building + gb_gout_sub_building_value + gb_gout_building

gb_gout_delivery_point 2

Stores the delivery point suffix.

gb_gout_department 60

Stores the department name.

Note: To display the department names, the Use Postal Extensions option must be checked to use the postal extension table (GBEXDATA.tbl). The postal extension table is included in the GB Global Address Verification (GAV) tables delivered in September 2014 or later.
Note: This is a new attribute for v15 Update 1. If you import or migrate your old or legacy projects after installing v15 Update 1, the new attribute will be automatically applied upon import or migration. If you import or migrate your old or legacy projects in v15 and then install v15 Update1, the new attribute will be applied when you run the GB Postal Matcher process.

gb_gout_dpnd_thorough_name

30

Stores the dependent thoroughfare name.

gb_gout_dpnd_thorough_desc

15

Stores the descriptor (type).

gb_gout_dpnd_locality_code

5

Stores the double-dependent locality code.

gb_gout_dpnd_locality_name

30

Stores the double-dependent locality name.

gb_gout_dps_checksum

1

Stores the delivery point duplicate row calculation (checksum) value.

gb_gout_house_number

10

Stores the house number.

gb_gout_locality_code

5

Stores the locality code.

gb_gout_locality_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and if any of the following occurs:

  • Output locality code changed from input locality code.
  • Output double-dependent locality code changed from input double-dependent locality code.
  • Output post town code changed from input county or post town code (position 5-9).
  • Output county code changed from input county or post town code (position 0-4).

gb_gout_locality_name

30

Stores the locality name.

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

gb_gout_organization_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and the organization changed from the original input.

gb_gout_organization_name

60

Stores the business organization name.

Note: The length of gb_gout_organization_name is extended from 30 to 60 in v15 Update 1. To display the extended version of organization names, the Use Postal Extensions option must be checked to use the postal extension table (GBEXDATA.tbl). The postal extension table is included in the GB Global Address Verification (GAV) tables delivered in September 2014 or later.
Note: If you import or migrate your old or legacy projects after installing v15 Update 1, the new attribute length will be automatically applied upon import or migration. If you import or migrate your old or legacy projects in v15 and then install v15 Update1, the new attribute length will be applied when you run the GB Postal Matcher process.

gb_gout_organization_key

8

Stores the organization key provided by the PAF file.

gb_gout_paf_key

8

Stores the key provided from the PAF file.

gb_gout_postcode_type

1

Stores the postcode type. Values are:

  • L—Large user
  • S—Small user or street

gb_gout_postcode_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and the postcode changed from the original input.

gb_gout_pobox

6

Stores the PO box number.

gb_gout_posttown_code

5

Stores the post town code.

gb_gout_posttown_name

30

Stores the post town name.

gb_gout_postal_code

7

Stores the postal code.

gb_gout_postal_code_out

4

Stores the postal code outbound.

gb_gout_postal_code_in

3

Stores the postal code inbound.

gb_gout_street_name_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and the street name changed from the original input.

gb_gout_street_type_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and the street type changed from the original input.

gb_gout_sub_building

30

Stores the sub-building name: for example, Flat or Flat#.

gb_gout_sub_building_value

10

Stores the sub-building value only.

gb_gout_sub_building_changed

1

This flag is set to Y if the match level code is 0, 4, or 5 and the sub-building name changed from the original input.

gb_gout_thorough_name

30

Stores the thoroughfare name.

gb_gout_thorough_desc

15

Stores the descriptor (type).

gb_gout_udprn 8

Stores a UDPRN (Unique Delivery Point Reference Number), an 8-character numeric code to identify the PAF addresses.

Note: This is a new attribute for v15 Update 1. If you import or migrate your old or legacy projects after installing v15 Update 1, the new attribute will be automatically applied upon import or migration. If you import or migrate your old or legacy projects in v15 and then install v15 Update1, the new attribute will be applied when you run the GB Postal Matcher process.