Find Users By Email

Owned by Roxanne Lafleur (Unlicensed)
Jul 03, 2019
  • Work Process - Purpose
    • To find an Operator or Course Provider user by his/her email address.
  • Work Process - Summary
    • Querying the TM110_PCOCTO_OPERATOR (Test taker) or TC008_USER (Course Provider User) using their email address
  • Contribution Of The Client Group To The Work Process
    • The Client Group to provide the email address from the Operator and Course Provider.
  • Steps Of The Work Process
    • Querying TM110_PCOCTO_OPERATOR table:

      SELECT *

      FROM TM110_PCOCTO_OPERATOR

      WHERE UPPER(OPERATOR_EMAIL_TXT) = 'ROXANNE.LAFLEUR@TC.GC.CA';

    • Querying TC008_USER table:

      SELECT *

      FROM TC008_USER

      WHERE UPPER(USER_EMAIL_TXT) = 'ROXANNE.LAFLEUR@TC.GC.CA';