Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null 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.

Index Name Field(s) Unique Primary Clustered
 IX_DONOTMAILREASONCODE_DATEADDED DATEADDED    
 PK_DONOTMAILREASONCODE ID  
 UIX_DONOTMAILREASONCODE_DESCRIPTION DESCRIPTION    

Trigger Name Description
 TR_DONOTMAILREASONCODE_AUDIT_UPDATE
 TR_DONOTMAILREASONCODE_AUDIT_DELETE
 TR_DONOTMAILREASONCODE_INSERT_BBNCCODETABLEIDMAP
 TR_DONOTMAILREASONCODE_DELETE_BBNCCODETABLEIDMAP
 TR_DONOTMAILREASONCODE_AUDIT_ETLDELETEDID

Referenced by Field
 ADDRESS DONOTMAILREASONCODEID
 BATCHAUCTIONITEMCONSTITUENT DONOTMAILREASONCODEID
 BATCHCONSTITUENT PRIMARYBUSINESS_ADDRESS_DONOTMAILREASONCODEID
 BATCHCONSTITUENT ADDRESS_DONOTMAILREASONCODEID
 BATCHCONSTITUENTADDRESSUPDATE DONOTMAILREASONCODEID
 BATCHCONSTITUENTUPDATE BUSINESS_DONOTMAILREASONCODEID
 BATCHCONSTITUENTUPDATEADDRESSES DONOTMAILREASONCODEID
 BATCHEVENTSPONSORSHIP DONOTMAILREASONCODEID
 BATCHEVENTSPONSORSHIP COMPANY_DONOTMAILREASONCODEID
 BATCHREVENUECONSTITUENT DONOTMAILREASONCODEID
 BATCHSPONSORSHIPCONSTITUENT DONOTMAILREASONCODEID
 COAUPDATE FOOTNOTECODE1REASONCODEID
 COAUPDATE FOOTNOTECODE2REASONCODEID
 COAUPDATE FOOTNOTECODE3REASONCODEID
 COAUPDATE FOOTNOTECODE4REASONCODEID
 COAUPDATE FOOTNOTECODE5REASONCODEID
 COAUPDATE FOOTNOTECODE6REASONCODEID
 COAUPDATE FOOTNOTECODE7REASONCODEID
 COAUPDATE MAILGRADEFREASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE1REASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE2REASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE3REASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE4REASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE5REASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE6REASONCODEID
 DATATUNEUPFOOTNOTEREASONMAP FOOTNOTECODE7REASONCODEID
 DONATIONBATCH DONOTMAILREASONCODEID
 DONATIONBATCH COMPANY_DONOTMAILREASONCODEID
 MKTFINDERNUMBERCONSTITUENT DONOTMAILREASONCODEID
 PEOPLEFINDER DONOTMAILREASONCODEID
 REGISTRANTBATCH DONOTMAILREASONCODEID
 REGISTRANTBATCH ORGANIZATION_DONOTMAILREASONCODEID

Entity-Relationship diagram of this table