Fix to the wrong candidate entrance issue
This is the issue when the wrong candidate is entered for an exam…
We will use this example
In FTAE – CDE – External Auditing, under FTU 1104 Durham Flight Centre Inc. The wrong candidate 113117 (Newton John Henry Little) was entered. The correct candidate should be 848619 (Slawomir Terlecki). The examination itself has already been moved into the correct file number (848619).
Verify that the data is in-accurate
Login to FTAE
Click the CDE icon, external auditing
Scroll to FTU 1104 (You will see the wrong candidate 113117 (instead of 848619)
Change the candidate_5802 number in two TABLES
SELECT *FROM FTAE_DBA.CDE_EXAM_EMAIL_REQUEST_LOG
WHERE CANDIDATE_5802 IN ('113117')
ORDER BY EMAIL_SENT_DATETIME DESC ;
Modify the Correct record by changing CANDIDATE_5802 from 113117 to 848619
Ensure that the record has changed by clicking the Retrieve Again button in FTAE application