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;

Browser not supported