Version 1 - Reviewed: November 18, 2016
In some TariffShark databases, a few Filing Types are registered beneath the wrong FERC Programs. While we have been unable to recreate this issue in our lab, it is definitely present in a few databases.
Running the SQL script provided herein against any TariffShark database of version 720, 730, 820, 830, 920, 930, 940, 941, 942, 1000, 1010, 1020, 1021, 1022, 1053, 1054, 1408, or 1409 will fix the issue.
In the event that you run this script and your database was already fine, no harm will be done.