Difference between revisions of "TRC Contact Database Rules"
m (Tweeked link. The page I pointed to may or may not exist.) |
(Added info about individual records) |
||
| Line 7: | Line 7: | ||
* Address (if provided) | * Address (if provided) | ||
* Email address | * Email address | ||
* Telephone ( | * Telephone (any of home/work/mobile/FAX provided [but not all have spots on the paper membership application]) | ||
* Information about events run | * Information about events run | ||
* Membership status (member number, expiration date) | * Membership status (member number, expiration date) | ||
* Address validity flag | * Address validity flag | ||
* Opt-in mailing flag | * Opt-in paper mailing flag | ||
== Database Usage == | == Database Usage == | ||
| Line 24: | Line 24: | ||
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. | 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.) | |||
Revision as of 23:30, 10 May 2008
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.)