{ "meta": { "stats": { "requestFetchMs": 35, "vectorPreparationMs": 0, "requestPreparationMs": 0, "vectorResolutionMs": 0, "vectorBuildingMs": -1, "enhanceMs": 0 }, "resolvedPaths": [ "projectFeatured/projectConsortiaOrganizationRoleStage/consortia", "projectFeatured/model", "projectFeatured/projectProvince/province", "projectFeatured/projectCity/city", "projectFeatured/stage", "projectFeatured/projectCostBenefit", "projectFeatured/organization", "projectFeatured/project" ], "relations": [ { "mapping": "projectFeatured=>project", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `project_description_ext2`.`refinance_descr` `refinanceNotes`, `project_description_ext2`.`proj_descr_short` `description`, `joinProject_featured`.`id` `projectFeaturedId`, `projects`.`vfm_date` `vfmDate`, `projects`.`year_psc` `yearPsc`, `projects`.`vfm_used` `vfmUsed`, `projects`.`year_debt` `yearDebt`, `projects`.`construct_jobs` `constructJobs`, `projects`.`year_cost_capital` `yearCostCapital`, `projects`.`greenfield_id` `greenfieldId`, `projects`.`preferred_consortia_id` `preferredConsortiaId`, `projects`.`year_fed_funding` `yearFedFunding`, `projects`.`project_id` `id`, `projects`.`year_prov_funding` `yearProvFunding`, `projects`.`year_cost_agreement` `yearCostAgreement`, `projects`.`construct_jobs_after` `constructJobsAfter`, `projects`.`cost_capital` `costCapital`, `projects`.`year_psc_cost` `yearPscCost`, `projects`.`projectname` `name`, `projects`.`year_project_cost` `yearProjectCost`, `projects`.`psc_cost` `pscCost`, `projects`.`stage_id` `stageId`, `projects`.`active` `active`, `projects`.`desc_other_funding` `descOtherFunding`, `projects`.`com_fin_time` `comFinTime`, `projects`.`process_advisor` `processAdvisor`, `projects`.`owner_organization_id` `ownerId`, `projects`.`year_muni_funding` `yearMuniFunding`, `projects`.`desc_psc` `descPsc`, `projects`.`consortia_id` `consortiaId`, `projects`.`psc` `psc`, `projects`.`procure_time_actual` `procureTimeActual`, `projects`.`is_horizontal` `isHorizontal`, `projects`.`cost_savings` `costSavings`, `projects`.`project_cost` `projectCost`, `projects`.`desc_psc_cost` `descPscCost`, `projects`.`post_construction_term` `postConstructionTerm`, `projects`.`tender_type_id` `tenderTypeId`, `projects`.`next_stage_id` `nextStageId`, `projects`.`year_other_funding` `yearOtherFunding`, `projects`.`desc_cost_capital` `descCostCapital`, `projects`.`desc_debt` `descDebt`, `projects`.`desc_muni_funding` `descMuniFunding`, `projects`.`fin_subcompletion_time` `finSubcompletionTime`, `projects`.`customers` `customers`, `projects`.`desc_fed_funding` `descFedFunding`, `projects`.`desc_cost_savings` `descCostSavings`, `projects`.`year_cost_savings` `yearCostSavings`, `projects`.`jobs` `jobs`, `projects`.`desc_equity` `descEquity`, `projects`.`desc_prov_funding` `descProvFunding`, `projects`.`model_id` `modelId`, `projects`.`sub_sector_id` `subSectorId`, `projects`.`desc_project_cost` `descProjectCost`, `projects`.`ontime_construction` `ontimeConstruction`, `projects`.`cost_agreement` `costAgreement`, `projects`.`sector_id` `sectorId`, `projects`.`year_equity` `yearEquity` FROM `project_featured` joinProject_featured JOIN `projects` ON `joinProject_featured`.`project_id` = `projects`.`project_id` LEFT JOIN `project_description_ext3` ON `projects`.`project_id` = `project_description_ext3`.`project_id` LEFT JOIN `project_description_ext2` ON `projects`.`project_id` = `project_description_ext2`.`project_id` LEFT JOIN `project_description_ext1` ON `projects`.`project_id` = `project_description_ext1`.`project_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id" }, { "mapping": "projectProvince=>province", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `joinProject_province`.`index` `projectProvinceId`, `provinces`.`province_id` `id`, `provinces`.`name` `name` FROM `project_province` joinProject_province JOIN `provinces` ON `joinProject_province`.`province_id` = `provinces`.`province_id` WHERE `joinProject_province`.`index` IN (8519) ", "ingestionMs": "0" }, "keyPath": "project_province.province_id -> provinces.province_id" }, { "mapping": "projectFeatured=>projectProvince", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `project_province`.`project_id` `projectId`, `project_province`.`province_id` `provinceId`, `project_province`.`index` `id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_province` ON `joinProjects`.`project_id` = `project_province`.`project_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_province.project_id" }, { "mapping": "projectConsortiaOrganizationRoleStage=>consortia", "query": { "resultCount": "7", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `consortia`.`imis_id` `imisId`, `consortia`.`name` `name`, `consortia`.`consortia_id` `id`, `consortia`.`url` `url`, `joinProject_consortia_organization_role_stage`.`mapping_id` `projectConsortiaOrganizationRoleStageId` FROM `project_consortia_organization_role_stage` joinProject_consortia_organization_role_stage JOIN `consortia` ON `joinProject_consortia_organization_role_stage`.`consortia_id` = `consortia`.`consortia_id` WHERE `joinProject_consortia_organization_role_stage`.`mapping_id` IN (1225,1226,1227,1228,1229,1230,1231) ", "ingestionMs": "0" }, "keyPath": "project_consortia_organization_role_stage.consortia_id -> consortia.consortia_id" }, { "mapping": "projectFeatured=>stage", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `stages`.`stage` `name`, `stages`.`stage_id` `id`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `stages` ON `joinProjects`.`stage_id` = `stages`.`stage_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> stages.stage_id" }, { "mapping": "projectFeatured=>projectCostBenefit", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `projects`.`project_id` `id` FROM `project_featured` joinProject_featured JOIN `projects` ON `joinProject_featured`.`project_id` = `projects`.`project_id` LEFT JOIN `project_description_ext3` ON `projects`.`project_id` = `project_description_ext3`.`project_id` LEFT JOIN `project_description_ext2` ON `projects`.`project_id` = `project_description_ext2`.`project_id` LEFT JOIN `project_description` ON `projects`.`project_id` = `project_description`.`project_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id" }, { "mapping": "projectFeatured=>organization", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `organization`.`sponsor` `sponsor`, `organization`.`type_id` `typeId`, `organization`.`imis_id` `imisId`, `organization`.`organization_id` `id`, `organization`.`name` `name` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `organization` ON `joinProjects`.`owner_organization_id` = `organization`.`organization_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> organization.organization_id" }, { "mapping": "projectFeatured=>projectCity", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `project_city`.`project_id` `projectId`, `project_city`.`index` `id`, `project_city`.`city_id` `cityId`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_city` ON `joinProjects`.`project_id` = `project_city`.`project_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_city.project_id" }, { "mapping": "projectCity=>city", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `cities`.`city_name` `name`, `cities`.`province_id` `provinceId`, `cities`.`city_id` `id`, `joinProject_city`.`index` `projectCityId` FROM `project_city` joinProject_city JOIN `cities` ON `joinProject_city`.`city_id` = `cities`.`city_id` WHERE `joinProject_city`.`index` IN (7883) ", "ingestionMs": "0" }, "keyPath": "project_city.city_id -> cities.city_id" }, { "mapping": "projectFeatured=>projectConsortiaOrganizationRoleStage", "query": { "resultCount": "7", "generationMs": "0", "executionMs": "1", "filteringMs": "0", "sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `project_consortia_organization_role_stage`.`project_id` `projectId`, `project_consortia_organization_role_stage`.`role_id` `roleId`, `project_consortia_organization_role_stage`.`stage_id` `stageId`, `project_consortia_organization_role_stage`.`mapping_id` `id`, `project_consortia_organization_role_stage`.`organization_id` `organizationId`, `project_consortia_organization_role_stage`.`consortia_id` `consortiaId` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_consortia_organization_role_stage` ON `joinProjects`.`project_id` = `project_consortia_organization_role_stage`.`project_id` AND `project_consortia_organization_role_stage`.`stage_id` = '30' WHERE `project_consortia_organization_role_stage`.`stage_id` = '30' AND `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_consortia_organization_role_stage.project_id" }, { "mapping": "=>projectFeatured", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `project_featured`.`note` `note`, `project_featured`.`project_id` `projectId`, `project_featured`.`start` `start`, `project_featured`.`end` `end`, `project_featured`.`id` `id` FROM `project_featured` ", "ingestionMs": "0" } }, { "mapping": "projectFeatured=>model", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "filteringMs": "0", "sql": "SELECT `models`.`model_name` `name`, `models`.`model_id` `id`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `models` ON `joinProjects`.`model_id` = `models`.`model_id` WHERE `joinProject_featured`.`id` IN (6) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> models.model_id" } ] }, "projectFeatured": { "stage": { "project_id": 315, "name": "Operational", "projectFeaturedId": 6, "id": 14 }, "projectCostBenefit": { "projectFeaturedId": 6, "id": 315 }, "projectCity": { "project_id": 315, "city": { "projectCityId": 7883, "name": "Regina", "id": 116 }, "projectFeaturedId": 6, "cityId": 116, "id": 7883, "projectId": 315 }, "organization": { "sponsor": false, "project_id": 315, "imisId": 19851, "projectFeaturedId": 6, "name": "Saskatchewan Ministry of Education", "typeId": 1, "id": 176 }, "start": "2017-10-04", "project": { "yearDebt": "2016", "psc": 182000000, "postConstructionTerm": 30, "descCostSavings": "VFM Report (2015$)", "vfmDate": "2015-12-01", "preferredConsortiaId": 218, "modelId": 6, "costSavings": 30900000, "description": "

Opportunity

\n\n

Saskatchewan’s economy and population have experienced unprecedented growth over the past several years, placing increased pressure on the public education system. In response, the Saskatchewan Government built 18 new publicly owned and operated elementary schools on joint-use sites in four of the province’s fastest growing regions. Each joint-use site has two schools—one public and one Catholic—offering educational programming for children ranging from pre-kindergarten to grade 8.

\n\n

Procurement for the schools began on July 31, 2014 when the Government announced that it would proceed using a P3 model to construct the schools concurrently. On June 15, 2014 the government announced Joint-Use Mutual Partnership as the preferred proponent team for both projects and two months later it signed two separate project agreements with the Consortia. The schools welcomed their first students in September 2017.

\n\n

Results

\n\n
    \n\t
  • Joint-Use Schools 1 resulted in six schools on three sites in Regina creating space for 3,300 students and 270 childcare spots operated by a third party.
  • \n\t
  • Design features include flexible layouts and a variety of learning spaces ranging in size and configuration; smaller learning communities of similar age group students allowing for project based learning and teacher collaboration; daylight in al learning areas; and support of 21st century learning.
  • \n
\n\n

“Financial analysis, conducted by external experts, demonstrated that a P3 model will deliver the best value for Saskatchewan taxpayers. Our industry consultations indicate there is local and national interest in the projects and this competition will help drive innovation and savings.”

\n\n

- Gordon Wyant, Minister responsible for SaskBuilds

\n", "vfmUsed": true, "ownerId": 176, "isHorizontal": false, "descProjectCost": "VFM Report (2015$)", "ontimeConstruction": 0, "yearProjectCost": "2015", "customers": 11910, "id": 315, "subSectorId": 21, "yearEquity": "2016", "stageId": 14, "descDebt": "CCPPP Case Study", "finSubcompletionTime": "658", "sectorId": 8, "greenfieldId": 1, "descPsc": "VFM Report (2015$)", "yearCostSavings": "2015", "constructJobs": 700, "pscCost": 233200000, "active": true, "marketValue": 186000000, "costAgreement": 186000000, "yearCostAgreement": "2015", "yearPsc": "2015", "projectCost": 202300000, "procureTimeActual": "1 Year 17 Days", "projectFeaturedId": 6, "name": "Saskatchewan Joint-Use Schools Project #1", "descPscCost": "VFM Report (2015$)", "yearPscCost": "2015", "consortiaId": 646, "descEquity": "CCPPP Case Study", "tenderTypeId": 2, "comFinTime": "2 Months 3 Days", "nextStageId": 15 }, "model": { "project_id": 315, "name": "Design-Build-Finance-Maintain", "projectFeaturedId": 6, "id": 6 }, "projectProvince": { "province": { "projectProvinceId": 8519, "name": "Saskatchewan", "id": 12 }, "project_id": 315, "projectFeaturedId": 6, "id": 8519, "projectId": 315, "provinceId": 12 }, "id": 6, "projectId": 315, "projectConsortiaOrganizationRoleStages": [ { "organizationId": 388, "project_id": 315, "roleId": 376, "projectFeaturedId": 6, "consortiaId": 646, "id": 1225, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1225, "id": 646 }, "stageId": 30 }, { "organizationId": 1420, "project_id": 315, "roleId": 373, "projectFeaturedId": 6, "consortiaId": 646, "id": 1226, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1226, "id": 646 }, "stageId": 30 }, { "organizationId": 564, "project_id": 315, "roleId": 273, "projectFeaturedId": 6, "consortiaId": 646, "id": 1227, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1227, "id": 646 }, "stageId": 30 }, { "organizationId": 2017, "project_id": 315, "roleId": 273, "projectFeaturedId": 6, "consortiaId": 646, "id": 1228, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1228, "id": 646 }, "stageId": 30 }, { "organizationId": 806, "project_id": 315, "roleId": 298, "projectFeaturedId": 6, "consortiaId": 646, "id": 1229, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1229, "id": 646 }, "stageId": 30 }, { "organizationId": 2018, "project_id": 315, "roleId": 298, "projectFeaturedId": 6, "consortiaId": 646, "id": 1230, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1230, "id": 646 }, "stageId": 30 }, { "organizationId": 441, "project_id": 315, "roleId": 144, "projectFeaturedId": 6, "consortiaId": 646, "id": 1231, "projectId": 315, "consortia": { "name": "Joint Use Mutual Partnership #1", "projectConsortiaOrganizationRoleStageId": 1231, "id": 646 }, "stageId": 30 } ] } }