Find Users By Email

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';

Marine