Phone number data model

In Guidewire PolicyCenter, the Contact entity has the following fields that support phone numbers:

PrimaryPhone
FaxPhone
FaxPhoneCountry
FaxPhoneExtension
HomePhone
HomePhoneCountry
HomePhoneExtension
WorkPhone
WorkPhoneCountry
WorkPhoneExtension

The Person entity inherits all these fields, and, in addition, has the following fields that support phone numbers:

CellPhone
CellPhoneCountry
CellPhoneExtension

For the listed entity fields:

The phone country fields are typekeys that reference the PhoneCountryCode typelist, which provides the list of ISO country codes for phone data.
The extension fields define varchar columns.

These two types of fields are associated with the main phone column through the following columnParam subelements:

phonecountrycodeProperty
extensionProperty

For example, in the XML text of the Contact.eti file, notice the following definitions.

<typekey desc="Home phone country." name="HomePhoneCountry" nullok="true"
      typelist="PhoneCountryCode"/>

<column desc="Home phone number associated with the contact." name="HomePhone" 
        nullok="true" type="phone">
  <columnParam name="phonecountrycodeProperty" value="HomePhoneCountry"/>
  <columnParam name="extensionProperty" value="HomePhoneExtension"/>
</column>

<column desc="Home phone extension." name="HomePhoneExtension" nullok="true" type="varchar">
  <columnParam name="size" value="60"/>
</column>