Formatting Addresses

This chapter provides an overview of address formats and discusses how to specify address formats.

Click to jump to parent topicUnderstanding Address Formats

You can format addresses for any country in the world. You can create country and state descriptions and street, suite, building, and postal zone formats to meet the needs of any country format. For example, the state description can be changed to county, province, district, or other geopolitical designation used by the country in question. In addition, PeopleSoft contains fully populated country code and state code tables, which we update each major release if national boundaries and designations have changed.

Click to jump to parent topicSpecifying Address Formats

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Specify Address Formats

Page Name

Object Name

Navigation

Usage

Country Description

COUNTRY_DEFN

Set Up <product line>, Install, Product and Country Specific, Country Table

Define countries to be used throughout the system. Used mainly for currencies and addresses.

Address Format

ADDR_FORMAT_TABLE

Set Up <product line>, Install, Product and Country Specific, Country Table, Address Format

Customize fields and field descriptions, so addresses conform to the customary address format of the specified country. Once set, the format appears everywhere the system uses the address subrecord.

Valid Address

EO_ADDR_VALIDAT

Set Up <product line>, Install, Product and Country Specific, Country Table, Valid Address

Add valid combinations of address fields.

State or Province Table

STATE_DEFN

Set Up <product line>, Install, State/Province

Add or review a state, province, county, or other geopolitical region within a country.

Click to jump to top of pageClick to jump to parent topicDescribing Countries

Access the Country Description page.

2-Char Country Code(two-character country code)

Enter the Value Added Tax (VAT) registration ID for the country..

EU Member State (european union member state)

Select if the country is a member of the European Union. Select to include the country in prompts for intrastate reporting.

Click to jump to top of pageClick to jump to parent topicFormatting Addresses

Access the Address Format page.

Use this page to set up three aspects of the address: editing, displaying, and printing.

Address Edit Page

Displays the secondary page used for editing the address. You can create a new secondary page using PeopleSoft Application Designer. On the new address secondary page you create, use page fields from the DERIVED_ADDRESS record definition. You then need to add a secondary page control to ADDRESS_SBP pointing to your new secondary page. Once you complete these steps, the secondary page is accessible in this field.

Enable Address Search

Select to enable users to search for a valid value. Selecting this check box enables the Used in Search column and the Valid Address page.

Enable Address Validation

Available only when Enable Address Search is selected. Select to ensure validation of all values selected. When selected, users must select a value from the search list. If this check box clear, users can select from the search list or enter a new value.

Field Name

Displays the field options available for the address page.

Edit Label Override

(Optional) Enter an alternative label for the field. The new label is used when prompting for the field. You can customize address formats so that they conform to the address requirements of each location. For instance, for a U.S. address, you would change the Postal field to read ZIP Code.

Keep in mind the distinctions between county and state:

  • County: The tertiary geopolitical region within a state; the level after country and state. (In the UK, the level of state is called a county; you would enter such counties in the State field.)

  • State: The secondary geopolitical region within a country; a state in the U.S., a province in Canada, a county in the UK, and a department in France.

Used in Search

Available only when you select the Enable Address Search check box. Select the fields you want users to be able to search on.

Include in Display

Select to activate the corresponding address field as part of the standard address format for the selected country. To remove a field, clear the check box. When entering addresses, users enter a country code, and then the system updates the page to display the fields appropriate for that country.

Include in Print

Select to print the field when printing reports.

Line Number and Position Number

Enter the physical location of the fields for displaying and printing.

Use Description

Select to display the description for the field value. For example, for addresses in Japan, select this option to display the description of the state rather than the state code, since the code is numeric.

Pre Separator and Post Separator

Enter characters to be used surrounding the address field. For example, in the United States, a comma generally follows the city name, such as in San Francisco, CA. In India, there are parentheses around the postal code, for example (123).

Click to jump to top of pageClick to jump to parent topicValidating Addresses

Access the Valid Address page.

To enable this page, select the Enable Address Search check box on the Address Format page, which enables the Used in Search column. The fields you selected to be used in search appear on the Valid Address page as columns. Enter the valid postal code and state combinations that the user can search for and select.

Click to jump to top of pageClick to jump to parent topicSpecifying State Information

Access the State/Province page.

This table provides states, provinces, and equivalent geopolitical entities for all supported countries, such as Dutch communities and French departments. The codes are based on standard postal codes.

Enter a numeric code for statistical and reporting purposes. The second enterable field, County in the preceding example, changes depending on the country. If the country is France, the field label appears as Department.