New Search
to track the multiple donors as they come in (generally they are not all received at one time, but rather <br /> over a period of months.) Similarly a volunteer may be participating in a one -time only project or an <br /> ongoing service. <br /> Inventory: "Inventory", for the purposes of this donation database refers to a list of pre - selected <br /> donation opportunities that are available, referred to internally as the "gift catalog." This inventory is <br /> essentially a complete list of items and projects available for donation from bricks, to benches, to park <br /> renovations. We need the ability to easily add to the inventory as new items become available and <br /> the system should provide some automation of inventory reduction once an item is purchased. We <br /> also need to allow for small projects and large projects with flexibility within the "park ", "project <br /> name ", "phase or area" and "location description" fields with a large project utilizing all those fields <br /> and a smaller neighborhood park only requiring the "park" field. <br /> FUNCTIONALITY <br /> The key to the functionality of this information from a user standpoint is the ability to view the <br /> information on screen and its relationship between the three components. For example, once a donor <br /> makes a donation it should become linked to the item and we should be able to view all the <br /> information related to the three components of entry together. The history of that donor should also <br /> be immediately viewed on screen as a new donation is made. The user must be able to quickly sort, <br /> select, and access all data entered into the system. <br /> The following diagram details the links between the various components. Essentially it is the donation <br /> activity, the volunteer project, and the funded project that becomes the key connection between the <br /> components. In other words, a donor can exist without an inventory item and an unfulfilled inventory <br /> item can exist without a donor, but it is the act of the donation that links the records together. <br /> Relationship Links Between Components <br /> Donation <br /> Donor Data Inventory Data <br /> Activity <br /> Volunteer <br /> Volunteers <br /> (donor data + volunteer specific) Project <br /> Funded (occasional link) <br /> Granting Agency 4 Inventory Data <br /> (donor data + grant specific) Protect <br /> Page 2 of 4 POS Donation & Volunteer Database Scope 2 <br />