Work Process - Purpose
- To verify uploads status for a specific Course Provider.
Work Process - Summary
- Query the Organization table to obtain Course Provider Organization_ID number.
- Query the Upload History table using the Organization_ID foreign key to verify uploads for this Course Provider.
Contribution Of The Client Group To The Work Process
- Client Group may request this if they cannot verify uploads via the PDF Application.
Steps Of The Work Process
- With the Course Provider name, use the following query to obtain the Organization_ID for this company:
  SELECT *
  FROM TC006_ORGANIZATION
  WHERE UPPER(ORGANIZATION_NAME_TXT) LIKE '%DL COURSE%';
- With the Organization_ID, use the following query to see upload history for this Course Provider:
  SELECT *
  FROM TM019_UPLOAD_HISTORY
  WHERE ORGANIZATION_ID = '4236147';

Browser not supported