ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE
DESCRIPTION
ORACLE ERP CODE
DESCRIPTION
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES EMPLOYEE COSTS
CONSISTENT FINANCIAL REPORTING MAPPING
CFR CODE
A0HY1 A0HY5 A0HY6 A0YA1 A0YA5 A0YA6 A0YD1 A0YD5 A0YD6 A0YG1 A0YG5 A0YG6 A0PA1 A0PA5 A0PA6 A0JA1 A0JA5 A0JA6 A0AA1 A0AA5 A0AA7 A0HA1 A0HA5 A0HA6 A0AH1 A0AH5 A0AH6 A0HL1 A0HL5 A0HL6 A0ZD1 A0ZD5 A0ZD6 A0CZ1 A0CZ5 A0CZ7 A0AZ1 A0AZ5 A0AZ7 A0BZ1 A0BZ5 A0BZ7
Admin Staff
A0001 A1001 A2001 A0006 A1006 A2006 A0007 A1007 A2007 A0008 A1008 A2008 A0009 A1009 A2009 A0010 A1010 A2010 A0201 A1201 A2201 A0203 A1203 A2203 A0204 A1204 A2204 A0205 A1205 A2205 A0206 A1206 A2206 A0209 A1209 A2209 A0210 A1210 A2210 A0211 A1211 A2211
Pay - Local Gov Employees NI - Local Gov Employees Pension - Local Gov Employees Pay - Caretakers & Ground staff NI - Caretakers & Ground staff Pension - Caretakers & Ground staff Pay - Cleaning NI - Cleaning Pension - Cleaning Pay - Catering NI - Catering Pension - Catering Pay - Technicians NI - Technicians Pension - Technicians Pay - Nursery Staff NI - Nursery Staff Pension - Nursery Staff Pay - Teachers NI - Teachers Pension - Teachers Pay - Teaching Assistants NI - Teaching Assistants Pension - Teaching Assistants Pay - Foreign Lang Assistants NI - Foreign Lang Assistants Pension - Foreign Lang Assistants Pay - Education Support Staff NI - Education Support Staff Pension - Education Support Staff Pay - Midday Supervisors NI - Midday Supervisors Pension - Midday Supervisors Pay - Supply Cover NI - Supply Cover Pension - Supply Cover Pay - Supply Cover (Absence) NI - Supply Cover (Absence) Pension - Supply Cover (Absence) Pay - Supply Cover (T & D) NI - Supply Cover (T & D) Pension - Supply Cover (T & D)
Bursars, Business Managers, Clerk to governors, Receptionist, School Secretaries, telephonists, typist. Caretakers, Ground staff, Maintenance Staff, Security Staff, Porters Cleaning Staff
Administrative Staff Administrative Staff Administrative Staff Premises Staff Premises Staff Premises Staff Premises Staff Premises Staff Premises Staff Catering Staff Catering Staff Catering Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Teaching Staff Teaching Staff Teaching Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Education Support Staff Cost of Other Staff Cost of Other Staff Cost of Other Staff Teaching Staff Teaching Staff Teaching Staff Supply Staff Supply Staff Supply Staff Supply Staff Supply Staff Supply Staff
E05 E05 E05 E04 E04 E04 E04 E04 E04 E06 E06 E06 E03 E03 E03 E03 E03 E03 E01 E01 E01 E03 E03 E03 E03 E03 E03 E03 E03 E03 E07 E07 E07 E01 E01 E01 E02 E02 E02 E02 E02 E02
Caretakers
Cleaners
Catering Staff
Cashiers, Cooks & Chefs, Kitchen Porters, Servers, Snack bar staff
Technicians
Nursery Nurses
Teachers
Ancillary Staff
Classroom Asst
F.Lang Assistants
Invigilating Staff
Exam Invigilators, Librarians, Pianist, Supply Education Support Staff. Education Welfare Officers, Parent Support Advisors
Mid-day Supervisors SEN Supply Statemented Supply Staff
Supply for Teachers Absence
Supply Standards Fund
Supply for Teachers - on T & D
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
1
11/9/2009
ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE A0HB1 A0HB5 A0HB6 A0ZJ1 A0ZJ5 A0ZJ6
DESCRIPTION Sp.Needs Ancillary
ORACLE ERP CODE
A0213 A1213 A2213 A0214 A1214 A2214 A0215 A1215 A2215
DESCRIPTION
Pay - Special Needs Staff NI - Special Needs Staff Pension - Staff Needs Staff Pay - Other School Staff NI - Other School Staff Pension - Other School Staff Pay Community Focussed Staff NI Community Focussed Staff Pension Community Focussed Staff
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
CONSISTENT FINANCIAL REPORTING MAPPING
CFR CODE
E03 E03 E03 E07 E07 E07 E31 E32 E33
Education Support Staff Education Support Staff Education Support Staff Breakfast, lunchtime and after school club staff, Cost of Other Staff Management & Support Staff of special facilities, Sports Cost of Other Staff Centre, Arts Centres, Nurses and Medical Staff Cost of Other Staff Cost of all staff employed directly by the school for extended Community Focussed extended school community activities that cannot be funded from the staff Community Focussed extended school delegated budget - Children Centres & Neighbourhood staff Community Focussed extended school Nurseries staff
OTHER EMPLOYEE COSTS DE031 AA401 Supply Agency Charges Taxable Payments Staff Advertising Interview Expenses Training & Development Employee Related Insurance Insurance Staff Absence
A3001 A4004 Pay - Agency Staff Other Allowances Teaching Staff agency costs only Duty meals, Lump Sum Compensation, Redundancy payments, medical fees, Car leasing, Presents for employees, CRB checks Recruitment costs, Advertising, Interviews, relocation expenses Plus other staff employee costs e.g. staff vaccinations, police clearance checks, Eye Care Vouchers, Medical Clearance Agency Supply Staff Indirect Employee Expenses E26 E08
AA603 AA604
A5103 A5105
Recruitment - Advertising Recruitment - Other Expenses
Indirect Employee Expenses Indirect Employee Expenses
E08 E08
DA011 AA702
A5201 A5005
Staff Training & Development Absence Insurance Support Staff Cover for Non-teacher Insurance, Employee related insurance for accident
Staff Development & Training Staff related insurance
E09 E11
DA017
A5006
Supply Teacher Insurance
Teaching Staff Only, also to included Maternity Insurance by Supply Teacher insurance NCC & Other providers
E10
PREMISES COSTS BA101 BL001 Fabric/Window/ Door (Strat) Premises Health & Safety Oil Electricity Gas Rents General Rents for Mobiles
B0006 B0204 Repair & Maintenance Repairs & Maintenance which is not capital expenditure also includes NCC Strategic Maintenance Electrical testing & Pest Control, Hygiene services, Paper towels, toilet rolls and hand dryers, health & safety licences, water dispensers, rock salt Building maintenance & Improvements Other occupation costs E12 E18
Premises Health & Safety
BC001 BC004 BC005 BD001 BD003
B1001 B1002 B1003 B2001 B2003
Oil Electricity Gas Rents & Leases Hire of Mobiles
Energy Energy Energy Other occupation costs Other occupation costs
E16 E16 E16 E18 E18
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
2
11/9/2009
ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE DJ016
DESCRIPTION School Use of Spec Facilities
ORACLE ERP CODE
B2004
DESCRIPTION
Use of Special School Facilities
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
CONSISTENT FINANCIAL REPORTING MAPPING
CFR CODE
E24
BE001 BF001 DE004 BG004 BI002 BI005
Rates Water Security Patrols & Services Fire Appliances & maint Window Cleaning Contract Cleaning
B2101 B2201 B3002 B3004 B5001 B5002
Rates Water Charges Security Equipment Fire Equipment Building cleaning Building Cleaning Contract
Swimming pools, Sports Centres, Pupil inter-site (moving Special Facilities between site), expenses relating to before & After school clubs, charitable donations, purchase of trading items for resale (school uniforms, books, stationery etc), Delegated home to school transport. Rates Water & Sewerage Security Patrols & services, CCTV/Burglar alarm Other occupation costs maintenance contracts Other occupation costs Window cleaning Charges by contactors for providing a cleaning service, charges by contractors for providing a caretaking service, related professional and technical services Maintenance & improvements on gardens, grounds, car parking, play areas, playground equipment, sports fields Premises insurance, Accident & Public liability Insurance Cleaning & Caretaking Cleaning & Caretaking
E17 E15 E18 E18 E14 E14
BI003 BB001 BJ002
Refuse Disposal Grounds Maintenance Premises Insurance
B5003 B6001 B7001
Refuse Collection Charge Grounds Maintenance Insurance - Buildings & Contents
Other occupation costs Grounds maintenance & Improvements Other Insurance Premiums
E18 E13 E23
TRANSPORT COSTS CE001 Travel
C5001 Travel Allowances - Staff Indirect Employee Expenses E08
SUPPLIES & SERVICES BI001 Cleaning Materials & Equip. Office Equipment & Furniture
D0202 Cleaning Materials Supplies used in cleaning & Caretaking, cost of equipment such as floor polishers, vacuum cleaners Administrative stationery & printing, reprographics, medical and domestic supplies, purchase, hire or maintenance contracts of ICT or other furniture and equipment not used for teaching purposes, subscriptions, publications, periodicals, copyright fees not related to the curriculum, governor expenses Library & text books Cleaning & Caretaking E14
DA001
D3101
Office Expenses & Stationery
Administrative Supplies
E22
DA009
Curriculum Resources Books
D0206
Books & Tapes
Learning resources (NOT ICT equipment)
E19
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
3
11/9/2009
ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE DA010
DESCRIPTION Curriculum Resources -Other
ORACLE ERP CODE
D4001
DESCRIPTION
Classroom Consumables
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
CONSISTENT FINANCIAL REPORTING MAPPING
CFR CODE
E19
Classroom & learning equipment, curriculum transport Learning resources (NOT ICT equipment) (minibus expenses), awards to pupils, charges for the school library, furniture used for teaching purposes, pupil travel for work experience placements, purchase, lease, hire or maintenance contracts of audio-visual or other equipment used for teaching, reprographic resources and equipment used specifically for teaching purposes, servings & repairs to musical and PE equipment used as part of the curriculum, subscription, publications, periodicals and copyright fees associated with the curriculum, teaching materials, television licences, key stage 2,3 exam costs, hire of swimming pool and transport costs, public entertainment licences school trips All running costs associated with an extended school activity which cannot be funded from the delegated budget children centres and neighbourhood nurseries Expenditure relating to the initial Asset loan Income - not the asset loan repayment Cost of providing Free school meals, and free milk Non capital catering equipment, other supplies used in catering (cleaning materials, protective clothing, vending machines, service contracts, professional & technical services, repairs and maintenance of kitchen equipment including safety checks. GCSEs, A/AS levels/GNVQs, administrative costs (external; marking) Professional services, consultancy and advice purchased from LA or third party in support of the curriculum - ICT consultancy services for the curriculum, payment to any visiting lecturers/speakers. Courses purchased for students from external providers (Colleges of Further Education or other schools, music teachers who are self employed, peripatetic music teachers employed by the LA, Learning resources for education. Professional services, consultancy and advice to staff and governors purchased from the LA or an external party relating to: Management, Finance, legal, personnel, premises, clerking service (not directly employed by the school), management fee on PFI contracts Learning resources (NOT ICT equipment) Community Focussed extended school costs Not included in CFR Catering Supplies Catering Supplies
D4004 D4051
Educational Visits Community Focussed School Costs
E19 E32
DA014 DB001
NCC Loan Expenditure Local Pupil Free Meals Catering Supplies
D4052 D1008 D1005
Asset Loan - Expenditure School Meals Catering Provisions
No Code E25 E25
DE007
DE034
Post 16 Examination Costs Professional Services Curriculum
D4007
Exam Fees
Exam Fees
E21
D4008
Prof Services (Curriculum)
Bought in professional services Curriculum
E27
DE035
Professional ServicesNonCurriculum
D4009
Prof Services (Non Curriculum)
Bought in professional service - Other
E28
DF001
Postage
D5301
Postage & Carriage
Administrative Supplies
E22
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
4
11/9/2009
ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE DF002 DF006 DF010 DF011 DF012 DG001 DJ004 DJ001 EF032
DESCRIPTION Telephone & Fax Computer Maintenance Computer Hardware Computer Software Software Licences Subsistence Adv/Publicity/ Marketing Insurance Misc PFI PAYMENTS
ORACLE ERP CODE
D5102 D5004 D5003 D5005 D5006 D6001 D5201 D4207 D8001
DESCRIPTION
Telephone Costs Computer Hardware - maintenance Computer Hardware Computer Software Software annual licence agreement Staff Subsistence Advertising/Publicity Other Insurance PFI Scheme Payments
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
CONSISTENT FINANCIAL REPORTING MAPPING
Administrative Supplies
CFR CODE
E22 E20
Education software, including site or other licences, ICT Learning Resources hardware including keyboards, monitors printers etc used for teaching purposes. Purchases, lease hire or maintenance contracts of ICT used fro teaching. Costs of broadband, ISDN, ADSL or other dedicated phone lines. ICT in schools revenue expenditure. Indirect Employee Expenses Administrative Supplies Other insurance premiums Not included in CFR
Advertising, school publications (parents' report and school brochure) Vehicle insurance, school trip insurance PFI Schools Only
E08 E22 E23 No Code
SUPPORT SERVICES GA010 NCC Payroll Services
G0006 Client Payroll Service NCC Payroll Service Bought in professional Service - Other E28
REVENUE FINANCING DJ005 DJCON DJECR Bank Charges General Contingency Committed Revenue Balance Uncommitted Revenue Balances Bal. - Extended School Balances Asset Loan Repayments
H4101 H4306 H4307 Banking Charges Contingency Fund Committed Revenue Balance Payroll interest fees *Non Posting code - Budget Posting only *Non Posting code - Budget Posting only Administrative Supplies Not included in CFR Committed Revenue Balance E22 No Code B01
DJERB
H4308
Uncommitted Revenue Balance
*Non Posting code - Budget Posting only
Uncommitted Revenue Balance
B02
DJESB HC001
H4408 H4409
Extended Schools Balance Asset Loan - Repayments
*Non Posting code - Budget Posting only
Extended School Balance
B06
INCOME KA003 KA121 PFI CREDITS (GRANTS) Other DFES Government Grants Other Grants & Payments Received
J0205 J2002 The Private Finance Initiative Other Local Authorities PFI Schools Only Income from the Teacher Training Agency, development and other non-capital grants from government, single regeneration budget , education action zone, income from the specialist schools trust New Opportunities Fund, Lottery Grants, European Union, Milk Subsidy, Income from recycling refunds, paper, glass, plastic Not included in CFR Other Government Grants No Code I06
KB002
J2001
Other Grants
Other Grants & Payments Received
I07
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
5
11/9/2009
ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE KB004
DESCRIPTION Cont. from External Sources
ORACLE ERP CODE
J3003 Donations
DESCRIPTION
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
CONSISTENT FINANCIAL REPORTING MAPPING
CFR CODE
I13
Income from Schools accounts from foundation, diocese or Donations or Private funds trust funds during the year to support education needs at the school, business sponsorship, fund-raising activities, voluntary contributions from parents that are used to provide education, benefits for students Income from catering, school milk provision, vending Income from Catering machines, payments received from catering contractors Payments from staff absence insurance schemes - to cover Receipts Supply Tchrs Ins clms the cost of supply teachers All insurance receipts in respect of claims for losses incurred Receipts from Other insurance claims Parental contribution for education visits, field trips, boarding Income from contribution to visits etc fees, payments to school for damage done by pupils Donations or Private funds Donations or Private funds Community Focused extended school facilities income
KD005 KE044 KE045 KJ001
Catering/Bar Sales Receipts Supply Tchrs Ins clms Receipts from Other Ins claims Sundry Income
J6002 J6602 J6601 J3004
Meals/Catering Insurance Receipts Supply Staff Insurance Receipts Parental Contributions
I09 I10 I11 I12
KJ013
Income from Community focused Activities Lettings - General Bank Interest Income from Facilities & Services
J3005 J3006 J6305
Private Fund Contributions PTA Contributions Extended Schools Facilities
Income relating to Children Centres & Private Nurseries
I13 I13 I17
KE003 KG001 KJ011
J6402 J7002 J6001
Lettings: Rent/Hire charges Bank Interest Income from Facilities & Services
Income from Facilities and Services Income from Facilities and Services Income from meals provided to other schools, all other Income from Facilities and Services income the school receives from facilities and services (income for consultancy, training courses and examination fees, income from sale of school uniforms, materials, private call/photocopying, publications, books, income from before and after school clubs, income form community activities, income from re-sale of items to pupils (musical instruments, classroom resources, commission on photographs, income from non-catering vending machines, income from a special facility, rent deducted off the site manager's salary, reimbursement from catering companies for energy expenditure
I08 I08 I08
CAPITAL FINANCING COSTS KB100 KB101 KJ012 Private Income (Capital) Public Income (Capital) NCC Loan Income
L0001 L0002 L0003 Devolved Formula Capital Balance Other Std Fund Capital Balance Other Capital Balances *Non Posting code - Budget Posting only *Non Posting code - Budget Posting only *Non Posting code - Budget Posting only Devolved Formula Capital Balance Other Standards Fund Capital Balances Other Capital Balance B03 B04 B05
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
6
11/9/2009
ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008
OLD MASTERPIECE CODE DJEDC DJESC
DESCRIPTION Bal. - Devolved Formula Capital Bal. - Other Standards Fund Capital Bal. - Other Capital Balances Cap. - Building Construction Cap. - Furniture & Equipment Capital Information Technology
ORACLE ERP CODE
L1001 L1002
DESCRIPTION
Capital Private Income Capital Public Income
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
Voluntary or private income including donations dedicated for use as capital NCC capital funding
CONSISTENT FINANCIAL REPORTING MAPPING
Private Income Capital Capital Income
CFR CODE
C103 C101
DJECB HB102
L1003 L1004
Asset Loan - Income Building Construction
Asset Loan - income only Cost of new construction, including fees, cost of conversions and renovations forming a new structure, costs of extensions to existing premises Any capitalised expenditure on acquisition, renewal or replacement of vehicles, equipment or machinery to be at the school (excludes leased equipment) E-learning credits, purchase of computer hardware, software, ICT in schools
Not included in CFR New construction, conversion, and renovation Vehicles, plant equipment and machinery
No Code CE02
HB103
L1005
Equipment & Furniture
CE03
HB105
L1006
Information Technology
Information and communications technology
CE04
D:\Docstoc\Working\pdf\ee6030f4-b8cd-459a-8f92-31498355af40.xls
7
11/9/2009
MASTERPIECE CODES NO LONGER USED AND ERP ALTERNATIVES OLD MASTERPIECE CODE A0YA8 A0EZ1 A0EZ5 A0EZ7 A0ZG1 A0ZG5 A0ZG6 BA102 BA111 BA114 CC003 CD005 DA002 DA004 DA019 DA020 DE006 DE033 DF009 DJ003 DJ006 FA002 GA011 GB005 GE006 GE007 GF002 GG101 GG102 GG104 GG115 GG116 GG117 GG213 KE037 KF001 KF003
KJ005
DESCRIPTION Caretakers Letting Fees SEN Supply Non Statemented
ORACLE ERP CODE
A0006 A0209 A1209 A2209
DESCRIPTION
Pay - Caretakers & Ground staff Pay - Supply Cover NI - Supply Cover Pension - Supply Cover
FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED AGAINST THESE CODES
Groundsmen
Fabric/Window/ Door (Non Strat) Energy Conservation Swimming Pool Materials Intersite Travel Standard Funds Travel Furniture Purchase/Repair Maintenance of Equipment Learning Resources - Other Governor Training Stat School Age Exam Costs Hygiene Services Computer Consumables Insurance Equipment Interest on Loans/Overdraft Staff Free Meals NCC Finance Support NCC Legal Support NCC Grounds Administration NCC Cleaning Administration NCC Personnel Support NCC Client Catering NCC Pupil Free Meals NCC Learning Resources NCC Music Services NCC Nias NCC Governors Clerking NCC PFI Premises Recharges Examinations Income Rents Income Caretakers Rent
Monsa Income
A0006 A1006 A2006 B0006 B0006 B0006 D4001 C5001 D3101 D3101 D4001 D4009 D4007 B0204 D5004
D4207 H4101 A4004
Pay - Caretakers & Ground staff NI - Caretakers & Ground staff Pension - Caretakers & Ground staff Repair & Maintenance Repair & Maintenance Repair & Maintenance
Classroom Consumables
Travel Allowances - Staff Office Expenses & Stationery
Office Expenses & Stationery
Classroom Consumables Prof Services (Non Curriculum) Exam Fees Premises Health & Safety Computer Hardware - maintenance
Other Insurance Banking Charges Other Allowances
D4009
Prof Services (Non Curriculum)
Professional services, consultancy and advice to staff and governors purchased from the LA or an external party relating to: Management, Finance, legal, personnel, premises, clerking service (not directly employed by the school), management fee on PFI contracts
D1008
D4008 D4008 D4008 D4009 J6001 J6001 J6001 J6001
J6001
School Meals Prof Services (Curriculum)
Prof Services (Non Curriculum) Income from Facilities & Services Income from Facilities & Services Income from Facilities & Services Income from Facilities & Services
Income from Facilities & Services
Professional services, consultancy and advice purchased from LA or third party in support of the curriculum - ICT consultancy services for the curriculum, payment to any visiting lecturers/speakers. Courses purchased for students from external providers (Colleges of Further