Staff Productivity
Back to Query Directory
Recently we have allowed one of our part time staff to telecommute from home. She has a VPN connection to our Terminal Server here at the main office. Any ideas of how I can track her time--or at least verify her hours? While her work is on the "honor" system, I'd still like the ability to monitor the quantity of work. Any ideas?
While I believe I can see the time she logs on and off of SOS, her log on time doesn't mean she is actually working during that time. How about looking at amount of work on her daysheet?
Actually, there is a good bit of literature that indicates higher productivity in home workers, and this will allow your staff to show that they can be at least as productive at home as at the office. The following query would do the trick if you just want to use number of transactions entered as a metric. I would suggest that you use it over a substantial "in-office" period to establish a baseline, then once she settles in at home, do it again with the "at-home" date range. This query would give you all users who enter transactions, but you can certainly add a condition to limit to certain adduser values if you like.
SELECT
COALESCE(STRING(adddate), 'ALL DATES') AS "DATE",
COALESCE(adduser, 'ALL USERS') AS "USER",
COUNT(*) AS "ENTRIES"
FROM
journal
WHERE
adddate BETWEEN '2008-01-01' AND '2008-01-31'
GROUP BY
ROLLUP(adddate, adduser)
ORDER BY
"DATE", "USER"
COALESCE(STRING(adddate), 'ALL DATES') AS "DATE",
COALESCE(adduser, 'ALL USERS') AS "USER",
COUNT(*) AS "ENTRIES"
FROM
journal
WHERE
adddate BETWEEN '2008-01-01' AND '2008-01-31'
GROUP BY
ROLLUP(adddate, adduser)
ORDER BY
"DATE", "USER"
This query sorts by date and user, and I included the ROLLUP feature to give you the overall values as well. To restrict output to users AB and CD,
you would add the following line just above the GROUP BY clause:
AND adduser IN ('AB', 'CD')
You could do the same for number of patient records entered by simply changing the word "journal" in line 6 to "patients"; or count appointments created by changing it to "appt_d".
CategoryQueries
