Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(255)   Default = '' Name of the export process.
 DESCRIPTION nvarchar(1000)   Default = '' Description of the export process.
 FILENAME nvarchar(255)   Default = '' Name of the file on the web server.
 DATEFORMAT nvarchar(50)   Default = '' Format in which the dates are stored in the import file.
 FUZZYDATEFORMAT nvarchar(50)   Default = '' Format in which the fuzzy dates are stored in the import file.
 MONTHDAYFORMAT nvarchar(50)   Default = '' Format in which month/day values are stored in the import file.
 CODETABLEUSEID bit   Default = 0 Flag indicating to use a code table entry's ID instead of its translation when importing data from the import file.
 SIMPLEDATALISTUSEID bit   Default = 0 Flag indicating to use a simple data list item's ID instead of its translation when importing data from the import file.
 USEDEFAULTVALUEWHENBLANK bit   Default = 0 Flag indicating whether to use the bacth default value when an import field has a blank value.
 COLUMNMAP xml   Represents the column mapping between the import file and the batch process instance.
 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.
 SEARCHLISTUSEQUICKFIND bit   Default = 0 Flag indicating whether to use a search list's quick find field to locate the specified record rather than the record's ID.
 ADDNEWCODETABLEENTRIES bit   Default = 0 Flag indicating wheather to add code table entries that do not already exist.
 TREATFIRSTROWASHEADER bit   Default = 1 Flag indicating whether or not the first row in the CSV file is treated as a header
 BATCHCOMMITOPTIONCODE tinyint   Default = 0
 BATCHCOMMITOPTION nvarchar(50) (Computed) CASE [BATCHCOMMITOPTIONCODE] WHEN 0 THEN N'Do nothing' WHEN 1 THEN N'Validate new batches but do not commit any records' WHEN 2 THEN N'Commit batches if they have no batch exceptions' WHEN 3 THEN N'Commit all valid rows from new batches' END
 AUTOMATCHTHRESHOLD int   Default = 0
 OVERALLMATCHTHRESHOLD int   Default = 0
 PARAMETERSXML xml
 SUBDIRECTORY nvarchar(255)   Default = ''
 CHECKFORDUPLICATES bit   Default = 1
 USEWILDCARDS bit   Default = 0
 TEMPFILENAME nvarchar(255)   Default = ''
 DELIMITER nvarchar(5)   Default = ','
 USEBATCHTEMPLATEMATCHSETTINGS bit   Default = 0

Foreign Key Field Type Null Notes Description
 BATCHTEMPLATEID uniqueidentifier BATCHTEMPLATE.ID The batch instance into which the data will be imported.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BATCHAPPUSERID uniqueidentifier APPUSER.ID Represents the user who will be the owner of the batch once it is created by the import process.
 IMPORTSOURCEID uniqueidentifier IMPORTSOURCE.ID
 DELIMITEDFILETEMPLATEID uniqueidentifier IMPORTFILETEMPLATE.ID
 FIXEDWIDTHFILETEMPLATEID uniqueidentifier IMPORTFIXEDWIDTHFILETEMPLATE.ID

Index Name Field(s) Unique Primary Clustered
 IX_IMPORTPROCESS_DATEADDED DATEADDED    
 IX_IMPORTPROCESS_DATECHANGED DATECHANGED      
 PK_IMPORTPROCESS ID  
 UC_IMPORTPROCESS_NAME NAME    

Trigger Name Description
 TR_IMPORTPROCESS_AUDIT_UPDATE
 TR_IMPORTPROCESS_AUDIT_DELETE

Referenced by Field
 IMPORTPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table