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 allows you to create and maintain city information within the system.
The Maintain Cities (IDCI) screen displays all of the Cities which have been loaded in by the [UDGNIS] function.
At line 7 changed one line
Work Rule data is stored in the [P2K_CM_STATE_PROVINCES], [P2K_CM_COUNTRIES], [P2K_CM_ZIP_RANGES], and [P2K_CM_TAX_JURISDICTIONS] tables.
City data is stored in the [P2K_CM_CITIES] table.
At line 9 changed 10 lines
!!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.
\\
;[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.
At line 20 removed 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