Working frequency and Turnover status

Introduction

"Working frequency and Turnover status" task helps Fieldwork department keep track how well the interviewers work. There are 2 main parts: 1. The first part is sending email on the day which is 4 days before the last day of the month. For example, if August has 31 days, this email is sent on 27th. This email lists all interviewers who have working hours = 0 during the month. 2. The second part is sending on the last day of the month. It contains working hour info and the number of resigning interviewers and the number of new hired interviewers during the month. These two parts are set up for 2 groups: - CATI afdeling Svendborg - CATI afdeling København

Solution

We use Cgscript to get:

1. Interviewer names

2. Interviewer usernames which are user names in Catweb system

3. Hours worked

Based on time span and working hours, number of interviewers are counted and emails are generated as the introduction part mentions.

After that, emails are sent to FieldworkStatus@catinet.dk automatically following the schedule in the introduction part.

Cgscript function is used in this task:

- Interviewer_getPerformanceListInTimeSpan(groupResourceId, startday, endday) - Datetime functions

Demo

These are final reports:

Email 1: Non working interviewers. This email is sent on 4 days before the last day of the month:

Email 2: Working frequency and turnover status which is sent on the last day of the month

Reference

Detail information and formulas for interviewer performance and working hours and datetime functions:

\\catproc\Share\CatGlobe Teams\Questionnaire\Projects\Version 5.7\VN2115QNR - Getting the performance of an interviewer group \\Catproc\share\CatGlobe Teams\Data\Projects\Version 5.8\VN2549DAT - CGS - Datetime Functions

"CATI afdeling København - FieldWork Status" "CATI afdeling Svendborg - FieldWork Status"

"CATI afdeling København - Non-working interviewers"

"CATI afdeling Svendborg - Non-working interivewers"

( Site:http://mycatinet.catglobe.com/)