Report To Help for Developers

Reports are used to select a subset of People for mailing list purposes. The selection is based on zip code and affiliation. A variety of formats can be generated - including snail mail address and or email address.

Table: reports

descrip
an identifier for the report
end_update_cutoff
on or before what date of last update should people be included in the report. defaults to 'today'.
format
10 different ones
id
unique id
last_run
last date this report was run
nrecs
how many records do you want? a random selection will be made for you to achieve this many.
rep_order
what order should the people records be in? Zip Code or Last Name
update_cutoff
on or after what date of last update should people be included in the report
zip_range
a free text field describing a zip code range - like "95060, 94050-94090"

Relations

affil_reportaffilreporthas_many
affilsaffil_report => affilmany_to_many