giftsandmemos: Create a List of Gifts and Memos

In crazybilly/muadc: A collection of functions and variables

Description

Build a list of all gifts (or commitments) and memos.

Usage

giftsandmemos(onedollar = F, collectdata = F)

commitsandmemos(onedollar = F, collectdata = F)

Arguments

onedollar	a logical value describing whether or not gifts of $1 or less should be considered
collectdata	a logical value describing whether or not the data should be collected from the database

Details

If collectdata == T, returns a data frame of all gifts/commitments and memos with one line per transaction. If collectdata is FALSE, a tbl_sql with 6 columns:

• "pidm" constituent's id

• "desg" the designation number to which the gift was given

• "campaign" the campaign in which the gift was given

• "fisc_code" the fiscal year in which the gift was given

• "amt" the gift amount or the amount which was memo credited to the constituent

• "dt" the date the gift or memo was receipted

Value

a 6 column data_frame or a tbl_sql

crazybilly/muadc documentation built on March 6, 2021, 4:15 p.m.