Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(255)   Default = '' The name of the import selection.
 DESCRIPTION nvarchar(1024)   Default = '' A description of the import selection.
 USEINQUERYDESIGNER bit   Default = 0 Indicates whether or not this selection can be used by the query designer.
 IDFIELD nvarchar(255)   Default = '' The field in the import file that represents the record IDs to be imported.
 STATUSCODE tinyint   Default = 0 The status of the import selection.
 STATUS nvarchar(24) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Pending import' WHEN 1 THEN N'Importing' WHEN 2 THEN N'Imported' WHEN 3 THEN N'Imported with exceptions' END Provides a translation for the 'STATUSCODE' field.
 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.
 IDTYPECODE tinyint   Default = 0
 IDTYPE nvarchar(19) (Computed) CASE [IDTYPECODE] WHEN 0 THEN N'System record ID' WHEN 1 THEN N'Lookup ID' WHEN 2 THEN N'Alternate lookup ID' END
 ALTERNATELOOKUPIDTYPECODEID uniqueidentifier

Foreign Key Field Type Null Notes Description
 RECORDTYPEID uniqueidentifier   RECORDTYPE.ID The record type of the IDs in the import selection.
 QUERYCATEGORYCODEID uniqueidentifier QUERYCATEGORYCODE.ID The category of the import selection.
 SITEID uniqueidentifier SITE.ID The site of the import selection.
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID The selection that was imported.
 OWNERID uniqueidentifier   APPUSER.ID The application user who created the import selection.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_IMPORTSELECTIONPROCESS_DATEADDED DATEADDED    
 IX_IMPORTSELECTIONPROCESS_DATECHANGED DATECHANGED      
 IX_IMPORTSELECTIONPROCESS_OWNERID OWNERID      
 IX_IMPORTSELECTIONPROCESS_QUERYCATEGORYCODEID QUERYCATEGORYCODEID      
 IX_IMPORTSELECTIONPROCESS_RECORDTYPEID RECORDTYPEID      
 IX_IMPORTSELECTIONPROCESS_SITEID SITEID      
 PK_IMPORTSELECTIONPROCESS ID  
 UC_IMPORTSELECTIONPROCESS_NAME NAME    
 UIX_IMPORTSELECTIONPROCESS_IDSETREGISTERID IDSETREGISTERID    

Trigger Name Description
 TR_IMPORTSELECTIONPROCESS_AUDIT_UPDATE
 TR_IMPORTSELECTIONPROCESS_AUDIT_DELETE

Referenced by Field
 IMPORTSELECTIONPROCESSEXPORTFORMAT PARAMETERSETID
 IMPORTSELECTIONPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table