!!!Alias: DLG THIS TABLE IS USED FOR VERTEX GEO CODE LOADS. IT IS NO LONGER USED IN EPERSONALITY
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
Loaded Geocodes

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[GEO_CODE]|Varchar2(16)|[CODE]| |
|[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| |
|[JURISDICTION_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[NUMBER_OF_CHARACTERS]|Number(5)|[NUMBER5|NUMBERn]| |
|[ZIP_POSTAL_START]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[ZIP_POSTAL_END]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[MULTI_COUNTY_CODE]|Varchar2(16)|[CODE]| |
|[COMPRESSED_CITY_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| |
|[AUTHORITY_CODE]|Varchar2(16)|[CODE]| |
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|

User Fields: Allowed\\
Audit Logging: Allowed\\


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