Find Operator In DB
- 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;