System Profile
System Full Name | Standardized Cost Recovery and Activity Monitoring System | |
System Full Name (French) | Système normalisé de surveillance des activités et de recouvrement des coûts | |
Business Administrator | Sharon Domitsu, Kathy Kilpatrick | |
Business Owner | Marc CaouetteLauren McMahon | |
DirectorDavid | TurnbullPhilippe Ngassam | |
Subject Matter Expert | ||
Division | National Aircraft Certification | |
NTARS Code | C110 | |
Source Location | ||
Source Code Location (Archived) | ||
Migration to DevOps |
|
|
New Source Code Location (DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/SCRAM-SURCSA |
Technology Assessment
Platform Type | Web (Internal) |
|---|---|
Database Platform and Version | Oracle 11g18C |
Development Language and Framework | Classic ASP |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | |
Authentication |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | SCRAMD | |||
PREACC | ||||
ACC | SCRAMA | |||
PROD | SCRAMP | |||
TRAINING |
System Overview
SCRAM is an application comprised of two components: Cost Recovery and Activity Monitoring. Data in SCRAM reflects time spent against specific tasks on a daily basis by all employees National Aircraft Certification, including travel and overtime.
The tasks in SCRAM have been aligned with the tasks in ARASS (Activity Reporting and Standards System), which is mandated by the Civil Aviation Directorate. Individuals within National Aircraft Certification do not input data directly into ARASS, but rather the corresponding SCRAM data is uploaded to ARASS by the SCRAM Administrator on regular basic (monthly?)a quarterly basis.
Good To Know
Open SCRAM project by open the Web site of SCRAM-SURCA project on devOps
...
→ we can permanent to remove all these obsolete lines when we make any update on SCRAM source code at the same time. Currently we do not change because we do not feel we need to do this now knowing this application is replaced soon
How-To and Fixes
| Info |
|---|
Update SCRAM fees for new fiscal year (PBI 164454) |
...
After inserting in SCRAM prod database, here are the values of NEWS
...
Note: we have to make sure the new_dates have to be sorted ascending in order from oldest to newest corresponding with news_languages ascending ' sequence so the fee can be calculated correctly.
Test with clients in Acceptance
If there is no available project, importing a project from Napa, for ex: P&WC PT9 Turboprop (Tremblant)
Open SCRAM (use a user id and password to log in)
Select ‘Project’ from the top menu.
Click ‘Import Project from NAPA’
Search window will appear to allow to enter the criteria to search that project
2. Under Projects tab of that selected project, make sure Cost Recovery Project is checked, Hourly Billing is checked and there should be a value in Feecap Amount
...
“Feecap Amount” as shown below.
Currently, we found that if the ‘Feecap Amount” is 0, then there is no credit value returned in the invoice at this place. The client wants to see the value in the invoice, there fore we have to add a value at the ’Feecap'. You can verify this information when testing.
...
3)Select the project under ‘Certification Activities’ list, for ex, this below project belongs to STC group. Then we can add hours to test and click Save. These hours will be shown under Billing tab and we need to click on check mark (of Cost Recovery column in step 4) if we want to include those hours in billing.
...
5) Click on ‘Show Request for Invoice’ or ‘Record for File’ to show the total which reflects the new updated fee. For ex: The ‘Show Request for Invoice' is showing this new updated fee which is $43.03 per hour
...
Test Plans, Suites and Tested Cases imported from TFS
| View file | ||
|---|---|---|
|
...