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

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
3 26-Nov-2021 10:22 673 bytes jescott to previous
2 26-Nov-2021 10:22 702 bytes jmyers to previous | to last
1 26-Nov-2021 10:22 2 KB jmyers to last

Page References

Incoming links Outgoing links
IDCI
IDCI

Version management

Difference between version and

At line 5 changed one line
The Maintain Cities (IDCI) screen displays all of the Cities which have been loaded in by the [UDGNIS] function.
The Maintain Cities (IDCI) screen allows you to create and maintain city information within the system.
At line 7 changed one line
City data is stored in the [P2K_CM_CITIES] table.
Work Rule data is stored in the [P2K_CM_STATE_PROVINCES], [P2K_CM_COUNTRIES], [P2K_CM_ZIP_RANGES], and [P2K_CM_TAX_JURISDICTIONS] tables.
At line 9 changed 5 lines
;[County Name|COUNTY_NAME]:The name of the county associated with the city is identified in this field.
;[County Code|COUNTY_CODE]:The county code associated with the city is identified in this field.
;[City Code|CITY_CODE]:The city code is identified in this field.
;[City|CITY_NAME]:The name of the city is identified in this field.
!!Country Zip Ranges tab
;[Country Name|COUNTRY_NAME]:The name of the country associated with the zip code range is identified in this field.
;[Country Code|COUNTRY_CODE]:The country code associated with the zip code range is identified in this field.
;[Alt Country Code|COUNTRY_CODE]:An alternate country code associated with the zip code range is identified in this field.
;[State Name|STATE_PROVINCE_CODE]:The state associated with the zip code range is identified in this field.
;[Zip Code|ZIP_POSTAL]:The zip code associated with the zip range is identified in this field.
;[City|CITY_NAME]:The name of the city associated with the zip code range is identified in this field.
;[City Code|CITY_CODE]:The city code associated with the zip code range is identified in this field.
;[Description|DESCRIPTION]:A short description of the zip range is provided in this field.
\\
At line 20 added 9 lines
!!Jurisdiction Zip Ranges tab
;[GNIS Code|GEO_CODE]:The GNIS associated with the zip range is identified in this field.
;[Jurisdiction|JURISDICTION_NAME]:The jurisdiction associated with the zip range is identified in this field.
;[GEO Type|GEO_TYPE]:The GEO type associated with the zip range is identified in this field.
;[Zip Code Start|ZIP_POSTAL_START]/[Zip Code End|ZIP_POSTAL_END]:These fields identify the start and end of the zip codes.
;[City|CITY_NAME]:The name of the city associated with the zip code range is identified in this field.
;[City Code|CITY_CODE]:The city code associated with the zip code range is identified in this field.
;[Description|DESCRIPTION]:A short description of the zip range is provided in this field.
----
This page (revision-3) was last changed on 26-Nov-2021 10:22 by jescottTop