| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 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. |
| AUTOMATCHUSELASTNAME |
bit | Default = 0 | ||
| AUTOMATCHUSEFIRSTNAME |
bit | Default = 0 | ||
| AUTOMATCHUSEMAIDENNAME |
bit | Default = 0 | ||
| AUTOMATCHUSEBIRTHDATE |
bit | Default = 0 | ||
| AUTOMATCHUSEGENDER |
bit | Default = 0 | ||
| AUTOMATCHEXACTMATCHONLY |
bit | Default = 1 | ||
| AUTOMATCHINCLUDEINACTIVE |
bit | Default = 0 | ||
| AUTOMATCHINCLUDEDECEASED |
bit | Default = 1 | ||
| AUTOMATCHUSEMIDDLENAME |
bit | Default = 0 | ||
| AUTOMATCHUSEADDRESS |
bit | Default = 0 | ||
| AUTOMATCHUSECITY |
bit | Default = 0 | ||
| AUTOMATCHUSECOUNTRY |
bit | Default = 0 | ||
| AUTOMATCHUSECOUNTY |
bit | Default = 0 | ||
| AUTOMATCHUSENZCITY |
bit | Default = 0 | ||
| AUTOMATCHUSENZSUBURB |
bit | Default = 0 | ||
| AUTOMATCHUSESTATE |
bit | Default = 0 | ||
| AUTOMATCHUSEZIP |
bit | Default = 0 | ||
| AUTOMATCHUSEPHONE |
bit | Default = 0 | ||
| AUTOMATCHUSELOOKUPID |
bit | Default = 1 | ||
| PLUGINSERVICEURL |
UDT_WEBADDRESS | Default = '' | ||
| AUTOMATCHUSEEMAIL |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 BUSINESSPHONECODEID |
uniqueidentifier | PHONETYPECODE.LOCALID | FK to PHONETYPECODE | |
| FAXPHONECODEID |
uniqueidentifier | |
PHONETYPECODE.LOCALID | FK to PHONETYPECODE |
| RELATIONSHIPTYPECODEID |
uniqueidentifier | RELATIONSHIPTYPECODE.ID | FK to RELATIONSHIPTYPECODE | |
| PRIMARYBUSINESSRELATIONSHIPTYPECODEID |
uniqueidentifier | RELATIONSHIPTYPECODE.ID | FK to RELATIONSHIPTYPECODE | |
| PRIMARYBUSINESSRECIPROCALTYPECODEID |
uniqueidentifier | RELATIONSHIPTYPECODE.ID | FK to RELATIONSHIPTYPECODE | |
| BUSINESSADDRESSTYPECODEID |
uniqueidentifier | ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE | |
| MGCONDITIONTYPECODEID |
uniqueidentifier | |
MATCHINGGIFTCONDITIONTYPECODE.ID | FK to MATCHINGGIFTCONDITIONTYPECODE |
| REVENUENOTETYPECODEID |
uniqueidentifier | |
REVENUENOTETYPECODE.ID | FK to REVENUENOTETYPECODE |
| CONSTITUENTLINKPAGEID |
uniqueidentifier | |
PAGEDEFINITIONCATALOG.ID | FK to PAGEDEFINITIONCATALOG |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CONTACTTYPECODEID |
uniqueidentifier | CONTACTTYPECODE.LOCALID | FK to CONTACTTYPECODE | |
| SPOUSEREMOVEDRELATIONSHIPTYPECODEID |
uniqueidentifier | RELATIONSHIPTYPECODE.ID | FK to RELATIONSHIPTYPECODE | |
| PRIMARYADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| ORGANIZATIONPRIMARYADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | FK to ADDRESSTYPECODE |
| CHANNELCODEID |
uniqueidentifier | |
CHANNELCODE.ID | FK to CHANNELCODE |
| MGALIASTYPECODEID |
uniqueidentifier | |
ALIASTYPECODE.ID | FK to ALIASTYPECODE |
| DONOTEMAILSOLICITCODEID |
uniqueidentifier | SOLICITCODE.ID | FK to SOLICITCODE | |
| INFOSOURCECODEID |
uniqueidentifier | |
INFOSOURCECODE.ID | FK to INFOSOURCECODE |
| FORMERADDRESSTYPECODEID |
uniqueidentifier | |
ADDRESSTYPECODE.ID | |
| EMAILADDRESSTYPECODEID |
uniqueidentifier | |
EMAILADDRESSTYPECODE.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_NETCOMMUNITYDEFAULTCODEMAP_DATEADDED |
DATEADDED | |
||
 IX_NETCOMMUNITYDEFAULTCODEMAP_DATECHANGED |
DATECHANGED | |||
| PK_NETCOMMUNITYDEFAULTCODEMAP |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_NETCOMMUNITYDEFAULTCODEMAP_AUDIT_UPDATE |
|
| TR_NETCOMMUNITYDEFAULTCODEMAP_AUDIT_DELETE |