We currently use giftlist API to load our data warehouse and it is built on the assumption that giftID and SplitID are unique keys to identify the gift. We recently learned that is not the case. Everytime an adjustment is made to the gift, splitid is changing.  We need a way to identify prior splits in our warehouse so that we don't count the same gift twice.