The contents of the table are going to be recreated in whole each day as well. Meaning I am going to truncate and populate the tables prior to the ftp - so managing this information within the table probably wouldn't work. However, maybe a secondary table would do the trick.