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

<--->

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 sorted ascending corresponding with news_languages ascending .

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

3) Add hours to test and click Save, these hours will be shown under Billing tab and we need to click on check mark if we want to include those hours in billing (See step 4).

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