Find SAIK for Course Provider

Owned by Roxanne Lafleur (Unlicensed)
Jul 05, 2019
  • Work Process - Purpose
    • Identifying SAIK's for specific Course Providers.
  • Work Process - Summary
    • SAIK's (Secure Access Identification Key) are stored in YM001_MASTER_SAIKS table.  This will show how to find SAIK's for a specific Course Provider.
  • Contribution Of The Client Group To The Work Process
    • The Client Group may request this task to verify a SAIK valid for a specific Course Provider.  There have been issues where a SAIK has been invalidated by the Course Provider by requesting a new one without updating their web service request parameters.  This has resulted in Test Online becoming unavailable and non-responsive.  Such issues must be addressed immediately as they will be reported very quickly by the Client Group.
  • Steps Of The Work Process
    • After finding the ORGANIZATION_ID in TC006_ORGANIZATION, use this value to query YM001_MASTER_SAIKS and make changes accordingly.

      SELECT *

      FROM YM001_MASTER_SAIKS

      WHERE ORGANIZATION_ID = '74';

    • To restore a SAIK which has been invalidated by having a past value set in the DATE_DELETED_DATE column, use the following and this will re-activate the SAIK:

      UPDATE YM001_MASTER_SAIKS

      SET DATE_DELETED_DTE = NULL

      WHERE MASTER_SAIKS_CD = 'TC2014-501-004-WSCE001B';