This table is used to store all the phone numbers related to any Person.
|IsSMS||12.0.0||Number(1,0)||Indicates whether or not the SMS feature is enabled. Valid values: 1= Enabled, 0=Disabled. Defaults to 0. Required.|
Phone number of the person in digits only. Indexed. Required. PhoneNumber with PhoneNumberExt must be unique.
|PhoneNumberExt||12.0.0||Varchar2(10)||Extension digits extracted from PersonPhoneNumberAssoc.phonenumberasentered. Characters limited to numbers only. Indexed with PhoneNumber. Optional.|
|PhoneNumberID||12.0.0||Number(16,0)||Unique sequential number generated by the application. Indexed. Required.|
|WhenCreated||12.0.0||Timestamp(6)||The date and time the record was created. Defaults to system date. Required.|
The date and time the record was modified. Defaults to system date. Required.
The name of the person who created the record. Defaults to user. Required.
The name of person who modified the record. Defaults to user. Required.