Table Lookup Tables - spectrum_quality_1 - 23.1

spectrum-inline

Product type
Software
Portfolio
Enrich
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Geocoding > Enterprise Tax
Spectrum > GeoEnrichment
Spectrum > Web Services
Spectrum > Spatial > Spectrum Spatial
Spectrum > Spectrum Platform
Spectrum > Data Integration
Spectrum > Quality > Addressing
Spectrum > Quality > Spectrum Quality
Spectrum > Discovery
Spectrum > Dataflow Designer
Spectrum > Quality > Context Graph
Version
23.1
Language
English
Product name
Precisely Spectrum
Title
spectrum-inline
First publish date
2007
ft:lastEdition
2023-06-02
ft:lastPublication
2023-06-02T09:54:39.526000

Table Lookup uses the following tables to identify terms. Use Table Management to create new tables or to modify existing ones. For more information, see Introduction to Lookup Tables.

Base Tables

Base tables are provided with the Data Normalization installation package.

  • Aeronautical Abbreviations
  • All Acronyms Initialism
  • Business Names Abbreviations
  • Canadian Territory Abbreviations
  • Computing/IT Abbreviations
  • EU Acronyms
  • Fortune 1000
  • French Abbreviations
  • French Arrondissement to Department Number
  • French Commune to Postal Code
  • French Department to Region
  • French Department Number to Department
  • Gender Codes
  • Geographic Directional Abbreviations
  • German Acronyms
  • German City to State Code
  • German Area Code to City
  • German District to State Code
  • German State Abbreviations
  • Government Agencies Abbreviations
  • IATA Airline Designator
  • IATA Airline Designator Country
  • Legal Abbreviations
  • Medical Abbreviations
  • Medical Organizations Acronyms
  • Military Abbreviations
  • Nicknames
  • Secondary Unit Abbreviations
  • Secondary Unit Reverse
  • Singapore Abbreviations
  • Spanish Abbreviations
  • Spanish Directional Abbreviations
  • Spanish Street Suffix Abbreviations
  • State Name Abbreviations
  • State Name Reverse
  • Street Suffix Abbreviations
  • Street Suffix Reverse
  • Subsidiary to Parent
  • U.K. Town to Postcode Area
  • U.K. Dialing Code Prefixes
  • U.K. Dialing Codes to Town
  • U.K. Postcode Area to Town
  • U.S. Army Acronyms
  • U.S. Navy Acronyms
  • ZREPLACE (Used by the SAP Module for French address validation)

Core Names

Core Names tables require an additional license. For more information, contact your account executive.

Core Names tables must be loaded using the Data Normalization database load utility. For instructions, see the Spectrum Technology Platform Installation Guide.

  • Enhanced Family Names Ethnicity
  • Enhanced Gender Codes
  • Enhanced Given Names Ethnicity

Arabic Plus Pack

Arabic Plus Pack tables require an additional license. For more information, contact your account executive.

Arabic Plus Pack tables must be loaded using the Data Normalization database load utility. For instructions, see the Spectrum Technology Platform Installation Guide.

  • Arabic Family Names Ethnicity (Arabic)
  • Arabic Family Names Ethnicity (Romanized)
  • Arabic Gender Codes (Arabic)
  • Arabic Gender Codes (Romanized)
  • Arabic Given Names Ethnicity (Arabic)
  • Arabic Given Names Ethnicity (Romanized)

Asian Plus Pack

Asian Plus Pack tables require an additional license. For more information, contact your account executive.

Asian Plus Pack tables must be loaded using the Data Normalization database load utility. For instructions, see the Spectrum Technology Platform Installation Guide.

  • CJK Family Names Ethnicity (Native)
  • CJK Family Names Ethnicity (Romanized)
  • CJK Given Names Ethnicity (Native)
  • CJK Given Names Ethnicity (Romanized)
  • Japanese Gender Codes (Kana)
  • Japanese Gender Codes (Kanji)
  • Japanese Gender Codes (Romanized)