thankQ Help

•Some validation can be turned off / ignored for certain Configurations.

•Only runs on records that have an Import Status of “New”, “De-duped” or “Updated by User”.

•A stored procedure will validate the data in the records, checking the following:

oData Types – Data must be able to be converted to the correct type.

oData Length – Data must not be longer than the length in thankQ.

•A stored procedure will be available per import table, checking the following:

oMandatory fields are specified (configurable in Lookup Values)

oValue Range checks (configurable in Lookup Values)

oDuplicate records – Cannot have same primary key as previous records imported in this Import.

•Inserts any failures into the table with the reason why it failed.

•Once validated, records have status of “Validated”. If one or more of the checks fail, the records have a status of “Validation Failed”.