This is version 1 2 3 4 5 6 7 8 9 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

STATES AND PROVINCES#

States And Provinces are the geographical divisions of countries. The state and province definitions in ePersonality are used to complete address and taxation information.

This section explains the Define States and Provinces (IDSP) screen and its associated fields.

The state and province abbreviations are used as standards throughout the system.

The information in the State (U.S.A.) and Province (Canada) tables are initially supplied by High Line, however, you may update or alter this information to suit your company’s needs.

‘Define States and Provinces’ Usage and Examples

State and Province data is stored in the P2K_CM_STATE_PROVINCES table.

State/Prov

This field shows the state or province’s standard postal abbreviation.

State/Prov Name

This field provides the full name of the state or province

State_Province_Name is a 50-character alphanumeric mandatory field.

Country \ COUNTRY_CODE

The country code is a High Line assigned code that uniquely identifies a country.

Country_Code from P2K_CM_COUNTRIES is a 16-character alphanumeric mandatory field.

Postal Start

This field provides the start of the zip or postal code range used for verification purposes.

Postal End \ ZIP_POSTAL_END

This field provides the end of the zip or postal code range used for verification purposes.

Area Code

This field will provide an area code which will default in when you are entering phone numbers for specific geographic areas in other screens (e.g. IDEN).