This page (revision-37) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
37 26-Nov-2021 10:22 10 KB rforbes to previous
36 26-Nov-2021 10:22 10 KB rforbes to previous | to last
35 26-Nov-2021 10:22 11 KB rforbes to previous | to last
34 26-Nov-2021 10:22 11 KB rforbes to previous | to last
33 26-Nov-2021 10:22 12 KB rforbes to previous | to last
32 26-Nov-2021 10:22 16 KB jescott to previous | to last
31 26-Nov-2021 10:22 15 KB jmyers to previous | to last
30 26-Nov-2021 10:22 15 KB jmyers to previous | to last
29 26-Nov-2021 10:22 15 KB jmyers to previous | to last
28 26-Nov-2021 10:22 15 KB jmyers to previous | to last
27 26-Nov-2021 10:22 15 KB jmyers to previous | to last
26 26-Nov-2021 10:22 15 KB jmyers to previous | to last
25 26-Nov-2021 10:22 15 KB jmyers to previous | to last
24 26-Nov-2021 10:22 15 KB jmyers to previous | to last
23 26-Nov-2021 10:22 15 KB jmyers to previous | to last
22 26-Nov-2021 10:22 15 KB jmyers to previous | to last
21 26-Nov-2021 10:22 15 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
US Load GNIS Locations
US Load GNIS Locations

Version management

Difference between version and

At line 7 changed one line
!!UDGNIS – Load GNIS Codes
!!UDGNIS – Load GNIS Codes
At line 9 changed one line
!UDGNIS – Selection Criteria
!UDGNIS – Selection Criteria
At line 22 changed 3 lines
|Directory Name|if Create File = ‘Y’, user must enter a valid Directory Name for the .csv file
|File Name|if Create File = ‘Y’, user must enter a File Name for the .csv file
|Exception Level|Optional, [Exception Level|X_TRACE_LEVEL] lexicon available\\This field defines the exception level (report messages) required.\\You should run with Exception Level except for Tracing\\In ‘Utility Trace’, the report may be quite large
|Directory Name|if Create File = ‘Y’, user must enter a valid Directory Name for the .csv file
|File Name|if Create File = ‘Y’, user must enter a File Name for the .csv file
|Exception Level|Optional, [Exception Level|X_TRACE_LEVEL] lexicon available\\This field defines the exception level (report messages) required.\\You should run with Exception Level except for Tracing\\In ‘Utility Trace’, the report may be quite large
At line 29 changed 2 lines
!UDGNIS – Processing
*UDGNIS loads in the ‘US Geographic Names Information System (GNIS)’ Location codes from the Symmetry Tax Engine (STE)
!UDGNIS – Processing
*UDGNIS loads in the ‘US Geographic Names Information System (GNIS)’ Location codes from the Symmetry Tax Engine (STE)
At line 34 changed 2 lines
*If the ‘Create File’ toggle is set to <<Yes>>, each state will generate one .csv file to contain the geographic information for the state.
*The file name will be suffixed with the State code; you may attach the mex id of the run to the file name.\\e.g. File Name: cathy_gnis_mex\\- ‘mex’ will be replaced with the execution ID, then suffix with the State code
*If the ‘Create File’ toggle is set to <<Yes>>, each state will generate one .csv file to contain the geographic information for the state.
*The file name will be suffixed with the State code; you may attach the mex id of the run to the file name.\\e.g. File Name: cathy_gnis_mex\\- ‘mex’ will be replaced with the execution ID, then suffix with the State code
At line 37 changed 2 lines
*If the ‘Print Detail’ toggle is set to <<Yes>>, UDGNIS will list the detail entries that are processed for each level: Country, States, Counties, Cities, Schools, Municipalities, Tax Jurisdictions.
*If you have converted from Vertex Taxation to Symmetry Taxation for the Payroll Module, you MUST run UDGNIS with the ‘Vertex Conversion’ toggle set to <<Yes>> for the first time. Please read [Vertex Conversion|US Load GNIS Locations#section-US+Load+GNIS+Locations-VertexConversion] below.
*If the ‘Print Detail’ toggle is set to <<Yes>>, UDGNIS will list the detail entries that are processed for each level: Country, States, Counties, Cities, Schools, Municipalities, Tax Jurisdictions.
*If you have converted from Vertex Taxation to Symmetry Taxation for the Payroll Module, you MUST run UDGNIS with the ‘Vertex Conversion’ toggle set to <<Yes>> for the first time. Please read [Vertex Conversion|US Load GNIS Locations#section-US+Load+GNIS+Locations-VertexConversion] below.
At line 50 changed one line
!UDGNIS – List of Data Base Tables to be updated
!UDGNIS – List of Data Base Tables to be updated
At line 56 changed one line
*‘ISO Alpha 2’ and ‘ISO Alpha 3’ will be updated if these are not set up
*‘ISO Alpha 2’ and ‘ISO Alpha 3’ will be updated if these are not set up
At line 108 changed one line
*If UDGNIS was run with the parameter Create Jurisdictions = No, the user will need to enter the IDTX entry using the ‘Tax Jurisdiction Editor Dialog Box’ provided by the system on the applicable screen
*If UDGNIS was run with the parameter Create Jurisdictions = No, the user will need to enter the IDTX entry using the ‘Tax Jurisdiction Editor Dialog Box’ provided by the system on the applicable screen
At line 113 changed one line
*if user is converting from Vertex Taxation to Symmetry Taxation in the Payroll Module, user MUST run UDGNIS with ‘Vertex Conversion’ = ‘Y’ for the first time
*if user is converting from Vertex Taxation to Symmetry Taxation in the Payroll Module, user MUST run UDGNIS with ‘Vertex Conversion’ = ‘Y’ for the first time
At line 115 changed one line
*after UDGNIS is run with ‘Vertex Conversion’ = ‘Y’, all related Vertex Geographic Data Base Tables are converted, after the conversion, user MUST review UDGNIS exception report and manually fix any IDTX entries that cannot be converted
*after UDGNIS is run with ‘Vertex Conversion’ = ‘Y’, all related Vertex Geographic Data Base Tables are converted, after the conversion, user MUST review UDGNIS exception report and manually fix any IDTX entries that cannot be converted
At line 117 changed one line
*IDCN County Code format is changed from Vertex Format ‘XX-XXX-0000’ to Symmetry Format ‘XX-XXX’, the Alternate County Code will store the previous Vertex County Code for reference
*IDCN County Code format is changed from Vertex Format ‘XX-XXX-0000’ to Symmetry Format ‘XX-XXX’, the Alternate County Code will store the previous Vertex County Code for reference
At line 133 changed one line
*IDTX Vertex GEO Code format is changed from ‘XX-XXX-XXXX’ to Symmetry Format ‘AA-BBB-CCCCCCC’, the old Vertex GEO Code will be stored in the Vtx GEO Code for reference
*IDTX Vertex GEO Code format is changed from ‘XX-XXX-XXXX’ to Symmetry Format ‘AA-BBB-CCCCCCC’, the old Vertex GEO Code will be stored in the Vtx GEO Code for reference
At line 135 changed one line
*if Symmetry has an exact match of the Jurisdiction Name, then this IDTX entry will be updated with the new GNIS Code in format of ‘AA-BBB-CCCCCCC’, along with the County dcn_id and City dci_id
*if Symmetry has an exact match of the Jurisdiction Name, then this IDTX entry will be updated with the new GNIS Code in format of ‘AA-BBB-CCCCCCC’, along with the County dcn_id and City dci_id
At line 153 changed 2 lines
!UDGNIS – Sample .csv File
*if ‘Create File’ = Yes, each State will generate one .csv File to contain the Geographic Information for the State
!UDGNIS – Sample .csv File
*if ‘Create File’ = Yes, each State will generate one .csv File to contain the Geographic Information for the State
At line 203 changed one line
!UDGNIS – Vertex Conversion Sample File
!UDGNIS – Vertex Conversion Sample File
This page (revision-37) was last changed on 26-Nov-2021 10:22 by rforbesTop