!!!LOAD GEO CODES
\\
----
!!Processing Information

This function provides the ability to load Geo Codes and Zip Ranges that will facilitate the defaulting of the Jurisdiction by Zip Code. The process developed is based on the [Geographic Coding |GEO_CODE] System provided by [Vertex|VERTEX].

!1. Loading the MATCHMST file

Before to execute this function you need to have loaded the [P2K_CM_LOADED_GEOCODES] table from the Vertex [MATCHMST] file.  Currently this data is loaded using the [SQL Loader|SQLLDR] tool provided with the data base. A control file has been provided for this functionality in the RUNTIME directory: __[GEOCODER.CTL|UDTX/geocoder.ctl]__.  To execute SQL Loader and populate this interim table with the data from Vertex, you would type in a command like:

{{{sqlldr p2k/pass@database control=GEOCODER}}}

You must ensure, of course, that the GEOCODER.CTL file is referencing the correct directory path and file name for the MATCHMST file. This will then load the over 70,000 GEO Code records into the table.

!2. Loading into the Data base Structures

Executing the UDTX function as noted below will take the vertex supplied data and populate (either inserting or updating) [P2K_CM_STATE_PROVINCES], [P2K_CM_TAX_JURISDICTIONS], [P2K_CM_COUNTIES] and [P2K_CM_ZIP_RANGES] tables.  Note that any of GEO Code records that should be deleted will not be handled by this process.  You should refer to your Vertex subscription documentation to delete these records (as applicable) manually through the [IDTX] screen.


----
!!Report Parameters & Filters
||Report Parameters||
|Country| Set to USA.
|State|You may select from a specific state or if left blank, will load for all states that are in the interim file.
|Exception Level|leave at 0-Exceptions Only.  There is no tracing with this function.
|User Comment|Any comment line that you wish to appear on the report.

This report will identify the number of records that it processed of each type (as noted above).  The processing will allow for the creation of new records or the updating of the name of the jurisdiction/county/zip code area if it has changed.








----
![Notes|Edit:Internal.UDGNIS] 	
[{InsertPage page='Internal.UDGNIS' default='Click to create a new notes page'}]