Updating Contact Details For A Course Provider

Owned by Roxanne Lafleur (Unlicensed)
Last updated: Apr 08, 2020 by Mike Grainger (Unlicensed)
2 min read
  • Work Process - Purpose
    • To make sure we always have the most recent contact information for Course Provider users defined in our TC Domain Table (TC008_USER).
  • Work Process - Summary

    • This process consists of finding the Course Provider User whose information needs modifying and making the necessary changes.

  • Contribution Of The Client Group To The Work Process
    • The client group will confirm with the Course Provider which information needs changing and pass the request to the developer on behalf of the Course Provider.
  • Steps Of The Work Process

    • This part of the DB design is "interesting".  Course Provider users are also defined in the YC070_PARTY table.  In this table, there is a column called PARTY_TYPE_CD which refers to another table called TC039_PARTY_TYPE:



      For Course Provider users, their PARTY_TYPE_CD will be "2" as defined in TC039_PARTY_TYPE for Course Providers.  The value for PARTY_ID is the actual Course Provider number which is the primary key in TC006_ORGANIZATION table, ORGANIZATION_ID:



      In order to find the contact details for a specific Course Provider, you may use the PARTY_ID from the Course Provider user found in the YC070_PARTY table and query the TC013_CONTACT table to see the Course Provider's contact details.  For example, if a Course Provider has an ORGANIZATION_ID of "78" in the TC006_ORGANIZATION table, you may query the YC070_PARTY table using that value AND find the company's contact information by querying the TC013_CONTACT table using that same value again:



      At this point, you will have obtained the contact information for the Course Provider and you my update their details by using the PARTY_ID in that table as a point of reference:

      SELECT *

      FROM TC013_CONTACT

      WHERE PARTY_ID = '78';



      Notice the CONTACT_TYPE_CD numbers above, if we were to query the TC029_CONTACT_TYPE table, we would get the following results:

      SELECT *

      FROM TC029_CONTACT_TYPE;


      Therefore, if we were to want to modify the FAX number for this specific Course Provider, we would run this specific query:

      UPDATE TC013_CONTACT

      SET CONTACT_DETAILS_TXT = '1-800-533-0000'

      WHERE CONTACT_ID = '184'

      AND PARTY_ID = '78';

      Giving the following results: