| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 NUMBER |
nvarchar(100) | Default = '' | Stores the phone number. | |
| ISPRIMARY |
bit | Default = 0 | Indicates this phone number is the primary phone number. | |
| SEQUENCE |
int | Default = 0 | Stores the user-defined sequence for phone numbers on a constituent. | |
| 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. |
| DONOTCALL |
bit | Default = 0 | Indicates this phone number should not receive phone calls. | |
| STARTTIME |
UDT_HOURMINUTE | Default = '' | Time that the phone number becomes valid | |
| ENDTIME |
UDT_HOURMINUTE | Default = '' | Time that the phone number becomes no longer valid | |
| INFOSOURCECOMMENTS |
nvarchar(256) | Default = '' | Contains additional comments about the information source. | |
| STARTDATE |
date | |
The date the phone number becomes valid. | |
| ENDDATE |
date | |
The date the phone number becomes invalid. | |
| ISCONFIDENTIAL |
bit | Default = 0 | Indicates this phone number is confidential. | |
| ORIGINCODE |
tinyint | Default = 0 | Defines where the address originated. | |
| ORIGIN |
nvarchar(9) (Computed) | |
CASE [ORIGINCODE] WHEN 0 THEN N'User' WHEN 1 THEN N'Web Forms' END | Provides a translation for the 'ORIGINCODE' field. |
| NUMBERNOFORMAT |
nvarchar(100) (Computed) | |
dbo.UFN_PHONE_REMOVEFORMATTING(NUMBER) | Stores a non-formatted version of the number. |
| SEASONALSTARTDATE |
UDT_MONTHDAY | Default = '0000' | For seasonal phone types only; DD/MM start date of when this phone should be considered. | |
| SEASONALENDDATE |
UDT_MONTHDAY | Default = '0000' | For seasonal phone types only; DD/MM end date of when this phone should be considered. |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 CONSTITUENTID |
uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
| PHONETYPECODEID |
uniqueidentifier | |
PHONETYPECODE.LOCALID | FK to PHONETYPECODE |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| INFOSOURCECODEID |
uniqueidentifier | |
INFOSOURCECODE.ID | FK to INFOSOURCECODE |
| COUNTRYID |
uniqueidentifier | |
COUNTRY.LOCALID | The country for this phone number. |
| DONOTCALLREASONCODEID |
uniqueidentifier | |
DONOTCALLREASONCODE.ID | The reason code translation ID for do not call. |
| RELATIONSHIPID |
uniqueidentifier | |
RELATIONSHIP.ID | Stores the relationship ID this phone number is associated with. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_PHONE_CONSTITUENTID |
CONSTITUENTID | |||
| IX_PHONE_CONSTITUENTID_PHONETYPECODEID_NUMBER |
CONSTITUENTID, PHONETYPECODEID, NUMBER | |||
 IX_PHONE_DATEADDED |
DATEADDED | |
||
| IX_PHONE_DATECHANGED |
DATECHANGED | |||
| IX_PHONE_NUMBERNOFORMAT |
NUMBERNOFORMAT | |||
| IX_PHONE_RELATIONSHIPID |
RELATIONSHIPID | |||
| PK_PHONE |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_PHONE_TASYNC_I |
|
| TR_PHONE_TASYNC_U |
|
| TR_PHONE_TASYNC_D |
|
| TR_PHONE_AUDIT_ETLDELETEDID |
|
| TR_PHONE_AUDIT_UPDATE |
|
| TR_PHONE_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHCONSTITUENTUPDATEPHONES |
PHONEID |
| BATCHEVENTSPONSORSHIP |
PHONEID |
| DONATIONBATCH |
PHONEID |
| RE7INTEGRATIONPHONEMAP |
ID |
| REGISTRANTBATCH |
PHONEID |
| SALESORDER |
PHONEID |