06

Document Sample
06 Powered By Docstoc
					06.01 N+2 for Current Year

Report Definition – 06.01 N+2 for Current Year
Customer Project Manager Issue Issue date Status Prepared by : Department of Communities and Local Government : Nigel Williams : 1.0 : 30th March 2009 : For Review : Tony Banbury

62ed9bc0-48e0-4564-900e-29d2b23ed96d.doc

page 1 of 6

06.01 N+2 for Current Year

Document Control
Amendment History:
Date 30/03/09 23/04/09 Issue 0.1 1.0 Status First draft Updated following UAT Author TB TB

Distribution: Name and role Project Team Project Manager 1.0 I R

I R S

Not issued For information only – no action required For review – comments to be directed to the Project Manager For sign-off

62ed9bc0-48e0-4564-900e-29d2b23ed96d.doc

page 2 of 6

06.01 N+2 for Current Year

Report Definition
Report Title Report Reference Category Purpose Ad hoc / Standard Developed by End Users Access / Distribution Frequency of Use Data Refresh Output Media Report Description: N+2 for Current Year 06.01 N+2 Shows monthly progress towards the N+2 target within the selected year Ad hoc Tony Banbury MA, RDA users Reporting tool Yearly, monthly, ad hoc Daily PDF (default), HTML Shows monthly progress towards the N+2 target within the selected year. Users are prompted for a programme as well as a target year for which the N+2 value is being tracked. The “ERDF Spend” value is the total cumulative ERDF grant from aggregate claims that have been authorised or paid up to and including the target year. The “N+2 Target” is the cumulative financial allocation from the target year – 2, less the EC advance in Euros.

62ed9bc0-48e0-4564-900e-29d2b23ed96d.doc

page 3 of 6

06.01 N+2 for Current Year

Suggested Report Layout

2

3

1 1 2 4

3

62ed9bc0-48e0-4564-900e-29d2b23ed96d.doc

page 4 of 6

06.01 N+2 for Current Year

Report Items
The report layout adheres to the standard report template. Ref 1 Label <month> Description Calendar month Source – Framework ref Reporting Calendar > Month > Calendar Month Short Name Claim > Claim Financials > By Expenditure Category Type > Expenditure > Expenditure Grant EUR Programme > Programme Financials > By Programme > By Year > N Plus 2 Grant EUR N/A Format Text Comments The month shown corresponds to the month in which the aggregate claim was authorised. Where the claim authorised year is <= the year selected For all authorised or completed aggregate claims Where the year is <= the year selected

2

ERDF Spend

The total cumulative ERDF grant from aggregate claims that have been authorised or paid up to and including the target year. Cumulative N+2 target for the year selected “ERDF Spend” / “<yyyy> N+2 Target” as a percentage

Decimal (5.1) scale -6, i.e. millions

3

<yyyy> N+2 Target

Decimal (5.1) scale -6, i.e. millions Percentage

4

% of N+2 Achieved

62ed9bc0-48e0-4564-900e-29d2b23ed96d.doc

page 5 of 6

06.01 N+2 for Current Year

Summary Data
Detail any aggregations within the report, including sub totals. Item None Comments

Parameter List
Parameters available to users are to be presented via a separate “Prompt Page”. The prompt page adheres to the standard report template. Sequence 1 Name Programme Report Field Programme Name Source Framework Ref Programme > Programme Name Comments Only show aggregate programmes, i.e. where Programme Level = „Aggregate‟ Optional N Default Value None Free Form Entry N Drop down Multiple Select N

2

Target Year

Year Number

Reporting Calendar > Year > Year Number

N

None

N Drop down

N

Sort Order
Report Field <month> Direction Asc Horizontal / Vertical (applies to Crosstab reports / charts only)

62ed9bc0-48e0-4564-900e-29d2b23ed96d.doc

page 6 of 6