Enterprise Components

Formatting Addresses

This chapter provides an overview of using address formats with PeopleSoft Enterprise applications and discusses how to specify address formats.

Understanding Address Formats

You can use addresses throughout PeopleSoft applications for customer, vendor, and student locations. The address format pages are used to specify the details and defaults for the way address fields display and how they prompt users.

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 in use by the country in question. In addition, PeopleSoft applications contain fully populated country code and state code tables that Oracle updates for each major release, according to current changes in national boundaries and designations.

Specifying Address Formats

This section discusses how to:

Describe countries.
Format addresses.
Validate addresses.
Specify state information.

Important! This task, Specifying Address Formats, does not apply to the PeopleSoft Enterprise Customer Relationship Management application nor the PeopleSoft Enterprise Financials/Supply Change Management application, because these applications do not use the common address objects.

Pages Used to Specify Address Formats

Page Name	Definition Name	Navigation	Usage
Country Description	COUNTRY_DEFN	Set Up <Product Line>, Install, Country Table Enterprise Components, Component Configurations, Address - Hidden, Country - Hidden	Define countries to be used throughout the system. Used mainly for currencies and addresses.
Address Format	ADDR_FORMAT_TABLE	Set Up <Product Line>, Install, Country Table, Address Format Enterprise Components, Component Configurations, Address - Hidden, Country - Hidden	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, Country Table, Valid Address Enterprise Components, Component Configurations, Address - Hidden, Country - Hidden	Add valid combinations of address fields.
State/Province	STATE_DEFN	Set Up <Product Line>, Install, State/Province Enterprise Components, Component Configurations, Address - Hidden, State - Hidden	Add or review a state, province, county, or other geopolitical region within a country.

Describing Countries

Access the Country Description page (Set Up <Product Line>, Install, Country Table).

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.

Formatting Addresses

Access the Address Format page (Set Up <Product Line>, Install, Country Table, Address Format).

Use this page to set up the three main 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 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. The system default is to leave this check box clear.
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 is clear, users can select from the search list or enter a new value. The system default is to leave this check box clear.
Search Limit	Enter a numeric value to limit the number of search results. This option enables you to limit the search results retrieved during Address Search.
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 have the PeopleSoft system include this field when an address appears in read-only mode. Clear this check box for specific fields if your organization wants to display addresses in a format that is different than the appearance of the address during data entry.
Include in Print	Select to print the field when printing.
Line Number and Position Number	Enter the physical location of the fields for displaying and printing. The line number and position number control the field order in the Address Edit page. The Line Number field specifies the line in which the address field should appear on the page. If there are more than two fields on the same line, then the Position Number field is used to resolve the conflict.
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).

Validating Addresses

Access the Valid Address page (Set Up <Product Line>, Install, Country Table, Valid Address).

To enable this page, select the Enable Address Search check box on the Address Format page. This enables the Used in Search column. The fields that you select to be used in the 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.

Specifying State Information

Access the State/Province page (Set Up <Product Line>, Install, State/Province).

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.

Numeric Code

Enter a two digit numeric code for statistical and reporting purposes.

Province

The second enterable field, Province in the preceding example, changes depending on the country.

This field has a maximum limitation of 30 characters. Other examples for this field include:

State—if the country is USA, the field label appears as State.
Department—if the country is France, the field label appears as Department.
Community—if the country is Holland, the field label appears as Community.

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.