Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 IMPORTFILEPATH nvarchar(200)   Default = '' Path where import files are stored.
 IMPERSONATE bit   Default = 0 Determines whether the import file path will be accessed using impersonation.
 IMPERSONATEUSERNAME nvarchar(200)   Default = '' User name for account that has rights to the import file path.
 IMPERSONATEPASSWORD nvarchar(4000)   Default = '' Password for account that has rights to the import file path.
 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.

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

Index Name Field(s) Unique Primary Clustered
 IX_IMPORTPROCESSOPTIONS_DATEADDED DATEADDED    
 IX_IMPORTPROCESSOPTIONS_DATECHANGED DATECHANGED      
 PK_IMPORTPROCESSOPTIONS ID  

Trigger Name Description
 TR_IMPORTPROCESSOPTIONS_AUDIT_UPDATE
 TR_IMPORTPROCESSOPTIONS_AUDIT_DELETE