METADATA FOR DATA FIELDS,,,,,,,,,,,,
"This worksheet lists the fields of the ""Quarterly Data Summary"" sheet and provides explanation of the metrics (metdata).",,,,,,,,,Organisations in-scope,[Please specify],,
,,ALL INFORMATION SHOULD RELATE TO THE LATEST AVAILABLE DATA,,,,,,,Organisations out-of-scope,[Please specify],,
,,,,,,,,,Actual Department metadata - where differs from requested,,,
GROUP,SUB-GROUP,FIELD NAME,TECHNICAL DEFINITION (REQUESTED),PERIOD OF DATA REPORTED IN QDS (REQUESTED),PERIOD FOR DATA IN JANUARY QDS (REQUESTED),DEPARTMENTAL COVERAGE OF DATA (REQUESTED),DATA SOURCE,"TYPE OF DATA (eg MI, Official Stats or National Stats)",TECHNICAL DEFINITION (ACTUAL),DEPARTMENTAL COVERAGE OF DATA (ACTUAL),"FURTHER NOTES, CAVEATS AND LIMITATIONS",EXPLANATIONS RELATING TO CHANGES IN DATA FROM PREVIOUS QDS PUBLICATIONS
Spending,Budget,"Total Departmental Expenditure Limit (DEL)
",(Resource DEL excluding depreciation) + (Capital DEL),Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information,,,,
,,"of which Resource DEL (excl. Depreciation)
","(Resource DEL excluding depreciation)
",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information,,,,
,,"Top 5 contributory elements
","5 largest areas of spending, as defined by the department, to cover a substantial proportion of DEL.",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Determined by top 5 programmes chosen,"The top 5 contributory elements are from our own management information, taken from the data within our RM system (accounting system). And this is based on the internal allocation and reporting of information and how we report to senior management.",Management information,,,,
,,A,"Support to the Cabinet, Prime Minsiter and the Deputy Prime Minister",,,,,,,,,
,,B,Political and Consititutional Reform,,,,,,,,,
,,C,National Security,,,,,,,,,
,,D,Effciency and Reform,,,,,,,,,
,,E,Independent Business Units,,,,,,,,,
,,Purchase of goods & services within Resource DEL,"RDEL, Purchase of Goods and services. Procurement spending should be recorded as a gross rather than net expenditure. This should be current procurement which falls within resource DEL, therefore excluding all Capital procurement. Should include entries against NAC Codes: ""B3501"" + ""E20""; Expenditure should be recorded in £m. ",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information,,,,
,,Payroll within Resource DEL,"Pay includes salaries, employers’ National Insurance Contributions, and accruing pension costs in RDEL. NAC Codes – all codes under ""A15"". Expenditure should be recorded in £million and in real terms, with no normalisation applied. ",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information,,,,
,,Grants within Resource DEL,"Grant payments or subsidies to individuals or bodies inside or outside the public sector within Resource DEL. The figure should not include any ""capital"" grants or subsidies. The NAC Code definition is:
- Current grants to local government spending NAC= “M10”, “M15”, “M20”, “M30”, “M40”
- Current grants to persons and not for profit bodies NAC= ""D10""
- Current grants abroad NAC= ""D20""
- Subsidies to private sector companies NAC= ""C10, C50""
- Subsidies to public corporations NAC=""C20, C35""
",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information,,,,
,,of which Capital DEL,"(Capital DEL), taken from COINS.",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information
,,Top 5 contributory elements,"5 largest areas of spending, as defined by the department, to cover a substantial proportion of Capital DEL.",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Determined by top 5 programmes chosen,COINS,Management information
,,A,Non Cuirrent Assets - Additions,,,,,
,,B,Capital Grants,,,,,
,,C,NDPBs Grant Capital,,,,,
,,D,,,,,,
,,E,,,,,,
,,Total Annually Managed Expenditure (AME),"(Resource AME excluding depreciation) + (Capital AME), taken from COINS",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Full,COINS,Management information
,,Top 5 contributory elements,"5 largest areas of spending, as defined by the department, to cover a substantial proportion of Total AME.",Quarterly COINS data,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q2 2010-11 (Jul-Sep)",Determined by top 5 programmes chosen,COINS,Management information
,,A,New Provisions,,,,,
,,B,Utilisation of provision,,,,,
,,C,Impairment fixed assets,,,,,
,,D,,,,,,
,,E,,,,,,
,Common Areas of Spend,Office Estate Area,Quarterly data - IPD Cost Codes Solution - currently with departments for feedback (18th November deadline). Will be alligned with Common Areas of Spend Estates Standard.,Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,ePIMS,Management information
,,Office Estate Costs,Quarterly data - IPD Cost Codes Solution - currently with departments for feedback (18th November deadline). Will be alligned with Common Areas of Spend Estates Standard.,Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Office Accomodation over 500m2 for entire family,TBC,Management information
,,Cost of the Office Estate per M2,Quarterly data - IPD Cost Codes Solution - currently with departments for feedback (18th November deadline). Will be alligned with Common Areas of Spend Estates Standard.,Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Office Accomodation over 500m2 for entire family,TBC,Management information,,,“The data previously submitted in Q1 (QDS2) for ‘Cost per m2’ has now been updated to reflect the change to the ‘Total office estate (m2)’ figure.”,“The data previously submitted in Q1 (QDS2) for ‘Total office estate (m2)’ has now been updated to reflect the MOG changes. The MOG changes were reflected in the Estate costs but not carried over to the m2 information”
,,Cost of the Office Estate per full-time equivalent (FTE),Quarterly data - IPD Cost Codes Solution - currently with departments for feedback (18th November deadline). Will be alligned with Common Areas of Spend Estates Standard.,Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Office Accomodation over 500m2 for entire family,TBC,Management information,MASTER,,“The data previously submitted in Q1 (QDS2) ‘Cost per FTE’ has now been updated to reflect the MOG changes. The new FTE figure now includes these changes.”,The FTE figure has been increased to reflect the increase in Q1 and hence the Q2 figure for ‘cost per FTE’ has now been reduced.
,,Procurement spend,"The total value of payments made to third party suppliers, excluding VAT. This excludes payroll, non-cash expenditure (e.g. depreciation), grants and benefit payments, but should include capital, resource and programme spend on goods and services. For further guidance see the Common Areas of Spend Procurement Standards",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Commercial Function,Management information,www.cabinetoffice.gov.uk/resource-library/common-areas-spend-data-definitions,,"Data has been drawn from General Ledger to be consistent with previous returns and COINs data. It includes intra-government spend and staff expenses and receipts/accounting adjustments, and excludes non-recoverable VAT.",The increase (£19.6m) between Q1 and Q2 is mainly due to costs attributable to services provided by DWP in connection with NGHR (£13.5m); increased payments to Fujitsu over the previous quarter of £2.3m for ICT services; accrued spend for business rates (£2.3m) and a payment to MoJ for accommodation (£0.9m).
,,Price of standard commodity items,"Price of a box of standard A4 white copier plain paper (typically 80 gsm) in £ units per 2,500 sheets of paper.
Average price paid per KWH of energy in £ units.",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Commercial Function,Management information,www.cabinetoffice.gov.uk/resource-library/common-areas-spend-data-definitions,,,
,,Average price of energy(£/KWH),,,,,,,www.cabinetoffice.gov.uk/resource-library/common-areas-spend-data-definitions,,"The unit price (£0.046318) reflects the average of prices paid for London and Norwich buildings for electricity, gas and WDHS (London only). Rates are those for energy purchased by GPS for government departments via variable framework agreement. Prices vary subject to market conditions. ",Average price for Quarter 1 previously reported has been adjusted following correction by British Gas of gas consumption and unit prices and inclusion of different rates paid for electricity and gas for Norwich building.
,,Total 3rd party ICT cost,"As defined in the Common Areas of Spend ICT Standards
",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Commercial Function,Management information,,,,
,,Desktop Cost per full-time equivalent,"As defined in the Common Areas of Spend ICT Standards.
",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Commercial Function,Management information,,,"The provision of CO standard Thin Client desktop device including monitor, keyboard, core software and all services to maintain and support it. ",
,,"Corporate Service cost, broken out by functional area into HR (£nillion)","The total of staff, ccl, outsourced activity, shared services, joint venture / mutual, other external advisory and other direct function costs - as defined in the Common Areas of Spend Corporate Service Standards
",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Finance Function,Management information,,,,
,,Finance (£million),,,,,,,,,,
,,Procuremnt (£million),,,,,,,,,,
,,Legal (£million),,,,,,,,,,
,,Communications (£million),,,,,,,,,,
,,"Fraud, Error, Debt
Total Identified Fraud (£million)
","As defined in the Common Areas of Spend Fraud, Error and Debt Standards. Fraud and Error should be calculated for all areas defined in the Standards - Procurement, Payroll, Grants, Tax and Other
Debt and debtor days should be those arising from Fraud and Error, but cover all areas of debt - Debt Type, Tax, Benefits, Fines and penalties, Loans, Sales of goods and services, Other/sundry.
",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Finance Function,Management information,"
The definitions align with the Common Areas of Spend Standard Definition, as follows.
www.cabinetoffice.gov.uk/resource-library/common-areas-spend-data-definitions
",,,
,,Total Known Errors (£million),,,,,,,,,,
,,Total Debt (£million),,,,,,,,,,
,,Total Debtor Days,,,,,,,,,,
,,"Voluntary and community sector (VCS)/Small and medium enterprises (SME)
Procurement spend with SME (£)
","The total direct (ie prime contractor only) procurement spend with SMEs / VCS, excluding VAT, as defined in the Common Areas of Spend Procurement Standards.
The total grant spend with VCS.",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",Full,Finance Function,Management information,,,"Data has been drawn from General Ledger to be consistent with previous returns and COINs data. It includes receipts/accounting adjustments, and non-recoverable VAT. Reflects SMEs identified so far.",Clarification of scope of data. Reflects slight reduction (£0.01m) in spend previously reported due to clarification of status of a supplier as non SME.
,,Procurement spend with VCS (£),,,,,,,,,"Data has been drawn from General Ledger to be consistent with previous returns and COINs data. It includes receipts/accounting adjustments, and non-recoverable VAT. Reflects VCSEs identified so far.",Clarification of scope of data. Reflects slight reduction in spend previously reported due to clarification of status of a supplier as non VCSE (not effected by rounding).
,,Grants to VCS (£),,,,,,,,,,"The variance in the award of grants from £37.6m in quarter 4 2010-11, to £95.3m in the first quarter of 2011-12, relates to a £60m grant to ‘Big Lottery Fund’ in April 2011 in respect of the transition fund. The £60m grant is by far the largest we will make this year and therefore quarter 1 will also be significantly larger than quarter 2, 3 and 4 in 2011-12."
,Financial Indicators,"Accuracy of Cash Forecasting
",Cashflow Management Scheme: Departments with a gross cashflow of over £3bn p.a. provide daily and monthly forecasts of their gross cash payments and receipts up to six weeks ahead. Smaller departments provide monthly forecasts only.The scheme monitors the difference between the forecast and outturn and expresses the difference as a percentage variance on forecast.. Target is for the outturn to be within 5% of the forecast.”,Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",All departments,Departmental Cashflow Management outturns,Management information,,,"As a small department, the Cabinet Office is not part of the Treasury’s cash flow management scheme, which covers the larger government departments. The impact of our cash balances on overall exchequer liquid assets is minimal
Departmental monthly forecasts go to Treasury by the 20th of the preceding month. Over half of Cabinet Office’s cash flow is capital expenditure or grants (current and capital) – a large proportion relative to many other departments (salaries and welfare benefits are likely to be easier to forecast as they are related to numbers of recipients or claimants) .
Grant and capital payments fluctuate and can be difficult to predict on a month by month basis. There are valid operational reasons why we need to make some capital or grant payments outside the month we originally expect. Our receipts from other government departments and external organisations can also be difficult to predict and their timings are largely outside our direct control. In the period covered by the QDS Cabinet Office made some one-off payments to other government departments to settle liabilities arising from machinery of government moves.
",The improvement in accuracy reflects better forecasting of the timing of large grant payments. We are exploring opportunities for further improvements.
,,"Working Capital Forecast
[% variance of Actual v Forecast]","The percentage variance of forecast to actual working capital.
Working capital is calculated as : Total current assets less total current liabilities
o Current Assets
- Inventories
- Current trade and other receivables
- Cash and cash equivalents
- Other current financial assets
- Assets classified as held for sale
o Current Liabilities
- Current trade and other payables
- Gilt edged stock
- Other current liabilities ",Quarterly,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)
* where possible",Full,Management Information and Annual Accounts ,Management information,,,"
","The following are the factors that caused the variance.
Current Assets-Receivables
The variance reflects a reduction of outstanding advances from election returning officers. This reduction took place earlier than anticipated by the original forecast. A remaining relatively small reduction was due to net assets received from NDPBs following their closure.
Current Assets -Bank Balances
The original forecast anticipated balance needed for impending grant payments. The timing of these liabilities at the end of Q2 was different from that anticipated in the forecast.
Current Liabilities - Receivables
The reduction reflects the following items that were not reflected in the original forecast: settlements to the Big Lottery Fund in respect of a grant and the to the consolidated fund standing services - in respect of elections; offset by relatively small variances in end of month accruals and the settlement of MoG transfers."
,,Net Book Value (%) [% variance of Actual v Forecast],"The percentage variance of forecast to actual Net Book Value(NBV) of Fixed Assets.
NBV of fixed assets is calculated as the historic cost or valuation (of the assets included) less accumulated depreciation (i.e. depreciation to date) of the assets.
Note that in WGA, Fixed Assets are referred to as ""Non-current assets"" and include the following:
- property, plant and equipment
- investment property
- intangible assets
- non-current trade and other receivables
- Other non-current financial assets ",Quarterly,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)
* where possible",Full,Management Information and Annual Accounts ,Management information,,,"Land and buildings form around 80% of the Cabinet Office’s non-current assets. The net book value was as expected at 30 September 2011, with minor movements arising from the completion of assets previously classified as under the course of construction.",
,Major Projects (Top 5),Project A,Whole life department cost as defined in the Major Projects Authority (MPA) guidelines.,Full life,Most recent forecast,Full,Departmental internal reporting systems,Management information,,,,
,,Project B,,,,,,,,,,
,,Project C,,,,,,,,,,
,,Project D,,,,,,,,,,Project D: This figure has now been restated from previous £7m to £9m in accordance with the Common Areas of Spend defintion
,,Project E,,,,,,,,,,
,,£m whole life cost of major projects,,,,,,,,,,
Results,Input Indicators,1 The central government cost for every person participating in National Citizen Service,As per Business Plan and Business Plan Measurement Annex,,,,,,,,,Full cost data is not yet available. All cost figures are subject to year end collation and reconciliation and will therefore not be available until Q1 2012-13
,,2 Average cost of training a community organiser (Senior Community Organisers; Mid-level Community Organisers,,,,,,,,,Average cost of training Senior Community Organiser is £676 and average cost for training Mid-level Community Organiser is £190,
,,3 The cost of each type of Cabinet Office moratorium,,,,,,,,,"ICT - £320,000, Property - £220,000, Advertising & marketing - £180,000, Procurement - £110,000, Recruitment £10,000",
,,"4 For every pound spent by government departments, the cost of running a central procurement function to buy common, standard government supplies and equipment",,,,,,,,,"It costs 0.34% of every pound spent by government departments to run a central procurement function to buy common, standard government supplies and equipment",
,,5 The cost of managing the relationship with government suppliers per pound spent on buying supplies and equipment,,,,,,,,, 0.079% of every pound is spent on managing the relationship with government suppliers to buy supplies and equipment,
,"Impact Indicators
","1 The number of mutuals supported by the Mutuals Support Programme, and the number of public service areas in which these mutuals are supported.",,As per Business Plan and Business Plan Measurement Annex,,,,,,,,The Mutual Support Programme was launched on the 5th December 2011. Therfore there are no figures to report on at present.
,,"2Level of volunteering, by age group",,,,,,,,,"% volunteering in the last 12 months, 16 to 24 years old - 28.5%, 25 to 44 years old - 21.9%, 45 to 64 years old - 25%, 65 to 74 years old - 27.8%, 75+ years old - 19.5%",
,,3a Cost of the total staffing resources supporting the work of government,"Cost of the total staffing resources supporting the work of government.
Paybill data for payroll staff includes cost of salaries, allowances, non-consolidated performance related payments, overtime, employers pension contributions, and employer NI contributions.
Paybill data for non-payroll staff are payments made for the reference quarter for all consultants, interim managers, agency staff and specialist contractors.",,Paybill for the quarter ending 30 Sept 2011,"All main departments,their agencies and executive NDPBs (excluding devolved administrations and security services).
","Indicator is the sum of information reported in departments' monthly workforce management information returns for each month that make up the reference quarter e.g. for quarter ending 30 Sept the figure is the sum of the total paybills for July, August and Sept. ",Management information,,"For some quarters, individual organisation's information may not be included in the total figure presented. Where missing organisations are deemed to be significant in terms of coverage, this is noted here.
For the quarter ending 30 Sept, other than those organisations deemed out of scope, the main omissions are DCMS' executive NDPBs.","These are not official statistics, but internal management information published in the interests of transparency.",
,,3bSize of the total staffing resources supporting the work of government,"Size of the total staffing resources supporting the work of government.
Total staffing numbers (FTE basis) include all payroll staff as well as all non-payroll staff (contingent labour) i.e. consultants, interim managers, agency staff and specialist contractors. ",,Staffing levels as at 30 Sept 2011,"All main departments,their agencies and executive NDPBs (excluding devolved administrations).
",Published figure is the sum of staffing numbers indicated in departments' monthly workforce management information returns for the last month of the reference quarter e.g. for quarter ending 30 Sept the figures is the staffing level as at 30 Sept. More up-to-date workforce management information can be found on individual departmental websites.,Management information,,"For some quarters, individual organisation's information may not be included in the total figure presented. Where missing organisations are deemed to be significant in terms of coverage, this is noted here.
For the quarter ending 30 Sept, other than those organisations deemed out of scope, the main omissions are DCMS' executive NDPBs.","These figures have not been reconciled centrally with any National Statistics.
These are not official statistics, but internal management information published in the interests of transparency.
The ONS quarterly public sector employment statistics provide an official headline measure for comparing the overall size of employment in central government with other sectors of the economy, at the appropriate quarterly reference point. ","Revision to previous figure for June position (503,000) due to data cleansing, checking and revisions by organisations of submitted returns."
,,3c Ratio of HR staff to all staff,,,Paybill for the quarter ending 30 June 2011,"All main departments,their agencies and executive NDPBs (excluding devolved administrations and security services).
","The published figure is the sum of information reported in departments' monthly workforce management information returns for each month that make up the reference quarter e.g. for quarter ending 30 June, the figure is the sum of the total paybills for April, May and June.",Management information,"These indicators are measures of the efficiency of Civil Service HR. Although they cover the Civil Service as a whole, they are reported as an impact measure by Cabinet Office because it sponsors the Next Generation HR programme (which aims to simplify HR departments across the Civil Service and eradicate duplication). Civil Service HR is defined as HR functions within core departments (Ministerial and Non-Ministerial) and their Agencies but not their NDPBs (which fall outside the scope of the Next Generation HR programme).HR is defined as per the Common Areas of Spend definition of HR. It therefore includes HR shared services but excludes payroll and pensions administration (which form part of Finance) and also technical training (which is a business activity).The ratio measure (3c) is as at the end of the period in question. The cost per employee measure (3d) is over the period in question.Individual departments also report the absolute cost of their HR function in the Common Areas of Spend section of their QDS. These are also prepared according to the Common Areas of Spend definition of HR. But departments have the choice of whether to include their NDPBs or not.",,,
,,3d Cost of HR function per employee,,,Staffing levels as at 30 June 2011,"All main departments,their agencies and executive NDPBs (excluding devolved administrations).
","Published figure is the sum of staffing numbers indicated in departments' monthly workforce management information returns for the last month of the reference quarter e.g. for quarter ending 30 June, the figures is the staffing level as at 30 June.",Management information,,,,
,,"4 Total central government spend on advertising, management consulting and identified 'overhead commodities' (such as office stationery and IT commodities)",,,,,,,,,"Figures are as reported by Commercal Directors based on a common list of categories agreed with departments. Spend volumes are determined by individual Commerccial Directors.
In some instances, departments have not included spend for all ALBs. ",
,,5 Total savings made by improved management of relationships with key government suppliers (absolute pound savings and period on period change),,,,,,,,,,
,,"6 Hold the General Election as provided by the Fixed Term Parliament Act on a voting system chosen by the British people, more equal constituency boundaries and a more accurate and secure electoral register based on individual registration",,,,,,,,,,
,"Other data sets
",1 Number of participants on National Citizen Service,"Departments to carry out further work to identify which to include in the QDS, in line with guidance/agreeement from the centre.",,,,,,,,,
,,2 Funding released from Big Society Bank,,,,,,,,,,
,,3 Number of interns on new Whitehall internship programme,,,,,,,,,,
,,4 Number of public bodies in central government,,,,,,,,,"Data is not held on the number of all central government public bodies. However the Public Bodies Reform team suggest that the QDS simply tracks the reduction of public bodies as part of their reforms. The scope of the programme includes Non Departmental Public Bodies, Non Ministerial Departments, Public Corporations and some other bodies with statutory functions. The total number of bodies in scope is 904. As part of the Public Bodies Reform programme CO have reduced the number of public bodies by 53 to date. The number of bodies will continue to reduce to as departments implement their reforms over the SR period.",
,,5 Number of community organisers trained,,,,,,,,,,
,"Structural Reform Plan Actions
",Total number of actions completed since April 2011,The number of actions completed as agreed alongside the Number 10 Business Plan monitoring process.,Quarter,"Current = Q3 2011-12 (Oct-Dec)
Previous = Q2 2011-12 (Jul-Sep)",Full,Departmental internal reporting systems,Management information,,,,
,,Total number of actions overdue,The number of actions overdue over the period as agreed alongside the Number 10 Business Plan monitoring process.,Quarter,"Current = Q3 2011-12 (Oct-Dec)
Previous = Q2 2011-12 (Jul-Sep)",Full,Departmental internal reporting systems,Management information,,,For further information on overdue actions please see link: http://www.number10.gov.uk/wp-content/uploads/2012/01/CO-srp-december-20111.pdf
,,Number of overdue actions that are attributable to external factors,The number of actions overdue over the period as agreed alongside the Number 10 Business Plan monitoring process that are due to external factors.,Quarter,"Current = Q3 2011-12 (Oct-Dec)
Previous = Q2 2011-12 (Jul-Sep)",Full,Departmental internal reporting systems,Management information,,,
,,Total number of actions ongoing,The number of actions ongoing over the period as agreed alongside the Number 10 Business Plan monitoring process.,Quarter,"Current = Q3 2011-12 (Oct-Dec)
Previous = Q2 2011-12 (Jul-Sep)",Full,Departmental internal reporting systems,Management information,,,
,,Total number of actions in the business plan that have yet to start,The number of actions yet to start over the period as agreed alongside the Number 10 Business Plan monitoring process.,Quarter,"Current = Q3 2011-12 (Oct-Dec)
Previous = Q2 2011-12 (Jul-Sep)",Full,Departmental internal reporting systems,Management information,,,
People,Whole Department Family; Workforce Size,"Payroll Staff
Department and Agencies","The number of payroll FTE staff in post in the organisations in scope as at the specified reference date.
Methodology as per ONS QPSES/CO monthly MI collection.
The figures reported should align with those that organisations have reported to ONS QPSES and CO monthly workforce MI collection as appropriate.
Any differences should be noted.
Civil Service organisations includes the three crown NDPBs: HSE, ACAS and CMEC where appropriate.",Quarter,"Current = position as at 30th September 2011
Previous = position as at 30th June 2011",All departmental Civil Service organisations,Organisations HR Systems,Management information,,,
,,"Non-departmental public bodies
","The number of payroll FTE staff in post in the organisations in scope as at the specified reference date.
Methodology as per ONS QPSES/CO monthly MI collection.
To ensure consistency with the future planned publication of CO monthly workforce MI returns, departments should report FTE employment in eNDPBs consistent with the organisations in scope for the CO monthly exercise. Any differences between the organisations included for the QDS and those included by the department in their monthly workforce returns should be noted as appropriate.
NB: Due to a minimum employment requirement applying to ONS QPSES, total executive NDPB employment numbers may not align with summary departmental eNDPB employment levels published in QPSES
",,,"All department's Executive NDPBs as reported for CO monthly workforce MI collection.
NB: where there are additions or ommisions in the organisations included in the figure for FTE employment, then this should be mentioned in the final column.",,,,,
,,"Department Family (Total)
",Total of the two rows above,,,All organisations within ministerial responsibility,,,,,
,,"Average Staff Cost
","Please supply paybill per head – as defined in HMT’s Civil Service Pay Guidance. This is the total paybill cost divided by staff in post (FTE).
The paybill costs should include:
o Staff salaries;
o Allowances;
o Overtime payments;
o Non-consolidated pot;
o ERNIC;
o Employers’ pensions contributions.
Figure presented should be a rolling annual average i.e. Current period will show total paybill costs for the year ending the reference period, divided by the average FTE staff in post over the year (where the average staff in post should be a simple average i.e. (the FTE staff in post at start of period plus FTE staff in post at end of period) divided by 2. The previous period will present a figure for the year ending the previous quarter.
Departments should present a figure as defined, but given that organisations are supplying paybill costs each month to CO for the monthly workforce MI collection, they should look to ensure that, where appropriate, information is consistent across both the monthly MI returns and their QDS.",Quarter,"Current = year ending 30th September 2011
Previous = year ending 30th June 2011","Main department, executive agencies, crown NDPBs (where applicable) and executive NDPBs",HR and Payroll/Finance systems.,Management information,,,
,,"Contingent Labour
Department and Agencies","The number of agency staff, specialist contractors, interim managers or consultants engaged – these non-payroll staff being commonly referred to as ‘contingent labour’.
Organisations should ensure consistency with the information supplied for the Cabinet Office monthly workforce MI collection.",Quarter,"Current = position as at 30th September 2011
Previous = position as at 30th June 2011","Main department and its agencies, and where applicable, crown NDPBs i.e. CMEC, HSE and ACAS. In effect all the department's Civil Service organisations",Organisations HR Systems,Management information,,,
,,Non-departmental public bodies,,,,Executive NDPBs as reported for CO monthly workforce MI collection,,,,,
,,Department Family,,,,All organisations within ministerial responsibility,,,,,
,Department & Agencies only; ,"Workforce Shape
- Administrative Assistants and
","The proportion of staff mapped across to the standard Civil Service grades.
SCS staff should be those at SCS level.
All Civil Service organisations should be able to map to the standard Civil Service grades - this is the same as the process that occur each year as part of the annual civil service employmnent survey.
Where organisations do not operate the standard Civil Service grades, they should supply their best estimate, mapping across to the broad responsibility levels as appropriate.
Unknown grades should be apportioned across the grades as necessary so that underlying numbers align with the number of FTE payroll staff supplied above. Where underlying numbers are not consistent, departments should provide an explanatory note in their meta-data sheet.
Departments have now been asked to supply proportions in each grade rather than raw numbers. This is because this is easier to interpret and is consistent with the measures for diversity.
Organisations should ensure consistency with the information supplied for the Cabinet Office monthly workforce MI collection.
Underlying numbers used to calculate proportions should align with the number of FTE staff papyroll staff supplied above.
At the appropriate reference point i.e. end of March, figures should align with the ONS Annual Civil Service Employment Survey (ACSES), where approporiate. Any discrepancies should be noted as necessary in the final column.",Quarter,"Current = position as at 30th September 2011
Previous = position as at 30th June 2011","Main department and its agencies, and where applicable, crown NDPBs i.e. CMEC, HSE and ACAS.
In effect all the department's Civil Service organisations",,Management information,,,
,, Executive Officers,,,,,,,,,
,,Higher and Senior Executive Officers,,,,,,,,,
,,Grade 7/6,,,,,,,,,
,,Senior Civil ,,,,,,,,,
,,Servants,,,,,,
,,"Part Time
","The number of staff working less than standard hours divided by all staff (headcount basis - expressed as a percentage).
Organisations should ensure that figures align with those supplied to ONS for their quarterly public sector employment statistics (QPSES)",,,,,
,,"Workforce Dynamics
Recruitment Exceptions
","The number of recruitment exceptions that have been approved during the quarter.
Where appropriate, organisations should ensure that figures align with those supplied to Cabinet Office for their quarterly exceptions reporting collection in 2010/11. For 2011/12, organisations need only report their exceptions on their QDS - at this stage they do not need to also report separately each quarter to the Cabinet Office.
Organisations should report the number of exceptions for each discrete quarter rather than a cumulative annual position.",Quarter,"Current = Q2 2011-12 (Jul-Sep)
Previous = Q1 2011-12 (Apr-Jun)",,Organisations internal monitoring,Management information
,,"Annual Turnover Rate
","Annual turnover rate (Headcount basis): The number of staff exiting the organisation during the year ending the reference period, divided by the average staff in post over the year ending the reference period (where the average staff in post is calculated as the number of staff in post at the start and end of the relevant period divided by 2, and leavers are ALL leavers exiting the organisation during the period). Each quarter’s figure will show an annual turnover rate for the year ending that quarter.
The definition used here is one of many interpretations of 'turnover'. Whilst we appreciate that organisations may use different measures for their own internal monitoring, we have opted for the described measure to ensure consistency across departments. Where organisations wish to make other measures available, they are free to do so in accompanying commentary or their meta-data sheet as appropriate.
Figures used in the calculation of the denominator should be consistent with those used elsewhere.
",Quarter,"Current = year ending 30th September 2011
Previous = year ending 30th June 2011",,Organisations HR Systems,Management information
,,"Workforce Diversity [Total]
BME","Number of staff recorded as BME/ Total number of staff with a recorded ethnicity (headcount basis - expressed as a percentage).
NB: Unknown and undeclared ethnicity status staff should be excluded from the denominator.
At the appropriate reference date (end of March) figures should align with those supplied for ONS ACSES.
",Quarter,"Current = position as at 30th September 2011
Previous = position as at 30th June 2011",,,Management information
,,Women,"Number of female/ Total number of staff (headcount basis - expressed as a percentage).
Each quarter figures should align with those supplied for ONS QPSES and for ACSES (as at end of March).",Quarter,,,,Management information
,,"
Disabled
","Number of disabled people/ Total number of staff with a recorded disabled status (headcount basis - expressed as a percentage)
NB: Unknown and undeclared disabled status staff should be excluded from the denominator.
At the appropriate reference date (end of March) figures should align with those supplied for ONS ACSES.",Quarter,,,,Management information
,,"Workforce Diversity
[Senior Civil Servants only]
BME","as BME staff above but for SCS level staff only.
There was an error in the detailed definition supplied for the first QDS - the denominator was incorrectly described as all SCS staff.
The denominator definition has now been amended.
Organisations were previously (for QDS1) requested to report figures in line with that supplied for the Cabinet Office bi-annual SCS database collection. Given that we wish to ensure more timely access to the most recent available data, organisations should in future supply SCS diversity figures as at the specified reference date as appropriate, sourcing these from their internal HR systems. This will mean that figures are in line with diversity figures supplied for delegated grades.
Where appropriate, organisations may still wish to satisfy themselves that numbers supplied for the CO SCS database (as at 31 March and 30 September each year) are consistent with those supplied for their QDS for the relevant reference periods. NB: Numbers may not always align since the SCS database collects information on core SCS staff and therefore excludes some senior staff who may be working at an equivalent level to SCS staff but who are not considered part of the SCS proper.",Biannual,,,,Management information
,,Women,"as Female staff above but for SCS level staff only.
There was an error in the detailed definition supplied for the first QDS - the denominator was incorrectly described as all SCS staff.
The denominator definition has now been amended.
Organisations were previously (for QDS1) requested to report figures in line with that supplied for the Cabinet Office bi-annual SCS database collection. Given that we wish to ensure more timely access to the most recent available data, organisations should in future supply SCS diversity figures as at the specified reference date as appropriate, sourcing these from their internal HR systems. This will mean that figures are in line with diversity figures supplied for delegated grades.
Where appropriate, organisations may still wish to satisfy themselves that numbers supplied for the CO SCS database (as at 31 March and 30 September each year) are consistent with those supplied for their QDS for the relevant reference periods. NB: Numbers may not always align since the SCS database collects information on core SCS staff and therefore excludes some senior staff who may be working at an equivalent level to SCS staff but who are not considered part of the SCS proper.",Biannual,,,,Management information
,,Women in Top Management Posts’,"Number of female SCS level staff at payband 2 (Director) or above/ Total number of SCS level staff at Director level or above (headcount basis - expressed as a percentage).
There was an error in the detailed definition supplied for the first QDS - the denominator was incorrectly described as all SCS staff.
The denominator definition has now been amended.
Organisations were previously (for QDS1) requested to report figures in line with that supplied for the Cabinet Office bi-annual SCS database collection. Given that we wish to ensure more timely access to the most recent available data, organisations should in future supply SCS diversity figures as at the specified reference date as appropriate, sourcing these from their internal HR systems. This will mean that figures are in line with diversity figures supplied for delegated grades.
Where appropriate, organisations may still wish to satisfy themselves that numbers supplied for the CO SCS database (as at 31 March and 30 September each year) are consistent with those supplied for their QDS for the relevant reference periods. NB: Numbers may not always align since the SCS database collects information on core SCS staff and therefore excludes some senior staff who may be working at an equivalent level to SCS staff but who are not considered part of the SCS proper.",Biannual,,,,Management information
,,"
Disabled
","as disabled people above but for SCS level staff only.
There was an error in the detailed definition supplied for the first QDS - the denominator was incorrectly described as all SCS staff.
The denominator definition has now been amended.
Organisations were previously (for QDS1) requested to report figures in line with that supplied for the Cabinet Office bi-annual SCS database collection. Given that we wish to ensure more timely access to the most recent available data, organisations should in future supply SCS diversity figures as at the specified reference date as appropriate, sourcing these from their internal HR systems. This will mean that figures are in line with diversity figures supplied for delegated grades.
Where appropriate, organisations may still wish to satisfy themselves that numbers supplied for the CO SCS database (as at 31 March and 30 September each year) are consistent with those supplied for their QDS for the relevant reference periods. NB: Numbers may not always align since the SCS database collects information on core SCS staff and therefore excludes some senior staff who may be working at an equivalent level to SCS staff but who are not considered part of the SCS proper.",Biannual,,,,Management information
,,"Attendance
Average Working Days Lost (AWDL) Actual","Definition and potential source: Cabinet Office Sickness Absence quarterly reports. See attached guidance.
Information should align with that supplied for the Cabinet Office quarterly sickness absence reporting.",Quarter (data provide a rolling annual position each quarter),"Current = position as at 30th September 2011
Previous = position as at 30th June 2011",,,Management information
,,"
Average Working Days Lost (AWDL) Standardised
","Definition and potential source: Cabinet Office Sickness Absence quarterly reports.
The AWDL standardised figure is only available from Cabinet Office. Cabinet Office/HMT officials will arrange for departments to be sent the standardised AWDL figure in plenty of time for inclusion in the relevant quarter's QDS",Quarter (data provide a rolling annual position each quarter),,,Cabinet Office Sickness Absence quarterly reports,Management information
,"Department & Agencies only; People Survey Metrics
",Engagement Index,The organisation's engagement index from the most recent annual Civil Service People Survey,Annual,"Current = 2010 survey
Previous = 2009 survey",Scope limited to main department only,Civil Service People Survey,Census survey
,,"Theme Scores
Leadership & Managing Change
","The organisation's theme score for the leadership and manging change"" theme from the most recent annual Civil Service People Survey .
Figure as published in survey reports",,,,,
,,My Work,"The organisation's theme score for the ""my work"" theme from the most recent annual Civil Service People Survey",,,,,
,,"My Line Manager
","The organisation's theme score for the ""my line manager"" theme from the most recent annual Civil Service People Survey"
,,Organisational Objectives & Purpose,"The organisation's theme score for the ""organisational objectives and purpose"" theme from the most recent annual Civil Service People Survey"