File Naming Conventions - trillium_discovery - trillium_quality - 17.1

Trillium DQ Installation Guide
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 DQ Installation Guide
First publish date
2008
Last updated
2024-10-19
Published on
2024-10-19T09:58:08.471711

The GAV tables are delivered in a compressed format. The file extensions are .zip (for Windows operating systems) and .tar (for UNIX operating systems). The following file naming conventions are used:

64-Bit UTF-8 GAV Tables

XXMMMq64.ext, where XX is the 2-letter country code, MMM is the abbreviation for the month the table was issued, and ext is either zip or tar. Valid for use on Windows and Linux 64-bit operating systems.

Note: Trillium ships two sets of Canadian tables. One set, which has the prefix CAC, is required for SERP certification and is limited to batch processing. The second set has the prefix CA; this set can be used in batch or real-time processing, but does not produce a SERP certificate.

Asian/APAC GAV Tables

XXMMMq.ext, where XX is the 2-letter country code, MMM is the abbreviation for the month the GAV table was issued, and ext is zip or tar. For example, CNJULq.zip is the China GAV table for July.

ACE GAV Tables

jpACEMMM.zip, where MMM is the month the GAV table was issued.

Note: ACE GAV Tables are used by the Japanese Address Code Edition (ACE) Postal Matcher. These tables provide address dictionaries to validate and enrich address data. They can be used to return standard address fields as well as address codes and bar codes.

Global (GA) GAV Tables

XXXMMMYY.ext, where XXX is the 3-letter country code, MMMYY represents the abbreviation for the month and year the table was issued, and ext is either zip or tar. For example, NORJAN18.zip is the Norwegian GAV table for January 2018.

Note: Global (GA) GAV Tables are a subset of international GAV tables that are invoked from within the Trillium software. The GAV tables in this subset are: Austria, Brazil, Czech Republic, Denmark, Finland, Greece, Hungary, Ireland, Mexico, New Zealand, Norway, Poland, Sweden, and the Basic countries.

US Census Table

USCMMMq.ext. This is the name of the United States census table that includes the Interpolated Rooftop files. MMM is the abbreviation for the month the directory was issued and ext is either zip or tar.

USXMMMq.ext. This is the name of the United States census table that includes the ZIP+4 Centroid files. MMM is the abbreviation for the month the directory was issued and ext is either zip or tar.

USPMMMq.ext. This is the name of the file that contains only the Interpolated Plus directory, where MMM is the abbreviation for the month the directory was issued and ext is either zip or tar.

Note: Census tables, which are available for the U.S. only, assign census geographic codes, such as county, tract, latitude and longitude, to address data. If you are interested in assigning latitude and longitude values to address data for other countries, contact your account manager for more information.

DPV Table

USDMMMq.ext. This is the name of the United States Delivery Point Validation table. MMM is the abbreviation for the month the table was issued and ext is either zip or tar.

Note: Delivery Point Validation (DPV) is a U.S. Postal Service product that helps validate the accuracy of existing address information and identify inaccurate, incomplete, or erroneous addresses.

LACSLink Table

USLMMMq.ext. This is the name of the United States LACSLink table, where MMM is the abbreviation for the month the table was issued and ext is either zip or tar.

Note: LACSLink is a product of the U.S. Postal Service that provides users with an automated method of obtaining a new address for locations that have been converted by local municipalities, usually when the community has implemented a 911 emergency system.

SuiteLink Table

USSMMMq.ext. This is the name of the United States SuiteLink table, where MMM is the abbreviation for the month the table was issued and ext is either zip or tar.

Note: SuiteLink is a product of the U.S. Postal Service that improves business address information by adding suite numbers to qualified records. Only business records that have been identified through CASS processing as having a high-rise default are candidates for SuiteLink processing.

RDI Tables

USRMMMq.ext. This is the name of the Residential Delivery Indicator (RDI) table, where MMM represents the abbreviation for the month the RDI table was issued and ext is either zip or tar. For example, USRAPRq.tar.

Note: Residential Delivery Indicator (RDI) is a product available from the U.S. Postal Service (USPS) that identifies a USPS delivery point as being a residential or commercial.
Note: Trillium’s license agreements with the U.S. Postal Service limit the shipment and transfer of DPV, LACSLink, SuiteLink, and RDI tables to the United States and its territories. Customers who purchase these table from Trillium must adhere to the same restriction.