SCRAM

System Profile

Technology Assessment

Environment Access Information

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?).

Good To Know

Open SCRAM project by open the Web site of SCRAM-SURCA project on devOps

If there is any error of running this application in local host, please change the web.config:

Remove any line with this beginning <!-- #include at these places

App_header_e.aspx

App_footer_e.aspx

App_heaeder_f.aspx

App_footer_f.aspx

→ 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

Fix:

For ex: it is required to update hourly rate $43.03 effectively on 2022-04-01

Insert into SCRAM.NEWS
(NEWS_ID, NEWS_DATE, NEWS_MESSAGE, NEWS_LANGUAGE)
Values
(4, TO_DATE('2022/04/01', 'YYYY/MM/DD'), '43.03', '4');

After inserting in SCRAM prod database, here are the values of NEWS

Note: we have to make sure the new_dates have to be in order from oldest to newest corresponding with news_languages' sequence so the fee can be calculated correctly.

Test with clients in Acceptance

1. 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” 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.

4) Under Billing tab at that project, choose the start date and end date of the hourly billing to cover the date we want to check the updated fee, make sure to check boxes on the entered hours under Cost Recovery,

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