Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of this process.
 DESCRIPTION nvarchar(255)   Default = '' The description of this process.
 REFERENCENUMBER nvarchar(20)   Default = '' The Charity Claim Reference Number for this instance of archived parameters.
 STARTDATE datetime Start date
 ENDDATE datetime End date
 UPDATEGIFTAIDSTATUS bit   Default = 1 Indicates that at the beginning of the R68 process the UPDATEGIFTAIDSTATUS global change will be run.
 TAXCLAIMNUMBER nvarchar(10)   Default = '' Tax Claim Number
 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.
 COMMITTED bit   Default = 0 Flag to indicate if the results from this parameter set have been committed.
 RUNGIFTAIDSPONSORSHIPSONLY bit   Default = 0 Indicates that the R68 process should only pick up Gift Aid sponsorships.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   BUSINESSPROCESSSTATUS.ID Primary Key.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID Indicates the IDSETREGISTER used to filter records included in the process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_R68ARCHIVEDPARAMETERS_DATEADDED DATEADDED    
 IX_R68ARCHIVEDPARAMETERS_DATECHANGED DATECHANGED      
 PK_R68ARCHIVEDPARAMETERS ID  

Trigger Name Description
 TR_R68ARCHIVEDPARAMETERS_AUDIT_UPDATE
 TR_R68ARCHIVEDPARAMETERS_AUDIT_DELETE

Entity-Relationship diagram of this table