NETCOMMUNITYDEFAULTCODEMAP (4.0SP17)

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

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BUSINESSPHONECODEID	uniqueidentifier	false	PHONETYPECODE.ID	FK to PHONETYPECODE
FAXPHONECODEID	uniqueidentifier	true	PHONETYPECODE.ID	FK to PHONETYPECODE
RELATIONSHIPTYPECODEID	uniqueidentifier	false	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
PRIMARYBUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	false	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
PRIMARYBUSINESSRECIPROCALTYPECODEID	uniqueidentifier	false	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
BUSINESSADDRESSTYPECODEID	uniqueidentifier	false	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
MGCONDITIONTYPECODEID	uniqueidentifier	true	MATCHINGGIFTCONDITIONTYPECODE.ID	FK to MATCHINGGIFTCONDITIONTYPECODE
REVENUENOTETYPECODEID	uniqueidentifier	true	REVENUENOTETYPECODE.ID	FK to REVENUENOTETYPECODE
CONSTITUENTLINKPAGEID	uniqueidentifier	true	PAGEDEFINITIONCATALOG.ID	FK to PAGEDEFINITIONCATALOG
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CONTACTTYPECODEID	uniqueidentifier	false	CONTACTTYPECODE.ID	FK to CONTACTTYPECODE
SPOUSEREMOVEDRELATIONSHIPTYPECODEID	uniqueidentifier	false	RELATIONSHIPTYPECODE.ID	FK to RELATIONSHIPTYPECODE
PRIMARYADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
ORGANIZATIONPRIMARYADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
CHANNELCODEID	uniqueidentifier	true	CHANNELCODE.ID	FK to CHANNELCODE
MGALIASTYPECODEID	uniqueidentifier	true	ALIASTYPECODE.ID	FK to ALIASTYPECODE
DONOTEMAILSOLICITCODEID	uniqueidentifier	false	SOLICITCODE.ID	FK to SOLICITCODE
INFOSOURCECODEID	uniqueidentifier	true	INFOSOURCECODE.ID	FK to INFOSOURCECODE
FORMERADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
EMAILADDRESSTYPECODEID	uniqueidentifier	true	EMAILADDRESSTYPECODE.ID
DONOTEMAILCONSENTSOLICITCODEID	uniqueidentifier	true	SOLICITCODE.ID
DATAPROTECTIONEVIDENCESOURCECODEID	uniqueidentifier	true	DATAPROTECTIONEVIDENCESOURCECODE.ID

Fields
Field	Field Type	Null	Notes	Description
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
AUTOMATCHUSELASTNAME	bit	false	0
AUTOMATCHUSEFIRSTNAME	bit	false	0
AUTOMATCHUSEMAIDENNAME	bit	false	0
AUTOMATCHUSEBIRTHDATE	bit	false	0
AUTOMATCHUSEGENDER	bit	false	0
AUTOMATCHEXACTMATCHONLY	bit	false	1
AUTOMATCHINCLUDEINACTIVE	bit	false	0
AUTOMATCHINCLUDEDECEASED	bit	false	1
AUTOMATCHUSEMIDDLENAME	bit	false	0
AUTOMATCHUSEADDRESS	bit	false	0
AUTOMATCHUSECITY	bit	false	0
AUTOMATCHUSECOUNTRY	bit	false	0
AUTOMATCHUSECOUNTY	bit	false	0
AUTOMATCHUSENZCITY	bit	false	0
AUTOMATCHUSENZSUBURB	bit	false	0
AUTOMATCHUSESTATE	bit	false	0
AUTOMATCHUSEZIP	bit	false	0
AUTOMATCHUSEPHONE	bit	false	0
AUTOMATCHUSELOOKUPID	bit	false	1
PLUGINSERVICEURL	UDT_WEBADDRESS	false	''
AUTOMATCHUSEEMAIL	bit	false	0
AUTOMATCHUSESUFFIX	bit	false	0

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_NETCOMMUNITYDEFAULTCODEMAP_DATEADDED	DATEADDED	False	False	True
IX_NETCOMMUNITYDEFAULTCODEMAP_DATECHANGED	DATECHANGED	False	False	False
PK_NETCOMMUNITYDEFAULTCODEMAP	ID	True	True	False

Triggers
Trigger Name	Description
TR_NETCOMMUNITYDEFAULTCODEMAP_AUDIT_UPDATE
TR_NETCOMMUNITYDEFAULTCODEMAP_AUDIT_DELETE