Database Options
The following describes the database options presented in the Windows Database Load Utility.
- GeoTAX master files
- The GeoTAX/Enterprise Tax Premium Database is a required dataset and is the master file for the Enterprise Tax Module software. The master 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 the Enterprise Tax Module uses to override results from the master files in street-level matching. If you have data that is more current than that in the master files, you can enter the new data into the auxiliary file and use it for your address matching. The Enterprise Tax Module 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 master 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 Module Guide.
- State-supplied Florida format file
- This is a state-supplied file in Florida-native format which is provided by individual state governments. The Enterprise Tax Module first attempts to match to the state database. If the Enterprise Tax Module cannot find a state match, it attempts a match to the GeoTAX Auxiliary file, if loaded, then to the master 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. The Enterprise Tax Module first attempts to match to the state database. If the Enterprise Tax Module cannot find a state match, it attempts a match to the GeoTAX Auxiliary file, if loaded, then to the master 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 Pitney Bowes Sales and Use Tax Rate file allows you to use the Enterprise Tax Module 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 the Enterprise Tax Module 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 Pitney Bowes. The install program produces a database file GTMSTR2 in the specified destination.