System Profile
System Full Name | National Aviation Company Information System |
System Full Name (French) | Système d'information national des compagnies aériennes |
Business Administrator | Kevin Banh |
Business Owner | Deborah Martin |
Director | Felix Meunier |
Subject Matter Expert | |
Division | |
NTARS Code | CA29 |
Source Location | |
Source Code Location | |
Migration to DevOps | |
New Source Code Location (DevOps) | |
Technology Assessment
Platform Type | Citrix |
|---|---|
Database Platform and Version |
Oracle 18C |
Development Language and Framework |
|---|
Appeon PowerBuilder 2021 | |
Operating System and Version | Windows Server 2016 |
|---|---|
Additional Dependencies | |
Authentication |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | NNDEV | |||
PREACC | NNPROJ | |||
ACC | NNCLNT | |||
PROD | NNPROD | |||
TRAINING | NNACEP |
System Overview
<--->
Good To Know
<--->
How-To and Fixes
<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >The National Aviation Company Information System (NACIS) is used by Civil Aviation Safety Inspectors to record and manipulate the authorities and delegations issued to industry, to generate, print, and issue official operating certificates and acceptance letters on behalf of the Minister under the Aeronautics Act and related regulations. It is also used to organize, schedule and track the results of the audits and inspections conducted by Transport Canada, as well as providing key services and information to several Civil Aviation functional and operational Branches and regions related to regulatory oversight.
Good To Know
Document | RDIMS# or Link |
|---|---|
NACIS Document Tracking Sheet | |
Standard 421 Appendix A: Aircraft Type Designator Tables includes Blanket and Individual Type Ratings - Canadian Aviation Regulations (CARs) | |
Developer Notes |
In terms of the NAPA_NACIS database, here are the servers:
Development (NNDEV): Host = tcdevpkgb
Pre-Acceptance (NNPROJ): Host = tcdevpkgb
Client Acceptance (NNCLNT): Host = tcdevpkgb
Production (NNPROD): HOST = TCPRDPKGB
Training (NNACEP): Host = tcdevpkgb
To have access in this application, you need to send an e-mail to Kevin Banh.
How-To and Fixes
How to add and remove email addresses for the FAOC Expiry Notification List
(1) Logon to the NACIS Production database NNPROD.
(2) Go to table NACIS_SETTINGS
(3) Go to Code value 92, Description FAOC EXPIRY NOTIFICATION SCHEDULED JOB and add or remove values (email addresses) in the TEXTUAL_VALUE field.