thankQ Help

•Only runs on records that have an Import Status of “Validated” or “Waiting to Update”.

•Checks foreign keys. Must exist in either import or in live thankQ.

•Makes sure the import records the foreign key links to have an Import Status of “Validated” or above.

•A stored procedure will be available per import table.

•Errors can force all records to stop the import process at this point for certain Configurations.

•Potential to stop entire process here until all records are Checked (even without any errors).

•If one or more foreign keys link to records that don’t exist, the import record has an Import Status of “Validation Failed”. The foreign key failures are inserted into the table with the reason why.

•If all foreign keys pass and the linked records have an Import Status greater than or equal to “Validated”, the import record has an Import Status of “Checked”.

•If all foreign keys pass and the linked records have an Import Status less than “Validated”, the import record has an Import Status of “Waiting to Update”.

•Once all records have an Import Status of “Checked” (or the Configuration allows it to continue), the Import record has a Status of “Records Validated”.