GC Enterprise IT Portfolio FAQs

From wiki
Revision as of 14:58, 19 November 2019 by Jana.jessome (talk | contribs)
Jump to navigation Jump to search


Home IT Expenditure Application Portfolio Management (APM) IT Plan FAQs



IT Expenditure[edit | edit source]

High-Level IT Expenditure Model Questions[edit | edit source]

Question: For the IT Expenditure Model, can you briefly explain the various schedules and the linkages between them?

Answer: The Schedules of the GC IT Expenditure Model and their linkages are as follows:

Schedule 1 – Total High Level Expenditures

  • Combines Schedule 2 – High-Level Expenditures OPEX and Schedule 3 – High-Level Expenditures CAPEX worksheets to provide an overall departmental expenditure summary.

Schedule 2 – High Level Expenditures OPEX: Summary level operational expenditures aligned to the GC Profile of IT Services;

  • The expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources, etc.) of Schedule 4 (OPEX) are automatically populated in the "Distributed Computing" “Column” and respective “Rows” of Schedule 2.
  • The combined expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources etc) of Schedule 5 (OPEX) are automatically populated in the "Application / Database Development and Maintenance" “Column” and respective “Rows” of Schedule 2.

Schedule 3 – High Level Expenditures CAPEX: Summary level capitalization expenditures aligned to the GC Profile of IT Services;

  • The expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources, etc.) of Schedule 4 (CAPEX) are automatically populated in the "Distributed Computing" “Column” and respective “Rows” of Schedule 3.
  • The combined expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources etc) of Schedule 5 (CAPEX) are automatically populated in the "Application / Database Development and Maintenance" “Column” and respective “Rows” of Schedule 3.

Schedule 4 – Distributed Computing Environment (DCE) Services (OPEX and CAPEX): Expenditures for each of the services under DCE, defined in the GC Profile of IT Services;

  • The expenditures from Schedule 4 (OPEX) “Total” column and respective rows (i.e. Hardware, Software, Human Resources, etc.) should match & link with the "Distributed Computing" “Column” and respective “Rows” of Schedule 2 High level Expenditures OPEX.
  • The expenditures from Schedule 4 (CAPEX) “Total” column and respective rows (i.e. Hardware, Software, Human Resources, etc.) should match & link with the "Distributed Computing" “Column” and respective “Rows” of Schedule 3 High level Expenditures CAPEX.

Schedule 5 – Application / Database Development & Maintenance Services by Application Domains (OPEX and CAPEX): Expenditures related to Application / Database Development & Maintenance, aligned to the Application Domains as originally introduced as part of Application Portfolio Management (APM);

  • The combined expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources etc) of Schedule 5 (OPEX) are automatically populated in the "Application / Database Development and Maintenance" “Column” and respective “Rows” of Schedule 2.
  • The combined expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources etc) of Schedule 5 (CAPEX) are automatically populated in the "Application / Database Development and Maintenance" “Column” and respective “Rows” of Schedule 3.

Schedule 6 – Application / Database Development & Maintenance Services by Outcome Areas (OPEX and CAPEX): Expenditures related to Application / Database Development & Maintenance, aligned to the Outcome Areas and Internal Services;

  • Note on Schedule 5 and 6: The combined expenditures from the “Total” column and respective rows (i.e. Hardware, Software, Human Resources, etc) of Schedule 5 and 6 should match.
  • There should also be internal consistency between the columns which are linked to Internal Services domains and the Internal Services Outcome Area, and the Other domain and the Program Outcome areas.
    • Looking at the ADDM by App. Domains OPEX tab, the columns for the Application Domains "Acquisition" through "Legal" are the Internal Services domains. Therefore the subtotals of these columns should be equal to the subtotal for the ADDM by Outcome Areas OPEX tab Internal Services column.
    • Looking at the ADDM by Outcome Areas OPEX tab, all Outcome areas except Internal Services are the Program Outcomes, broken first by portfolio (Ecomonic Affairs through Government Affairs) and then into specific Outcomes. The subtotal of all program Outcome Areas should be equal to the ADDM by App. Domains OPEX "Other" column subtotal.
    • The same follows for the CAPEX tabs.
    • If your totals do not balance, the system will give you an error when you attempt to approve the High Level Expenditures (OPEX or CAPEX) schedules (2 and 3).

Schedule 7 – Notes: Annotated notes that departments wish to provide by individual Schedules 1 to 4 or an itemized list (for example One-time expenses; Special events e.g. Winter Olympics, G8 Summit; Ever greening etc.) of notes.

  • Include any pertinent information that would inform TBS regarding your OPEX/CAPEX decisions. For example, if your department does not have a Capital Vote, and therefore did not report capitalized expenditures separately, this should be noted.
Question: Can you describe important changes to the report?

Answer:

  • The report has been split into Operational cost (OPEX) and Capitalization cost (CAPEX) sections, with respective tabs for each.
  • The External Services expenditure category was broken apart on all schedules to allow cloud service-related expenses to be identified as separate from other professional services.
  • In the model file, the amount of error checking has been increased, in order to improve reporting quality by departments.

Note: It is important that no structural changes are made to the worksheets, e.g. addition or deletion of rows or columns, as it will impact the functioning of formulas and error checking.

Question: Does my department need to report both Operational (OPEX) and Capitalization (CAPEX) expenses?

Answer: You must report CAPEX costs if:

  • your department capitalizes IT expenses, and
  • your department has a capital vote.

You may report CAPEX costs (but are not obligated to) if:

  • your department capitalizes IT expenses, and
  • your department does not have a capital vote.

In this case, if you choose not to report CAPEX costs, these costs should be included on your OPEX tabs. You should not leave these costs out.

If your department does not capitalize IT expenses:

  • you would report all expenses on the OPEX tabs.
Question: Does my department have to report on DCE Services (Schedule 4, previously Schedule 2)?

Answer: There was an error made in the training deck that was presented for the 2015/16 IT Expenditure report. For that year, TBS allowed departments to group their DCE Services (Schedule 2 at the time) expenses under a total column, instead of breaking it down into separate service lines. The change was somewhat late-breaking in nature, therefore the IT Expenditure Guide, and the FAQ page were not updated to match the altered version of the IT Expenditure Model, which was posted on GCconnex. This led some departments to believe that they did not need to report on Schedule 2 at all, since both the original and modified templates were available.

The following year, the error was not caught, and TBS reverted back to the original model. Therefore, departments who had mistakenly used the original model and not reported on Schedule 2 were not made aware of the error. Additionally, some departments continued to use the amended model, and this was also not caught, though reporting in a grouped manner was no longer supported.

To clarify, reporting on DCE Services (Schedule 4) is mandatory. Please use the most current model, version 1.4. All previous models have been deprecated, and will not be accepted by TBS.

Application Portfolio Management (APM)[edit | edit source]

Question: Do I include GCDocs in APM?

Answer: The official line is that departments don’t need to include GCdocs in their APM if they are hosted by another Department.

That said, some do include it in APM, but set the “Include in Portfolio Assessment” to “No – out of scope”.

There are situations where Departments have many instances of GCdocs, one local for Secret network, and one hosts by PSPC.

Some have also setup Dev/testing environments local, but set the Status to “In Development”.

So it varies, if it’s hosted, you don’t need to include it. The same goes for GCConnex and the GCTools, no need to include in APM.

Question: What value is to be used for the SSC Primary Data Location for Cloud applications? Should this field be left blank for Cloud apps? If so, then on the Dept. Dashboard, the number of cloud applications will show as 'Not Specified' in the Data Centre chart.

Answer: If you have an application in the cloud, please set the "SSC Primary Data Centre" field blank and set the "Deployment Model" appropriately. TBS will adjust the Dashboard for WLM accordingly to outline applications already migrated to the cloud.

Question: Just wondering what value is to be used for the SSC Primary Data Location for Cloud applications. Should this field be left blank for Cloud apps? If so, then on the Dept. Dashboard, the number of cloud applications will show as 'Not Specified' in the Data Centre chart. Please advise.

Answer: If you have an application in the cloud, please set the "SSC Primary Data Centre" field blank and set the "Deployment Model" appropriately.

TBS will adjust the Dashboard for WLM accordingly to outline applications already migrated to the cloud.

IT Plan[edit | edit source]

Question: Why an extract on Feb 28?

Answer: The Feb 28th extract is the next quarterly update after the Nov 15th extract, will be the basis for the written plan numbers.

Between the Nov 15th and Feb 28th, Departments are to work with their SSC Client Executive to confirm capacity and plans for the 2020-21 Fiscal year.

Question: What is SSC 3.0?

Answer: SSC 3.0 will take an enterprise approach that will build upon other Government of Canada programs such as “[Tell Us Once”], the Cloud First Adoption Strategy, and the Directive on Automated Decision-Making for the responsible use of artificial intelligence. SSC is committed to a team-based, collaborative approach that will engage, enable, and empower SSC employees to help provide the digital services Canadians expect. SSC 3.0 will support a government-wide Enterprise Digital Workplace Platform. This means federal public servants will have access to devices ranging from mobile to traditional workstations from anywhere. SSC 3.0 will prepare us to leverage new digital technologies to the fullest across the GC and to deliver the best possible services to Canadians. For more information please see: https://www.canada.ca/en/shared-services/ssc-3-enterprise-approach.html

Question: SSC to define when a BRD is needed vs. a ticket

Answer: Look at SSC catalogue, "how to order" is identified on their site Click on the "Order" button to determine which services require a BRD

Question: Can MAF Q1 apply to activities as well? Gate 6+ was identified in the question

Answer: TBS appreciates the need for clarification on indicator Q1. All IT Plan investments (projects or activities) will be considered as effort to improve the aging IT in the GC. So long as the IT Plan identifies the activity as an ongoing operational activity, it will be included in the numerator of Q1 B and Q1 C.

Question: Where can I get a list of projects which require DARB approval for MAF Q2?

Answer: A list of CEPP projects which may apply to Q2 MAF has been posted here: Question 2B - List of CEPP projects. It is up to the Departments to assess the PCRA level of each project against their OPMCA level.

Question: CIO reporting to DM - Many departments are concerned about the need for continuous updates to IT Plan as well as Deputy Head approval

Answer: TBS is not seeking additional attestation letters from your Deputy Head. However, as per the Policy, your Deputy Head in accountable IT Plan investments no matter when it is added to the system. Deputy Head sign-off is still required before submitting the online data to OCIO. It is up to the Departments to decide the appropriate process to ensure Deputy Head approval of all IT investments since this could have a significant demand on partner organizations. In addition, the ADM CEPP May 8th deck identified that CIOs need a seat at the executive table. The Feb 28th date simply represents the next known date for our usual Quarterly update of IT Plans for CEPP prioritization.

TBS will only be looking for two attestation pieces:

Signed attestation March 31 by Deputy Head

Checkbox in Clarity on Nov 15th to identify Deputy Head and CIO approval of itemized investments

Question: Can you clarify what is happening with services?

Answer: In previous years, services were entered/managed in Clarity and applications were linked to those. There was reference to a new application being implemented for services this year, but yet service information is still in Clarity. Can you clarify what is being done with regard to services? Are they being entered/managed in Clarity or in a different tool?

It’s best to work with the team in your Department who completed the GC Service Inventory to ensure that applications can aligned as much as possible. This list of GC services is stored in another system (outside of Clarity.)

Once the GC Service Inventory is available to our team, we will do some fit-gap reports and share with the community to identify next steps and impacts.

The intent is to eventually have a single list of Services with all application linked to those services in order to inherit the mission criticality.

Further guidance will be forthcoming from TBS regarding the intersection of GC Services, APM, Mission criticality and CBAS in the coming months.

The services team has developed a FAQ which touches upon this question:

En: https://gcconnex.gc.ca/file/view/50149777/faq-english?language=en

Fr: https://gcconnex.gc.ca/file/view/52484313/faq-francais?language=en

Question: November through March, how do you interpret "this fiscal year" in AQ1 and AQ2 if we are looking at next year’s planning? Is it the current year? Or next year?

Answer: The guide states "this fiscal year", however, this would not be effective for next year’s planning activities which are due November 15th. This “fiscal year” should represent the date a project passes Gate 3 (Business case and general readiness ◦For confirmation of funding and business outcomes).

Question: What is the right Level of Detail for the IT Plan items?

Answer: Many departments wonder, “What is the right level of detail for the IT Plan?” Should I report every project/run activity on a separate line item? Should I have 100 line items? 20? It is sometimes hard to know at what granularity to report so the following should give departments a bit of guidance.

Projects should be broken down individually. One line item should correspond to a departmental project.

Run activities should be regrouped and rolled up to a few line items. There are a few ways in which a department may choose to do so:

  • A natural breakdown that already exists internally, for example, by directorate or sectors
  • By service lines
  • By IT Expenditure categories
  • Or other groupings

Regrouping Run activities does not decrease their visibility, it simply bundles them up. These activities are non-discretionary, and do not require a high-level of granularity. TBS does analysis on all the IT Plans and if some discrepancies are noticed (i.e. the Run one year greatly differs from other years), it will be challenged.

Departmental IT Plan data from Clarity is used to report a demand profile at a high level. Analysis is done also at a high level, and when needed, TBS will engage with departments to further understand the data or to challenge it. No conclusions are made solely by TBS on departmental data. Furthermore, departments should be engaging with their account teams at SSC to ensure a common understanding of the data in Clarity.

Question: What if my project is not approved? Should I include it in the IT Plan?

Answer: Yes, the IT Plan is a plan and should give TBS & SSC a forecast for the next three years when it comes to departmental projects and run activities. In the essence of a continuous update model, departments should be updating Clarity regularly to account for new changes and additional information on projects and run activities. We are expecting departments to include a list of their approved projects as well as their forecasted projects/activities for the next two years (2020-2021).

Question: All my prioritization & achievability scores are now 0, where did they go and why?

Answer: When changes were brought to the GC Prioritization Framework, some of the questions were changed and some answers modified. Furthermore, all the questions were included in Clarity to facilitate reporting and generate scores automatically once the answers are selected and answered. In order for your scores to be generated, you will have to answer all of the prioritization and achievability questions.

Question: My score isn’t appearing even though I’ve answered all the questions in Clarity related to the GC Prioritization Framework, why?

Answer: In order for the score to appear, you need to answer all of the questions, save the page and Refresh it as well. This should make your score appear.

Question: What can I expect following the fall submission deadline?

Answer: The initial focus for the first reporting date following the fall deadline on Nov. 15 2019 will the new or additional work requiring SSC Services. Departments are required to include in their IT Plan any new work for SSC for 2020/21 and 2021/22. Including this work early on will give SSC the chance to lay the groundwork needed to be ready to provide the services needed by departments earlier and anticipate their workload.

TBS will conduct analysis and create a demand profile of departmental IT Plan data and work with SSC to create a full picture of demand and supply and what the next two years would look like. Here are a few things that will be analyzed:

  • looking at alignment to priorities
  • sustainability & end-of life, how departments are investing to maintain their application portfolio health
  • SSC services
  • other analysis
Question: How do I request a Clarity license?

Answer: Departments can submit their requests for licenses to CIOB-DPPI IT-Division-TI ZZCIOBDP@tbs-sct.gc.ca and their request will be actioned. Departments are required to notify if any licenses need to be deleted or replaced to keep the licenses as up to date as possible.

Question: How do I export data from Clarity?

Answer: When in Clarity, departments can go into their IT Plan dashboard, and for any given portlet[1], there will be a cog[2], if you click on it, a few options will pop up and you can click on Export to Excel (Data Only). This will give you a table with the columns you see in Clarity into Excel.

Clarity img1.png


  1. A portlet is a table populated with data from a source; in this case, this IT Plan data from your department.
  2. The wheel at the top right corner of the portlet.
Question: Is there a data loader for the IT Plan, like for APM?

Answer: No, there is no data loader for the IT Plan. APM has a linear relationship between its values unlike the IT Plan.

Question: Is the Prioritization Framework and the Decision Framework the same thing?

Answer: No, the Prioritization Framework are a set of questions that the departments answer in order to obtain a prioritization score and an achievability score. Following that, TBS applies a Decision Framework which is a set of business rules to further prioritize the items into three priority groups.

Question: Why do we compare this year’s IT Plan against last years Expenditures?


Answer: The intent of the MAF indicator is not to look at the problem with an auditing or evaluation lens by comparing the same year. We wanted to evaluate the planned expenses of the most recent IT Plan against facts in hand proving good judgment and completeness. It has a goal of nudging behaviour.

The two years can be different, which is the 15% buffer which we have added into the calculation. That said, further justifications to the MAF team can be submitted should there be a need to explain significant differences.




Need help? Contact us.


Envelope icon orange.png
Cop icon orange.png
GCconnex icon orange.png