Find Course Provider User

Owned by Roxanne Lafleur (Unlicensed)
Jun 27, 2019
  • Work Process - Purpose:
    • This has the purpose of identifying which users are associated to Course Provider Accounts.
  • Work Process - Summary
    • This consists of identifying the Course Provider by the number shown in the PDF Application, then finding all Course Provider users who have TC Domain Accounts.
  • Contribution Of The Client Group To The Work Process
    • The clients identify the Course Providers only by numbers defined in the PDF Application.
  • Steps Of The Work Process
    • Log in to the PDF Application as a TC User and select Course Provider on the left menu:



      In the Course Provider grid, the number will appear in the left column.  The Course Providers are identified in the DB as "Organizations" in the TC006_ORGANIZATIONS table and the number found in the grid represents the "COURSE_PROVIDER_TXT" column in this table.  THIS NUMBER IS NOT THE COURSE PROVIDER ID, THE COURSE PROVIDER ID IS THE "ORGANIZATION_ID" COLUMN.



      To find a Course Provider using this column, use the following query:

      SELECT *

      FROM TC006_ORGANIZATION

      WHERE COURSE_PROVIDER_TXT = '176';

      Once you execute this query, you will have the Course Provider's ID (ORGANIZATION_ID) and using this value, you can query the TC Users table, TC008_USER and obtain all the users for this Course Provider who have accounts in our Domain.  The query is a follows:

      SELECT *

      FROM tc008_user

      WHERE organization_id = '78';