Updating Contact Details For A Course Provider

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

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: