Find Course Provider User

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

Marine