See Tests Currently Being Taken

Owned by Roxanne Lafleur (Unlicensed)
Jun 27, 2019
1 min read
  • Work Process - Purpose
    • To verify the PCOC Web Service is functional and Test Online exams are currently running. This is done most frequently on weekends following planned system outages as well as following Web Service and Test Online releases.
  • Work Process - Summary
    • We query the LM109_EXAM_GRP_TOKEN table and verify the TIMER_REMAINING_NBR value for exams.  We then refresh (re-query) to see changes in this value which informs us timers are currently counting down for exams.
  • Contribution Of The Client Group To The Work Process
    • Following this verification after outages and releases, clients must be informed immediately that the system is up and running and Tests are under way.
  • Steps Of The Work Process
    • Simply run the following query multiple times while checking the values for both the PCOCTO_OPERATOR_CD column and TIMER_REMAINING_NBR columns for timer functionality:

      SELECT *

      FROM LM109_EXAM_GRP_TOKEN

      WHERE DATE_DELETED_DTE IS NULL

      AND RESULT_STATUS_TYPE_CD = '3'

      ORDER BY DATE_CREATED_DTE DESC;