Bookshelf Home | Contents | Index | Search | PDF |
Applications Administration Guide > Ongoing Application Administration Tasks >
Specifying Telephone Formats
Default telephone formats are specified in the List of Values view. You can only have one default telephone number format per country. The default format is applied when you enter only numbers, without slashes, dashes, or other formatting symbols.
Before users enter telephone numbers:
- Set the default country. See Setting Up Locales. The default phone format is determined by the locale setting.
- Define formats for countries outside the default country. See Specifying Non-North American Telephone Formats.
If a user enters a telephone number from a country for which the format has not yet been specified, the telephone number may be formatted incorrectly.
NOTE: If you define any new telephone formats, coordinate with communications administrators who specify CTI functionality and define dialing filters. For more information, see Siebel Communications Server Administration Guide.
North American Telephone Formats
The default format for North American telephone numbers is (000) 000-0000. The telephone formatting logic for North American telephone numbers works as follows:
- If the user enters 10 digits in a telephone number field, it is formatted as (123) 123-1234.
- If the user enters more than 10 digits, the first 10 digits are formatted as (123) 123-1234, and the rest of the digits are used as the extension number. The user can enter up to 40 digits.
- If the user enters fewer than 10 digits, an error message appears.
- If the user begins the telephone number with a leading zero, an error message appears.
This telephone formatting logic is followed even when the default country is not in North America.
Specifying Non-North American Telephone Formats
If your users need to enter telephone numbers for countries outside North America, you must specify telephone number formats for those countries.
To specify non-North American telephone formats
- Choose View > Site Map > Application Administration > List of Values.
- Query the Type field for the entry PHONE_FORMAT to see existing telephone formats.
- Add a new record and complete the necessary fields.
Some fields are described in the following table. For more field information, see Working with Lists of Values.
- Follow the instructions in Clearing the Cache.
International Telephone Formats
To enter an international telephone number (a telephone number for a country other than the current default country) in a telephone field, the user must specify the country by preceding the telephone number with a plus sign (+) followed by the country code (for example, +44). If the user does not enter a country code, the default country code is assumed.
After the user indicates the country by entering the plus sign and country code, the telephone formatting logic for international telephone numbers works as follows:
- If the user enters exactly the same number of digits in a telephone number field as there are in the telephone format for the indicated country, the entry is formatted as specified.
- If the user enters more than the number of digits in the telephone format for the indicated country, the first digits are formatted as specified and the rest of the digits are used as an extension number. The user can enter up to 40 digits.
- If the user enters fewer than the number of digits in the telephone format for indicated country, the entry is accepted without an error message. (This is to accommodate telephone numbers of different lengths.)
- If there is no List of Values telephone format entry for the indicated country, the number is accepted, but not formatted. No error message is returned.
Unformatted Telephone Numbers
When you change or add a telephone number format, the existing telephone numbers are not updated automatically.
CAUTION: When entering telephone numbers, users can enter letters in place of digits, but computer telephony integration (CTI) features, such as outbound dialing, do not work for these numbers. Queries for such numbers must include the letters, not the numeric equivalents. Siebel eBusiness Applications do not detect or warn users if they enter Q or Z (letters that do not appear on all telephones).
Examples
Table 8 shows how telephone numbers would appear under various circumstances. In this example, the default country is the United States and the default format is the North American format, (000) 000-0000. Another format has been entered for England (country code 44): 00.000-000.
The telephone format has no effect on sort order.
When performing a query on a telephone number, do not include any format characters such as (,), -, ., x, or spaces.
You can query for only country 61 by typing +61* but you cannot query for only North American telephone numbers this way, because +1* returns all telephone numbers. To query for North American telephone numbers, use
not like +*
instead.Table 9 gives examples of how to query telephone numbers.
When the user performs a query using a telephone number, the country code of the default country automatically prefixes the query (unless the default country is in North America, in which case no prefix is added). For example, if the default country is Germany, and the user types "0181" in the telephone field of a query, the German country code (+49) is added to the query (that is, +49*0181*).
To find a number for a country other than the default country, the user must specify the country code in the query. To avoid limiting the query to one country, the user must refine the query and remove the country code portion of the query specification.
To see a demonstration of this behavior, look at the Contacts screen. Every number for a country other than the default contains a "+n" at the beginning, while every number for the default country code appears as local (no +). Numbers that have the "+n" require explicit queries (country code plus number) while local numbers are returned normally.
Importing Information with EIM
Siebel Enterprise Integration Manager (EIM) manages the exchange of data between Siebel database tables and other corporate databases. When you use EIM to import information that includes international telephone numbers, the numbers are handled as described in the previous sections.
For more information about EIM, see Siebel Enterprise Integration Manager Administration Guide.
Bookshelf Home | Contents | Index | Search | PDF |
Applications Administration Guide Published: 09 September 2004 |