Abstract:
An apparatus, system and method for facilitating and improving prospect identification and facilitating dollar specific gift targeting is described. The invention includes a central data processor for storing, indexing and manipulating data and a memory means for storing and selectively retrieving specific portions of a database specified by a user request There is a communication link to establish a communication path between the central data processor and one or more external databases in response to a user request. A prospect data processor selectively generates prospect data, and an analysis storage, retrieval and means are also included for storing and retrieving selected prospect data and for returning generated codes to a client database.

Description:
FIELD OF THE INVENTION  
         [0001]    The present invention relates to an interactive computerized electronic system which uses customized criteria to identify potential donors and to evaluate and catalogue the specific dollar potential and projected yield of existing and potential donors and others. The present invention has particular applicability in the field of gift targeting for charitable institutions. In particular, the present invention relates to a method and apparatus for generating data specific to each individual analyzed in order to improve prospect identification and facilitate dollar specific gift targeting for existing and potential donors, and in which such individual-specific data is selectively generated and analyzed for purposes of creating codes to be made available to the client. This data may be appended to each existing and prospective donor&#39;s record on the client&#39;s database, by making the data available by electronic means or otherwise. Although the present invention has particular application in the field of charitable giving the teachings of the present invention may also be used to identify prospective purchasers for a number of goods and services particularly high end goods and services.  
         BACKGROUND OF THE INVENTION  
         [0002]    Institutions, including non-profit organizations, today rely on funding from an array of sources to support their mission. Traditionally these sources are government funding, charitable foundations, corporate foundations and individuals. Increasingly, organizations are relying on gifts from individuals to sustain the organization.  
           [0003]    In the past, donors were persons or other charitable institutions that were contacted personally by the fund-raisers of the institution seeking funds. One shortcoming of such a method of raising funds is the cost of reaching the donors. Personal contacts are time consuming and as a result labor intensive thus adding to the cost per dollar of contributions received. Another shortcoming of this approach is its inability to effectively identify and prioritize prospective donors. Resultantly, potentially good donors are overlooked and are therefore not cultivated or solicited effectively.  
           [0004]    Today, due to the busy schedules, working long hours and other commitments, it is particularly impracticable to reach a wide donor pool through personal solicitations. Institutions have therefore resorted to mass mailing of promotional literature and solicit funds from the recipients of such literature. Often organizations in search of donore send this material to a general audience which may or may not include existing donors. This broadcast distribution of solicitation materials to a general audience typically results in small gifts with many prospects choosing not to respond. Such futility may arise due to several reasons, some of them are: the target donors being asked for a gift substantially lower than his or her means, or being unable to afford a contribution, or having a low affinity for the cause and/or institution.  
           [0005]    As organizations become more sophisticated - employing more skilled fund raising professionals and state of the art fund raising software - there has been an increasing demand for a method and system that effectively segments or targets their individual constituencies. An objective is to use the principles of commercially proven target marketing when making decisions about how best to manage individuals with the greatest capacity and inclination to give. The questions non profit organizations are repeatedly asking include:  
           [0006]    How do I find my very best prospects (prospective identification);  
           [0007]    What should I ask each of my constituents to give (gift targeting);  
           [0008]    Will the techniques I use lower the cost to raise a dollar? 
         SUMMARY OF INVENTION  
         [0009]    The present invention relates to an interactive method and apparatus for improving prospect identification and facilitating dollar specific gift targeting. Applicant&#39;s interactive system may include one or more of the following, it identifies an organizations wealthiest donors and prospective donors and provides evaluation regarding their inclination to give; it can target the dollar specific gift potential of every individual on an organization&#39;s database; it provides a dollar specific assessment of every individual&#39;s gift potential, typically for a three to five year period; it makes recommendations on prospect research priorities; it returns this information to the organization by any suitable means including electronically and it may be installed on the organizations database of individuals or made accessible to them via electronic means.  
           [0010]    Applicant&#39;s interactive system may includes a central data processor for storing, indexing and manipulating data, memory means for storing and selectively retrieving portions of a database specified by a user request, a communication means or communications path between a central data processor and the client&#39;s database as well a external databases, a prospect data processor for selectively generating profile data on a prospect, an analysis storage and retrieval means for storing and retrieving selected prospect data and a communication means for returning this information to the organizations database on individuals.  
           [0011]    It is an object of the present invention to provide an apparatus and method for evaluating and prioritizing existing and potential donees.  
           [0012]    It is another object of the present invention to provide a method and apparatus for identifying and selecting, from cataloguing provided client data and external databases, donors for solicitation of funds or other donations, and targeting such selected donors.  
           [0013]    It is yet another object of the present invention to provide a method and apparatus for generating a database of selective prospective and existing donors with the highest gift potential for use for use by the organization.  
           [0014]    It is yet another object of the present invention to provide a method and apparatus for prioritizing prospective and existing donors with the highest gift potential based on an individuals affinity for the organization.  
           [0015]    It is yet another object of the present invention to provide an apparatus and method for quantifying the dollar specific gift potential of individuals on a client&#39;s database including both donors and prospects, in order to increase a clients fund raising.  
           [0016]    It is yet another object of the present invention to provide an apparatus and method for identifying the appropriate method of solicitation.  
           [0017]    It is yet another object of the present invention to provide an apparatus and method for returning information obtained using the method and system to the client in an electronic format that can be installed on the client&#39;s database or linked to the database, including in such a way where this information is accessible to each individual&#39;s constituent file on the client database.  
           [0018]    These and other objects and advantages of applicants&#39; method and apparatus for the generation and efficient and advantageous use of a donor database can best be understood by reference to the following detailed description in conjunction with the accompanying drawings. 
       
    
    
     BRIEF DESCRIPTION OF THE DRAWINGS  
       [0019]    [0019]FIG. 1 is a schematic block diagram of a system utilizable for the generation and use of a donor database in accordance with the present invention.  
         [0020]    [0020]FIG. 2 is a schematic logic block diagram of a system for the generation of an optimized donor database wherein the donee institution provides a database of existing donees.  
         [0021]    [0021]FIG. 3 is an example of the screen version of a table that may be generated from the data. 
     
    
     DETAILED DESCRIPTION OF PREFERRED EMBODIMENTS  
       [0022]    Referring to FIG. 1, there is shown a block diagram of a system that can be utilized for the generation and use of a donor database in accordance with one embodiment of the present invention. As shown, the client provides a database containing data of entities collected by the client and may include individuals with an affinity to the client. Such entities may be persons who have made past contributions, individuals with general interest in the organizations mission, persons who have made purchases at an affiliated store, etc. Such a database can be expressed in electronic media. The data from the database is imported into the CPU, which may, for example, comprise a central data processor with an associated system memory and standard peripherals. The CPU also has selectively addressable memory capable of storing digital data. The CPU may also be a network of computers linked together in a wide area network (WAN) or a local area network (LAN), combinations thereof, or one or more independent workstations.  
         [0023]    At the CPU, the data provided by the donee-client is read and the donor information is tracked using a unique identification number which has been assigned by the client to each record. The identification number includes, but is not limited to an alphanumeric code that serves as a means for identifying a particular record. Such assignation of codes may be necessitated, amongst other reasons, for the purpose of distinguishing between persons who have the same name or other similarities in their record of information. The identification number may be randomly generated or may have a significance, for example, may have the year in which the donor first gave a gift as a prefix. A mere reading of the identification number would therefore provide some information as to the record or data profile to which it is linked.  
         [0024]    The client&#39;s database of records that is provided by the donee-client may consist of data such as, name, address, telephone number, gift history, and other biographical data. Against each record, the CPU selectively accesses data from one or more external databases that provides current, usually publically available information about each entity to which the record pertains. The information that the external database would provide access to includes, but is not limited to, high net worth indicators, SEC insider trading information, success in various business ventures, recent promotions, change of job, change in members of the family, change in financial status, change of residence, date of birth, etc. The external database may be maintained within the CPU. It could also be an in-house database compiled as a result of research and data-mining.  
         [0025]    An external database is now queried by the CPU. Such queries would typically be by each individual&#39;s unique identification number. In response to this query, an external database is searched and this provides updated data or file enhancements for each donor-entity. The updated data, amongst other data, gives the most current financial status, nature of job held, change of residence, etc. This data profile is imported into the CPU where it is linked via each individual&#39;s unique identification number to the biographical data received from the client. The data in these fields can then be, preferably, expressed in a tabular form. By “tabular form” it is meant that the data contained in the fields is arranged in accordance with desired criterion. It may include a traditional table or another arrangement of fields and the data contained therein. An example of the screen version of one such table that may be generated is depicted in FIG. 3.  
         [0026]    This process is repeated for each record and the entire data compiled, preferably, in such tabular form. In response to queries that arrange, divide, and group the data contained in the fields, the updated and revised data of the donor entities are divided into groups in accordance with certain criteria. For example, the donor data profiles may be arranged in accordance with the gift-giving capacity, or arranged by affinity for the organization, or both, etc. These tabular arrangements are formatted and placed in a form suitable for use by the client. This arrangement forms the output, which contains target codes assigned to each record provided by the client. The geodemographic and wealth information (databases)as well as entity&#39;s biographical and gift giving history (supplied by client), if any, provide the basis for assignment of the dollar specific gift-giving potential and yield of each entity. This data can now be used by the client to target specific individuals for specific ask amounts or target specific groups of individuals for specific dollar ask amounts—leading directly tom the generation of funds. For example, the entities targeted for a gift of $50,000 or more who are most closely linked to the client may be targeted in a particular manner and then pursued on a high priority basis.  
         [0027]    In an alternative embodiment, the client may not provide a client database. In this embodiment CPU  4 , in accordance with the present invention, will search external databases for potential donors in response to appropriate queries. An example of such a query could be a search for all persons who have registered luxury cars during the previous year. The persons thus identified would form prospective donors with a relatively higher gift-giving potential. Furthermore, such persons may be requested to give a gift of a higher amount than would have been requested in the past in view if this information. Several such queries will generate lists of persons who are in varying degrees of financial well-being. The data profiles thus mined will be categorized and formatted in a manner as outlined above. This formatted and categorized data, each profile having a gift-giving potential (both generally as well as in actual money amount), will enable the client to approach the person accordingly.  
         [0028]    Referring now to FIG. 2, there is shown a logic block diagram of a system that can be utilized in accordance with the present invention. In Step 1, the data provided by the client which may include biographical data and gift history is exported from client&#39;s database to the CPU. Steps 2a abd 2b demonstrate that by using each entity&#39;s unique identification number, the data supplied by the client is supplied by the client is sent to one or more external databases, which are mined for publically available geo-demographic and wealth indication information for each entity. Step 3 links he selectively accessed data appended to each entity&#39;s record to the client information by using each entity&#39;s unique identification number.  
         [0029]    A series of steps 4, 5, 6, and 7, sum the value of all the gifts given, the total number of gifts given, and the amount of the largest gift, and segments these gifts into categories for each individual. Step 4 is a summation step and it provides the total amount of the value of all gifts given by a donor, the total number of gifts given by that donor and the value of the largest gift given by that individual, the last three year total given by that donor (in accordance with the invention, the number of years for which gifts are totaled may be a variable), the total for each of the last three years given by that donor and the largest gift given by that donor in the last three years. Step 5 provides similar data per donor except the gifts are limited to those given for special occasions. An example of a special event could be a golf outing held to raise funds for the construction of a library. Step 6 provides similar data per individual to step 4 except it is limited to gifts given towards the client&#39;s annual fund raising program. Step 7 provides similar data to step 14 but is limited to the gifts given towards capital fund raising as well as other gifts not given for a special event or to an annual fund raising program.  
         [0030]    A series of queries then analyze these data profiles and separate individuals into categories based on the gift-giving potential of each individual. The purpose of performing this step is to screen and sort the data for individuals who demonstrate varying degrees of potential for making gifts. Furthermore, these individuals are grouped according to the amount of gift that can be requested from them. These categories are arrived at using judiciously pre-selected values for variables and operators and comparators. For example the first category could consist of persons who have a median household income ≧$75,000 OR an estimated household income 7 AND wealth rating ≧8 AND P$ycle code=1, total gifts ≧$2,000 OR wealthengine codes ≧1AE OR 1BE OR 2AE OR 2CE OR 2DE OR 5AE OR 5BE OR 5CE. This would constitute the top pool of prospective donors. The pool may be modified by modifying the criteria. This process is repeated for other categories of potential donors.  
         [0031]    Step 8 shows that individuals are selected, using predetermined gift history and external data criteria, for their ability to give a major gift of $50,000 or more to the client. For example, the major gift category could consist of persons who have a median household income of $75,000 or an estimated household income of 7 and a wealth rating &gt;8. Once selected, individuals in this category are further sub-divided within this category according to their affinity for the: client. For example, an individual could be given a major gift code with high affinity. because this individual has given a gift of $100,000 to the client in the last three years.  
         [0032]    Step 9 shows that individuals are selected using predetermined gift history and external data criteria for their ability to give a planned or estate gift of $50,000 or more to the client. For example the planned gift category could consist of persons who have a median household income of $75,000 or more and are aged 55 years or older. Once selected, individuals in this category are further sub-divided within this category according to their affinity for the client. For example, an individual could be given a planned gift code with a moderate affinity because they had previously served on the client&#39;s Board of Directors. Individuals in this group may or may not have been selected for the major gift category.  
         [0033]    Step 10 shows that each individual provided to applicant by the client is assigned an annual fund short term code, based on predetermined gift history and external data criteria. Each individual will be assigned a dollar specific amount (from $25-$10,000 or more) that they can be asked to give to the client on an annual basis. This amount assigned to each individual from the client database—reflects an individual&#39;s ability to give and at the same time takes into account a gift which an individual is most likely to give to the client. The annual fund short term code is an amount that can be requested on the individual in the first 6 months of the completion of this process.  
         [0034]    Step 11 shows that each individual provided to applicant by the client is assigned an annual fund long term code, based on predetermined gift history and external data criteria. Each individual will be assigned a dollar specific amount (from $25-$10,000 or more) that they can be asked to give to the client on an annual basis. This amount—assigned to each individual from the client database—reflects an individual&#39;s ability to give and at the same time takes into account a gift which an individual is most likely to give to the client. The annual fund long term code is an individual&#39;s true gift potential—an amount that can be requested within a three to five year period. It will be appreciated by those skilled in the art that depending on the institution and/or the type of donors or potential donors etc. one or more of these steps may be eliminated.  
         [0035]    Once individuals have been assigned to the categories, the data which contains the assignments is rendered into a client usable format. This file is returned to the client. The client installs this information back onto their database or gains access to this information via electronic means, using the unique identification number for each individual to link the new data to the individual&#39;s existing record. The client now has information for each individual on their database which categorizes existing and prospective donors according to their major and planned gift potential and affinity. The client database also now contains short term and long term specific dollar ask amounts reflecting each entity&#39;s ability and willingness to give to the client on an annual basis. With the information generated by the applicant, the client&#39;s fund raising efforts can now be directed towards the donors and prospective donors, incorporating the results obtained by the use of this invention, thereby increasing the amount of gifts received as well as maximizing the giving potential of each donor.  
         [0036]    In an alternate embodiment, there may be summations of all gifts, gifts for annual funds, gifts for special events, and gifts for capital funds and other gifts not given to the annual fund or special events, for the past three years per individual. These gifts are also totaled for each of these past three years. In accordance with the present invention, the number of years for which the gifts are totaled may be a variable. Alternatively, the next series of steps can consist of cross tabbing these summations and selections by campaign and year. Cross tabbing consists of linking together two or more fields, in accordance with predetermined criterion. For example, two fields may be cross tabbed, i.e. linked together using the operator “greater than”. In the preferred embodiment, the results of the summations are cross tabbed i.e. placed in one row per individual, and subsequently separated by campaign and then by year. Separate tables may be made for total gifts, total events, total annual fund, total capital and other gifts, events, and gifts. In one embodiment, these tables may be constructed using a spreadsheet program such as ACCESS or any other such similar program that permits manipulation of data in tabular form.  
         [0037]    Using this data, other databases are mined for an updated profile of geodemographic data per individual or entity. External databases may be maintained in-house or may be other publicly available databases, such as, credit rating, balance sheets of publicly held corporations, etc., which are connected to the CPU. This selectively accessed data is then linked to each identification number on the CPU. As an example, given below is a detailed description of steps that may be performed as have been outlined above:  
         [0038]    Once the database file is obtained from the client, two queries are made in order to export the information required. The first is a query to export the biographical information and the second will export the necessary gift information. Two such default queries for this process are listed below. Adjustments specific to each client may be necessary.  
       Query 1 (Biographical Information)  
       [0039]    Open RE Query  
         [0040]    Select the “Create New Query” icon or File, New  
         [0041]    The Add New Query Screen will appear  
         [0042]    Select Query Type: “Individual” and Query Format “dynamic” 
         [0043]    From the Biographical tab, pull the following fields into the output box:  
         [0044]    Constituent ID  
         [0045]    Last Name  
         [0046]    First Name  
         [0047]    Middle Name  
         [0048]    Title 1, Title 2  
         [0049]    Suffix 1, Suffix 2  
         [0050]    Address Lines (Primary)  
         [0051]    City, State, Zip (Primary)  
         [0052]    Address Type (Primary)  
         [0053]    Business Organization Name  
         [0054]    Business Position  
         [0055]    Constituency Code Description  
         [0056]    *In Constituent Management, make sure Primary Address=Home Address before exporting this query.  
         [0057]    Save Query (i.e., “DMBio”)  
         [0058]    Open RE Export  
         [0059]    Select the “Create a New Export” icon  
         [0060]    Select Export type “Constituent” and Records to Include “Selected Records” 
         [0061]    A From Group box will appear. Select the Biographical Query just created in RE Query by clicking on the arrow on the right hand side of this box and scrolling through the list of queries OK  
         [0062]    Return to the New Export Screen and check box Load Query Output Fields (this tells RE Export to select the same fields that were selected in the Biographical Query) OK  
         [0063]    Address Criteria screens will appear for each address line (including City, State and Zip)  
         [0064]    Select “Based on criteria” for each line  
         [0065]    Click the Export Icon (the suitcase)  
         [0066]    An Export Format Screen will appear  
         [0067]    Select “Comma Separated Value” OK  
         [0068]    A Constituency Parameters Screen will appear  
         [0069]    Select the number of constituencies you would like to have appear in the export (i.e., 1)  
         [0070]    Under Constituency Criteria, choose “Selected Constituencies” 
         [0071]    Select all constituencies pertaining to an individual (this will vary with each client) For example: “INDIV” “Board”, etc.)  
         [0072]    An Enter Export File Name Screen will appear  
         [0073]    Name the Export (i.e., DMBio) &amp; choose the Drive and Folder you would like the export to be sent to (i.e., g:/wrk/“client name”/PID/ “DMBio”) OK  
         [0074]    A Processing Export File screen will appear  
         [0075]    Once the file is 100% exported, a control report appears.  
         [0076]    The File has now been exported to the location you have selected.  
       Query 2 (Gift History)  
       [0077]    From the Biographical Tab, pull the following field into the Output Box:  
         [0078]    Constituent ID  
         [0079]    From the Gift Tab, pull the following fields into the Output Box:  
         [0080]    Gift Amount  
         [0081]    Gift Date  
         [0082]    Gift Campaign Description  
         [0083]    Gift Fund Description  
         [0084]    Gift Appeal Description  
         [0085]    Pull the “Gift Type” Field into the Filter Box to select specific information from this field:  
         [0086]    Gift Type Select “One of” and choose everything except Pledge and MG Pledge  
         [0087]    Export this query directly from RE Query into the Drive and Folder in which the database is set up for the PID.  
         [0088]    A Field can be filtered and not included in the Output Box (i.e., gift type)  
       Creating a Database to Import Queries  
       [0089]    Once the information has been exported, a database must be created to import the information. A spreadsheet program such as ACCESS may be used for this purpose.  
         [0090]    Open ACCESS  
         [0091]    File, New Database. Save in client folder (e.g., g/wrk/client name/PID/database.mdb)  
         [0092]    Click File, “Get External Data”, Import  
         [0093]    Choose Text Files (.csv) as File Type  
         [0094]    Select RE Export file for Biographical Information saved in comma separated value (.csv) format (i.e., “DMBio.csv)  
         [0095]    Click “IMPORT” 
         [0096]    Access will convert file using the following prompts:  
         [0097]    Choose file type that best describes your data  
         [0098]    Select Delimited, “NEXT” 
         [0099]    Select Delimiters and Text Qualifiers (i.e., Comma, “”), “NEXT” 
         [0100]    Store Data in “New Table” 
         [0101]    Field Options, “NEXT” 
         [0102]    Select No Primary Field  
         [0103]    Select Table Name, “FINISH” 
         [0104]    Repeat process for Gift Export, importing into the same database.  
         [0105]    When the two tables are in the ACCESS database, rename the fields.  
         [0106]    For the Bio table, rename the fields based on what they were named in the RE program, making sure that the constituent ID field is renamed “ConsID” with a “text” data type” 
         [0107]    For the gift table, rename the fields in the following way:  
         [0108]    Field 1—Field Name: “ConsID”, data type “text” 
         [0109]    Field 2—Field Name: “Gift Amount”, data type “currency” 
         [0110]    Field 3—Field Name: “Date”, data type “Date/Time” 
         [0111]    Field 4—Field Name: “Campaign”, data type “text” 
         [0112]    Field 5—Field Name: “Fund”, data type “text” 
         [0113]    Field 6—Field Name: “Appeal”, data type “text” 
         [0114]    Once the tables are renamed, several queries must be created to sort the gift history for the prospect identification and gift targeting process.  
       Query #1—Total Gifts  
       [0115]    This Query will give you the sum, number of gifts and largest gift amounts for all gifts per individual  
         [0116]    In Design View, Select the Gift Table  
         [0117]    Pull each field down onto the Query Grid in the following order:  
         [0118]    ConsID  
         [0119]    Gift Amount  
         [0120]    Gift Amount  
         [0121]    Gift Amount  
         [0122]    * Note: The Gift Amount field should be pulled down three times because the gift amount information will be sorted differently in each field.  
         [0123]    On the Toolbar, select the Totals icon A Total Row will appear on the Query Grid  
         [0124]    In the first Gift Amount Field, change “Group by” in the Total Row to “Max” 
         [0125]    In the second Gift Amount Field, change “Group by” in the Total Row to “Count” 
         [0126]    In the third Gift Amount Field, change “Group by” in the Total Row to “Sum” 
         [0127]    Run Query  
       Query # 2—“Total Events” 
       [0128]    This Query will give you the sum, number of gifts and largest gift amounts for all special events gifts per individual.  
         [0129]    Repeat the above instructions AND  
         [0130]    Pull down the “Campaign” field onto the Query Grid  
         [0131]    Type “Events” in the criteria row  
         [0132]    Run Query  
         [0133]    *Note the criteria may vary from client to client. You may need to use the Fund or Appeal Field to sort out the Special Events Gifts instead of the Campaign field. Also, there may be more than one category of events to be added to the criteria row. For example, the client may sort out event gifts in the Fund Field and have a different fund code for each event.  
       Query # 3—“Total Annual Fund” 
       [0134]    This Query will give you the sum, number of gifts and largest gift amounts for all annual fund gifts per individual  
         [0135]    Repeat the instructions from Query #1 AND  
         [0136]    Pull down the “Campaign” field onto the Query Grid Type “Annual Fund” in the criteria row  
         [0137]    Run Query  
         [0138]    *Note the same fluctuation by client will occur in this query as well. There may be a series of Annual Fund categories that must be added to the criteria for this query. These categories may be sorted in the Fund or Appeal field.  
       Query # 4—“Total Capital or Other Gifts” 
       [0139]    This query will give you the sum, number of gifts and largest gift amounts for all capital and other gifts not given to the annual fund or for a special event for each individual in the database.  
         [0140]    Repeat the instructions from Query #1 AND  
         [0141]    Pull down the “Campaign” field onto the Query Grid Type “Capital” in the criteria row  
         [0142]    Run Query  
         [0143]    *Note the same fluctuation by client will occur in this query as well. There will be a series of Capital gift categories and categories not falling under annual fund or special event giving that must be added to the criteria for this query. These categories may be sorted in the Fund or Appeal field.  
       Query # 5—“Events” 
       [0144]    This Query will give you the sum of gifts over the last three years as well as the total for these three years specifically for “Events”per individual.  
         [0145]    Repeat the instructions from query #1 AND  
         [0146]    Add “Date” to the Query  
         [0147]    In the criteria row for “Date”, type: &gt;=97. This will only run gifts only from 1997 and forward.  
         [0148]    Add the Campaign Field to the Query Grid  
         [0149]    In the Criteria Row for the Campaign Field, type “Events” 
         [0150]    Run Query  
         [0151]    *Note that again the criteria may be different for each client. The criteria for this query, however, must be identical to the criteria in the “Total Events” query.  
       Query #6—“Annual Fund” 
       [0152]    This Query will give you the sum of gifts over the last three years as well as the total for these three years specifically for Annual Fund per individual.  
         [0153]    Repeat the instructions from Query # 5  
         [0154]    Except, In the Criteria Row for the Campaign Field, type “Annual Fund” 
         [0155]    Run Query  
         [0156]    *Note that again the criteria may be different for each client. The criteria for this query, however, must be identical to the criteria in the “Total Annual Fund” query.  
       Query # 7—“Capital and Other Gifts” 
       [0157]    This Query will give you the sum of gifts over the last three years as well as the total for these three years for all capital and other gifts not given to the annual fund or for a special event for each individual in the database.  
         [0158]    Repeat the instructions for Query # 5, But  
         [0159]    In the Criteria Row for the Campaign Field, type “Capital” 
         [0160]    Run Query  
         [0161]    *Note that again the criteria may be different for each client. The criteria for this query, however, must be identical to the criteria in the “Total Capital and Other Gifts” query.  
       Query #8—“Crosstab Total Events” 
       [0162]    This query will place all gifts in the “Total Event” query in one row per individual and separate each gift by Campaign.  
         [0163]    select the data from the “Total Events” query.  
         [0164]    NEXT  
         [0165]    Select the field values you want for row headings:  
         [0166]    ConsID  
         [0167]    NEXT  
         [0168]    Select the field values you want as column headings  
         [0169]    Campaign  
         [0170]    Select the number you want calculated for each column and row intersection  
         [0171]    Field: Sum of Gift Amount Function: Sum  
         [0172]    FINISH  
       Query # 9—“Crosstab Total Annual Fund” 
       [0173]    This query will place all gifts in the “Total Annual Fund” query in one row per individual and separate each gift by Campaign.  
         [0174]    Select the data from the “Total Annual Fund” query.  
         [0175]    NEXT  
         [0176]    Select the field values you want for row headings:  
         [0177]    ConsID  
         [0178]    NEXT  
         [0179]    Select the field values you want as column headings  
         [0180]    Campaign  
         [0181]    Select the number you want calculated for each column and row intersection  
         [0182]    Field: Sum of Gift Amount Function: Sum  
         [0183]    FINISH  
       Query # 10—“Crosstab Total Capital and Other” 
       [0184]    This query will place all gifts in the “Total Capital and Other” query in one row per individual and separate each gift by Campaign.  
         [0185]    Select the data from the “Total Capital and Other” query.  
         [0186]    NEXT  
         [0187]    Select the field values you want for row headings:  
         [0188]    ConsID  
         [0189]    NEXT  
         [0190]    Select the field values you want as column headings  
         [0191]    Campaign  
         [0192]    Select the number you want calculated for each column and row intersection  
         [0193]    Field: Sum of Gift Amount Function: Sum  
         [0194]    FINISH  
       Query #11—“Crosstab Events” 
       [0195]    This query will place all gifts in the “Events” query in one row per individual and separate each gift by year.  
         [0196]    Select the data from the “Events” query.  
         [0197]    NEXT  
         [0198]    Select the field values you want for row headings:  
         [0199]    ConsID  
         [0200]    NEXT  
         [0201]    Select the field values you want as column headings  
         [0202]    Date  
         [0203]    Select the number you want calculated for each column and row intersection  
         [0204]    Field: Sum of Gift Amount Function: Sum  
         [0205]    FINISH  
       Query #12—“Crosstab Annual Fund” 
       [0206]    This query will place all gifts from the “Annual Fund” query in one row per individual and separate each gift by year.  
         [0207]    Select the data from the “Annual Fund” query.  
         [0208]    NEXT  
         [0209]    Select the field values you want for row headings:  
         [0210]    ConsID  
         [0211]    NEXT  
         [0212]    Select the field values you want as column headings  
         [0213]    Date  
         [0214]    Select the number you want calculated for each column and row intersection  
         [0215]    Field: Sum of Gift Amount Function: Sum  
         [0216]    FINISH  
       Query # 13 “Crosstab—Capital and Other Gifts” 
       [0217]    This query will place all gifts in the “Capital and Other” query in one row per individual and separate each gift by year.  
         [0218]    Select the data from the “Capital and Other” query.  
         [0219]    NEXT  
         [0220]    Select the field values you want for row headings:  
         [0221]    ConsID  
         [0222]    NEXT  
         [0223]    Select the field values you want as column headings  
         [0224]    Date  
         [0225]    Select the number you want calculated for each column and row intersection  
         [0226]    Field: Sum of Gift Amount Function: Sum  
         [0227]    FINISH  
       Query #14 “Total Gifts Make-Table Query” 
       [0228]    This query will use the Total Gift Query to make a table just for total gifts.  
         [0229]    Copy “Total Gifts” Query  
         [0230]    Rename new query (i.e., “Total Gifts to Table”) and run the Make-Table Query  
         [0231]    Name new table “Total Gifts Table” 
         [0232]    Run Query  
         [0233]    Once the Total Table is created, rename the following fields:  
         [0234]    Change field “Count of Gift Amount” to “Total Count” 
         [0235]    Change field “Max of Gift Amount” to “Largest” 
         [0236]    Change field “SumofGift Amount” to “Total” 
       Query # 15 “Total Events Make-Table” 
       [0237]    This query will use the Total Events Cross tab Query to make a table just for total events gifts.  
         [0238]    Make a copy of the Total Events Cross tab query  
         [0239]    Rename new query (i.e., “Total Events to Table”)  
         [0240]    In design view, click on the Query Type icon and select “Make-Table Query” 
         [0241]    Or on the toolbar select “Query” and select “Make-Table Query” 
         [0242]    Make a new table. Table Name: “Total Events Table” 
         [0243]    Run Query  
         [0244]    The new table will appear.  
         [0245]    Once the Total Event Table is created, rename the following fields:  
         [0246]    Change field “Countof Gift Amount” to “Total Event Count” 
         [0247]    Change field “Maxof Gift Amount” to “Largest Event” 
         [0248]    Change field “SumofGift Amount” to “Total Event” 
       Query # 16 “Total Annual Fund” Make Table Query  
       [0249]    This query will use the Total Annual Fund Cross tab Query to make a table just for Capital and other gifts.  
         [0250]    Repeat the Instructions for Query #15  
         [0251]    Except, Make a copy of the “Total Annual Fund Query” and  
         [0252]    Rename new query and run the Make-Table Query  
         [0253]    Make Table “Total Annual Fund” and  
         [0254]    Once the Total Annual Fund Table is created, rename the following fields:  
         [0255]    Change field “Countof Gift Amount” to “Total Annual Fund Count” 
         [0256]    Change field “Maxof Gift Amount” to “Largest Annual Fund” 
         [0257]    Change field “SumofGift Amount” to “Total Annual Fund” 
       Query # 17 “Total Capital and Other” Make Table Query  
       [0258]    This query will use the Total Capital and Other Gift Cross tab Query to make a table just for Capital and other gifts.  
         [0259]    Repeat the Instructions for Query #15  
         [0260]    Except, Make a copy of the “Total Capital and Other Query” and  
         [0261]    Rename new query and run the Make-Table Query  
         [0262]    Make Table “Total Capital and Other” and  
         [0263]    Once the Total Capital and Other Table is created, rename the following fields:  
         [0264]    Change field “Countof Gift Amount” to “Total Annual Fund Count” 
         [0265]    Change field “Maxof Gift Amount” to “Largest Annual Fund” 
         [0266]    Change field “SumofGift Amount” to “Total Annual Fund” 
       Query #18 “Events Make-Table” 
       [0267]    This query will use the Events Cross tab Query to make a table just for events gifts.  
         [0268]    Make a copy of the Events Cross tab query  
         [0269]    Rename new query (i.e., “Events to Table”)  
         [0270]    Make a new table. Table Name: “Events Table” 
         [0271]    Run Query  
         [0272]    The new table will appear.  
         [0273]    Once the Events Table is created, rename the following fields:  
         [0274]    Change field “97” to “Event 97” 
         [0275]    Change field “98” to “Event 98” 
         [0276]    Change field “99” to “Event 99” 
         [0277]    Change field “Total of SumofGift Amount” to “Total Event 97-99” 
       Query #19 “Annual Fund” Make Table Query  
       [0278]    This query will use the Annual Fund Cross tab Query to make a table just for Capital and other gifts.  
         [0279]    Repeat the instructions from Query #18  
         [0280]    Except Make a copy of the “Annual Fund” Query and  
         [0281]    Rename new query and run the Make-Table Query  
         [0282]    Make Table “Annual Fund Table” 
         [0283]    Once the Annual Fund Table is created, rename the following fields:  
         [0284]    Change field “97” to “Annual Fund 97” 
         [0285]    Change field “98” to “Annual Fund 98” 
         [0286]    Change field “99” to “Annual Fund 99” 
         [0287]    Change field “Total of SumofGift Amount” to “Total Annual Fund 97-99” 
       Query #20 “Capital and Other Gifts Make-Table Query” 
       [0288]    This query will use the Capital and Other Gift Cross tab Query to make a table just for Capital and other gifts.  
         [0289]    Repeat the steps for Query #18 BUT  
         [0290]    Make a copy of the “Capital and Other Gift Cross tab” Query  
         [0291]    Rename new query and run the Make-Table Query  
         [0292]    Name new table “Capital and Other Gift Table” 
         [0293]    Once the Capital and Other Gift Table is created, rename the following fields:  
         [0294]    Change field “97” to “Capital and Other 97” 
         [0295]    Change field “98” to “Capital and Other 98” 
         [0296]    Change field “99” to “Capital and Other 99” 
         [0297]    Change field “Total of SumofGift Amount” to “Total Capital and Other 97-99” 
       Import Instructions for Data Overlays  
     High Net Worth &amp; Geodemographic Overlay  
       [0298]    Unzip High Net Worth and Geodemographic disks returned  
         [0299]    Open ACCESS  
         [0300]    Open the database just created for the RE import  
         [0301]    Click File, “Get External Data”, Import  
         [0302]    Choose Text Files (.csv) as File Type  
         [0303]    Select High Net Worth file saved in comma separated value (.csv) format  
         [0304]    Click “IMPORT” 
         [0305]    Access will convert file using the following prompts:  
         [0306]    Choose file type that best describes your data  
         [0307]    Select Delimited  
         [0308]    NEXT  
         [0309]    Select Delimiters and Text Qualifiers  
         [0310]    NEXT  
         [0311]    Store Data in “New Table” 
         [0312]    Field Options  
         [0313]    NEXT  
         [0314]    Select No Primary Field  
         [0315]    Select Table Name  
         [0316]    FINISH  
         [0317]    Repeat for Geodemographic file saved in comma separated value format (.csv)  
         [0318]    Once the High Net Worth and Geodemographic files are in ACCESS, rename the fields you will need for the PID:  
       High Net Worth  
       [0319]    These codes are usually found in fields 12-21 and alternate between Match Category and Match Type. Rename the High Net Worth code fields as follows:  
                                                   Field 12: MC1           Field 13: MT1           Field 14: MC2           Field 15: MT2           Field 16: MC3           Field 17: MT3           Field 18: MC4           Field 19: MT4           Field 20: MC5           Field 21: MT5                      
 
         [0320]    *Locate the field that contains the Constituent ID Number and rename that field “ConsID” This is usually Field 1 or Field 2. Also, make sure the data type for the ConsID field is “text”, which must be the same in all tables. This is the Field through which the data will be linked.  
       Geodemographic  
       [0321]    The Geodemographic Codes used in the PID are: ConsID, Median Household Income, Estimated Household Income, Wealth Rating and Date of Birth. The current location of these fields in the Geodemographic file are:  
         [0322]    Field 21: ConsID  
         [0323]    Field 26: Date of Birth (DOB)  
         [0324]    Field 32: Estimated Household Income (EHHI)  
         [0325]    Field 56: Median Household Income (MHHI)  
         [0326]    Field 58: Wealth Rating (WR)  
       Linking Tables in Database  
       [0327]    Before beginning this process, make sure each of the tables in the ACCESS database has a field for Constituent ID. (It is this field that will link all of the tables AND ensure that the data is returned to the proper record #) Also, make sure Constituent ID has the same Data Type in each of the tables.  
         [0328]    1. Combine all RE tables (if more than one)  
         [0329]    A. Create a relationship between the RE tables Join Properties  
         [0330]    Select “includes all rows from Biographical and only those records from Events Table where joined fields are equal” (this is because the Biographical table contains every record in the database and Events Table contains only the records that have captured Event gifts)  
         [0331]    Repeat process for the Other Gift and Total Tables  
         [0332]    B. Create a query that selects the fields from each RE table you need for analysis. Select all fields from the Biographical table (including the ConsID field) and select the specified gift information from each of the tables.  
         [0333]    From the Total Table, select: Largest and Total  
         [0334]    From the Total Events Table, select: Total Event  
         [0335]    From the Total Annual Fund Table, select: Total Annual Fund  
         [0336]    From the Total Capital and Other Table, select: Total Capital and Other  
         [0337]    From the Events Table, select: Event 97, Event 98, Event 99 and Total Event 97-99  
         [0338]    From the Annual Fund Table, select: Annual Fund 97, Annual Fund 98, Annual Fund 99 and Total Annual Fund 97-99  
         [0339]    From the Capital and Other Gift Table, select: Capital and Other 97, Capital and Other 98, Capital and Other 99 and Total Capital and Other 97-99  
         [0340]    (Select the ConsID field from the Biographical table only and add only the specified gift information fields from the other tables. It is not necessary to add the ConsID field for each of the tables because the tables have been linked).  
         [0341]    Run Query  
         [0342]    C. Create a table from the query that includes all RE information  
         [0343]    1. Once RE tables are combined, add the following new fields to the RE table in ACCESS  
       TWG Fields  
       [0344]    AFST—Annual Fund Short Term  
         [0345]    AFLT—Annual Fund Long Term  
         [0346]    MG—Major Gift  
         [0347]    PG—Planned Gift  
         [0348]    These fields will contain TWG&#39;s target codes.  
         [0349]    2. Create relationships between the new combined RE table and the High Net Worth and Geodemographic tables, where the join type is “includes all rows from Biographical and only those records from High Net Worth Table where joined fields are equal” Repeat for Geodemographic Table.  
         [0350]    3. Create a QUERY that selects the fields from each of the tables that you will need for analysis  
         [0351]    All fields from the Combined RE Table and Fields that were renamed in both the High Net Worth and Geodemographic Tables during import  
         [0352]    4. Create a table from the Query created  
         [0353]    5. New Table is now ready for analysis  
       Criteria for Analysis  
     Process and Criteria for Identifying Top Prospects  
       [0354]    The purpose is to screen the database for individuals who demonstrate the potential for making annual gifts of $1,000 or more. The top giving candidate pool is defined, in general, as the top 1,000 prospects or the top 7-10 % of a client&#39;s audience, whichever is smaller. The default queries for this process are listed below.  
         [0355]    Step 1—Create Top Pool  
         [0356]    Run a basic query using the following criteria:  
                                       MEDIAN HOUSEHOLD INCOME (MHHI)   &gt;= $75,000 OR       ESTIMATED HOUSEHOLD INCOME   &gt;= 7 AND       WEALTH RATING   &gt;= 8 AND       P$ycle Code     = 1       TOTAL GIFTS   &gt;= $2,000 OR       WealthEngine CODES   &gt;= 1A E OR 1B E OR                2A E OR 2C E OR                2D E OR 5A E OR                5B E OR 5C E                  
 
         [0357]    If total number of records in the combined search lists equals 10% of the client audience of individuals, this group should be considered as the “Top Prospect” pool  
         [0358]    Step 2—Modify the Top Pool (if necessary)  
       If Pool is Greater Than 10%  
       [0359]    If the total number of records in initial search is greater than 10%, using the above search list, run follow-up searches using the same criteria as above but raising the criteria as follows:  
                                                       MHHI   &gt;= $85,000                      
 
         [0360]    If the total number of records in the search is still greater than 10% of the client audience,  
                                                       MHHI   &gt;= $85,000 AND           Total Gifts   &gt;= $5000                      
 
         [0361]    If the total number of records in the search is still greater than 10% of the client audience, make  
         [0362]    EHHI=7 AND WR=9 AND P$ycle Code=1  
         [0363]    If the total number of records in the search is still greater than 10% of the client audience,  
         [0364]    Eliminate the EHHI and WR criteria AND  
         [0365]    Make MHHI &gt;=$85,000 AND P$ycle Code=1  
         [0366]    If the total number of records in the search is still greater than 10%, proceed with a top prospect pool of greater than 10% but not exceeding 12% of the database.  
       If Pool is Less Than 10%  
       [0367]    If the total number of records in the search is less than 10%, using the above search list, run follow-up searches using the same criteria above, but lowering the criteria as follows:  
                                                       EHHI   &gt;= 6 AND           WR   &gt;= 7 AND           P$ycle Code     = 1                      
 
         [0368]    If the total number of records in the search is still less than 10% of the client audience,  
         [0369]    MHHI &gt;=$50,000 AND  
         [0370]    P$ycle Codes =4 or 5 or 6 or 11  
         [0371]    If the total number of records is still less than 10%, proceed with a top prospect pool of less than 10%, but not below 8% of the database.  
         [0372]    Optionally, to easily distinguish the top prospect pool from the rest of the database, create a new field in the table called “TOP” and globally update these records by entering “TOP” in this new field to distinguish them from the rest of the database.  
       Preliminary Target Code Assignment  
     Top Prospect Pool  
       [0373]    Run the following queries against the top prospect pool and assign a Short Term Target Code (STTC) according to the following criteria:  
                                                                                                                                                                                       Query   STTC = Ask Amount $15,000            1)   Total Gift   &gt;= $100,000 OR           Total Gift   &gt;= $25,000 AND           Largest Annual Fund   &gt;= $15,000 in last three years OR           Gift           Total Capital/Other   &gt;= $25,000 AND           Gifts           Largest Capital/Other   &gt;= $25,000           Gift                Globally assign a STTC of “SH” to this group       Query   STTC = Ask Amount of $10,000            2)   Total Gift   &gt;= $10,000 AND           Largest Annual Fund   &gt;= $7,500 in last three years OR           Gift           Two Annual Gifts of   &gt;= $5,000 in last three years OR           Total Capital/Other   &gt;= $10,000 in the last three years           Gifts                Globally assign a STTC of “90” to this group       Query   STTC = Ask Amount of $5,000            3)   Total Gift   &gt;= $10,000 AND           Largest Annual Fund   &gt;= $3,000 in last three years OR           Gift           Total Gift   &gt;= $10,000 AND           Two Annual Gifts of   &gt;= $2,500 in last three years OR           Total Capital/Other   &gt;= $7,500 in the last three years OR           Gifts           Total Gift   &lt;= $100,000 AND           Largest Annual Fund   &gt;= $10,000 prior to the last three years           Gift                Globally assign a STTC of “80” to this group       Query   STTC = Ask Amount of $2,500            4)   Total Gifts   &gt;= $5,000 AND           Largest Annual Fund   &gt;= $1,500 in last three years OR           Gift           Total Capital/Other   &gt;= $4,000 in the last three years           Gifts                Globally assign a STTC of “70” to this group       Query   STTC = Ask Amount of $1,500            5)   Total Gifts   &gt;= $2,500 AND           Largest Annual Fund   &gt;= $1,000 in last three years OR           Gift           Total Capital/Other   &gt;= $2,500 in the last three years           Gifts                Globally assign a STTC of “60” to this group       Query   STTC = Ask Amount of $1,000            6)   Total Gifts   &gt;= $2,000 AND           Largest Annual Fund   &gt;= $500 in last three years OR           Gift           Two Annual Gifts of   &gt;= $500 in last three years OR           Total Capital/Other   &gt;= $2,000 OR           Gifts           Total Special Event   &gt;= $1,000 in the last three years OR           Gifts           Total Gift   &lt;= $100,000 AND           Largest Annual Fund   &gt;= $1,000 prior to the last three years           Gift                Globally assign a STTC of “50” to this group       Query   Remaining Top Prospect records should be individuals who do       7)   not have substantial gift histories but who should be considered           as POTENTIAL $1,000 gift prospects due to geodemographic           and WealthEngine data.           Globally assign a STTC of “54” to this group.                  
 
       Process and Criteria for Electronic Taret Coding not included in the Top Prospect Pool  
       [0374]    Run the following series of queries and assign a Short Term Target Code (STTC) of the rest of the file according to the following criteria, making sure that individuals assigned a STTC are drawn from the top prospect pool only.  
                                                                                                               Query 1)   STTC = Ask Amount of $500                Total Gift   &gt;= $1,500 OR           Total Gift   &gt;= $500 AND           Largest Gift   &gt;= $200 in the last three years OR           MHHI   &gt;= $70,000                Globally update STTC of this group to “40”       Query 2)   STTC = Ask Amount of $250                Total Gift   &gt;= $1,000 OR           Total Gift   &gt;= $250 AND           Largest Gift   &gt;= $100 in the last three years OR           MHHI   &gt;= $60,000                Globally update STTC of this group to “30”       Query 3)   STTC = Ask Amount of $100                Total Gift   &gt;= $200 OR           Largest Gift   &gt;= $50 in the last three years OR           MHHI   &gt;= $50,000                Globally update STTC of this group to “20”       Query 4)   Globally update the remaining individuals in this database to           “10”                  
 
       Short Term Target Code Goals  
       [0375]    “54”−“SH”=10% of fund raising database  
         [0376]    “20”−“40”=45% of fund raising database  
         [0377]    “10”=45% of fund raising database  
       Process and Criteria for Electronic Target Coding of Long Term Potential  
       [0378]    This step should be implemented only after all Short Term Target Code assignments have been completed and reviewed by the Project Manager.  
       Criteria for Assigning Long Term Target Codes  
       [0379]    The long term target code is considered an assessment of an individual&#39;s giving level in 5 years. Since the assessment of an individual&#39;s giving status over the long term is an educated guess, TWG&#39;s analysis uses an individual&#39;s Short Term Target Code as a base for analyzing long term potential. Long Term Target Codes (LTTC) are assigned according to two basic criteria: 1.) individuals who have made gifts, and; 2.) individuals with no gift history.  
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Top Prospects                    Query 1)   LTTC = Ask Amount $15,000           STTC = SH           Make LTTC = STTC (“SH”)       Query 2)   LTTC = Ask Amount $10,000           STTC = 90           Make LTTC = STTC (“90”)       Query 3)   LTTC = Ask Amount $10,000                STTC     = 80 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 1 level to “90” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“80”)       Query 4)   LTTC = Ask Amount $10,000                STTC     = 70 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 2 levels to “90” OR           LTTC = Ask Amount $5,000                STTC     = 70 AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $74,999                Make LTTC = STTC plus 1 level to “80” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“70”)       Query 5)   LTTC = Ask Amount $5,000                STTC     = 60 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 2 levels to “80” OR           LTTC = Ask Amount $2,500                STTC     = 60 AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $74,999                Make LTTC = STTC plus 1 level to “70” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“60”)       Query 6)   LTTC = Ask Amount $2,500                STTC     = 50 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 2 levels to “70” OR           LTTC = Ask Amount $1,500                STTC     = 50 AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $74,999                Make LTTC = STTC plus 1 level to “60” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“50”)       Query 7)   LTTC = Ask Amount $1,500                STTC     = 54 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 2 levels to “60”       Query 8)   Remaining individuals that do not match the above criteria           Make LTTC = STTC plus 1 level to “50”                    Lower 90%                    Query 1)   LTTC = Ask Amount $1,500                STTC     = 40 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 2 levels to “60”           LTTC = Ask Amount $1,500                STTC     = 40 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $50,000 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “60”           LTTC = Ask Amount $1,500                STTC     = 40 AND           Total Gift   &gt;= 1 AND           EHHI     = 7 AND           WR     = 9 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “60” OR           LTTC = Ask Amount $1,000                STTC     = 40 AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $74,999                Make LTTC = STTC plus 1 level to “50” OR           LTTC = Ask Amount $1,000                STTC     = 40 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 1 level to “50” OR           LTTC = Ask Amount $1,000                STTC     = 40 AND           Total Gift   &gt;= $1,000 AND           MHHI   Is Null                Make LTTC = STTC plus 1 level to “50” OR           LTTC = Ask Amount $1,000                STTC     = 40 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $50,000           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “50” OR           LTTC = Ask Amount $1,000                STTC     = 40 AND           Total Gift     = 0 or is null AND           EHHI     = 7 AND           WR     = 9 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “50” OR           LTTC = Ask Amount $1,000                STTC     = 40 AND           Total Gift   &gt;= 1 AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “50” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“40”)       Query 2)   LTTC = Ask Amount $1,000                STTC     = 30 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 2 levels to “50” OR           LTTC = Ask Amount $1,000                STTC     = 30 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $40,000 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “50” OR           LTTC = Ask Amount $1,000                STTC     = 30 AND           Total Gift   &gt;= 1 AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “50” OR           LTTC = Ask Amount $500                STTC     = 30 AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $74,999                Make LTTC = STTC plus 1 level to “40” OR           LTTC = Ask Amount $500                STTC     = 30 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $75,000                Make LTTC = STTC plus 1 level to “40” OR           LTTC = Ask Amount $500                STTC     = 30 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $40,000           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “40” OR           LTTC = Ask Amount $500                STTC     = 30 AND           Total Gift     = 0 or is null AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “40” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“30”)       Query 3)   LTTC = Ask Amount $500                STTC     = 20 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $50,000                Make LTTC = STTC plus 2 levels to “40” OR           LTTC = Ask Amount $500                STTC     = 20 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $40,000 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “40” OR           LTTC = Ask Amount $500                STTC     = 20 AND           Total Gift   &gt;= 1 AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “40” OR           LTTC = Ask Amount $250                STTC     = 20  AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $49,999                Make LTTC = STTC plus 1 level to “30” OR           LTTC = Ask Amount $250                STTC     = 20 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $50,000                Make LTTC = STTC plus 1 level to “30” OR           LTTC = Ask Amount $250                STTC     = 20 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $40,000           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “30” OR           LTTC = Ask Amount $250                STTC     = 20 AND           Total Gift     = 0 or is null AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “30” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“20”)       Query 4)   LTTC = Ask Amount $250                STTC     = 10 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $50,000                Make LTTC = STTC plus 2 levels to “30” OR           LTTC = Ask Amount $250                STTC     = 10 AND           Total Gift   &gt;= 1 AND           MHHI   &gt;= $40,000 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “30” OR           LTTC = Ask Amount $250                STTC     = 10 AND           Total Gift   &gt;= 1 AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 2 levels to “30” OR           LTTC = Ask Amount $100                STTC     = 10 AND           Total Gift   &gt;= 1 AND           MHHI   &lt;= $49,999                Make LTTC = STTC plus 1 level to “20” OR           LTTC = Ask Amount $100                STTC     = 10 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $50,000                Make LTTC = STTC plus 1 level to “20” OR           LTTC = Ask Amount $100                STTC     = 10 AND           Total Gift     = 0 or is null AND           MHHI   &gt;= $40,000           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “20” OR           LTTC = Ask Amount $100                STTC     = 10 AND           Total Gift     = 0 or is null AND           EHHI   &gt;= 6 AND           WR   &gt;= 8 AND           P$ycle Codes     = 4 or 5 or 6 or 11                Make LTTC = STTC plus 1 level to “20” OR           Remaining individuals that do not match above criteria           Make LTTC = STTC (“10”)                  
 
         [0380]    [0380]                                         Long Term Target Code Goals                                “50”-“SH” =   13% of the fund raising database       “20”-“30” =   49% of the fund raising database       “10” =   38% of the fund raising database                    
       Process and Criteria for Identifying Major Gift Prospects  
       [0381]    PURPOSE: To screen the database for individuals who demonstrate the potential for making a one time gift of $50,000 or more.  
       Major Gift Code Assignment  
       [0382]    Run the following queries and assign a Major Gift Code (MGC) according to the following criteria:  
                                                                                                               Query 1)   MGC = High Affluence and High Affinity                Total Gift   &gt;= $20,000 AND           Largest Gift   &gt;= $5,000 AND           AFST   &gt;= 50 OR           Largest Gift   &gt;= $10,000 AND           AFST   &gt;= 50                Globally assign a MGC of “A” to this group       Query 2)   MGC = High Affluence and Moderate Affinity                Total Gift   &gt;= $10,000 AND           Largest Gift   &gt;= $2,500 AND           AFST   &gt;= 50 OR           MHHI   &gt;= $125,000 AND           Total Gift   &gt;= $1000 AND           AFST   &gt;= 50                Globally assign a MGC of “B” to this group       Query 3)   MGC = High Affluence and Low Affinity                MHHI   &gt;= $125,000 AND           AFST   &gt;= 50 OR           POW&amp;R     = 1AE OR 1BE OR 2AE OR           MHHI   &gt;= $100,000 AND           Total Gifts   &gt;= $1,000 AND           P$ycle Codes     = 4 or 5 or 6 or 11 AND           AFST   &gt;= 50 OR           P$ycle Code     = 1 AND           AFST   &gt;= 50                Globally assign a MGC of “C” to this group       Query 4)   MGC = High Affluence and Research Affinity           WealthEngine Matches in top categories without a major gift           code [any Match type]           (1A, 1B, 2A, 2C, 2D, 5A, 5B, OR 5C)           Globally assign a STTC of “R” to this group OR           P$ycle Codes 4 or 5 or 6 or 11 AND           In the top prospect pool OR           P$ycle Code 1                  
 
       Major Gift Target Code Goals  
       [0383]    “A”=b  1 % of the fund raising database  
         [0384]    “B”=1% of the fund raising database  
         [0385]    “C”=2% of the fund raising database  
         [0386]    “R”=3% of the fund raising database  
       Process and Criteria for Identifying Planned Gift Prospects  
       [0387]    PURPOSE: To screen the database for individuals who demonstrate the potential and are age appropriate for making a planned gift of $50,000 or more.  
       Planned Gift Code Assignment  
       [0388]    Run the following queries and assign a Planned Gift Code (PGC) according to the following criteria:  
                                                                                                                                                     Query 1) PGC High Affluence and High Affinty                Total Gift   &gt;= $15,000   AND           Age   &gt;= 55   AND           Age   = not “U”   OR           Largest Gift   &gt;= $10,000   AND           Age   &gt;= 55   AND           Age   = not “U”   OR           Total Gift   &gt;= $15,000   AND           P$ycle Codes   = 2 OR 3   AND           DOB   = U or is null   OR           Largest Gift   &gt;= $10,000   AND           P$ycle Codes   &gt;= 2 OR 3   AND           DOB   = U or is null                Globally assign a PGC of “A” to this group            Query 2) PGC = High Affluence and Moderate Affinity            Total Gift   &gt;= $10,000   AND   Age 55+ and not “U” OR       MHHI   &gt;= $100,000   AND   Age 55+ and not “U” AND       Total Gift   &gt;= $1,000   OR       Total Gift   &gt;= $10,000   AND   DOB is null or “U” AND       P$ycle Codes   = 2 or 3       OR       MHHI   &gt;= $100,000   AND       Total Gift   &gt;= $1,000   AND       P$ycle Codes   = 2 or 3            Globally assign a PGC of “B”to this group            Query 3) PGC = High Affluence and Low Affinity                Age 55+ and not “U”   AND   Top Prospect Pool OR           P$ycle Codes   = 2 or 3   AND           Total Gift   &gt;= 1   AND           MHHI   &gt;= $75,000   OR           P$ycle Code   = 1   AND           Age 55+ and not “U”   AND           Total Gift   &gt;= 1   AND           MHHI   &gt;= $75,000                Globally assign a PGC of “C” to this group            Query 4) PGC = High Affluence and Research Affinity            MGC “R” where   Age 55+ and not “U” OR       P$ycle Code = 1   AND Age &gt;= 55 and not “U” OR       P$ycle Code = 2 or 3            Globally assign a PGC of “R” to this group                  
 
       Planned Gift Target Code Goals  
       [0389]    “A”=&lt;1 % of the fund raising database  
         [0390]    “B”=1 % of the fund raising database  
         [0391]    “C”=4 % of the fund raising database  
         [0392]    “R”=4 % of the fund raising database  
       Import Analysis Codes for Constituent Attribute Tab  
       [0393]    Once the PID analysis has been completed in Access, the new/updated data is installed on the original client-donee database.  
       Data Preparation  
       [0394]    To install the data, 4 steps must be taken to prepare it:  
         [0395]    1. In the Access database created for the PID analysis, a new table called “Lookup Table” is created. This table will add information that will define and describe the target codes that have been assigned to each record during the PID analysis. This table will include the following three fields:  
                                       CATCat:   name of target code (e.g.: “Major Gift Code”)       CATDesc:   TWG&#39;s assigned target code       CATComment:   definition of target code (e.g.: “high affluence           and moderate affinity” or “$100 to 249”)                  
 
         [0396]    In the CATDesc field, every possible target code (e.g.: 10, 20, 30, A, B, C, etc.) is entered, for each field planned to be imported. For example, “10” must be added twice, once for Annual Fund Short Term and once for Annual Fund Long Term, and “A” must be entered twice, once for Major Gift Code and once for Planned Gift Code, etc.) There should be 30 records total in this table for these four target codes, one record for each description. (including 2 records for Special Handling Codes)  
         [0397]    In the CATCat and CATComment Fields, the information entered must correspond with the information in the CATDesc field. For example,  
                                       CATCat   CATDesc   CATComment                   Major Gift Code   A   high affluence and high affinity       Annual Fund Short Term   80   $5,000 to $9,999       Annual Fund Long Term   90   $10,000 or more       Planned Gift Code   A   high affluence and high affinity                  
 
         [0398]    2. A query that joins the “Main Table” [the table that contains the entire PID analysis] to the “Lookup Table” is created. This join is made between the field that information is to be added to and the information being added.  
         [0399]    Select all of the fields in the “Lookup Table” and from the “Main Table”, select the Constituent ID field  
         [0400]    In the criteria row for the CATCatfield, type: Like “Major Gift Code” 
         [0401]    Run Query  
         [0402]    The result is a list of every record in the database that contains information specified in the Query (For Example, in the Major Gift Code Query, the number of records must equal the number of major gift codes assigned during analysis.)  
         [0403]    This same Query is created for each of the fields that are to be imported onto the original database. [e.g. Major Gift Code, Planned Gift Code, Annual Fund Short Term, Annual Fund Long Term, Membership Short Term, Membership Long Term]  
         [0404]    3. Create a UNION query that combines each of these new queries.  
         [0405]    For example, in the SQL view in the query tab, the following may be typed:  
         [0406]    SELECT * FROM [name of query #1] 
         [0407]    UNION  
         [0408]    SELECT * FROM [query #2] 
         [0409]    UNION  
         [0410]    SELECT * FROM [query #3] 
         [0411]    UNION  
         [0412]    SELECT * FROM [query #4];  
         [0413]    The result should be a query that has the information from all of the fields that will be imported onto the original RE database. It should be noted that there will be more than one record for individual records that have been given more than one target code. For example,  
                                           ConsID   CATCat   CATDesc   CATComment                   101   Major Gift Code   A   high affluence and                   high affinity       101   Annual Fund Short Term   80   $5,000 to $9,999       101   Annual Fund Long Term   90   $10,000 or more       101   Planned Gift Code   A   high affluence and high                   affinity       102   Annual Fund Short Term   10   $1 to 99       102   Annual Fund Long Term   30   $250 to 499       103   Annual Fund Short Term   30   $250 to 499       103   Annual Fund Long Term   50   $1,000 to 2,499                  
 
         [0414]    4. Export the Union query from Access to a text file.  
         [0415]    Import this data to the database of the program.  
         [0416]    After your RE database has been backed-up, open RE Configuration  
         [0417]    Click Attributes Tab  
         [0418]    Select Constituent  
         [0419]    In the Description Field, enter “Annual Fund Short Term” 
         [0420]    In the Data Type field, select “Table” 
         [0421]    In Table Name Field, select “add new table” and choose “Annual Fund Short Term” 
         [0422]    [Repeat this same process for the three other categories: Annual Fund Long Term, Major Gift Code, Planned Gift Code] 
       Exit Configuration  
       [0423]    Open RE Database Administration  
         [0424]    Select File  
         [0425]    Select Import  
         [0426]    File Name: click on browse on the right end of this box. Locate Drive and folder  
         [0427]    Select the name of the export file  
                                       OK           Import type:   Click on scroll arrow and select Constituent           Attribute       Operation:   Select Import       RE Field Mapping:   Select Header Record       Constituent ID/Keys:   Select Constituent ID       Exceptions:   Select Automatically create new table entries           Exception file: choose name/destination for a           file that will store           any exceptions to the import       OK                  
 
         [0428]    When process complete, all new information is now on the RE database, under the Attributes Tab, in Constituent Management.  
       Import Analysis Codes for the Prospect Research Tab  
       [0429]    Once the PID analysis has been completed in Access, the new/updated data must be installed on the original client—donee database.  
       Data Preparation  
       [0430]    To install the data, 4 steps must be taken to prepare it:  
         [0431]    1. In the Access database created for the PID analysis, a new table called “Lookup Table”is created. This table will add information that will define and describe the target codes that have been assigned to each record during the PID analysis. This table will include the following four fields:  
                                       Category:   TWG&#39;s assigned target code       Description:   name of target code (e.g.: “Major Gift Code”)       Notes:   definition of target code (e.g.: “high affluence and moderate           affinity” or “$100 to 249”)       Date:   date PID analysis completed                  
 
         [0432]    In the Category field, every possible target code (e.g.: 10, 20, 30, A, B, C, etc.) is entered for each field that is imported. There should be 30 records total in this table for these four target codes, one record for each description. (including 2 records for Special Handling Codes)  
         [0433]    In the Description and Notes Fields, the information entered must correspond with the information in the Category field. For example,  
                                                             Description   Category   Notes   Date                                Major Gift Code   A   high affluence and   12/1/99               high affinity       AF Short Term   80   $5,000 to $9,999   12/1/99       AF Long Term   90   $10,000 or more   12/1/99       Planned Gift Code   A   high affluence and   12/1/99               high affinity                  
 
         [0434]    2. A query that joins the “Main Table” [the table that contains the entire PID analysis] to the “Lookup Table” is created. This join is made between the field that information is to be added to and the information being added. For example, click on the Major Gift Code field (the field that contains A, B, C or R) in the “Main Table” and drag it to the Category field on the “Lookup Table”. A line between these two fields should now appear, indicating that the join has been made.  
         [0435]    Select all of the fields in the “Lookup Table” and from the “Main Table”, select the Constituent ID field.  
         [0436]    In the criteria row for the Description field, type: Like “Major Gift Code” 
         [0437]    Run Query  
         [0438]    The result is a list of every record in the database that contains information specified in the Query.  
         [0439]    Create this same Query for each of the fields that is imported onto the original database. [e.g. Major Gift Code, Planned Gift Code, Annual Fund Short Term, Annual Fund Long Term, Membership Short Term, Membership Long Term] 
         [0440]    3. A UNION query that combines each of these new queries is created.  
         [0441]    This can be done by:  
         [0442]    In the SQL view, type the following exactly as follows:  
         [0443]    SELECT * FROM [name of query #1] 
         [0444]    UNION  
         [0445]    SELECT * FROM [query #2] 
         [0446]    UNION  
         [0447]    SELECT * FROM [query #3] 
         [0448]    UNION  
         [0449]    SELECT * FROM [query #4];  
         [0450]    The result should be a query that has the information from all of the fields that will be imported onto the original RE database. For example,  
                                               PRDesc               ConsID   PRDt   PRValue   PRNotes                   101   Major Gift Code   A   high affluence and high           12/1/99       affinity       101   AFShortTerm   80   $5,000 to $9,999           12/1/99       101   AF Long Term   90   $10,000 or more           12/1/99       101   PG Code   A   high affluence and high           12/1/99       affinity       102   AF ShortTerm   10   $1 to 99           12/1/99       102   AF Long Term   30   $250 to 499           12/1/99       103   AF Short Term   30   $250 to 499           12/1/99       103   AF Long Term   50   $1,000 to 2,499           12/1/99                  
 
         [0451]    4. Export the Union query from Access to a text file. (Access files cannot be imported directly onto the program, but must be first saved as a text file).  
       Access Export  
       [0452]    Right Click on the Union query  
         [0453]    Select Save As/Export  
         [0454]    Select To an External File or Database OK  
         [0455]    Select a destination for this export. Change file type from Microsoft Access (.mdb) to a Text file (.txt)  
         [0456]    Choose the current folder and rename the file. The file name should have no spaces and be no longer than 8 characters and should have the file extension .txt (e.g.: exportl.txt)  
         [0457]    Click Export  
         [0458]    The Export Text Wizard will appear:  
         [0459]    Select Delimited, click Next  
         [0460]    Select INCLUDE FIELD NAMES ON FIRST ROW  
         [0461]    Select [“] as the text qualifier NEXT  
         [0462]    Export to file: file location and name, FINISH  
         [0463]    When export is finished, click OK  
         [0464]    The next file will be saved in its new destination  
         [0465]    Now this is imported onto the database of the program.  
         [0466]    In RE, open RE Database Administration  
         [0467]    Select File  
         [0468]    Select Import  
         [0469]    File Name: click on browse on the right end of this box. Locate the drive and folder  
         [0470]    Select the file name (export1.txt) OK  
                                       Import Type:   Click on scroll arrow and select Prospect Rating       Operation:   Select Import       RE Field Mapping:   Select Header Record       Constituent ID/Keys:   Select Constituent ID       Exceptions:   Select Automatically create new table entries                  
 
         [0471]    Exception file: choose name/destination for a file that will store any exceptions to the import  
         [0472]    OK  
         [0473]    When process complete, all new information is now on the RE database, under the “Prospect Tab: Ratings”, in Constituent Management.  
         [0474]    The following is an example of a geodemographic request for information that may be used with the present invention.  
         [0475]    Dear______,  
         [0476]    As discussed, I have attached the file we would like to have information appended to. This file contains xxxx records. Please email the appended file to me (the file must be zipped) The record layout is as follows:  
         [0477]    1. ID—20 characters  
         [0478]    2. Constituent ID—20 characters  
         [0479]    3. Last Name—50 characters  
         [0480]    4. First Name—50 characters  
         [0481]    5. Middle Name—50 characters  
         [0482]    6. Prefix 1—30 characters  
         [0483]    7. Prefix 2—20 characters  
         [0484]    8. Suffix 1—30 characters  
         [0485]    9. Suffix 2—20 characters  
         [0486]    10. Address Line 1—50 characters  
         [0487]    11. Address Line 2—50 characters  
         [0488]    12. Address Line 3—50 characters  
         [0489]    13. Address Line 4—50 characters  
         [0490]    14. Address Line 5—50 characters  
         [0491]    15. Home City—50 characters  
         [0492]    16. Home State—10 characters  
         [0493]    17. Home Zip—10 characters  
         [0494]    18. Field 18—20 characters  
         [0495]    19. Business Name—50 characters  
         [0496]    20. Business Position—50 characters  
         [0497]    21. Consitutency Code 1—50 characters  
         [0498]    22. Consituency Code 2—50 characters  
                                                                                             Vender           Data Element   Field Size   Field Type   Sample Output   Code   Note                                Exact Date of Birth   2 digits   Numeric   68   100   “68” = 1968       Wealth Rating   1 Digit   Numeric   9   302   Rating Scale 1-9       Median Household Income   5 or 6 digits   Numeric   109,000   300 stripped   2 or 3 digits; appe                           $150,000       Estimated Household Income   1 digit   Numeric   6   105   Rating Scale 1-7       P$cyle   1 or 2 digits   Numeric   11   213   Categories 1-11 o                  
 
         [0499]    The following is an example of a high net worth overlay request that may be used in the practice of the present invention  
         [0500]    Dear______,  
         [0501]    Could you please conduct the high net worth overlay for the attached file of XXXX records? I understand that the price will be $XX/match and to expect around XXX matches at a cost of $XXX.  
         [0502]    I would like the data returned to me in the file format specified below—with each match category separated into a distinct field, with the match type in the field next to it. i.e.,  
         [0503]    Field 1 ConsID  
         [0504]    Field 2 (Last Name)  
         [0505]    Field 3 (First Name)  
         [0506]    Field 4: 1A  
         [0507]    Field 5: Match 1  
         [0508]    Field 6: 1B  
         [0509]    Field 7: Match 2  
         [0510]    Field 8: 2A  
         [0511]    Field 9: Match 3  
         [0512]    Field 10: 2B  
         [0513]    Field 11: Match 4  
         [0514]    Field 12: 2C  
         [0515]    Field 13: Match 5  
         [0516]    Field 14: 2D  
         [0517]    Field 15: Match 6  
         [0518]    Field 16: 3A  
         [0519]    Field 17: Match 7  
         [0520]    Field 18: 3B  
         [0521]    Field 19: Match 8  
         [0522]    Field 20: 3C  
         [0523]    Field 21: Match 9  
         [0524]    Field 22: 3D  
         [0525]    Field 23: Match 10  
         [0526]    Field 24: 3E  
         [0527]    Field 25: Match 11  
         [0528]    Field 26: 3F  
         [0529]    Field 27: Match 12  
         [0530]    Field 28: 4A  
         [0531]    Field 29: Match 13  
         [0532]    Field 30: 4B  
         [0533]    Field 31: Match 14  
         [0534]    Field 32: 4C  
         [0535]    Field 33: Match 15  
         [0536]    Field 34: 4D  
         [0537]    Field 35: Match 16  
         [0538]    Field 36: 4E  
         [0539]    Field 37: Match 17  
         [0540]    Field 38: 4F  
         [0541]    Field 39: Match 18  
         [0542]    Field 40: 5A  
         [0543]    Field 41: Match 19  
         [0544]    Field 42: 5B  
         [0545]    Field 43: Match 20  
         [0546]    Field 44: 5C  
         [0547]    Field 45: Match 21  
         [0548]    Field 46: 5D  
         [0549]    Field 47: Match 22  
         [0550]    Field 48: 5E  
         [0551]    Field 49: Match 23  
         [0552]    Field 50: 6A  
         [0553]    Field 51: Match 24  
         [0554]    Field 52: 6B  
         [0555]    Field 53: Match 25  
         [0556]    Field 54: 6C  
         [0557]    Field 55: Match 26  
         [0558]    Field 56: 6D  
         [0559]    Field 57: Match 27  
         [0560]    The attached file is a .csv file which is zipped. Please return the appended information in the same format or in Access 97 (.mdb). The file must be zipped.  
         [0561]    The record layout is as follows:  
         [0562]    1. ID—20 characters  
         [0563]    2. Constituent ID—20 characters  
         [0564]    3. Last Name—50 characters  
         [0565]    4. First Name—50 characters  
         [0566]    5. Middle Name—50 characters  
         [0567]    6. Prefix 1—30 characters  
         [0568]    7. Prefix 2—20 characters  
         [0569]    8. Suffix 1—30 characters  
         [0570]    9. Suffix 2—20 characters  
         [0571]    10. Address Line 1—50 characters  
         [0572]    11. Address Line 2—50 characters  
         [0573]    12. Address Line 3—50 characters  
         [0574]    13. Address Line 4—50 characters  
         [0575]    14. Address Line 5—50 characters  
         [0576]    15. Home City—50 characters  
         [0577]    16. Home State- 10 characters  
         [0578]    33. Home Zip—10 characters  
         [0579]    17. Field 18—20 characters  
         [0580]    18. Business Name—50 characters  
         [0581]    19. Business Position—50 characters  
         [0582]    20. Consitutency Code 1—50 characters  
         [0583]    42. Consituency Code 2—50 characters  
       Data Import Instructions  
       [0584]    The Following Are Representative Instructions for Importing Data from the External Database or Bases  
         [0585]    When the study is complete, the data will be sent to you on a disk or via e-mail. Essentially you will be adding 4 new fields to your fund raising software. Each individual&#39;s unique identification number is used to link the new data to the existing record.  
         [0586]    1. Data Import  
         [0587]    There are two files—“dmcodes.txt” and “rawdata.txt” Both files are comma delimited text files and contain the column names in the first row. Save the text files you have just received to a location on the computer.  
         [0588]    Next, BACK UP YOUR FUND RAISING SOFTWARE SYSTEM  
         [0589]    In order to simplify the import, we have placed these codes in the following four columns:  
         [0590]    Unique ID (i.e., “20860031”—the identification number that links the information for each constituent back to the individual&#39;s record on your fund raising system. Please change the name for this column to the name that is used by your fund raising software.)  
         [0591]    Data Name—the data category (i.e., “Major Gift Code”)  
         [0592]    Data Code—assigned to each specific data element (i.e., “A”)  
         [0593]    Data Description—defines the data code (i.e., “high affluence and high affinity)  
         [0594]    Choose a location on your fund raising software system that will allow you to use the information as criteria and output for your reports and mailings and add the above four column names as new fields in your software exactly as they appear above. Import the file.  
         [0595]    * Please note that exceptions are records that have not been imported onto your database. It is not unusual to have a low number of exceptions—this usually occurs because some records might have been deleted or somehow altered. However, if several or all of the records are exceptions, the import has not been properly completed. Review the installation instructions again and make sure all steps were followed accurately.  
         [0596]    To ensure that the information has been properly imported, pull up a couple of individual records and review the information.  
         [0597]    **Please note that each individual should have at least two new codes on their record—a code for Annual Fund Short Term and Annual Fund Long Term.  
       Additional Alternative Import Instructions  
       [0598]    When the study is complete, the data will be sent to you on a disk or via e-mail. There are four Smart Codes—Major Gift, Planned Gift, Annual Fund Short Term and Annual Fund Long Term. Essentially you will be adding 4 new fields to your constituent attributes. Each individual&#39;s unique identification number is used to link the new data to the existing record.  
         [0599]    2. Raiser&#39;s Edge  
         [0600]    Save the text file containing the Smart Codes (dmcodes.txt) to a location on the computer.  
         [0601]    Next, BACK UP YOUR RAISER&#39;S EDGE SYSTEM  
         [0602]    After your RE database has been backed-up, open RE Configuration  
         [0603]    Click Attributes Tab  
         [0604]    Select Constituent  
         [0605]    In the Description Field, enter “Annual Fund Short Term” 
         [0606]    In the Data Type field, select “Table” 
         [0607]    In Table Name Field, select “add new table” and choose “Annual Fund Short Term” 
         [0608]    [Repeat this same process for the three other categories: “Annual Fund Long Term”, “Major Gift Code”, “Planned Gift Code”] 
       Exit Configuration  
       [0609]    Open RE Database Administration  
         [0610]    Select File  
         [0611]    Select Import  
         [0612]    File Name: Click on “browse” on the right end of this box. Locate Drive and folder where the text file has been saved  
         [0613]    Select the name of the import file (i.e.,: dmimport.txt)  
                                       Select “OK”           Import type:   Click on the scroll arrow and select Constituent           Attribute       Operation:   Select Import to the Raiser&#39;s Edge       RE Field Mapping:   Select Header Record       Constituent ID/Keys:   Select Constituent ID       Exceptions:   Select Automatically create new table entries           Exception file: choose name/destination for a           file that will store any exceptions to           the import       Select “OK”                  
 
         [0614]    The next prompt box will indicate the status of the import as it is importing, including the elapsed time, any exceptions*, and the percentages of files processed.  
         [0615]    * Please note that exceptions are records that have not been imported onto your database. It is not unusual to have a low number of exceptions—this usually occurs because some records might have been deleted or somehow altered. However, if several or all of the records are exceptions, the import has not been properly completed. Review the installation instructions again and make sure all steps were followed accurately.  
         [0616]    When process complete is, all new information will now be located on the RE database, under the “Attributes” Tab, in Constituent Management.  
       Instructions for Importing Raw Data onto Raiser&#39;s Edge  
       [0617]    Once the Smart Codes are installed, you can install the additional data elements located on the second file returned to you (rawdata.txt), onto your Raiser&#39;s Edge database.  
         [0618]    Open RE Configuration  
         [0619]    Click Attributes Tab  
         [0620]    Select Constituent  
         [0621]    In the Description Field, enter “Household Income” 
         [0622]    In the Data Type field, select “Table” 
         [0623]    In the Table Name Field, select “add Table Name” and choose “Household Income” 
         [0624]    Hit Enter to proceed to the next row  
         [0625]    Repeat this process for the following 4 categories:  
         [0626]    Fortune Finder  
         [0627]    Date of Birth  
         [0628]    Affluence &amp; Affinity  
         [0629]    Scale of Affluence  
       Exit Configuration  
       [0630]    Open RE Database Administration  
         [0631]    Select File  
         [0632]    Select Import  
         [0633]    File Name: click on browse on the right end of this box. Locate Drive and folder  
         [0634]    Select the name of the export file (i.e., rawdata.txt) OK  
                                       Import Type:   Click on scroll arrow and select Constituent           Attribute       Operation:   Select Import to The Raiser&#39;s Edge       RE Field Mapping:   Select Use Header Record       Constituent ID/Keys:   Select Constituent ID       Exceptions:   Select Automatically create new table entries           Exception file: choose name/destination for a           file that will store any exceptions to the import           OK                  
 
         [0635]    The next prompt box will indicate the status of the import as it is importing, including the elapsed time, any exceptions, and the percentages of files processed.  
         [0636]    When the process is complete, all new information is now on the RE database, under the Attributes Tab, in Constituent Management.  
         [0637]    To ensure that the information has been properly imported, pull up a couple of individual records and view the information on their constituent attribute tab.  
         [0638]    **Please note that each individual should have at least three new codes on their Constituent Attribute tab—a code for Annual Fund Short Term, Annual Fund Long Term and Affluence &amp; Affinity. Only the top prospects will have a Major Gift or Planned Gift Code and only individuals with a match will have additional data appended.  
         [0639]    When you view the information in Constituent Management . . . congratulations, you have successfully imported Smart Codes and additional data.  
         [0640]    The foregoing description of the applicant&#39;s interactive system for facilitating and improving prospect identification and gift targeting is illustrative only and many modifications may be made without departing from the scope of the invention as claimed below.