| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| 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) |  |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| OUTLOOKPHONETYPE |
nvarchar(12) (Computed) | |
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 Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 PHONETYPECODEID |
uniqueidentifier | PHONETYPECODE.LOCALID | FK to PHONETYPECODE | |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_EXCHANGEPHONEMAPPING_DATEADDED |
DATEADDED | |
||
 IX_EXCHANGEPHONEMAPPING_DATECHANGED |
DATECHANGED | |||
| PK_EXCHANGEPHONEMAPPING |
ID | |
|
|
| UIX_EXCHANGEPHONEMAPPING_PHONETYPECODEID |
PHONETYPECODEID | |
| Trigger Name | Description |
|---|---|
 TR_EXCHANGEPHONEMAPPING_AUDIT_UPDATE |
|
| TR_EXCHANGEPHONEMAPPING_AUDIT_DELETE |