PhoneTypes
Returns a list of phone types.
Table Specific Information
Select
The driver will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- TableEntriesId supports the '=' operator.
- Type supports the '=' operator.
- Format supports the '=' operator.
- Description supports the '=' operator.
- IncludeInactive supports the '=' operator.
SELECT * FROM PhoneTypes WHERE Type = 'Home' SELECT * FROM PhoneTypes WHERE IncludeInactive = true
Columns
| Name | Type | References | Description |
| TableEntriesId [KEY] | Integer | The immutable system record ID of the phone type. | |
| Description | String | The phone type description. | |
| Type | String | The phone number type.
The allowed values are TelephoneNumber, FaxNumber, EmailAddress, WebAddressUrl, Other. | |
| Format | String | The phone number format.
The allowed values are None, Mask1, Mask2, Mask3, Mask4, Mask5, Mask6, Mask7, Mask8, Mask9, Mask10, Mask11. | |
| FormatMask | String | The format mask pattern for the phone number. | |
| Sequence | Integer | The display sequence order of the phone type. | |
| IsActive | Boolean | Whether the phone type is active. | |
| IsSystemEntry | Boolean | Whether this is a system-defined phone type. | |
| DateAdded | Datetime | The date when the phone type was created. | |
| DateChanged | Datetime | The date when the phone type was last modified. | |
| AddedById | Integer | The ID of the user who created the phone type. | |
| LastChangedById | Integer | The ID of the user who last modified the phone type. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| IncludeInactive | Boolean | If set to true, includes inactive phone types in the result. |