NETCOMMUNITYDEFAULTCODEMAP

The NETCOMMUNITYDEFAULTCODEMAP table maps various default code table entries for Blackbaud Internet Solutions transactions.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	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
AUTOMATCHUSESUFFIX	bit		Default = 0

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
BUSINESSPHONECODEID	uniqueidentifier		PHONETYPECODE.LOCALID	FK to PHONETYPECODE
FAXPHONECODEID	uniqueidentifier	yes	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	yes	MATCHINGGIFTCONDITIONTYPECODE.ID	FK to MATCHINGGIFTCONDITIONTYPECODE
REVENUENOTETYPECODEID	uniqueidentifier	yes	REVENUENOTETYPECODE.ID	FK to REVENUENOTETYPECODE
CONSTITUENTLINKPAGEID	uniqueidentifier	yes	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	yes	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
ORGANIZATIONPRIMARYADDRESSTYPECODEID	uniqueidentifier	yes	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
CHANNELCODEID	uniqueidentifier	yes	CHANNELCODE.ID	FK to CHANNELCODE
MGALIASTYPECODEID	uniqueidentifier	yes	ALIASTYPECODE.ID	FK to ALIASTYPECODE
DONOTEMAILSOLICITCODEID	uniqueidentifier		SOLICITCODE.ID	FK to SOLICITCODE
INFOSOURCECODEID	uniqueidentifier	yes	INFOSOURCECODE.ID	FK to INFOSOURCECODE
FORMERADDRESSTYPECODEID	uniqueidentifier	yes	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
EMAILADDRESSTYPECODEID	uniqueidentifier	yes	EMAILADDRESSTYPECODE.ID
DONOTEMAILCONSENTSOLICITCODEID	uniqueidentifier	yes	SOLICITCODE.ID
DATAPROTECTIONEVIDENCESOURCECODEID	uniqueidentifier	yes	DATAPROTECTIONEVIDENCESOURCECODE.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_NETCOMMUNITYDEFAULTCODEMAP_DATEADDED	DATEADDED			yes
IX_NETCOMMUNITYDEFAULTCODEMAP_DATECHANGED	DATECHANGED
PK_NETCOMMUNITYDEFAULTCODEMAP	ID	yes	yes

Triggers

Trigger Name	Description
TR_NETCOMMUNITYDEFAULTCODEMAP_AUDIT_UPDATE
TR_NETCOMMUNITYDEFAULTCODEMAP_AUDIT_DELETE