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
Business Owner	Alex Shadeed
Director
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

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		Production
App registrations	CivAv-Dev-Reg-SFOC-COAS			CivAv-Prod-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
App Services	civav-dev-web-ci-sfoc-coas		civav-acc-web-sfoc-coas
Function App	civav-dev-fn-sfoc-coas
App Service Plan (Linux)	ASP-TCDevTestCivAvDevelopment		civav-acc-plan-sfoc-coas
App Service Plan (Windows)	ASP-TCDevTestCivAvRGP-a8fb
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