Find Operator In DB

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. 

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.

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

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;