ERP Codes

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