Set Exam Language To Fix Request In Wrong Language

Owned by Roxanne Lafleur (Unlicensed)
Jul 03, 2019
2 min read
  • Work Process - Purpose
    • To give the Operator a test link which starts his/her exam in the correct language.
  • Work Process - Summary
    • Having seen exams defined in one language in the TM104_EXAM_GROUP_VERSIONS table resulting in a test link which start the exam in the other language is something which has occurred in the past.  This provides a way to fix this but requires sending a new test link to the Operator.
  • Contribution Of The Client Group To The Work Process
    • Operator info such as first name, last name and date of birth are required and will be provided by the Client Group.
  • Steps Of The Work Process
    • When calling our Web Service, language is defined and entered in two tables: TM110_PCOCTO_OPERATOR and TM104_EXAM_GROUP_VERSIONS. Values are defined in the TC028_LANGUAGE table and are as follows:

      • 0 for BILINGUAL which will default to ENGLISH

      • 1 for ENGLISH
      • 2 for FRENCH

    • Since it is the value in TM104_EXAM_GROUP_VERSIONS, column LANGUAGE_CD which is being used to generate the test link, only this one needs to be updated as such :

      UPDATE TM104_EXAM_GROUP_VERSIONS

      SET LANGUAGE_CD = '1'

      WHERE EXAM_GROUP_ID = '964105';

    • The next step will now be to re-create the exam link for the Operator to use. For this we take the first part of the link which is the Test URL to our Servers containing the language parameter and make sure the value used is correct:

      https://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/to/p1000.aspx?lang=1

    • We then add the token at the end of the query string and click the link to the Test (WITHOUT STARTING THE ACTUAL TEST) to verify it is in the correct language:

      https://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/to/p1000.aspx?lang=1&token=9D5DDE62466847EDB32F9BD296F0ED70

    • Once this is verified, we copy the link to a response email we can send to our Client Group and advise them to send it to the Course Provider in order for him to transfer to the Test Operator.