Find SAIK For Course Provider And Ensure Validity

• Work Process - Purpose

  • Finding an Online Course Provider's Secure Access Identification Key. 

• Work Process - Summary
  • Querying the system to find Course Provider SAIK's.
• Contribution Of The Client Group To The Work Process
  • We are generally asked to find these following connection problems to Test Online reported by a Course Provider. Client Group to supply the ID number as seen in the PDF application in the Course Providers Grid.
• Steps Of The Work Process
  • First we will need to find the Organization_ID for this particular Course Provider.  We use the value provided by the Client Group as such:
    

    SELECT *

    FROM TC006_ORGANIZATION

    WHERE COURSE_PROVIDER_TXT = '176'; 
    
    

  • Then we use the value in the ORGANIZATION_ID column in the result set to query the YM001_MASTER_SAIKS table as such:
    

    SELECT *

    FROM YM001_MASTER_SAIKS

    WHERE ORGANIZATION_ID = '74';

    
    
  • To make sure the SAIK for a particular Course Provider is valid, we must verify that the effective date (DATE_SAIK_EFFECTIVE_DTE) is in the past and that the expiry date is in the future (DATE_SAIK_EXPIRY_DTE).  We must also verify that the DATE_DELETED_DTE column is null as any (past) value entered will invalidate the SAIK in this row.

SELECT t.*
  FROM YM001_MASTER_SAIKS t
 WHERE t.ORGANIZATION_ID = '74'
   AND t.date_deleted_dte IS NULL
   AND t.date_saik_effective_dte <= CURRENT_DATE
   AND t.date_saik_expiry_dte >= CURRENT_DATE
 ORDER BY t.date_created_dte;