Personnel Database/Processing
From PCSAR
< Personnel Database(Difference between revisions)
(→What It Does:) |
|||
| (14 intermediate revisions not shown.) | |||
| Line 1: | Line 1: | ||
| - | This task is currently handled by [[ | + | This task is currently handled by [[Brett Wuth]]. It is my intention to |
eventually redesign this process so it can be done by anyone. | eventually redesign this process so it can be done by anyone. | ||
==What It Does== | ==What It Does== | ||
===Each month the database is processed to accomplish=== | ===Each month the database is processed to accomplish=== | ||
| - | * creates the | + | * creates the [[Call Out List]] |
| - | * creates the | + | * creates the [[First Call List]], and distributes it via e-mail |
* updates the e-mailing lists (members, board, various committees) | * updates the e-mailing lists (members, board, various committees) | ||
| - | * creates the personnel records for members whose information has changed: [[ | + | * creates the personnel records for members whose information has changed: [[Personnel Record Printing]] |
| - | + | ||
* e-mails the membership list to SAR Alberta | * e-mails the membership list to SAR Alberta | ||
| - | * e-mails the above documents to the [[ | + | * e-mails the above documents to the [[Membership Coordinator]] for printing and distribution |
| + | * sends the [[First Call List]] to [[STARS]] and the RCMP | ||
| + | * update access to the website | ||
| + | * upload lists to Rapid Notify, the automated call-out system | ||
| + | |||
===When requested, the database can be processed to=== | ===When requested, the database can be processed to=== | ||
* create mailing labels | * create mailing labels | ||
| Line 16: | Line 19: | ||
==How To Do It== | ==How To Do It== | ||
| - | [[ | + | [[How To Process Personnel Database]] |
| - | ==Future Things To Do | + | ==Future Things To Do== |
| - | * Add <Solo> for solo activities, in-line with | + | * Add <Solo> for solo activities, in-line with <Part> |
| - | <Part>* Print lines in blank personnel record to be written on.* Reorder fields in printed personnel record | + | * Print lines in blank personnel record to be written on.* Reorder fields in printed personnel record |
| - | * see mail/pcsar -> 13 DF Bob Costa Oct23 Brett Wuth personnel | + | * see mail/pcsar -> 13 DF Bob Costa Oct23 Brett Wuth personnel record |
| - | + | * difference between work phone number for emergency contact and for administrative contact | |
| - | for administrative contact* Produce a report of whose first aid certification is about to | + | * Produce a report of whose first aid certification is about to expire |
| - | expire==New Things to Ask For | + | ==New Things to Ask For== |
| - | + | If you're searching the database by hand for the same | |
information over and over again, it's worthwhile to have a script | information over and over again, it's worthwhile to have a script | ||
written (by [[BrettWuth]]) to produce a report. As a rule | written (by [[BrettWuth]]) to produce a report. As a rule | ||
of thumb if you're about to do exactly the same report a second | of thumb if you're about to do exactly the same report a second | ||
time, give [[BrettWuth]] a call and let him scope out how | time, give [[BrettWuth]] a call and let him scope out how | ||
| - | difficult it would be to write a report for you. | + | difficult it would be to write a report for you. |
| + | |||
| + | If on the other hand you're doing a lot of ''different'' | ||
queries, all only once, then it would be a good idea to export the | queries, all only once, then it would be a good idea to export the | ||
data to general purpose database that has a good GUI (graphical) | data to general purpose database that has a good GUI (graphical) | ||
| - | query front-end. | + | query front-end. |
| + | |||
| + | As an aside, I already have and use a simple script that | ||
extracts just the current members from the database. | extracts just the current members from the database. | ||
Current revision
This task is currently handled by Brett Wuth. It is my intention to eventually redesign this process so it can be done by anyone.
Contents |
[edit] What It Does
[edit] Each month the database is processed to accomplish
- creates the Call Out List
- creates the First Call List, and distributes it via e-mail
- updates the e-mailing lists (members, board, various committees)
- creates the personnel records for members whose information has changed: Personnel Record Printing
- e-mails the membership list to SAR Alberta
- e-mails the above documents to the Membership Coordinator for printing and distribution
- sends the First Call List to STARS and the RCMP
- update access to the website
- upload lists to Rapid Notify, the automated call-out system
[edit] When requested, the database can be processed to
- create mailing labels
- print participation dates
[edit] How To Do It
How To Process Personnel Database
[edit] Future Things To Do
- Add <Solo> for solo activities, in-line with <Part>
- Print lines in blank personnel record to be written on.* Reorder fields in printed personnel record
- see mail/pcsar -> 13 DF Bob Costa Oct23 Brett Wuth personnel record
- difference between work phone number for emergency contact and for administrative contact
- Produce a report of whose first aid certification is about to expire
[edit] New Things to Ask For
If you're searching the database by hand for the same information over and over again, it's worthwhile to have a script written (by BrettWuth) to produce a report. As a rule of thumb if you're about to do exactly the same report a second time, give BrettWuth a call and let him scope out how difficult it would be to write a report for you.
If on the other hand you're doing a lot of different queries, all only once, then it would be a good idea to export the data to general purpose database that has a good GUI (graphical) query front-end.
As an aside, I already have and use a simple script that extracts just the current members from the database.
