Update Data Review Tools
Where there is request to update any information on Review Tools, the script needs to run.
Example 1 (Removing Inventory)
The following people are no longer in quality. Please remove any open inventory for them.
- 2765 Mary Grace
- 1887 Jack Smith
- 5357 Mary Scott
Use ReviewTool_DataLoad.sql
UPDATE [SMART].[rt_Claim] SET Deleted = 1 WHERE AuditorNo IN (2765,1887,5357) AND StageNo <> 20