Our Development team would like to audit if the Designation changes for their Prospect Plans. So it would work like -1 Status Change or -2 Campaign Change.
Is this possible? If you yes is there a limit to which fields can be audited?
Leslie,
When you say "Designation," do you mean the field under "Campaign" on the Plan window? If so, you can enter values into TR_CONT_DESIGNATION and then assign the appropriate values to the relevant Campaign in order to be able to select those values on a given plan.
It sounds like what you're talking about might be more in line with the "Type" or "Status" fields on the Plan window though (unless I'm misunderstanding, which is entirely possible!). Values can be added for Type in TR_PLAN_TYPE while TR_PLAN_STATUS is where you'll add for Status.
I personally use Type to identify my relationship with the Plan prospect at the start of the Plan (Current Donor, Lapsed Donor, Renewed Donor, etc.) while Status is used to track the current status of the Plan (Membership Confirmed, Membership Declined, Membership Cultivation, Stewardship, etc.).
I'm happy to help if you have any other questions (or if I've missed on my initial reading!).
Thank you,
Brian