Database Options - spectrum_platform - 23 - 23.1

Spectrum Installation Guide for Windows

Product type
Software
Portfolio
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Spectrum Platform
Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Installation Guide for Windows
Topic type
Configuration
Installation
Overview
How Do I
First publish date
2007
ft:lastEdition
2023-11-03
ft:lastPublication
2023-11-03T19:05:52.996250

The following describes the database options presented in the Windows Database Load Utility.

GeoTAX primary files
The GeoTAX/Enterprise Tax Premium Database is a required dataset and is the primary file for Enterprise Tax software. The primary files identify all geographic components associated with a street address, such as the latitude/longitude, census tract, and block group.
Point Data files
Point Data products include Master Location Data (MLD), Centrus Points, HERE Points, and TomTom Points. The point data provides point-level geocoding for the most accurate placement of addresses throughout the U.S. The Master Location Data database provides the best available address point location for every mailable and deliverable address in the United States.
User auxiliary file
This is a user-defined file that Enterprise Tax uses to override results from the primary files in street-level matching. If you have data that is more current than that in the primary files, you can enter the new data into the auxiliary file and use it for your address matching. Enterprise Tax returns matches made with a code that signifies the answer came from the auxiliary file. You can also return user-defined data from the auxiliary file with the match. The install program creates the file G1GTAUX in the specified destination.
GeoTAX auxiliary file
This file contains new addresses that have not yet been added to the primary files. It provides the most up-to-date address data possible. The install program creates the indexed sequential file G1GTAX2 in the specified destination.
Landmark auxiliary file
This is a user-defined file that allows you to specify customized address information in your input records. The recommended primary use of this file to match to your company’s non-address locations such as well heads, transmission towers or any other descriptive location. The latitude/longitude that is part of the input needed to build this file allows companies to automatically keep track of any jurisdictional changes that affect these unique locations. Matching to this file requires that the input record information match exactly to the Landmark file contents. This also applies to street records if you choose to enter them in the Landmark file. For more information, refer to the Enterprise Tax Guide.
State-supplied Florida format file
This is a state-supplied file in Florida-native format which is provided by individual state governments. Enterprise Tax first attempts to match to the state database. If Enterprise Tax cannot find a state match, it attempts a match to the GeoTAX Auxiliary file, if loaded, then to the primary files.
State-supplied TS-158 format file
This is a state-supplied file in TS-158 (ANSI Transaction Set No. 158) format which is provided by individual state governments. Enterprise Tax first attempts to match to the state database. If Enterprise Tax cannot find a state match, it attempts a match to the GeoTAX Auxiliary file, if loaded, then to the primary files.
Boundary file
Boundary files provide additional data about locations of special tax districts:
  • Special Purpose Tax Districts (spd.txb)
  • Insurance Premium Tax Districts (ipd.txb)
  • Payroll Tax Districts (pay.txb)
  • User-defined Boundary file (usr.txb)
PB Software tax rate file
The Precisely Sales and Use Tax Rate file allows you to use Enterprise Tax to provide sales and use tax rates for each of the assigned tax jurisdictions as well as the total rate for the assigned locations. The install program creates the indexed sequential file GTTAXRT.
Payroll tax correspondence file
Payroll tax cross-reference file allow you to use third-party software to determine the payroll tax rates. The cross-reference files combine the U.S. Government Federal Information Processing Standards (FIPS) codes with the proprietary geocodes used by tax software from third parties. The Payroll System Tax Code file is a customized file that you build to return the payroll tax codes used by your payroll system. The install program produces database files called G1GTPTC and G1GTPTC.vix.
Sovos cross reference file
This sales tax cross-reference file enables you to use Enterprise Tax to determine tax jurisdictions for a given address, then use Sovos software to determine the sales tax rates for those jurisdictions.
PB Software Vertex cross reference file
This is a Vertex cross-reference file supplied by Precisely. The install program produces a database file GTMSTR2 in the specified destination.