FMS - Multi School Reporting APIs Cost Centres
FMS Cross School Reporting APIs
NB: Access subject to customer licence
private XmlDocument btCLFP_ExportCostCentres()
{
var extractor = new CSFMSCSRExport.CsrExporter(tbServer.Text, tbDatabase.Text, tbUsername.Text, tbPassword.Text);
var result = extractor.ExportCostCentreHierarchy("2021") as XmlDocument;
return result;
}
Yields:
<?xml version="1.0" encoding="utf-8"?>
<CostGroups>
<Header>
<SchoolName>Waters Edge School</SchoolName>
<LaCode>823</LaCode>
<SchoolNumber>2999</SchoolNumber>
<ExportDatetime>2023-04-05T11:47:00</ExportDatetime>
<SoftwareVersion>6.93.529</SoftwareVersion>
<YearDescription>2021</YearDescription>
<SchemaVersion>1.0</SchemaVersion>
<User>SYS</User>
</Header>
<cost_group_id>284</cost_group_id>
<description>All Cost Centres</description>
<type>Cost Group</type>
<nlevel>1</nlevel>
<node>/All Cost Centres/</node>
<active>True</active>
<child>
<cost_group_id>287</cost_group_id>
<parent_cost_group_id>284</parent_cost_group_id>
<description>1. Staff</description>
<cost_code />
<type>Cost Group</type>
<nlevel>2</nlevel>
<node>/All Cost Centres/1. Staff/</node>
<active>True</active>
<child>
<parent_cost_group_id>287</parent_cost_group_id>
<description>Other Staff Costs</description>
<cost_code>150</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/1. Staff/Other Staff Costs/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>287</parent_cost_group_id>
<description>Staff Development</description>
<cost_code>190</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/1. Staff/Staff Development/</node>
<active>True</active>
</child>
<child>
<cost_group_id>288</cost_group_id>
<parent_cost_group_id>287</parent_cost_group_id>
<description>Support Staff</description>
<cost_code />
<type>Cost Group</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/</node>
<active>True</active>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Admin & Clerical</description>
<cost_code>110</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Admin & Clerical/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Catering Staff</description>
<cost_code>115</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Catering Staff/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Cleaners</description>
<cost_code>114</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Cleaners/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Educational Support</description>
<cost_code>111</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Educational Support/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Midday Supervisors</description>
<cost_code>113</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Midday Supervisors/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Site Officers</description>
<cost_code>112</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Site Officers/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>288</parent_cost_group_id>
<description>Technicans</description>
<cost_code>116</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Support Staff/Technicans/</node>
<active>True</active>
</child>
</child>
<child>
<cost_group_id>289</cost_group_id>
<parent_cost_group_id>287</parent_cost_group_id>
<description>Teaching</description>
<cost_code />
<type>Cost Group</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/1. Staff/Teaching/</node>
<active>True</active>
<child>
<parent_cost_group_id>289</parent_cost_group_id>
<description>Supply Teachers</description>
<cost_code>101</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Teaching/Supply Teachers/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>289</parent_cost_group_id>
<description>Teachers</description>
<cost_code>100</cost_code>
<type>Cost Centre</type>
<nlevel>4</nlevel>
<node>/All Cost Centres/1. Staff/Teaching/Teachers/</node>
<active>True</active>
</child>
</child>
</child>
<child>
<cost_group_id>290</cost_group_id>
<parent_cost_group_id>284</parent_cost_group_id>
<description>2. Premises</description>
<cost_code />
<type>Cost Group</type>
<nlevel>2</nlevel>
<node>/All Cost Centres/2. Premises/</node>
<active>True</active>
<child>
<parent_cost_group_id>290</parent_cost_group_id>
<description>Building Maintenance</description>
<cost_code>200</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/2. Premises/Building Maintenance/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>290</parent_cost_group_id>
<description>Cleaning Costs</description>
<cost_code>202</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/2. Premises/Cleaning Costs/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>290</parent_cost_group_id>
<description>Energy</description>
<cost_code>203</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/2. Premises/Energy/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>290</parent_cost_group_id>
<description>Grounds Maintenance</description>
<cost_code>201</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/2. Premises/Grounds Maintenance/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>290</parent_cost_group_id>
<description>Rates</description>
<cost_code>204</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/2. Premises/Rates/</node>
<active>True</active>
</child>
</child>
<child>
<cost_group_id>291</cost_group_id>
<parent_cost_group_id>284</parent_cost_group_id>
<description>3. Curriculum</description>
<cost_code />
<type>Cost Group</type>
<nlevel>2</nlevel>
<node>/All Cost Centres/3. Curriculum/</node>
<active>True</active>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>IT</description>
<cost_code>416</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/IT/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Music</description>
<cost_code>415</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Music/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Nursery / Reception</description>
<cost_code>400</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Nursery / Reception/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>PE</description>
<cost_code>417</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/PE/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>SEN</description>
<cost_code>420</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/SEN/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Year 1</description>
<cost_code>401</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Year 1/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Year 2</description>
<cost_code>402</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Year 2/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Year 3</description>
<cost_code>403</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Year 3/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Year 4</description>
<cost_code>404</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Year 4/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Year 5</description>
<cost_code>405</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Year 5/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>291</parent_cost_group_id>
<description>Year 6</description>
<cost_code>406</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/3. Curriculum/Year 6/</node>
<active>True</active>
</child>
</child>
<child>
<cost_group_id>286</cost_group_id>
<parent_cost_group_id>284</parent_cost_group_id>
<description>4. Central</description>
<cost_code />
<type>Cost Group</type>
<nlevel>2</nlevel>
<node>/All Cost Centres/4. Central/</node>
<active>True</active>
<child>
<parent_cost_group_id>286</parent_cost_group_id>
<description>Admin</description>
<cost_code>300</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/4. Central/Admin/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>286</parent_cost_group_id>
<description>Catering Costs</description>
<cost_code>304</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/4. Central/Catering Costs/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>286</parent_cost_group_id>
<description>Contingency</description>
<cost_code>310</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/4. Central/Contingency/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>286</parent_cost_group_id>
<description>External Services</description>
<cost_code>301</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/4. Central/External Services/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>286</parent_cost_group_id>
<description>Furniture & Equipment</description>
<cost_code>303</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/4. Central/Furniture & Equipment/</node>
<active>True</active>
</child>
</child>
<child>
<cost_group_id>285</cost_group_id>
<parent_cost_group_id>284</parent_cost_group_id>
<description>5. Income</description>
<cost_code />
<type>Cost Group</type>
<nlevel>2</nlevel>
<node>/All Cost Centres/5. Income/</node>
<active>True</active>
<child>
<parent_cost_group_id>285</parent_cost_group_id>
<description>LA Grants</description>
<cost_code>920</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/5. Income/LA Grants/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>285</parent_cost_group_id>
<description>Lettings Income</description>
<cost_code>701</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/5. Income/Lettings Income/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>285</parent_cost_group_id>
<description>Miscellaneous Income</description>
<cost_code>700</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/5. Income/Miscellaneous Income/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>285</parent_cost_group_id>
<description>Other Government Grants</description>
<cost_code>910</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/5. Income/Other Government Grants/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>285</parent_cost_group_id>
<description>School Budget Share Income</description>
<cost_code>900</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/5. Income/School Budget Share Income/</node>
<active>True</active>
</child>
<child>
<parent_cost_group_id>285</parent_cost_group_id>
<description>School Meals Income</description>
<cost_code>710</cost_code>
<type>Cost Centre</type>
<nlevel>3</nlevel>
<node>/All Cost Centres/5. Income/School Meals Income/</node>
<active>True</active>
</child>
</child>
</CostGroups>