Find SAIK for Course Provider

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';

Marine