T2 ICT used COS - min, average, mode and max declared salary and allowance amounts
Dear Freedom Of Information Team ( IND ),
Thank you for your recent reply (http://www.whatdotheyknow.com/request/jo...) and fully answering my FOI request.
Following on from your answer, will you provide the min, average, mode and max declared salary and allowance amounts by SOC (for T2 ICT used COS) by month from the introduction of the PBS in 2008 (please see FOI http://www.whatdotheyknow.com/request/av...) which may help your IT dept who can amend that query to help answer my request)
Will you provide the same information above but break it down across the top 25 sponsors.
Yours sincerely,
Peter Kellard
Thank you for you email.
I am outoof the office until Monday 5/09/11. Please contact the Freedom of
Information Mailbox for any urgent queries
Regards
Isra
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Dear Peter Kellard
Re: T2 ICT used COS - min, average, mode and max declared salary and allowance amounts (85304)
Thank you for your recent e mail concerning the above matter. We are currently dealing with your enquiry and will respond shortly.
Kind Regards
Dear Mr Kellard
Thank you for your enquiry of 5 September.
This falls to be dealt with under the Freedom of Information Act 2000
and we will endeavour to respond within 20 working days.
Kind Regards
-Original Message-----
From: Peter Kellard [mailto:[FOI #85304 email]]
Sent: 05 September 2011 23:22
To: Freedom Of Information Team ( IND )
Subject: Freedom of Information request - T2 ICT used COS - min,
average, mode and max declared salary and allowance amounts
Dear Freedom Of Information Team ( IND ),
Thank you for your recent reply
(http://www.whatdotheyknow.com/request/jo...
ncoming-204372)
and fully answering my FOI request.
Following on from your answer, will you provide the min, average,
mode and max declared salary and allowance amounts by SOC (for T2
ICT used COS) by month from the introduction of the PBS in 2008
(please see FOI
http://www.whatdotheyknow.com/request/av...
ncoming-147495)
which may help your IT dept who can amend that query to help answer
my request)
Will you provide the same information above but break it down
across the top 25 sponsors.
Yours sincerely,
Peter Kellard
Mr Kellard,
Please find attached a response to your request made under the Freedom of Information Act.
Ben Smith
Freedom of Information Act Policy
Senior Advisor
Dear Ms Walker
Thank you for your reply to my FOI request.
My request required an extension to an existing report from your MIS data as above. Will you confirm that such a modification to this report would be something that you and your immediate colleagues would be expected to undertake or would this request be passed onto to an IT team who would modify the existing report and pass the result back to you in order that your could answer my Query? My assumption is that such expertise would be outside of your teams remit and would require effort from the UKBA MIS reporting function.
You confirm in your reply that the raw data is available, however, processing the raw data to answer my request would involve running over 6400 reports. Isn’t that why we have computers and very smart IT people working in the UKBA agency MIS function so that they can modify existing reports and consolidate that information into one precise document? Such reporting is common practice in private industry and my request to extend the analysis of this raw data from the output you have already provided would be what I would expect of a small coursework project from a computer science undergraduate.
In light of the difficulty you have in dealing with my original request, I will simplify it to exclude the mode figures i.e T2 ICT used COS - min, average, and max declared salary and allowance amounts.
I am sure Jonathan Sedgwick will also be interested in your response.
This is simple stuff, please answer the question.
Yours sincerely,
Peter Kellard
Dear Peter Kellard
Re: FOI 19907 - Response (85304)
Thank you for your follow up enquiry concerning the above matter. We are currently dealing with your enquiry and will respond shortly.
Kind Regards
UKBA
FOI Team
Dear Mr Kellard,
Thank you for your recent email.
Please confirm that you require min, average and max declared salary and allowance amounts by SOC (for T2
ICT used COS) by month from the introduction of the PBS in 2008 broken down by the top 25 sponsors
Kind regards
Sandra Birkinshaw
Freedom of Information Team
North East, Yorkshire and the Humber Region
UK Border Agency
PO Box 3468
Sheffield S3 8WA
Fax 0114 207 2906
Email: [email address]
Web: www.ukba.homeoffice.gov.uk
Dear Mr Kellard,
Thank you for your email of 20 September.
I think it would be helpful if I explained the remit of the NEYH Freedom of Information (FOI) Team. As you will appreciate the UK Border Agency receives a number of requests for information under the Freedom of Information Act. The NEYH FOI Team is responsible for allocating requests falling to our particular area to experts able to provide the information being sent. We also provide advice to colleagues on whether the exemptions in the Act apply. Your original request was referred to our MI colleagues for advice on whether the information was available and how much it would cost to retrieve it. As you know we were unable to provide the information because to retrieve it would exceed the cost limit.
I have referred your revised request to our MI Team and we will endeavour to respond within 20 working days (18 October).
Kind regards
Sandra
Sandra Birkinshaw
Freedom of Information Team
North East, Yorkshire and the Humber Region
UK Border Agency
PO Box 3468
Sheffield S3 8WA
Fax 0114 207 2906
Email: [email address]
Web: www.ukba.homeoffice.gov.uk
Dear Ms Birkinshaw,
Thankyou for the update and progressing this request with your MI team colleagues.
Yours sincerely,
Peter Kellard
Dear Peter Kellard,
Please find attached the response to your below request.
Yours sincerely,
Freedom of Information Act Policy Team,
Dear Ms Birkinshaw,
Thank you for your reply. I understand that you are the messenger here and that you are replying on advice from MI colleagues. However, this response raises questions about the capability or the integrity of the person in the MI team who has advised you.
Certainly the person who answered FOI 17651/1341 which was an extension to a previous report (FOI 1309 http://www.whatdotheyknow.com/request/se...) would have had no difficulty in extending FOI 17651/1341 to include the extra data I have requested. The suggestion that you would have to run a report multiple times by SOC and month rather than extending an existing report is not credible.
The amendment to the report FOI 17651/1341 required to answer this FOI request would require the base query/view to be extended to include the following sql to return the extra data requested
,MIN(SALARY) AS MIN_SALARY
,AVG(SALARY) AS AVG_SALARY
,MAX(SALARY) AS MAX_SALARY
,MIN(ALLOWANCE) AS MIN_ALLOWANCE
,AVG(ALLOWANCE) AS AVG_ALLOWANCE
,MAX(ALLOWANCE) AS MAX_ALLOWANCE
and then pivot that data into the final output in the same way as the modification made to the report under FOI 17651/1341. To make these changes is more like 3.5 hours work not 3.5 man days.
I would like to request an internal review of the handling of this request, your Reference 20067.
For this review to be credible it is important that those involved do have an understanding of your MI reporting function and will have an understanding of the complexities of producing such reports including the sql they are based on. Any of those who worked on reports for FOI 17156/1309, FOI 17651/1341, FOI 17437/1333 are clearly capable or their direct reports should be considered for this review process.
In the initial response to this request your colleague Daniela Walker offered to provide an update to FOI 19690 for the period from the introduction of the PBS in 2008, whilst the review is ongoing I would appreciate a copy of that data.
A full history of my FOI request and all correspondence is available on the Internet at this address:
http://www.whatdotheyknow.com/request/t2...
Yours faithfully,
Peter Kellard
Dear Mr. Kellard,
Thank you for your email of 25 October 2011, in which you ask for an
internal review of our response to your Freedom of Information request of
20 September 2011.
We will aim to send you a full response by 22 November 2011, which is
twenty working days from the date when we received your request.
The internal review will be carried out by D. Pottinger. If you have any
questions then please do not hesitate to contact FoI Requests using the
above e-mail address.
Yours sincerely
FoI Requests
Home Office
2, Marsham Street
London
SW1P 4DF
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Mr Kellard
Please find attached a response to your request for an internal review
Diana Pottinger
Information Access Team
Ground Floor Seacole
2 Marsham Street
London
SW1P 4DW
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Dear Ms Pottinger,
Thank you for your reply and the information in the spread sheet, please pass on my thanks to your IT colleagues who have worked on this.
I have a couple of comments regarding the data. Firstly the Maximum Salary and Maximum Allowances columns appear to be incorrect and are showing total values rather than the maximums. For example May-09, SOC 1132 has Max Allowances of £92,126,22.00 and Jan-09 SOC 1112 has Max Salary of £211,429,000.00.
Secondly can you provide the counts against each column as it is difficult to derive the full context from the figures without this information?
Yours sincerely,
Peter Kellard
This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
Sent a follow up to UK Border Agency again.
This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
Dear Ms Pottinger,
I keep receiving a mailbox full error when responding to your reply. Please confirm you have received my response
http://www.whatdotheyknow.com/request/t2...
Yours sincerely,
Peter Kellard
This is an automatically generated Delivery Status Notification.
Delivery to the following recipients failed.
Dear Mr Kellard
Please see the attached response and separately attached data table
following your request for information.
Kind Regards
Daniela Walker
UK Border Agency
Level 5
Vulcan House, Steel
Millsands
Sheffield
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Dear Ms Walker
Thank you for this information, however you have accidently posted information relating to another request here.
For readers of this thread this data relates to FOI 1503 found at the link below
http://www.whatdotheyknow.com/request/jo...
Yours sincerely,
Peter Kellard
Dear Mr Kellard
Thank you for your email of 8 March.
We will look into your query and will contact in due course.
Kind Regards
Daniela Walker
UK Border Agency
Vulcan House Steel
PO Box 3468
Sheffield
S3 8WA
Dear Mr Kellard,
It appears that we erroneously sent this information to the email address'[FOI #85304 email]' instead of '[email address]'. Please accept my apologies for this error.
Kind regards
Sandra
Sandra Birkinshaw
Freedom Of Information Team
North East, Yorkshire & the Humber Region
UK Border Agency
PO Box 3468
Sheffield S3 8WA
Fax: 0114 2072894
Email: [email address]
Web: www.ukba.homeoffice.gov.uk
We work to defend the right to FOI for everyone
Help us protect your right to hold public authorities to account. Donate and support our work.
Donate Now