Dumping Records From Query

In addition to generating template spreadsheets and dumping out previous EPAF imports, windEPAF can also generate a populated spreadsheet base on the results of a query. So if you want to give a raise to all temporary employees who are under 26 years old, female and single; windEPAF can help you do that. Warning, your HR department may frown on this. But perhaps this tool can be used for good as well as evil.

Unlike the rest of windEPAF that is designed to be run by the users as jobsub jobs, this process needs a Systems Analyst/Programmer to write the SQL and place it in the query directory. The query needs to return four columns labeled pidm, posn, suff and effective_date. It is easy to remember because they are essentially the four required columns on the spreadsheet with pidm replacing id. Once this is done epaf_dump can be called with a reference transaction and the query file name.

> epaf_dump.py -t 2001 --file=single_women.sql