CREATE TABLE cost_centres (
	id INT NOT NULL PRIMARY KEY,
	name VARCHAR(255) NOT NULL
);

INSERT INTO cost_centres (id, name) VALUES
	(8513, 'Accounts Payable'), (8526, 'Admin Property'), (2117, 'Administration'),
	(5007, ''), (7305, 'AdvMetering & Policy'), (2225, 'Area Development Syd'),
	(4508, 'ASP Compliance'), (2509, 'Asset Access'), (9937, 'Asset Programs'),
	(9936, 'Asset Strat. & Perf.'), (9102, 'Ausgrid Board'), (3718, 'Blended Learning'),
	(1626, 'Brkdwn Invest Maint'), (7421, 'BTS Management & QPT'), (8004, 'Bud & Analysis'),
	(4315, 'Bus Intelligence'), (9801, 'Bus Planning'), (7440, 'Bus Sys Continuity'),
	(2140, 'Bus System Developmt'), (2129, 'Bus Trans'), (111, 'Business Analytics'),
	(6909, 'Business Improvement'), (325, 'Business Reporting'), (4311, 'Business Sales Group'),
	(2101, 'Business Serv Mgt'), (4806, 'Business Services'), (8506, 'Business Support'),
	(104, 'Business Systems'), (6906, 'Business Systems Ops'), (4941, 'C&I Reg & Billing'),
	(5107, 'C.C. Emerg Serv'), (5106, 'C.C. Plan & Neg'), (2514, 'Cable Laying'),
	(8547, 'Cash Management'), (1614, 'CBD Construction'), (1718, 'CCoast Field Ops'),
	(1645, 'Central Coast O/H'), (6907, 'Change, Trng & Devt'), (1629, 'Chatswood Hornsby UG'),
	(1630, 'Chatswood Overhead'), (1741, 'Chemical Testing'), (9930, 'Chief Fin. Officer'),
	(9507, 'Chief Oper. Officer'), (1940, 'City Grid Projects'), (1926, 'Civil Construction'),
	(4331, 'Collection Agent Ser'), (9517, 'Comm Inv & P''ships'), (8546, 'Commercial BranchMgt'),
	(7102, 'Commercial Services'), (6711, 'Communication'), (4511, 'Communications'),
	(7016, 'Connection Policy'), (1643, 'Construct&Breakdown'), (1625, 'Construction'),
	(2505, 'Construction Cont'), (1612, 'Construction East'), (4309, 'Contact Centre MGT'),
	(4318, 'Contact Centre Sup'), (2507, 'Contestability'), (2503, 'Contract Development'),
	(1839, 'Control & Pro Hunter'), (1831, 'Control & Pro Sydney'), (6603, 'Control Room - Syd'),
	(6604, 'Control Room - Wall'), (8542, 'Corp & Reg Reporting'), (8503, 'Corp Acc & Reporting'),
	(7602, 'Corp Communications'), (8520, 'Corp Proc Office'), (7812, 'Corporate HR Serv'),
	(9101, 'Corporate Secretary'), (1667, 'Cust Conn. Cent Cst'), (1666, 'Cust Conn. Hornsby'),
	(1668, 'Cust Conn. Newcastle'), (1665, 'Cust Conn. Oatley'), (1669, 'Cust Conn. Zetland'),
	(1661, 'Cust Supply & Plann'), (4306, 'Customer Complaints'), (4930, 'Customer Rego'),
	(3511, 'Customer Services'), (4323, 'Customer Solutions'), (4907, 'Customer Support Mgt'),
	(7424, 'Customer Systems Ser'), (4610, 'Data & Tech Svcs Mgt'), (4811, 'Debt Recovery Serv'),
	(4808, 'Debtor Management'), (1632, 'Dee Why O/H'), (1635, 'Dee Why UG'),
	(6926, 'Delivery & Eng.'), (6923, 'Demand Mgt & Sust'), (2005, 'Des Cont Prj UHunter'),
	(2303, 'Design & Eng Mgt'), (1642, 'Design & Maintenace'), (1611, 'Design&Bus Cont East'),
	(1634, 'Design&Bus Cont Nth'), (1624, 'Design&Bus Cont Sth'), (7407, 'Desktop & Serv Del'),
	(1821, 'Dev Serv'), (6927, 'Development'), (7452, 'Development Services'),
	(5215, 'Dial Before You Dig'), (2508, 'Dist Auto & Subs Eng'), (2501, 'Dist Contracts'),
	(2506, 'Dist Eng Mains Svcs'), (3518, 'Dist Equipment'), (2011, 'Dist Serv - Hunter'),
	(3615, 'Dist. & Transport'), (2527, 'Distribution Program'), (4501, 'Divisional MGT'),
	(1501, 'DOR Mgt'), (1607, 'East Underground - 1'), (1610, 'East Underground - 2'),
	(1742, 'Elec Test Chatswood'), (1743, 'Elec Test Homebush'), (1744, 'Elec Test Wallsend'),
	(6905, 'Emergency Risk M''gt'), (4719, 'Emergency Service'), (4302, 'Emergency Services'),
	(5004, ''), (2116, 'Emp Rel & Admin MGT'), (7111, 'Employment Services'),
	(4815, 'Energy Assist'), (9510, 'Energy Services Mgt'), (5307, 'EnergyFix'),
	(6924, 'EnergySave'), (7458, 'Ent Appl Serv'), (7429, 'Enterprise Info Sys'),
	(1836, 'Environmental Serv'), (2211, 'Est & Cost Planning'), (5300, 'External Business'),
	(3612, 'External Sales'), (8543, 'F&C Division Mgt'), (4810, 'Field & Fulfillment'),
	(1726, 'Field Operating Mgt'), (4717, 'Field OPS Admin'), (5105, 'Field Ops CCoast'),
	(5103, 'Field Ops LwrHunter'), (4716, 'Field OPS MGT'), (5110, 'Field Ops UHunter'),
	(1638, 'Field Serv CC Mgt'), (1606, 'Field Serv East Mgt'), (1659, 'Field Serv LHunt Mgt'),
	(1615, 'Field Serv South Mgt'), (2118, 'Field Support'), (4803, 'Fin & Bus Svcs Mgt'),
	(8532, 'Fin Systems'), (4809, 'Finance'), (7306, 'Finance & Bus Supp'),
	(8501, 'Finance Branch Mgt'), (8504, 'Financial Strategy'), (8531, 'Fixed Assets'),
	(1646, 'Fld Serv Newc Mgt'), (1628, 'Fld Serv North Mgt'), (3311, 'Fleet Garage Ops'),
	(3306, 'Fleet Leasing'), (4510, 'Geo Metering Ops Mgt'), (5211, 'GIS Data Ops Sydney'),
	(5212, 'GIS Data OpsWallsend'), (5216, 'GIS Projects'), (1641, 'Gosford O/H'),
	(9940, 'Health Safety & Env.'), (4621, 'High Power Testing'), (3401, 'Homebush Garage'),
	(3403, 'Hornsby Garage'), (1633, 'Hornsby Overhead'), (4802, 'Human Resources'),
	(7808, 'Human Resources Mgt'), (1915, 'HV Services Homebush'), (9001, 'I A Management'),
	(4804, 'Industrial Relations'), (7811, ''), (8518, 'Information Services'),
	(6902, 'Infrastr. Protection'), (4520, 'Install Data Ops Mgt'), (4718, 'Installation Inspect'),
	(4905, 'Installation Plc&Cmp'), (5002, 'Installations'), (4521, 'Instaln Data Op - CC'),
	(9103, 'Insurance'), (6819, 'Inv Strategy & Anal'), (6813, 'Investment Mgt'),
	(7433, 'IS Project Managemen'), (7408, 'IT Architecture'), (7411, 'IT Finance & Admin'),
	(7415, 'IT Infrast Serv Mgt'), (7413, 'IT Operational Risk'), (7404, 'IT Program &Policies'),
	(7405, 'IT Strategy & Arch'), (7402, 'IT Vendor & Sourcing'), (5109, 'Lake Macquarie O/H'),
	(7813, 'Learning & Develpmt'), (8528, 'Lease/Easements/Lic'), (9201, 'Legal Branch'),
	(1660, 'LHunt SubsUG&OH East'), (3101, 'Logistics & DEng Mgt'), (5108, 'Lowr Hunt Emerg Serv'),
	(1912, 'LV Maint Homebush'), (1916, 'LV Services Artarmon'), (1648, 'LwrH SB UG OH West'),
	(1650, 'LwrHunter Des & Cons'), (1649, 'LwrHunter Fac & Mtce'), (6811, 'Maint & Rep Planning'),
	(1662, 'Maint Break & Invest'), (1613, 'Maintenance'), (7015, 'Major C&M Mgt'),
	(7017, 'Major Connections'), (4711, 'Major Proj East & SL'), (4707, 'Major Projects'),
	(2111, 'Management Systems'), (9515, 'Marketing'), (4634, 'Measurement Services'),
	(4608, 'Meter Data Agency'), (4606, 'Meter Data Operation'), (4950, 'Meter Data Quality'),
	(4618, 'Meter Reading'), (4613, 'Meter Technology Grp'), (4611, 'Metering Operations'),
	(7430, 'Metering System Svcs'), (2222, 'Mjr Proj - Newcastle'), (2223, 'Mjr Proj - Sydney'),
	(9511, 'Mkt & Strategy Devel'), (4909, 'NEMS'), (2534, 'Net Contract Ops CCN'),
	(2532, 'Net Contract Ops E/S'), (2536, 'Net Contract Ops NCH'), (6601, 'Net Control Brch MGT'),
	(7201, 'Network Business'), (4305, 'Network Cust Invgtns'), (1837, 'Network Earthing'),
	(7441, 'Network Eng Svcs'), (6809, 'Network Investment'), (2530, 'Network Planning'),
	(6607, 'Network Reliablity'), (6606, 'Network Security'), (6818, 'Network Strategy'),
	(9935, ''), (9939, 'Network Tech. & Inn.'), (1752, 'Network Telecms East'),
	(1740, 'Network Test Mgt'), (9922, 'Networks NSW CS'), (4301, 'New Contact Centre'),
	(5104, 'New Cust. Supply,P&R'), (1652, 'New Dsgn & Cnstrctn'), (1653, 'New Mntnc Brkdwn&Inv'),
	(1725, 'Newc Field OPS'), (4308, 'Newcastle Despatch'), (1647, 'Newcastle Overhead'),
	(1651, 'Newcastle Subs UG&SL'), (1640, 'Noraville O/H'), (1636, 'North Poles'),
	(1637, 'North S/L'), (8549, 'Ntwk Integration Prg'), (2504, 'NW Contract Ops'),
	(7302, 'NW Pricing & Complia'), (7809, 'O H & S'), (1618, 'O/H Bankstown'),
	(1617, 'O/H Homebush InnerWe'), (1616, 'O/H Oatley'), (3405, 'Oatley Garage'),
	(9301, 'Office CIO Mgt'), (2512, 'Oil Containment'), (6908, 'Op Stds & Accred'),
	(6921, 'Op Tech & Innov Mgt'), (6814, 'Operational Invest'), (6925, 'Operations'),
	(4505, 'Operations East Mgt'), (1602, 'Operations South Mgt'), (2901, 'Ops LHunt&CCoast Mgt'),
	(7459, 'Ops Technologies'), (7806, 'Org Development'), (6815, 'Outage Management'),
	(1805, 'Overhead Design'), (1609, 'Overhead East'), (205, 'Payment Channels'),
	(7810, 'Payroll'), (2124, 'Performance Analysis'), (2119, 'Personnel Services'),
	(4710, 'Planning East'), (5010, 'Planning Inner North'), (4715, 'Planning -Inner West'),
	(5001, 'Planning North Beach'), (5005, 'Planning Outer North'), (4709, 'Planning South'),
	(4708, 'Planning West'), (1842, 'Plant Engineering'), (1621, 'Poles South'),
	(7431, 'Portfolio Delivery'), (6928, 'Portfolio Management'), (1812, 'Printing Services'),
	(6901, 'Procure & Contracts'), (8538, ''), (3523, 'Procurement Services'),
	(3801, 'Professional Develop'), (6812, 'Program Development'), (6701, 'Proj Dev & App Mgt'),
	(6810, 'Proj Mgt Office(PMO)'), (1911, 'Proj Svcs & All Mgt'), (4509, 'Project Development'),
	(1913, 'Project Eng & Co-Ord'), (1901, 'Projects Mgt'), (8519, 'Prop Bch Mgt'),
	(8524, 'Prop Portfolio Mgt'), (9938, 'Property Log & Fleet'), (1709, 'Prot & Tele Oatley'),
	(1751, 'Protection East'), (1733, 'Protection Newcastle'), (1716, 'ProtTeleConChatswood'),
	(2520, 'Public Light & Mgt'), (6820, 'RatingsSupplyQuality'), (3608, 'Reclamation'),
	(7814, 'Recruitment & Remune'), (7303, 'Reg Strategy Bch Mgt'), (3712, 'Regulatory Training'),
	(9306, 'Research Info Lib'), (8548, 'Retail Project'), (110, 'Revenue Assurance'),
	(4813, 'Revenue Services'), (4805, 'Safety'), (2106, 'Safety & Health'),
	(9516, 'Safety Management'), (7113, 'Safety Mgt Systems'), (7101, 'Safety People & Chg.'),
	(7112, 'Safety Services'), (4322, 'Save'), (1843, 'Sec. Systems Support'),
	(2801, 'Security & Mgt Serv'), (2805, 'Security Operations'), (7409, 'Server Ops & Solutns'),
	(9513, 'SGSC'), (4951, 'Small Cust Billing'), (4605, 'Smart Meter Initiati'),
	(7422, 'Solution Management'), (5213, 'Spatial DCT'), (9303, 'Staff Club'),
	(1809, 'Standards'), (2224, 'Strategic Plan & Ser'), (9943, 'Strategic Procuremnt'),
	(7114, 'Strategic Services'), (9931, 'Strategy & Performnc'), (2516, 'Street Lighting'),
	(1931, 'Sub Building Maint'), (1732, 'Sub Equip Newcastle'), (8713, 'Sub Risk Mitigation'),
	(8707, 'Substat Grnds/Bldgs'), (1639, 'Substations CCoast'), (1608, 'Substations East'),
	(1620, 'Substations Homebush'), (1838, 'Substations Hunter'), (1631, 'Substations North'),
	(1619, 'Substations Oatley'), (1832, 'Substations Sydney'), (6710, 'Sub-Trans Planning'),
	(4310, 'Syd Contact Centre'), (4702, 'Sydney City Mgt'), (4903, 'Sydney Despatch'),
	(5003, 'Sydney North Mgt'), (4701, 'Sydney South Mgt'), (1724, 'SydNth Field Ops'),
	(1719, 'SydSth Field Ops'), (6801, 'Syst Plan & Reg Mgt'), (6817, 'System Planning Mgt'),
	(8508, 'Taxation'), (4720, 'Tech Enq & Field Ops'), (2006, 'Tech Serv Hunter'),
	(7451, 'Technical Services'), (1731, 'TelecontrolNewcastle'), (7425, 'Telephony & Contact'),
	(3517, 'Timber Inspection'), (3701, 'Training Mgt'), (3710, 'Training Res.Develop'),
	(3717, 'Training Technical'), (1760, 'Trans Mains Mgt'), (1761, 'Trans Mains OH'),
	(1762, 'Trans Mains UG'), (1715, 'Trans Subs Cent Mgt'), (1750, 'Trans Subs East Mgt'),
	(1730, 'Trans Subs Newc Mgt'), (1706, 'Trans Subs Sth Mgt'), (1701, 'Transmission SS Mgt'),
	(8002, 'Treasury'), (3719, 'Trng - Apprentices'), (3715, 'Trng App Distrbution'),
	(3716, 'Trng App Electrical'), (3714, 'Trng App Wallsend'), (1702, 'TS&S Cap Replacement'),
	(4957, 'TSA - Large Customer'), (4956, 'TSA - Small Customer'), (108, 'TSA Reg Bus'),
	(6501, 'TSO Div Mgt'), (1623, 'U/G Homebush'), (1622, 'U/G Oatley'),
	(1644, 'Underground CCoast'), (5102, 'Upper Hunt Plan &Neg'), (2001, 'Upper Hunter Mgt'),
	(1717, 'Voltage Regulation'), (1734, 'VoltageRegulation'), (3601, 'W/H & Dist Mgt'),
	(3607, 'W/H (Sydney)'), (3609, 'W/H-Field Serv-Hunt'), (3606, 'W/H-Field Serv-Syd'),
	(1707, 'W/S Homebush'), (3404, 'Wallsend Garage'), (3406, 'West Gosford Garage'),
	(1010, 'Wholesale Management'), (7802, 'Workers Comp'), (4314, 'Workforce Planning'),
	(2502, 'Zone Development');
