INVITATION (4.0)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Contains information pertaining to invitations sent for events.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
EVENTID	uniqueidentifier	true	EVENT.ID	Foreign key to the event from which invitees are included in the invitation process.
BUSINESSPROCESSVIEWID	uniqueidentifier	true	BUSINESSPROCESSVIEW.ID	A foreign key to the view to use as output for the parameter set.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
OUTPUTIDSETRECORDTYPEID	uniqueidentifier	true	RECORDTYPE.ID	A foreign key to the record type of the output ID set to be created by the process.
MAILPACKAGEID	uniqueidentifier	true	MKTPACKAGE.ID	FK to MKTPACKAGE
EMAILPACKAGEID	uniqueidentifier	true	MKTPACKAGE.ID	FK to MKTPACKAGE
NAMEFORMATPARAMETERID	uniqueidentifier	true	NAMEFORMATPARAMETER.ID	The name format options to be used for this invitation.
ADDRESSPROCESSINGOPTIONID	uniqueidentifier	true	ADDRESSPROCESSINGOPTION.ID	The address processing options to be used for this invitation.

Fields
Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)	false	''	The name of the parameter set.
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.
DESCRIPTION	nvarchar(255)	false	''	The description of the Invitation
MAILDATE	datetime	true		The date the invitations were sent out.
CREATEOUTPUTIDSET	bit	false	0	Designates whether or not an ID set should be created as a result of the process.
OUTPUTIDSETNAME	nvarchar(100)	false	''	The name of the output ID set to be created by the process.
OVERWRITEOUTPUTIDSET	bit	false	0	Designates whether or not to overwrite the output ID set if one with the same name already exists.
CUSTOMPARAMETERDATAFORMITEM	xml	true		Custom parameters for this process.
CHANNELCODE	tinyint	false	0	0=Send through both mail and email, according to each constituents preferences., 1=Send through email only, 2=Send through mail only
CHANNEL	nvarchar(77) (Computed)	true		Provides a translation for the 'CHANNELCODE' field.
CHANNELPREFERENCECODE	tinyint	false	0	0=Email, 1=Mail
CHANNELPREFERENCE	nvarchar(5) (Computed)	true		Provides a translation for the 'CHANNELPREFERENCECODE' field.
HOUSEHOLDINGTYPECODE	tinyint	false	0	The type of household processing to use in this invitation.
HOUSEHOLDINGTYPE	nvarchar(40) (Computed)	true		Provides a translation for the 'HOUSEHOLDINGTYPECODE' field.
HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD	bit	false	0	Determines whether or not to include qualifying individuals who are not members of any household.
HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS	bit	false	0	Determines whether or not to include qualifying households which do not have any members.
HOUSEHOLDINGONERECORDPERHOUSEHOLD	bit	false	0	Determines whether or not to only accept one person per household during household processing.
LABELFILENAME	nvarchar(255)	false	''	The original file name for the label template.
LABELFILE	varbinary	true		The actual label template file.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_INVITATION_DATEADDED	DATEADDED	False	False	True
IX_INVITATION_DATECHANGED	DATECHANGED	False	False	False
IX_INVITATION_ID	ID	False	False	False
PK_INVITATION	ID	True	True	False
UIX_INVITATION_NAME_EVENTID	NAME EVENTID	True	False	False

Triggers
Trigger Name	Description
TR_INVITATION_AUDIT_UPDATE
TR_INVITATION_AUDIT_DELETE

Referenced by
Referenced by	Field
INVITATIONEXPORTFORMAT	PARAMETERSETID
INVITATIONSTATUS	PARAMETERSETID
INVITEE	INVITATIONID
INVITEERESEND	INVITATIONID