SFOC Creation Tool

System Profile

System Full Name	Complete a Special Flight Operations Certificate (SFOC)
System Full Name (FR)	Certificats d’opérations Aériennes Spécialisées (COAS)
Business Support Team
Business Administrator	Sylvain Bourque
Business Owner	Alex Shadeed
Director	Ryan Coates
Subject Matter Expert	Peter Khouri
Division
NTARS Code
Option Analysis document	https://034gc.sharepoint.com/:p:/s/DroneDEVteam/EU8W_fqlqoJKrbFTDgrM-VsBGvKDkSsa1nd8YOK9_1SNTQ
App registration	https://portal.azure.com/#blade/Microsoft_AAD_RegisteredApps/ApplicationMenuBlade/Overview/appId/22897920-2e0b-4e97-80ca-fbc41c5805cb/isMSAApp/
KeyVault	https://portal.azure.com/#@034gc.onmicrosoft.com/resource/subscriptions/fde9cf97-7bf0-4373-9fbd-eba18c6e0dfc/resourceGroups/TC-DevTest-CivAv-RGP/providers/Microsoft.KeyVault/vaults/civav-dev-keyvault/overview
Source Code Location	https://dev.azure.com/transport-canada/AFCCC-Civil-Aviation-RPAS/_git/SFOC
Source Code Power Automate	https://canada.flow.microsoft.com/manage/environments/Default-2008ffa9-c9b2-4d97-9ad9-4ace25386be7/flows/shared/64120641-bc51-41b8-9ca3-1c6c9122196a/details
Source Code Azure Functions	https://dev.azure.com/transport-canada/AFCCC-Civil-Aviation-RPAS/_git/SFOC?path=/DocumentMerge
Excel file with questions	https://034gc.sharepoint.com/:x:/r/sites/SFOCInspectors-InspecteursCOAS/_layouts/15/Doc.aspx?sourcedoc=%7BDE1D7B79-A182-44BB-84CF-3C9948B261A7%7D&file=SFOC%20Creation%20Tool%20Questions.xlsx&action=default&mobileredirect=true

How-To and Fixes

Word template document folder with SFOC tool questions

Updating document links in Populate Word template

Updating questions Yes/No cases with new Word template

Technology Assessment

Platform Type	Web (Internal)
Database Platform and Version
Development Language and Framework
Operating System and Version
Additional Dependencies	Visual Studio 2022
Authentication	Azure AD

Environment Access Information

ENV	UNC	URL	DB
DEV	Cloud-deployed	https://civav-dev-web-sfoc-coas.azurewebsites.net/	N/A
ACC	Cloud-deployed	https://civav-acc-web-sfoc-coas.azurewebsites.net/	N/A
PROD

System Overview

Good To Know

Initial documentation: /wiki/spaces/DDMP/pages/2364997634

No information will be saved in a database. All information is considered transient information inside the flow.

Azure Resources

Resource	Development	Non-Production
App registrations	CivAv-Dev-Reg-SFOC-COAS	CivAv-Acc-SFOC-COAS
Resource Group	TC-DevTest-CivAv-RGP	NPRD-CACN-SFOC-TEST-RGP	NPRD-CACN-SFOC-ACC-RGP
Key vaults	civav-dev-kv-sfoc-coas	civav-test-kv-sfoc-coas	civav-acc-kv-sfoc-coas
App Services	civav-dev-web-sfoc-coas	civav-acc-web-sfoc-coas
Function App	civav-dev-fn-sfoc-coas
Blazor App App Service Plan	ncasafsecsurasp (Linux)	civav-acc-plan-sfoc-coas
App Service Plan Azure Function	ASP-TCDevTestCivAvRGP-a8fb (Windows)
Container registries	civavcontainerregistry

Note: We have one container registry for Civav’s portfolio in Development and Non Production environment because of the cost related to this resource.

Deployment

Dev Environment

App Service

Note¹: It’s important to create a service connection in your DevOps project to have access to Azure’s resources inside your resource group.

Note²: It’s important to create a service connection in your DevOps project to have access to the Civav container registry

How-To and Fixes

Get a Power Apps license to be able to save Flows with Premium features. This link will direct you to a Power Apps License Request form.

Power Apps Per User License Request - Power Apps

Assets

Diagrams source files (to be opened in Draw.io):