Editing Personnel Database/Processing

From PCSAR

Jump to: navigation, search

Warning: You are not logged in. Your IP address will be recorded in this page's edit history.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Current revision Your text
Line 1: Line 1:
-
This task is currently handled by [[Brett Wuth]]. It is my intention to
+
This task is currently handled by [[BrettWuth]]. 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 [[Call Out List]]
+
* creates the call out list* creates the first call list, and distributes it via e-mail* updates the e-mailing lists (members, board, various
-
* creates the [[First Call List]], and distributes it via e-mail
+
committees)* creates the personnel records for members whose information has
-
* updates the e-mailing lists (members, board, various committees)
+
changed: [[PersonnelRecordPrinting]]* e-mails the fan out list* e-mails the membership list to SAR Alberta* e-mails the above documents to the [[MembershipCoordinator]] for printing and
-
* creates the personnel records for members whose information has changed: [[Personnel Record Printing]]
+
distribution===When requested, the database can be processed to:===
-
* e-mails the membership list to SAR Alberta
+
* create mailing labels* print participation dates==How To Do It:==
-
* e-mails the above documents to the [[Membership Coordinator]] for printing and distribution
+
[[HowToProcessMembershipDatabase]]
-
* 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===
+
==Future Things To Do:==
-
* create mailing labels
+
* Add <Solo> for solo activities, in-line with
-
* print participation dates
+
<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
-
==How To Do It==
+
record* difference between work phone number for emergency contact and
-
[[How To Process Personnel Database]]
+
for administrative contact* Produce a report of whose first aid certification is about to
-
 
+
expire==New Things to Ask For:==
-
==Future Things To Do==
+
* If you're searching the database by hand for the same
-
* 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
+
-
==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''
-
 
+
-
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
-
 
+
-
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.

Please note that all contributions to PCSAR are considered to be released under the Attribution-Share Alike 3.0 Unported (see PCSAR:Copyrights for details). If you don't want your writing to be edited mercilessly and redistributed at will, then don't submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. DO NOT SUBMIT COPYRIGHTED WORK WITHOUT PERMISSION!


Cancel | Editing help (opens in new window)
Retrieved from "http://pcsar.dyndns.org:8080/mediawiki/index.php/Personnel_Database/Processing"
Personal tools