Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

There are two steps to fix this issue:

Step 1: If no results are found, the ‘Transfer Results’ have to be removed so that the AEI can re-upload the results file. This is done by going to the table CDE_EXAM_EMAIL_REQUEST_LOG and clearing the following fields for the affected AEI :

·        IMPORTED_AND_TRANSFERRED

·        IMPORTED_AND_TRANSFERRED_BY

·        IMPORTED_AND_TRANSFERRED_DATE

 The FTAE System Administrator is subsequently notified that the above fields have been cleared and the next step is for the FTAE System Administrator to enter the examination results manually. This means that the exam was requested by the AEI (found in FTAE_DBA.CDE_EXAM_RESULTS_IMPORT_LOG)

 Step 2: After the FTAE System Administrator has entered the examination results manually from the feedback letter, another IM is sent to attach the examination results to the CDE line for the school. This is where the FTAE_DBA.FTAE_EXAM_RESULTS_FILE will have to be connected to the FTAE_DBA.CDE_EXAM_RESULTS_IMPORT_LOG.

Here are example requests for this problem (Example IM352754, IM350943, and IM355699)

In FTAE – Personnel – 605265 (Junyoung Cho), could you please attach the CPAER 023 examination results to the CDE line for School ID 0059, AEI 0129, exam date 2021-06-17? AEI does not have the electronic results file so results were entered manually from the feedback letter

Could you please enter an IM in Service Manager and forward it to CAAST?

            In FTAE – CDE External, there is a ‘Blank Results’ File:

            School ID 0059 – Brampton Flying Club

            AEI0129 – Judy Piccioni

            Date – 2021-06-17

            Exam – CPAER 023

            Candidate – 605265

  • Login to FTAE

  • Click the Personnel icon at the top.

  • Select the Search by 5802 or Name menu item

  • Enter, for this example, 605265 in the 5802 File Number field and select enter.

  • The Personnel screen appears showing the 5802 605265 and the name of the person.

  • Go to the Examinations tab. The exam for which the problem occurs (mentioned in email or IM) will appear in the list. Select that row. In this case, the examination is CPAER 023. This is the record that you will want to fix.

  • Select the Details icon at the top to see the Examination detailed information.

  • Select the Responses tab at the right hand side of the screen

  • In addition, you can also click on the CDE icon, and select the External – Auditing menu item. This list is a little slow and may take time to appear.

  •  Select the row with the AEI (0129) – Judy Piccione who invigilated the exam. Then find the exam

  • You can then right click on the row and select Display Examination Result menu item to see the results of the examination

  • Scroll to FTU 1104

  • Find the record that you want to fix

  • Find the exam email file

   SELECT ROWID, CDE_USERID, CANDIDATE_5802, EXAM_TYPE, QBANK_TYPE, EMAIL_SENT_DATETIME,

REQUEST_REMARKS, REQUEST_CANCELLED, CANCELLED_BY, CANCELLED_DATE,

DOWNLOADED_AND_SENT, DOWNLOADED_AND_SENT_BY, DOWNLOADED_AND_SENT_DATE,

   DOWNLOADED_AND_SENT_SERIES, DOWNLOADED_AND_SENT_VERSION,

   IMPORTED_AND_TRANSFERRED, IMPORTED_AND_TRANSFERRED_BY,

   IMPORTED_AND_TRANSFERRED_DATE, REQUEST_DELETED, ALREADY_PAID_DO_NOT_INVOICE

   FROM FTAE_DBA.CDE_EXAM_EMAIL_REQUEST_LOG

   WHERE CANDIDATE_5802 IN ('place the CANDIDATE_5802 here') AND

EXAM_TYPE = 'place the EXAM_TYPE here'

ORDER BY EMAIL_SENT_DATETIME DESC;

  •  Fill in the bottom five fields as follows:

IMPORTED_AND_TRANSFERRED = 'Y'

IMPORTED_AND_TRANSFERRED_BY = 'AVONC'
IMPORTED_AND_TRANSFERRED_DATE = now (keep this date handy for the next step)
REQUEST_DELETED leave null
ALREADY_PAID_DO_NOT_INVOICE leave null

  •  See if an import record is present (there probably won't be one)
    -- If one is present, update it as shown
    -- If none is present, create a new one as shown

 SELECT ROWID,
 FTAE_USERID, <'AVONC'>
 IMPORT_DATETIME, <this is the IMPORTED_AND_TRANSFERRED_DATE in the above record>
 CDE_USERID, <this is the AEI's userid, CDE_USERID from the above record>
 CANDIDATE_5802, <Chantal entered this in her email>
 EXAM_TYPE, <Chantal entered this in her email>
 EXAM_SERIES, <Chantal entered this in her email>
 EXAM_VERSION,<Chantal entered this in her email>
 ATTEMPT,<Chantal entered this in her email>
 QBANK_TYPE, 'F' if a flight crew exam, 'A' if an AME exam
 REQUEST_LOG_DATETIME, <this is the EMAIL_SENT_DATETIME from the above record>
 CANDIDATE_RESPONSES, <this can be retrieved from the ORIGINAL_ANSWER column in the FTAE_DBA.FTAE_EXAM_RESULTS_FILE>
 TOTAL_EXAM_MINUTES, <Ask Chantal if this is not entered in email>
PAUSED_COUNT, <0>
 RESTART_COUNT, <0>
 PWD_ATTEMPT_COUNT, <0>
 EF_TOGGLE_COUNT, <0>
 FEEDBACK_PRINT_COUNT, <0>
 FEEDBACK_NO_PRINT_REASON, null
 RESULT_TRANSFERRED, <'Y'>
 RESULT_TRANSFERRED_BY, <'AVONC'>
 RESULT_TRANSFERRED_DATE <this is the IMPORTED_AND_TRANSFERRED_DATE in the above record>
 EXAM_DATE <Chantal entered this in her email>
 FROM FTAE_DBA.CDE_EXAM_RESULTS_IMPORT_LOG
 WHERE CANDIDATE_5802 IN ('000001') AND EXAM_TYPE = 'ASAMP'
ORDER BY REQUEST_LOG_DATETIME;

  •  Ensure that the record has changed by clicking the Retrieve Again button to see that the results have been uploaded

  • No labels