General lookup/validation tables for Fundraising
There are several general lookup/validation tables to define when setting up Fundraising. See the General lookup/validation tables section for details.
| Fundraising Specific General Lookup/Validation Table | Purpose | Examples |
|---|---|---|
| APPEAL\_TYPE | A code that designates a short term activity with a specific goal. | FLOODRELIEF. LEGALDEFENSE. ROOFREPAIR |
| EXPENSE\_TYPE | A code that enables you to categorize and keep track of money spent for fundraising efforts. | PHONE. ELECTRIC. RENT. POSTAGE |
| FUNDRAISER\_TYPE | A code that designates the type of campaign that generates a donation. | NEIGHBOR\_REACH. FAMILY\_FRIENDS. CORP\_RACE |
| MEM\_TRIB\_RELATIONSHIP | A code that indicates relationship of a notification contact to the honoree of a memorial/tribute donation. | SIBLING. PARENT. SPOUSE. |
| REQUEST\_TYPE | A code that indicates what kind of request is made. | PHONE. LETTER. VISIT |
| SOURCE\_CODE | A code that indicates the marketing program or mailing that solicited a donation. | LTR\_Q2\_05. TELETHON |