Docstoc

A ERP Codes mapped to CFR _Excel format

Document Sample
A ERP Codes mapped to CFR _Excel format Powered By Docstoc
					                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




ORACLE ERP                     DESCRIPTION                        FURTHER CLARIFICATION ON ITEMS TO BE ALLOCATED                       CONSISTENT FINANCIAL REPORTING MAPPING   CFR CODE
  CODE                                                                        AGAINST THESE CODES

                  EMPLOYEE COSTS

A0001             Pay - Local Gov Employees                  Bursars, Business Managers, Clerk to governors, Receptionist, School      Administrative Staff                       E05
A1001             NI - Local Gov Employees                   Secretaries, telephonists, typist.                                        Administrative Staff                       E05
A2001             Pension - Local Gov Employees                                                                                        Administrative Staff                       E05
A0006             Pay - Caretakers & Ground staff            Caretakers, Ground staff, Maintenance Staff, Security Staff, Porters      Premises Staff                             E04
A1006             NI - Caretakers & Ground staff                                                                                       Premises Staff                             E04
A2006             Pension - Caretakers & Ground staff                                                                                  Premises Staff                             E04
A0007             Pay - Cleaning                             Cleaning Staff                                                            Premises Staff                             E04
A1007             NI - Cleaning                                                                                                        Premises Staff                             E04
A2007             Pension - Cleaning                                                                                                   Premises Staff                             E04
A0008             Pay - Catering                             Cashiers, Cooks & Chefs, Kitchen Porters, Servers, Snack bar staff        Catering Staff                             E06
A1008             NI - Catering                                                                                                        Catering Staff                             E06
A2008             Pension - Catering                                                                                                   Catering Staff                             E06
A0009             Pay - Technicians                                                                                                    Education Support Staff                    E03
A1009             NI - Technicians                                                                                                     Education Support Staff                    E03
A2009             Pension - Technicians                                                                                                Education Support Staff                    E03
A0010             Pay - Nursery Staff                                                                                                  Education Support Staff                    E03
A1010             NI - Nursery Staff                                                                                                   Education Support Staff                    E03
A2010             Pension - Nursery Staff                                                                                              Education Support Staff                    E03
A0201             Pay - Teachers                                                                                                       Teaching Staff                             E01
A1201             NI - Teachers                                                                                                        Teaching Staff                             E01
A2201             Pension - Teachers                                                                                                   Teaching Staff                             E01
A0203             Pay - Teaching Assistants                  Classroom Asst                                                            Education Support Staff                    E03
A1203             NI - Teaching Assistants                                                                                             Education Support Staff                    E03
A2203             Pension - Teaching Assistants                                                                                        Education Support Staff                    E03
A0204             Pay - Foreign Lang Assistants                                                                                        Education Support Staff                    E03
A1204             NI - Foreign Lang Assistants                                                                                         Education Support Staff                    E03
A2204             Pension - Foreign Lang Assistants                                                                                    Education Support Staff                    E03
A0205             Pay - Education Support Staff              Exam Invigilators, Librarians, Pianist, Supply Education Support Staff.   Education Support Staff                    E03
A1205             NI - Education Support Staff               Education Welfare Officers, Parent Support Advisors                       Education Support Staff                    E03
A2205             Pension - Education Support Staff                                                                                    Education Support Staff                    E03
A0206             Pay - Midday Supervisors                                                                                             Cost of Other Staff                        E07
A1206             NI - Midday Supervisors                                                                                              Cost of Other Staff                        E07
A2206             Pension - Midday Supervisors                                                                                         Cost of Other Staff                        E07
A0209             Pay - Supply Cover                                                                                                   Teaching Staff                             E01
A1209             NI - Supply Cover                                                                                                    Teaching Staff                             E01
A2209             Pension - Supply Cover                                                                                               Teaching Staff                             E01
A0210             Pay - Supply Cover (Absence)               Supply for Teachers Absence                                               Supply Staff                               E02
A1210             NI - Supply Cover (Absence)                                                                                          Supply Staff                               E02
A2210             Pension - Supply Cover (Absence)                                                                                     Supply Staff                               E02




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                      1                                                                             9/19/2011
                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




A0211             Pay - Supply Cover (T & D)                 Supply for Teachers - on T & D                                           Supply Staff                               E02
A1211             NI - Supply Cover (T & D)                                                                                           Supply Staff                               E02
A2211             Pension - Supply Cover (T & D)                                                                                      Supply Staff                               E02
A0213             Pay - Special Needs Staff                                                                                           Education Support Staff                    E03
A1213             NI - Special Needs Staff                                                                                            Education Support Staff                    E03
A2213             Pension - Staff Needs Staff                                                                                         Education Support Staff                    E03
A0214             Pay - Other School Staff                   Breakfast, lunchtime and after school club staff, Management & Support Cost of Other Staff                          E07
A1214             NI - Other School Staff                    Staff of special facilities, Sports Centre, Arts Centres, Nurses and     Cost of Other Staff                        E07
A2214             Pension - Other School Staff               Medical Staff                                                            Cost of Other Staff                        E07
A0215             Pay Community Focussed Staff               Cost of all staff employed directly by the school for extended community Community Focussed extended school staff   E31
A1215             NI Community Focussed Staff                activities that cannot be funded from the delegated budget - Children    Community Focussed extended school staff   E32
                                                             Centres & Neighbourhood Nurseries
A2215             Pension Community Focussed Staff                                                                                    Community Focussed extended school staff   E33

                  OTHER EMPLOYEE COSTS

A3001             Pay - Agency Staff                         Teaching Staff agency costs only                                            Agency Supply Staff                     E26
A4004             Other Allowances                           Duty meals, Lump Sum Compensation, Redundancy payments, medical             Indirect Employee Expenses              E08
                                                             fees, Car leasing, Presents for employees, CRB checks
A5103             Recruitment - Advertising                  Recruitment costs, Advertising, Interviews, relocation expenses             Indirect Employee Expenses              E08
A5105             Recruitment - Other Expenses               Plus other staff employee costs e.g. staff vaccinations, police clearance   Indirect Employee Expenses              E08
                                                             checks, Eye Care Vouchers, Medical Clearance
A5201             Staff Training & Development                                                                                           Staff development & Training            E09
A5005             Absence Insurance Support Staff            Cover for Non-teacher Insurance, Employee related insurance for             Staff related insurance                 E11
                                                             accident
A5006             Supply Teacher Insurance                   Teaching Staff Only, also to included Maternity Insurance by NCC &          Supply Teacher insurance                E10
                                                             Other providers




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                      2                                                                         9/19/2011
                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




                  PREMISES COSTS

B0006             Repair & Maintenance                       Repairs & Maintenance which is not capital expenditure - also includes      Building maintenance & Improvements   E12
                                                             NCC Strategic Maintenance
B0204             Premises Health & Safety                   Electrical testing & Pest Control, Hygiene services, Paper towels, toilet   Other occupation costs                E18
                                                             rolls and hand dryers, health & safety licences, water dispensers, rock
                                                             salt
B1001             Oil                                                                                                                  Energy                                  E16
B1002             Electricity                                                                                                          Energy                                  E16
B1003             Gas                                                                                                                  Energy                                  E16
B2001             Rents & Leases                                                                                                       Other occupation costs                  E18
B2003             Hire of Mobiles                                                                                                      Other occupation costs                  E18
B2004             Use of Special School Facilities           Swimming pools, Sports Centres, Pupil inter-site (moving between site), Special Facilities                        E24
                                                             expenses relating to before & After school clubs, charitable donations,
                                                             purchase of trading items for re-sale (school uniforms, books, stationery
                                                             etc), Delegated home to school transport.
B2101             Rates                                                                                                                Rates                                   E17
B2201             Water Charges                                                                                                        Water & Sewerage                        E15
B3002             Security Equipment                         Security Patrols & services, CCTV/Burglar alarm maintenance contracts Other occupation costs                      E18

B3004             Fire Equipment                                                                                                         Other occupation costs                E18
B5001             Building cleaning                          Window cleaning                                                             Cleaning & Caretaking                 E14
B5002             Building Cleaning Contract                 Charges by contactors for providing a cleaning service, charges by          Cleaning & Caretaking                 E14
                                                             contractors for providing a caretaking service, related professional and
                                                             technical services
B5003             Refuse Collection Charge                                                                                               Other occupation costs                E18
B6001             Grounds Maintenance                        Maintenance & improvements on gardens, grounds, car parking, play           Grounds maintenance & Improvements    E13
                                                             areas, playground equipment, sports fields
B7001             Insurance - Buildings & Contents           Premises insurance, Accident & Public liability Insurance                   Other Insurance Premiums              E23

                  TRANSPORT COSTS

C5001             Travel Allowances - Staff                                                                                              Indirect Employee Expenses            E08




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                      3                                                                       9/19/2011
                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




                  SUPPLIES & SERVICES

D0202             Cleaning Materials                         Supplies used in cleaning & Caretaking, cost of equipment such as floor       Cleaning & Caretaking                         E14
                                                             polishers, vacuum cleaners
D3101             Office Expenses & Stationery               Administrative stationery & printing, reprographics, medical and              Administrative Supplies                       E22
                                                             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
D0206             Books & Tapes                              Library & text books                                                          Learning resources (NOT ICT equipment)        E19
D4001             Classroom Consumables                      Classroom & learning equipment, curriculum transport (minibus                 Learning resources (NOT ICT equipment)        E19
                                                             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

D4004             Educational Visits                         school trips                                                                  Learning resources (NOT ICT equipment)        E19
D4051             Community Focussed School Costs            All running costs associated with an extended school activity which           Community Focussed extended school costs      E32
                                                             cannot be funded from the delegated budget - children centres and
                                                             neighbourhood nurseries
D4052             Asset Loan - Expenditure                   Expenditure relating to the initial Asset loan Income - not the asset loan    Not included in CFR                          No Code
                                                             repayment
D1008             School Meals                               Cost of providing Free school meals, and free milk                            Catering Supplies                             E25
D1005             Catering Provisions                        Non capital catering equipment, other supplies used in catering               Catering Supplies                             E25
                                                             (cleaning materials, protective clothing, vending machines, service
                                                             contracts, professional & technical services, repairs and maintenance of
                                                             kitchen equipment including safety checks.
D4007             Exam Fees                                  GCSEs, A/AS levels/GNVQs, administrative costs (external; marking)            Exam Fees                                     E21

D4008             Prof Services (Curriculum)                 Professional services, consultancy and advice purchased from LA or          Bought in professional services - Curriculum    E27
                                                             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.




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                       4                                                                                   9/19/2011
                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




D4009             Prof Services (Non Curriculum)             Professional services, consultancy and advice to staff and governors       Bought in professional service - Other    E28
                                                             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

D5301             Postage & Carriage                                                                                                    Administrative Supplies                   E22
D5102             Telephone Costs                                                                                                       Administrative Supplies                   E22
D5004             Computer Hardware - maintenance            Education software, including site or other licences, hardware including   ICT Learning Resources                    E20
D5003             Computer Hardware                          keyboards, monitors printers etc used for teaching purposes.
                                                             Purchases, lease hire or maintenance contracts of ICT used fro
D5005             Computer Software                          teaching.                                       Costs of broadband,
                                                             ISDN, ADSL or other dedicated phone lines.
D5006             Software annual licence agreement
                                                             ICT in schools revenue expenditure.
D6001             Staff Subsistence                                                                                                     Indirect Employee Expenses                E08
D5201             Advertising/Publicity                      Advertising, school publications (parents' report and school brochure)     Administrative Supplies                   E22

D4207             Other Insurance                            Vehicle insurance, school trip insurance                                   Other insurance premiums                   E23
D8001             PFI Scheme Payments                        PFI Schools Only                                                           Not included in CFR                      No Code

                  SUPPORT SERVICES

G0006             Client Payroll Service                     NCC Payroll Service                                                        Bought in professional Service - Other    E28

                  REVENUE FINANCING

H4101             Banking Charges                            Payroll interest fees                                                      Administrative Supplies                    E22
H4306             Contingency Fund                           *Non Posting code - Budget Posting only                                    Not included in CFR                      No Code
H4307             Committed Revenue Balance                  *Non Posting code - Budget Posting only                                    Committed Revenue Balance                  B01
H4308             Uncommitted Revenue Balance                *Non Posting code - Budget Posting only                                    Uncommitted Revenue Balance                B02
H4408             Extended Schools Balance                   *Non Posting code - Budget Posting only                                    Extended School Balance                    B06
H4409             Asset Loan - Repayments




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                      5                                                                             9/19/2011
                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




                  INCOME

J0205             The Private Finance Initiative             PFI Schools Only                                                             Not included in CFR                                   No Code
J2002             Other Local Authorities                    Income from the Teacher Training Agency, development and other non-          Other Government Grants                                 I06
                                                             capital grants from government, single regeneration budget , education
                                                             action zone, income from the specialist schools trust
J2001             Other Grants                               New Opportunities Fund, Lottery Grants, European Union, Milk Subsidy,        Other Grants & Payments Received                        I07
                                                             Income from recycling refunds, paper, glass, plastic
J3003             Donations                                  Income from Schools accounts from foundation, diocese or trust funds         Donations or Private funds                              I13
                                                             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

J6002             Meals/Catering                             Income from catering, school milk provision, vending machines,               Income from Catering                                    I09
                                                             payments received from catering contractors
J6602             Insurance Receipts Supply Staff            Payments from staff absence insurance schemes - to cover the cost of         Receipts Supply Tchrs Ins clms                          I10
                                                             supply teachers
J6601             Insurance Receipts                         All insurance receipts in respect of claims for losses incurred              Receipts from Other insurance claims                    I11
J3004             Parental Contributions                     Parental contribution for education visits, field trips, boarding fees,      Income from contribution to visits etc                  I12
                                                             payments to school for damage done by pupils
J3005             Private Fund Contributions                                                                                              Donations or Private funds                              I13
J3006             PTA Contributions                                                                                                       Donations or Private funds                              I13
J6305             Extended Schools Facilities                Income relating to Children Centres & Private Nurseries                      Community Focused extended school facilities income     I17
J6402             Lettings: Rent/Hire charges                                                                                             Income from Facilities and Services                     I08
J7002             Bank Interest                                                                                                           Income from Facilities and Services                     I08
J6001             Income from Facilities & Services          Income from meals provided to other schools, all other income the            Income from Facilities and Services                     I08
                                                             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




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                      6                                                                                            9/19/2011
                                                                      ORACLE ERP SUBJECTIVE CODES WEF 1ST APRIL 2008




                  CAPITAL FINANCING COSTS

L0001             Devolved Formula Capital Balance           *Non Posting code - Budget Posting only                                 Devolved Formula Capital Balance                B03
L0002             Other Std Fund Capital Balance             *Non Posting code - Budget Posting only                                 Other Standards Fund Capital Balances           B04
L0003             Other Capital Balances                     *Non Posting code - Budget Posting only                                 Other Capital Balance                           B05
L1001             Capital Private Income                     Voluntary or private income including donations dedicated for use as    Private Income Capital                          C103
                                                             capital
L1002             Capital Public Income                      NCC capital funding                                                     Capital Income                                  C101
L1003             Asset Loan - Income                        Asset Loan - income only                                                Not included in CFR                            No Code
L1004             Building Construction                      Cost of new construction, including fees, cost of conversions and       New construction, conversion, and renovation    CE02
                                                             renovations forming a new structure, costs of extensions to existing
                                                             premises
L1005             Equipment & Furniture                      Any capitalised expenditure on acquisition, renewal or replacement of   Vehicles, plant equipment and machinery         CE03
                                                             vehicles, equipment or machinery to be at the school (excludes leased
                                                             equipment)
L1006             Information Technology                     E-learning credits, purchase of computer hardware, software, ICT in     Information and communications technology       CE04
                                                             schools




        D:\Docstoc\Working\pdf\9dbd65fd-5e9a-430b-b476-e661ff0769ad.xls                                    7                                                                                  9/19/2011
A0001   Pay - Local Gov Employees
A1001   NI - Local Gov Employees
A2001   Pension - Local Gov Employees
A0006   Pay - Caretakers & Ground staff
A1006   NI - Caretakers & Ground staff
A2006   Pension - Caretakers & Ground staff
A0007   Pay - Cleaning
A1007   NI - Cleaning
A2007   Pension - Cleaning
A0008   Pay - Catering
A1008   NI - Catering
A2008   Pension - Catering
A0009   Pay - Technicians
A1009   NI - Technicians
A2009   Pension - Technicians
A0010   Pay - Nursery Staff
A1010   NI - Nursery Staff
A2010   Pension - Nursery Staff
A0201   Pay - Teachers
A1201   NI - Teachers
A2201   Pension - Teachers
A0203   Pay - Teaching Assistants
A1203   NI - Teaching Assistants
A2203   Pension - Teaching Assistants
A0204   Pay - Foreign Lang Assistants
A1204   NI - Foreign Lang Assistants
A2204   Pension - Foreign Lang Assistants
A0205   Pay - Education Support Staff
A1205   NI - Education Support Staff
A2205   Pension - Education Support Staff
A0206   Pay - Midday Supervisors
A1206   NI - Midday Supervisors
A2206   Pension - Midday Supervisors
A0209   Pay - Supply Cover
A1209   NI - Supply Cover
A2209   Pension - Supply Cover
A0210   Pay - Supply Cover (Absence)
A1210   NI - Supply Cover (Absence)
A2210   Pension - Supply Cover (Absence)
A0211   Pay - Supply Cover (T & D)
A1211   NI - Supply Cover (T & D)
A2211   Pension - Supply Cover (T & D)
A0213   Pay - Special Needs Staff
A1213   NI - Special Needs Staff
A2213   Pension - Staff Needs Staff
A0214   Pay - Other School Staff
A1214   NI - Other School Staff
A2214   Pension - Other School Staff
A0215   Pay Community Focussed Staff
A1215   NI Community Focussed Staff
A2215   Pension Community Focussed Staff
B2101   Rates
C5001   Travel Allowances - Staff
D8001   PFI Scheme Payments
G0006   Client Payroll Service

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:9/20/2011
language:English
pages:8