Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONSTITUENTFILE varbinary Contains the binary data of the constituent import file.
 CONSTITUENTFILENAME nvarchar(255)   Default = '' Contains the name of the constituent import file.
 CONSTITUENTFILESTATUSCODE tinyint   Default = 0 The load status of a constituent import file.
 CONSTITUENTFILEERRORS xml Contains the errors that were encountered in loading a constituent file.
 SUGGESTEDMEMBERSHIPLEVELSFILE varbinary Contains the binary data of the suggested membership levels import file.
 SUGGESTEDMEMBERSHIPLEVELSFILENAME nvarchar(255)   Default = '' Contains the name of the suggested membership levels import file.
 SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE tinyint   Default = 0 The load status of a suggested membership levels import file.
 SUGGESTEDMEMBERSHIPLEVELSFILEERRORS xml Contains the errors that were encountered in loading a suggested membership levels file.
 TARGETGIFTRANGESFILE varbinary Contains the binary data of the target gift ranges import file.
 TARGETGIFTRANGESFILENAME nvarchar(255)   Default = '' Contains the name of the target gift ranges import file.
 TARGETGIFTRANGESFILESTATUSCODE tinyint   Default = 0 The load status of a target gift ranges import file.
 TARGETGIFTRANGESFILEERRORS xml Contains the errors that were encountered in loading a target gift ranges file.
 WEALTHESTIMATORRATINGSFILE varbinary Contains the binary data of the wealth estimator ratings import file.
 WEALTHESTIMATORRATINGSFILENAME nvarchar(255)   Default = '' Contains the name of the wealth estimator ratings import file.
 WEALTHESTIMATORRATINGSFILESTATUSCODE tinyint   Default = 0 The load status of a wealth estimator ratings import file.
 WEALTHESTIMATORRATINGSFILEERRORS xml Contains the errors that were encountered in loading a wealth estimator ratings file.
 MODELINGANDPROPENSITYFILE varbinary Contains the binary data of the modeling and propensity import file.
 MODELINGANDPROPENSITYFILENAME nvarchar(255)   Default = '' Contains the name of the modeling and propensity import file.
 MODELINGANDPROPENSITYFILESTATUSCODE tinyint   Default = 0 The load status of a modeling and propensity import file.
 MODELINGANDPROPENSITYFILEERRORS xml Contains the errors that were encountered in loading a modeling and propensity file.
 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.
 AUXILIARYRESEARCHGROUPSIZE int   Default = 5000 Contains the max size of research groups that are created from the import.
 CONSTITUENTFILESTATUS nvarchar(12) (Computed) CASE [CONSTITUENTFILESTATUSCODE] WHEN 0 THEN N'No file' WHEN 1 THEN N'New file' WHEN 2 THEN N'Loading file' WHEN 3 THEN N'File loaded' END Provides a translation for the 'CONSTITUENTFILESTATUSCODE' field.
 SUGGESTEDMEMBERSHIPLEVELSFILESTATUS nvarchar(12) (Computed) CASE [SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE] WHEN 0 THEN N'No file' WHEN 1 THEN N'New file' WHEN 2 THEN N'Loading file' WHEN 3 THEN N'File loaded' END Provides a translation for the 'SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE' field.
 TARGETGIFTRANGESFILESTATUS nvarchar(12) (Computed) CASE [TARGETGIFTRANGESFILESTATUSCODE] WHEN 0 THEN N'No file' WHEN 1 THEN N'New file' WHEN 2 THEN N'Loading file' WHEN 3 THEN N'File loaded' END Provides a translation for the 'TARGETGIFTRANGESFILESTATUSCODE' field.
 WEALTHESTIMATORRATINGSFILESTATUS nvarchar(12) (Computed) CASE [WEALTHESTIMATORRATINGSFILESTATUSCODE] WHEN 0 THEN N'No file' WHEN 1 THEN N'New file' WHEN 2 THEN N'Loading file' WHEN 3 THEN N'File loaded' END Provides a translation for the 'WEALTHESTIMATORRATINGSFILESTATUSCODE' field.
 MODELINGANDPROPENSITYFILESTATUS nvarchar(12) (Computed) CASE [MODELINGANDPROPENSITYFILESTATUSCODE] WHEN 0 THEN N'No file' WHEN 1 THEN N'New file' WHEN 2 THEN N'Loading file' WHEN 3 THEN N'File loaded' END Provides a translation for the 'MODELINGANDPROPENSITYFILESTATUSCODE' field.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ANALYTICSPROJECTID uniqueidentifier ANALYTICSPROJECT.ID

Index Name Field(s) Unique Primary Clustered
 IX_BBAIMPORTFILES_DATEADDED DATEADDED    
 IX_BBAIMPORTFILES_DATECHANGED DATECHANGED      
 PK_BBAIMPORTFILES ID  

Trigger Name Description
 TR_BBAIMPORTFILES_AUDIT_UPDATE
 TR_BBAIMPORTFILES_AUDIT_DELETE

Entity-Relationship diagram of this table