Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name given to this option set.
 PURPOSE nvarchar(500)   Default = '' The purpose for this option set.
 INDUSECONSTITUENTPREFS bit   Default = 1 Flag to true if the processing should try to use constituent preferences.
 INDALTADDRESS1ISPRIMARY bit   Default = 0 Flag to true to use the primary address as the first alternative, regarless of type.
 INDALTADDRESS2ISPRIMARY bit   Default = 0 Flag to true to use the primary address as the second alternative, regarless of type.
 INDUSESEASONALADDRESS bit   Default = 0 Flag to true if the processing should try to use a seasonal address.
 INDINCLUDEWITHNOADDRESS bit   Default = 1 Flag to true is the individual should be included even if no address is found.
 ORGMAILINGPREFERENCE tinyint   Default = 0 Defines the action to be taken when mailing to an organization.
 ORGALTADDRESS1ISPRIMARY bit   Default = 0 Flag to true to use the primary address as the first alternative, regarless of type.
 ORGALTADDRESS2ISPRIMARY bit   Default = 0 Flag to true to use the primary address as the second alternative, regarless of type.
 ORGINCLUDEWITHNOADDRESS bit   Default = 0 Flag to true is the organization should be included even if no address is found.
 ORGSENDTOALLCONTACTS bit   Default = 1 Flag to true if all contacts should be used, not just the first one found.
 ORGINCLUDEWITHNOCONTACT bit   Default = 1 Flag to true is the organization should be included even if no contacts are found.
 ORGCONTACTALSOINDACTION tinyint   Default = 0 Defines what to do if an orgnaization's contact is also set to receive the mailing as an individual. Only applicable to certain kinds of mailings.
 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.
 ORGUSECONSTITUENTPREFS bit   Default = 1 Flag to true if the processing should try to use constituent preferences.
 ISDEFAULT bit   Default = 0 Flagged to true if the record is the default option set.
 GROUPUSECONSTITUENTPREFS bit   Default = 1
 GROUPUSESEASONALADDRESS bit   Default = 1
 GROUPALTADDRESS1ISPRIMARY bit   Default = 0
 GROUPALTADDRESS2ISPRIMARY bit   Default = 0
 GROUPINCLUDEWITHNOADDRESS bit   Default = 1
 ISSYSTEM bit   Default = 0

Foreign Key Field Type Null Notes Description
 INDALTADDRESS1TYPECODEID uniqueidentifier ADDRESSTYPECODE.ID First address alternative if there are no constituent preferences.
 INDALTADDRESS2TYPECODEID uniqueidentifier ADDRESSTYPECODE.ID Second address alternative if there are no constituent preferences.
 ORGALTADDRESS1TYPECODEID uniqueidentifier ADDRESSTYPECODE.ID Address type to be used if sending directly to the organization.
 ORGALTADDRESS2TYPECODEID uniqueidentifier ADDRESSTYPECODE.ID Alternative address type to be used if sending directly to the organization.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 GROUPALTADDRESS1TYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 GROUPALTADDRESS2TYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 SITEID uniqueidentifier SITE.ID The site with which a address processing option is associated.

Index Name Field(s) Unique Primary Clustered
 IX_ADDRESSPROCESSINGOPTION_DATEADDED DATEADDED    
 IX_ADDRESSPROCESSINGOPTION_DATECHANGED DATECHANGED      
 IX_ADDRESSPROCESSINGOPTION_ID ID      
 IX_ADDRESSPROCESSINGOPTION_SITEID SITEID      
 PK_ADDRESSPROCESSINGOPTION ID  
 UC_ADDRESSPROCESSINGOPTION_NAME NAME    

Trigger Name Description
 TR_ADDRESSPROCESSINGOPTION_AUDIT_UPDATE
 TR_ADDRESSPROCESSINGOPTION_AUDIT_DELETE

Referenced by Field
 ADDRESSPROCESSINGOPTIONORGCONTACTTYPE ADDRESSPROCESSINGOPTIONID
 INVITATION ADDRESSPROCESSINGOPTIONID
 INVITATIONHISTORY ADDRESSPROCESSINGOPTIONID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATE ADDRESSPROCESSINGOPTIONID
 MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE ADDRESSPROCESSINGOPTIONID
 MKTMEMBERSHIPMAILINGTEMPLATE ADDRESSPROCESSINGOPTIONID
 MKTMEMBERSHIPMAILINGTEMPLATERULE ADDRESSPROCESSINGOPTIONID
 MKTSEGMENTATION ADDRESSPROCESSINGOPTIONID
 MKTSEGMENTATIONSEGMENT ADDRESSPROCESSINGOPTIONID
 MKTSPONSORSHIPMAILINGTEMPLATE ADDRESSPROCESSINGOPTIONID
 MKTSPONSORSHIPMAILINGTEMPLATERULE ADDRESSPROCESSINGOPTIONID

Entity-Relationship diagram of this table