The Response Turnaround report summarizes the turnaround time for preparing a response for a selection of Logs. The selection is based on the reporting period which may be monthly, quarterly or annual. The report is broken down by response type within a specified category or summary field. The following example shows a monthly report for correspondence "addressed to" Minister, broken down by Response Type. Logs that have an Interim response are reported separately. The report lists:

• Number of Logs per Response Type
• Median Days to Prepare Final Response broken down by number of median days "in office" before response was started, number of median days "preparing response", and total number of median days to respond.

  The median of a finite list of numbers can be found by arranging all the observations from lowest value
  to highest value and picking the middle one.

• Performance in preparing response based on number sent out in 14 or less days, 15 to 28 days, and more than 28 days.

To Implement Response Turnaround Reporting

The Response Turnaround Report is not available by default as it relies on the configuration of User Defined Fields for supporting information as follows:

• Summary Field - the pivotal field for which the reports are to be generated. This can be any information gathered in a User Defined field in the Log and is typically "Addressed To", "Topic", or any other category for which you want to report turnaround times on.
• Date Response is Signed or Sent - the total response time is calculated using the Log's Received Date and a User Defined Date that records the date the response was signed or sent.
• Interim Date - if you send interim responses, you can report response times separately for these Logs. The Interim date is not used in calculations.

To activate the Response Turnaround Report see the Application Preferences.

Calculating Response Times

Response Turnaround times are calculated and stored in the Log record. The response times are based on the date Received and the date Signed. For example the number of days between the date Received and the date Signed is the Total turnaround time. Calculations are only done in terms of whole days with no rounding up. For example June 15,2008 to June 17,2008 is calculated as two days. Response times are only calculated after a Signed date has been entered in the Log.

If a Referral is used for tracking the time to prepare a response, the response time will be reported as "time in office" and "time to prepare". This is calculated as follows:

• "time to prepare" = sum of all Referrals marked as "preparing response". The time is the difference between the Completed date and the Referral Received Date. If the Received date is not specified, the Sent date is used.
• "in office time" = Total time minus "time to prepare".

Calculated turnaround times are shown in the Log after the Sign By field as "In Office/Preparation" days. The following sample shows an "In office" time of 5 days, and 22 days to "prepare response." Note that if there is no Sign Date then the response times are not calculated or shown.

Using Referrals to Track Response Preparation

Referrals that are used for tracking response preparation can be marked for CLIFF to use in calculating response preparation time. Simply click the PR check box beside the Action field.

Note that only one "PR" Referral may be open at a time, and if there are over-lapping dates between multiple "PR" Referrals, CLIFF will not take the over-lap into consideration when calculating the response time.