Thursday, January 15, 2009

New Query: Faculty and Graduates in Short Work Break.bqy

There is a new query available for Human Resource data warehouse users: Faculty and Graduates in Short Work Break.bqy.

The first query (Qry - Fac and Grad Short Work Break) identifies employees on Short Work Week who may need renewal. The second query (Qry - Fac and Grad Renewed) lists employees who have been renewed. If the return date is reached, they will be in active status, otherwise they will be in Short Work Break Status until their return date is reached.

Helpful pivot views of the results are included as well.

No comments: