INFOSOURCECODE (Table)

Primary Key	Field Type
ID	uniqueidentifier

Field	Field Type	Notes	Description
DESCRIPTION	nvarchar(100)		Stores the description of the table entry
ACTIVE	bit	Default = 1	Indicates whether or not the table entry is active
SEQUENCE	int	Default = 0	Stores the user-defined sequence for the table entry
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.

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Trigger Name	Description
TR_INFOSOURCECODE_AUDIT_UPDATE
TR_INFOSOURCECODE_AUDIT_DELETE
TR_INFOSOURCECODE_AUDIT_ETLDELETEDID
TR_INFOSOURCECODE_INSERT_BBNCCODETABLEIDMAP
TR_INFOSOURCECODE_DELETE_BBNCCODETABLEIDMAP

Referenced by	Field
ADDRESSVALIDATIONUPDATE	INFOSOURCECODEID
BATCHCONSTITUENT	ADDRESS_INFOSOURCECODEID
BATCHCONSTITUENT	PRIMARYBUSINESS_ADDRESS_INFOSOURCECODEID
BATCHCONSTITUENTADDRESSUPDATE	INFOSOURCECODEID
BATCHCONSTITUENTSOCIALMEDIAACCOUNT	INFOSOURCECODEID
BATCHCONSTITUENTUPDATEADDRESSES	INFOSOURCECODEID
BATCHCONSTITUENTUPDATEEMAILADDRESSES	INFOSOURCECODEID
BATCHCONSTITUENTUPDATEPHONES	INFOSOURCECODEID
BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT	INFOSOURCECODEID
COAUPDATE	INFOSOURCECODEID
CONSTITUENTORIGINATION	INFOSOURCECODEID
DATATUNEUP	INFOSOURCECODEID
DATATUNEUP	ADDRESSVALIDATION_INFOSOURCECODEID
EDUCATIONALINSTITUTION	INFOSOURCECODEID
EMAILADDRESS	INFOSOURCECODEID
EMAILFINDER	INFOSOURCECODEID
EXCHANGECONTACTBATCH	INFOSOURCECODEID
EXCHANGEDOWNLOADPROCESS	DEFAULTINFOSOURCECODEID
MATCHFINDERCONFIGURATION	INFOSOURCECODEID
NETCOMMUNITYDEFAULTCODEMAP	INFOSOURCECODEID
ORIGINATIONSETTING	REVENUESOURCECODEID
PEOPLEFINDER	INFOSOURCECODEID
PHONE	INFOSOURCECODEID
PHONEFINDER	INFOSOURCECODEID
SOCIALMEDIAACCOUNT	INFOSOURCECODEID

Index Name	Field(s)	Unique	Primary	Clustered
IX_INFOSOURCECODE_DATEADDED	DATEADDED
PK_INFOSOURCECODE	ID
UIX_INFOSOURCECODE_DESCRIPTION	DESCRIPTION