This chapter provides an overview of address formats and discusses how to specify 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.
This section discusses how to:
Describe countries.
Format addresses.
Validate addresses.
Specify state information.
Page Name |
Object Name |
Navigation |
Usage |
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. |
|
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_DEFN |
Set Up <product line>, Install, State/Province |
Add or review a state, province, county, or other geopolitical region within a country. |
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. |
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:
|
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). |
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.
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.