TRC Contact Database Rules

From TRCWiki
Revision as of 00:30, 11 May 2008 by Dean (talk | contribs) (Added info about individual records)
Jump to navigation Jump to search

Discussion about this page

Database Content

The TRC contact database contains the following for each person who has run a TRC rallye:

  • Name
  • Address (if provided)
  • Email address
  • Telephone (any of home/work/mobile/FAX provided [but not all have spots on the paper membership application])
  • Information about events run
  • Membership status (member number, expiration date)
  • Address validity flag
  • Opt-in paper mailing flag

Database Usage

Quarterly Mailing

At the Board's choosing, a paper mailing will go out about once per quarter. The mailing should go to all active members who have requested mailings, and may also go to other event participants who have been at a TRC event recently. The definition of "recently" varies some, but tends towards approximately 1 year.

Membership Mailing

At the end of October, TRC will mail out ballots for the November election. Ballots will be sent to all members, regardless of whether they have opted out of flier mailings.

Note that associate members get two ballots in their mailing, so it's required that membership type information be somehow visible to the people preparing the mailing.

Updates

After each rallye, participants are added to the DB from scoresheet registrations. If they are already in the rallye, the event is added to their record.

(If James and Judy Jones ran an earlier rallye, but James now runs without Judy, their database record should be split, so James' can be updated for this rallye.)