Find Exam Token By Operator ID

Owned by Roxanne Lafleur (Unlicensed)
Last updated: Jul 03, 2019
1 min read
  • Work Process - Purpose
    • An easy way of finding a token using a Course Provider provided ID.
  • Work Process - Summary
    • When calling our Web Service to obtain a test token, certain Course Providers will enter in our system an Operator ID generated by their system. This column is NOT UNIQUE but in most cases will be a quick way to retrieve a token by executing only one query.
  • Contribution Of The Client Group To The Work Process
    • In this case, none.
  • Steps Of The Work Process
    • We may query the LM109_EXAM_GRP_TOKEN table directly using one value provided by the Course Provider as such:

      SELECT *

      FROM LM109_EXAM_GRP_TOKEN

      WHERE ORGANIZATION_OPERATOR_ID = '699584';

      For cases like this, ALWAYS obtain the first name, last name and date of birth to make sure the token retrieved is the correct one for the operator as this column is NOT UNIQUE.