Sample Scripts

A small selection of sample scripts you can use as ideas for your data warehouse or reporting environment.

Annual Fund Data Extraction - Shows variable block where values are changed and used throughout the script. Lowers maintenance for your annual fund data extractions. Standardizes inclusions and exclusions so you don't forget. Greatly increases your flexibility when an annual fund data definition changes.

Assignment - Prospect management assignments with prospect and assignment names.

CAE - Run the standard CAE report and variations.

Campaign Counts - Counting donors and calculating statistics for campaigns.

Current Fiscal Year Previous Fiscal Year - Current and previous fiscal year giving.

Entity Statistics - Extract various entity statistics.

Fiscal Dates - All your fiscal dates so they don't have to be changed within programs and reports.

General Annual Fund Mailing - John Starritt & Bryan Mack.

Good Addresses - Fully formatted good addresses, phone numbers and more.

Outstanding Pledges - Managing all aspects of outstanding pledges.

Staff - Staff table to facilitate reporting on staff departments and groups.

State of the Database - Calculating contactable statistics.

10 Year Cash - Cash totals for 10 years with a variety of descriptions and columns to group sort and exclude/include by.

Test IDs - Test entity ids for programmers to use in testing. We all have specific test ids we use to test scripts so why not share them so we don't have to hard code.

Web - Information for deployment on the web. Special fields with special formatting.

These may be syntactically different from the language you're using, but the concepts will be similar.