PLANNEDGIFTACKNOWLEDGEMENTPROCESS (4.0SP17)

ID

uniqueidentifier

IDSETREGISTERID

uniqueidentifier

true

A foreign key to the ID set used to filter the records included in the acknowledgement process.

OUTPUTIDSETRECORDTYPEID

uniqueidentifier

true

A foreign key to the record type of the output ID set to be created by the acknowledgement process.

PLANNEDGIFTLETTERCODEID

uniqueidentifier

false

A foreign key to the planned gift letter code this process will use to acknowledge.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

NAME

nvarchar(100)

false

The name of the parameter set.

DESCRIPTION

nvarchar(255)

false

The description of the parameter set.

CREATEOUTPUTIDSET

bit

false

Designates whether or not an ID set should be created as a result of the acknowledgement process.

OUTPUTIDSETNAME

nvarchar(100)

false

The name of the output ID set to be created by the acknowledgement process.

OVERWRITEOUTPUTIDSET

bit

false

Designates whether or not to overwrite the output ID set if one with the same name already exists.

MARKLETTERSACKNOWLEDGED

bit

false

Indicates whether or not letters for this process should be marked as sent.

ACKNOWLEDGEDATETYPECODE

tinyint

false

Designates whether to use today's date or a specific date in the acknowledgement process as the acknowledge date.

ACKNOWLEDGEDATE

datetime

true

This date is used as the acknowledge date when marking records as acknowledged.

LABELFILENAME

nvarchar(255)

false

The original file name for the label template.

LABELFILE

varbinary

true

The actual file for the label template.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

ACKNOWLEDGEDATETYPE

nvarchar(13) (Computed)

true

Provides a translation for the 'ACKNOWLEDGEDATETYPECODE' field.

IX_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DATEADDED

False

False

True

IX_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DATECHANGED

False

False

False

PK_PLANNEDGIFTACKNOWLEDGEMENTPROCESS

True

True

False

UC_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_NAME

True

False

False

TR_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_AUDIT_UPDATE

TR_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_AUDIT_DELETE

TR_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_INSERT

TR_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DELETE_BUSINESSPROCESSINSTANCE

PLANNEDGIFTACKNOWLEDGEMENTPROCESSEXPORTFORMAT

PARAMETERSETID

PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUS

PARAMETERSETID