Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

  • 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.
  • No labels