!!!Alias: DSP
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
\\
States and provinces around the world

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[DCO_ID]|Number(10)|[ID]|Y|link to [P2K_CM_COUNTRIES]
|[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]|Y|
|[STATE_PROVINCE_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[ZIP_POSTAL_START]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[ZIP_POSTAL_END]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[PHONE_AREA_CODE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[FIPS_CODE]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |

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


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