thankQ Help

IMPORTPROCESS_AUDITTRACKING

Used to determine which audit records are to be inserted into thankQ when an import is run.

IMPORTPROCESS_DELETEFROMWEB

Used to connect the thankQ Web tables to the Data Import tables when removing data.

IMPORTPROCESS_FOREIGNKEYMAPPING

Used to link import table data to another for example linking the Serial Number used in a table to the same serial number used in a different table so that the records belong to the same contact.

IMPORTPROCESS_IMPORTRECORDSTATUS

Contains the names of each status value available to import records and their display priority.

IMPORTPROCESS_IMPORTS

Lists all imports currently being processed and the ID of the query it is processing. An empty table indicates no imports are currently running.

IMPORTPROCESS_IMPORTSTATUS

Contains the names of each status value available to Imports and their order.

IMPORTPROCESS_STOREDPROCS

Defines the stored procedures to call for each step of the Import Steps that are run by the thankQ Service.

IMPORTPROCESS_TABLECOLUMNMAPPING

Contains the names of each import table column and the table columns they are imported into.

IMPORTPROCESS_TABLEMAPPING

Contains the names of each import table and the table(s) they are imported into. Can contain multiple entries for an Import table if it maps to multiple thankQ tables.

IMPORTPROCESS_TABLEORDER

The order that import tables are processed in.