Find Operator In DB

Owned by Roxanne Lafleur (Unlicensed)
Jun 26, 2019
  • Work Process Purpose

    • An Operator is the Course Provider Client taking the actual online or in classroom exam.  When this operator has a record in the TM110_PCOCTO_OPERATOR table, this means the person has taken their exam online.  For the users taking their exam in classroom, their record is only created in the YC070_PARTY as well as in it's child table YC096_PERSON. 

  • Work Process Summary

    • In order to find the online Operator in our database, we have to query this table and validate this user using their first name, last name, date of birth and address.

  • Contribution Of The Client Group To The Work Process

    • The operator information can be obtained by contacting the course provider which is usually done by our program group.

  • Steps Of The Work Process

    • The following query can be executed to obtain the information from the TM110_PCOCTO OPERATOR table.

      SELECT *

      FROM TM110_PCOCTO_OPERATOR

      WHERE UPPER(LAST_NAME_NM) LIKE '%SMITH%'

      AND UPPER(FIRST_NAME_NM) LIKE '%JOHN%'

      ORDER BY DATE_CREATED_DTE DESC;