EXCHANGEPHONEMAPPING
Contains a list of mapped phone types to be used for exchange integration.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| OUTLOOKPHONETYPECODE |
tinyint |
|
Default = 8 |
0=Assistant, 1=Business Fax, 2=Business, 3=Business 2, 4=Callback, 5=Car, 6=Company, 7=Home Fax, 8=Home, 9=Home 2, 10=ISDN, 11=Mobile, 12=Other Fax, 13=Other, 14=Pager, 15=Primary, 16=Radio, 17=Telex, 18=TTY/TDD |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| OUTLOOKPHONETYPE |
nvarchar(12) (Computed) |
yes |
CASE [OUTLOOKPHONETYPECODE] WHEN 0 THEN N'Assistant' WHEN 1 THEN N'Business Fax' WHEN 2 THEN N'Business' WHEN 3 THEN N'Business 2' WHEN 4 THEN N'Callback' WHEN 5 THEN N'Car' WHEN 6 THEN N'Company' WHEN 7 THEN N'Home Fax' WHEN 8 THEN N'Home' WHEN 9 THEN N'Home 2' WHEN 10 THEN N'ISDN' WHEN 11 THEN N'Mobile' WHEN 12 THEN N'Other Fax' WHEN 13 THEN N'Other' WHEN 14 THEN N'Pager' WHEN 15 THEN N'Primary' WHEN 16 THEN N'Radio' WHEN 17 THEN N'Telex' WHEN 18 THEN N'TTY/TDD' END |
Provides a translation for the 'OUTLOOKPHONETYPECODE' field. |
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_EXCHANGEPHONEMAPPING_DATEADDED |
DATEADDED |
|
|
yes |
| IX_EXCHANGEPHONEMAPPING_DATECHANGED |
DATECHANGED |
|
|
|
| PK_EXCHANGEPHONEMAPPING |
ID |
yes |
yes |
|
| UIX_EXCHANGEPHONEMAPPING_PHONETYPECODEID |
PHONETYPECODEID |
yes |
|
|
Triggers