So we have a unique use case. The organization collects donations from employees of various departments with various roles at the organization. Collecting employee information like title, department, etc seems pretty straight forward using custom fields and profiles. However, lets say, 3 years down the road, a donor changes their department, the field would be updated when they renew their donation and would be accurately reflected in the system, but it would now impact historical information. Their donation records would stay the same, but their donations would be affiliated with the new department.
Am I making sense? Is custom fields the right approach? Alternatively, we may just download historical data and use that for reports comparing campaign years.