Version

Code	Description	Parent	Data Entry?	Level	Formula	Snapshots	ATM	Current Forecast	Current Forecast Quarter	Previous Forecast	Quarterly Input
nvarchar(80), not null	nvarchar(80), null	nvarchar(80), not null	FALSE	1	Free text field	Snapshot Source	ATM	Current Forecast	Current Forecast Quarter	Previous Forecast	Quarterly Input
			TRUE	2		Snapshot Target	NULL	NULL	NULL	NULL	NULL
				3
				4

Organisation

Code

Description

Parent

Data Entry?

Level

Formula

CGA Body Type

Dept Group

ELM

LG Body Type

NHS Body Type

PC Body Type

ATM

nvarchar(80), not null

nvarchar(80), null

nvarchar(80), not null

FALSE

Free text field

Dept

Dept003

ELM_ENTITY

County

Foundation Trust

NSFPC

ATM

TRUE

NULL

Minor

Dept004

ELM_POST

District

Non-Foundation Trust

SFPC

NULL

NDPB

Dept005

ELM_POST_ENTITY

Fire

NULL

Trading Fund

Pension Scheme

Dept006

NULL

GLA & Functional

NULL

Trust

Dept007

London Borough

NULL

Dept009

Metropolitan

Dept010

Parks Authority

Dept011

Passenger Transport

Dept013

Police

Dept014

Unitary

Dept015

Waste Disposal

Dept016

NULL

Dept017

Dept019

Dept020

Dept022

Dept025

Dept026

Dept027

Dept028

Dept029

Dept030

Dept031

Dept032

Dept033

Dept034

Dept035

Dept036

Dept037

Dept038

Dept041

Dept044

Dept045

Dept046

Dept047

Dept048

Dept049

Dept050

Dept057

Dept060

Dept061

Dept062

Dept063

Dept064

Dept065

Dept066

Dept067

Dept068

Dept069

Dept070

Dept071

Dept074

Dept075

Dept081

Dept084

Dept085

Dept087

Dept088

Dept089

Dept090

Dept097

Dept099

NULL

Variables

Code

Description

Parent

Data Entry?

Level

Formula

Accounts CAP/CUR

Budget CAP/CUR

Cash items

CFER Income/Receipts

CFER Resource/Capital

ESA

Estimates AinA

Estimates CAP/CUR

Gross/Income

Income Category

NAC

Near Cash/Non-Cash

Non-cash items

PESA Transfer

Resource/Capital

SIGNAGE

WGA Column

WGA Line

ATM

Bad Debts

Cbal

JOURNAL

Local Government Use only

Obal

Pension

nvarchar(80), not null

nvarchar(80), null

nvarchar(80), not null

FALSE

Free text field

A-CAP

B-CAP

NULL

ESA-D11

E-NAN

E-A&G

NULL

Assets

A1501

Near Cash

NULL

OTHRCUR_NONEMP_CG_LG

Resource

Positive

IFA.Single Use Military Equipment

TAX.Income tax

ATM

NULL

Cbal

JOURNAL

Local Government Use only

Obal

Pension

TRUE

A-CUR

B-CON

ESA-D121

E-NAR

E-A&O

Broadcast licence

A1502

NULL

CURTRAN_NONEMP_CG_LG

Capital

Negative

IFA.Patents Licences Trademarks & Art Originals

TAX.Corporation tax

NULL

A-DUM

B-NCH

ESA-D211

E-OAA

E-CAP

CFERs

A1503

CAPGRAN_CG_LG

Not Resource/Capital

NULL

IFA.Purchased Goodwill

TAX.Petroleum revenue tax

A-FIN

B-NUL

ESA-D2121

NULL

E-GRA

Donations

B3501

CURTRANAB_CG_LG

NULL

TFA.IT

TAX.Capital gains tax

NULL

ESA-D214

E-NUL

EU grants

B3502

CAPGRANAB_CG_LG

TFA.Dwellings

TAX.Inheritance tax

ESA-D29C

E-OTH

Goods/services

B3801

OTHRCUR_EMP_CG_LG

TFA.Other Land & Buildings

TAX.Stamp duties

ESA-D29D

NULL

Interest/dividends

B4501

CAPFORM_CG_LG

TFA.Infrastructure

TAX.Social security and NHS contributions

ESA-D29E

Lottery grants

B6001

CURTRAN_EMP_CG_LG

TFA.Payments on account & Assets under Constr.

TAX.Less income tax credits

ESA-D29U

NI Fund

B7001

CURTRAN_NONEMP_PC

TFA.Single Use Military Equipment

TAX.Value added tax

ESA-D3A

Other grants

B7101

CAPTRANAB_CG_LG

TFA.Transport equipment Plant & Machinery

TAX.Hydrocarbon oils duty

ESA-D3B

Pension scheme

B7201

NULL

TFA.Other

TAX.Excise duties

ESA-D3C

Repayments

B7301

IFA.Other

TAX.Other indirect taxes

ESA-D41A

Student Loans

B8001

TFA.Investment Properties

TAX.Insurance premium tax

ESA-D41B

Taxation

B8501

PROV.Early Departure

TAX.Vehicle excise duty

ESA-D421

NULL

B8601

PROV.Other types of provision

TAX.National non-domestic rates

ESA-D45

B9001

PROV.Nuclear decommis-sioning

TAX.Council tax

ESA-D51

B9201

PROV.Clinical negligence

TAX.Broadcast licence

ESA-D59

B9301

PROV.Industrial Health

OINC.Other income

ESA-D6111

B9501

P-ML.Funded Schemes

OINC.Sales of goods and services

ESA-D6112

B9502

P-GL.Funded Schemes

OINC.Local Govt housing rents and other income

ESA-D621

B9503

P-ML.Unfunded Schemes

OCS.Other expenses

ESA-D622

B9504

P-GL.Unfunded Schemes

OCS.Wages & salaries

ESA-D623

B9505

RES.Accumulated Income & Expenditure

OCS.Pension costs (FRS17 and other)

ESA-D624

B9506

RES.Revaluation reserves

OCS.Rentals under operating leases

ESA-D73A

B9507

RES.Donated assets reserves

OCS.Depreciation & impairment charges

ESA-D73B

B9801

RES.Restricted reserves

OCS.Purchase of goods & services

ESA-D74A

B9901

NULL

OCS.Benefits expenditure

ESA-D74B

C1001

OCS.Provisions expense

ESA-D75

C1002

OCS.Grants and subsidies - current

ESA-D91

C2001

OCS.Grants and subsidies - capital

ESA-D92A

C3501

OCS.Grants and subsidies - Other

ESA-D92B

C5001

OCS.Grants and subsidies - EU - general

ESA-D92C

D1001

INTR.Other interest receivable and similar income

ESA-D92D

D1002

INTR.Dividends receivable

ESA-D92E

D2001

P-IE.Expected return on funded schemes’ assets

ESA-D92F

D3001

I&E.Unwinding of discount in provisions

ESA-D99A

D4001

P-IE.Interest on liabilities

ESA-D99BB

D4002

INTP.Interest payable on bank loans and overdrafts

ESA-D99C

D9001

INTP.Interest payable on other borrowings

ESA-D99DA

E0501

INTP.Interest payable on Gilt-edged stock

NULL

E0601

INTP.Interest payable on finance leases

E1001

IFA.Cost - At 1 April

E1101

IFA.Cost - Additions

E1501

IFA.Cost - Donations

E1502

IFA.Cost - Revaluations/Impairments

E1503

IFA.Cost - Disposals

E1504

IFA.Cost - Reclassifications

E1601

IFA.Cost - Transfers

E2001

IFA.Cost - Write offs

E5001

IFA.Depreciation - At 1 April

E5002

IFA.Depreciation - Charge for the year

E5101

IFA.Depreciation - Revaluations/Impairments

E8001

IFA.Depreciation - Disposals

F1001

IFA.Depreciation - Reclassifications

F2001

IFA.Depreciation - Transfers

F2501

IFA.Depreciation - Write offs

F2502

TFA.Cost - At 1 April

F4001

TFA.Cost - Additions

F4501

TFA.Cost - Revaluations/Impairments

F4701

TFA.Cost - Disposals

F5001

TFA.Cost - Reclassifications/other

F5501

TFA.Cost - Transfers

F5601

TFA.Depreciation - At 1 April

F5701

TFA.Depreciation - Charge for the year

G1001

TFA.Depreciation - Past impairment loss reversals

G2001

TFA.Depreciation - Impairment losses

G2002

TFA.Depreciation - Disposals

G4501

TFA.Depreciation - Revaluation Depreciation

G5001

TFA.Depreciation - Reclassifications/other

H1001

TFA.Depreciation - Transfers

H2001

FAI.Other Loans

H3501

DLT.Student Loans (LT)

H3502

FAI.Launch Fund Investments

H5001

FAI.Bank of England

J3001

FAI.Other equity investments

K1001

FAI.Shares held joint ventures and associates

K1201

FAI.Monetary Gold and IMF special drawing rights

K3001

SWIP.Finished goods and goods for resale

K4001

SWIP.Raw materials and consumables

K9001

SWIP.Work in progress

L1001

DLT.Trade debtors

L1101

DLT.Other debtors

L2001

DLT.Deposits and advances

L2101

DLT.Taxes

L3001

DLT.Prepaid and accrued income

L3101

DST.Other trade debtors

L4001

DST.Other debtors

L4501

DST.Taxation and duties due

L4601

DST.Deposits and advances

M1001

DST.Prepayments and accrued income

M1501

DST.Student Loans (ST)

M2001

CASH.Liquid deposits

M3001

CAI.Other investments

M4001

CAI.Listed investments

N1001

CASH.Cash at bank and in hand

N2001

CST.Trade creditors

N3001

CST.Other creditors and deferred income

N4001

CST.Accrued expenses

P1001

CST.Refunds of taxation and social sec. payable

R3001

CST.Bank and other borrowings

S1001

CST.Interest payable

S1002

CST.Gilt Edged Stock

S1003

CLT.Trade creditors

S1501

CLT.Other creditors

S2001

CLT.Bank and other borrowings

S2501

CLT.Gilt-edged stock

S3001

PROV.At 1 April

S4001

PROV.Charged to I&E account

S4501

PROV.Utilised in year

S5001

PROV.Reversal of provisions

S5501

PROV.Unwinding of discount

S6001

PROV.Capitalised in year

S6501

P-ML.Liability at 1 April

S7001

P-ML.Current service costs

T1001

P-ML.Past service costs

T3001

P-ML.Losses/(gains) on settlements & curtailments

W1001

P-ML.Interest on scheme liabilities

W1501

P-GL.Changes in assumptions underlying liabilities

W1601

P-ML.Expected ROR on funded schemes’ assets

W2001

P-ML.Benefits paid

W3001

P-GL.Actual return less expected return on assets

W4001

P-GL.Experience gains and losses on liabilities

W5001

RES.At 1 April

W9001

RES.Transfers

X0601

RES.Other movements

X1101

RES.Local Govt Movements

X1201

RES.Recog. of Actuarial gains/lossses - I&E rsrve

X1601

RES.Revaluation in year

X5101

RES.Additions

Z1001

RES.Unrealised (gain)loss reval of donated assets

NULL

BS.Minority interests

TFA.Asset Financing - On B sheet PFI contracts

CMTS.L&B - Expiry within 1 year

CMTS.L&B - Expiry between 1 and 5 years

CMTS.L&B - Expiry thereafter

CMTS.Other - Expiry within 1 year

CMTS.Other - Expiry between 1 and 5 years

CMTS.Other - Expiry thereafter

FCE.Net position held in US Dollars

FCE.Net position held in Euro

FCE.Net position held in Yen

TFA.Asset Financing - Financed Lease

TFA.Asset Financing - Owned

NULL

&nbs