T2 ICT used COS - min, average, mode and max declared salary and allowance amounts

Peter Kellard made this Freedom of Information request to UK Border Agency

This request has been closed to new correspondence from the public body. Contact us if you think it ought be re-opened.

The request was partially successful.

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

Freedom Of Information Team ( IND ), UK Border Agency

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

show quoted sections

Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.

Freedom Of Information Team ( IND ), UK Border Agency

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

show quoted sections

NEYH, Freedom of Information,

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

show quoted sections

-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

show quoted sections

Freedom Of Information Team ( IND ), UK Border Agency

1 Attachment

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

show quoted sections

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

Freedom Of Information Team ( IND ), UK Border Agency

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

show quoted sections

NEYH, Freedom of Information,

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

show quoted sections

Dear Ms Birkinshaw,

Yes that is correct.

Yours sincerely,

Peter Kellard

NEYH, Freedom of Information,

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

show quoted sections

Dear Ms Birkinshaw,

Thankyou for the update and progressing this request with your MI team colleagues.

Yours sincerely,

Peter Kellard

Freedom Of Information Team ( IND ), UK Border Agency

1 Attachment

Dear Peter Kellard,

Please find attached the response to your below request.

Yours sincerely,

Freedom of Information Act Policy Team,

show quoted sections

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

FOI Responses, UK Border Agency

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

 

 

show quoted sections

 

show quoted sections

Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.

FOI Responses, UK Border Agency

2 Attachments

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

 

 

 

 

show quoted sections

 

show quoted sections

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

UK Border Agency

2 Attachments

This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

[email address]

show quoted sections

Sent a follow up to UK Border Agency again.

UK Border Agency

2 Attachments

This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

[email address]

show quoted sections

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

UK Border Agency

2 Attachments

This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

[email address]

show quoted sections

NEYH, Freedom of Information,

2 Attachments

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

 

 

show quoted sections

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

NEYH, Freedom of Information,

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

show quoted sections

NEYH, Freedom of Information,

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

show quoted sections

Looking for an EU Authority?

You can request documents directly from EU Institutions at our sister site AskTheEU.org . Find out more .

AskTheEU.org