Editing Personnel Database/Processing
From PCSAR
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 21: | Line 21: | ||
[[How To Process Personnel Database]] | [[How To Process Personnel Database]] | ||
- | ==Future Things To Do== | + | ==Future Things To Do:== |
- | * Add <Solo> for solo activities, in-line with <Part> | + | * Add <Solo> for solo activities, in-line with |
- | * Print lines in blank personnel record to be written on.* Reorder fields in printed personnel record | + | <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 | + | * see mail/pcsar -> 13 DF Bob Costa Oct23 Brett Wuth personnel |
- | * difference between work phone number for emergency contact and for administrative contact | + | record* difference between work phone number for emergency contact and |
- | * Produce a report of whose first aid certification is about to | + | for administrative contact* Produce a report of whose first aid certification is about to |
- | ==New Things to Ask For== | + | expire==New Things to Ask For:== |
- | If you're searching the database by hand for the same | + | * 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. |