United States (US) Postal Matcher Attributes - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

This table lists the attributes for the US Postal Matcher.

Attribute

Length

Description

us_gin_address_type

1

Input address type. Values are:

1 = Street

2 = RR/HC

3 = PO Box

4 = Error

5 = Bad Street Pattern

F = Foreign

us_gin_bldg_firm_name

40

Stores the input name.

us_gin_box_number

10

Stores the PO box number on dual address records.

us_gin_city_change_flag

1

Stores the city change flag.

us_gin_dual_addr_flag

1

Stores the dual address flag. Values are:

G = General Delivery

P = PO Box

R = Rural Route

Blank

us_gin_filler_01

28

Reserved for future use.

us_gin_house_number

10

Stores the input house number.

us_gin_postal_city_number

6

Stores the postal city number.

us_gin_postal_city_name

30

Stores the postal city name.

us_gin_postal_code

9

Contains the input postal code.

us_gin_postal_code_original

9

Contains the original postal code.

us_gin_postal_index_01-06

6

Contains the post finance number.

us_gin_route_number

10

Stores the rural route number.

us_gin_secondary_number

10

Contains the input secondary number.

us_gin_secondary_type

4

Contains the input secondary type.

us_gin_state_change_flag

1

Stores the state change flag.

us_gin_state_name

2

Stores the state and abbreviation.

us_gin_street_pre_direction

2

Contains the input pre-direction.

us_gin_street_post_direction

2

Contains the input post-direction.

us_gin_street_name

40

Contains the input street name.

us_gin_street_suffix

4

Contains the input street suffix (type).

us_gin_tertiary_number

10

Contains the tertiary number.

us_gin_tertiary_type

4

Stores the tertiary type.

us_gin_urban_city_name

30

Contains the urban city name.

us_gout_alias_street_name 40 Contains the alias street name.
us_gout_alias_street_post_direction 2 Contains the alias street post direction.
us_gout_alias_street_pre_direction 2 Contains the alias street pre-direction.
us_gout_alias_street_suffix 4 Contains the alias street suffix.
us_gout_alias_type 1 Contains the alias type. Values are:

A = Abbreviated

C = Street Name Changed

O = Nickname/Other

P = Preferred Street Name

us_gout_building_ind

1

Contains the current number of apartments.

A = < 5

B = 6 - 10

C = 11 - 25

D = 26 - 50

E = 51 - 100

F = 101 -200

G = 201 - 350

H > 350

us_gout_carrier_route

4

Contains the carrier route ID.

Note: A return of a carrier route assignment of "777" in the us_gout_carrier_route attribute indicates the input address matched to a PBSA delivery location in the US Postal zip4 directory.

us_gout_city_area_name_changed

1

This flag is set to Y if the city name changed from the input.

us_gout_completion_code

1

Return code.

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

1 = Matched Address.

us_gout_delivery_address

50

Stores the output delivery address. This is rebuilt from the best available matched or parsed address components.

us_gout_delivery_address_2

50

Stores the secondary address if a dual address is detected.

us_gout_delivery_point

2

Stores the output delivery point.

Note: The Delivery Point Barcode (DPBC) consists of the us_gout_postal_code, the us_gout_ delivery_point, and the us_gout_delivery_point_cd attributes.

us_gout_delivery_point_cd

1

Stores the output delivery point check digit.

Note: The Delivery Point Barcode (DPBC) consists of the us_gout_postal_code, the us_gout_ delivery_point, and the us_gout_delivery_point_cd attributes.

us_gout_house_number

10

Stores the output house number.

us_gout_lacs_status_ind

1

Contains the LACS indicator from the Zip4 file.

us_gout_county_number

3

Contains the numeric code to identify the county.

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

us_gout_postal_city_name

30

Contains the postal city name.

us_gout_postal_code

9

Stores the output postal code.

Note: The Delivery Point Barcode (DPBC) consists of the us_gout_postal_code, the us_gout_ delivery_point, and the us_gout_delivery_point_cd attributes.

us_gout_postal_code_changed

1

This flag is set to Y if the postal code changed from the input.

us_gout_postal_city_name_preferred

30

Contains the preferred city name for the record's zip code.

Note: Some zip codes are used for more than one city. When there is more than one city for a zip code, the U.S Postal Service designates one as the preferred city; other cities are referred to as alternate cities.

us_gout_record_type

2

Contains the linked record type. The first character represents the record type.

  • F = Firm
  • G = General Delivery
  • H = Highrise
  • P = PO BoxR = Rural Route
  • S = Street

The second character represents the match type.

  • Blank = Standard Match
  • D = Default Match
  • U = Unique Match
  • B = Both unique and default

us_gout_congressional_district

2

This is a standard value identifying a geographic area within the US served by a member of the US House of Representatives or Senate. If there is only one member of Congress within a state, the code is "AL" to indicate "At Large."

us_gout_secondary_type

4

Stores the secondary type.

us_gout_secondary_number

10

Contains the secondary number.

us_gout_street_name

40

Contains the street name.

us_gout_street_pre_direction

2

Contains the street pre-direction.

us_gout_street_post_direction

2

Contains the street post direction.

us_gout_street_suffix

4

Contains the street suffix.

us_gout_state_name

2

Contains the state abbreviation.

us_gout_street_name_changed

1

This flag is set to Y if the street name changed from the input.

us_gout_street_components_changed

1

This flag is set to Y if the street components changed from the input.

us_gout_tertiary_type 4 Stores the tertiary type.
us_gout_tertiary_number 10 Stores the tertiary number.

us_gout_urban_city_name

30

Stores the urbanization name.