Software 101 – Database Part 3

Part III of your database training will focus on finding information in SQL about folders, jobs, and companies in the software.

For this training, you will mainly be using the ‘Tier 1 Software Company Folder and Jobs Database Template’, which you should already have downloaded.

Information on a Company by entering the Company Name

Information on a company, such as its CompanyID, ApiCompanyId, deleted status and more can be found by using the follow query.  Keep in mind the company has to be spelled (capitals and punctuation, included) correctly as it appears in the system or a record will not be found.

• select *
  from Company
  where [Name] = ‘Company Name’

Information on a Company’s software account configuration by entering the CompanyID

Similar to finding information about a user using their UserID, when can find information about a company using their CompanyID.  This is helpful to use when confirming employee headcount and what software features they have access to.  To view this information use the following query:

• select *
  from CompanyAccountConfiguration
  where CompanyId = ‘CompanyID’

Information on a Company by entering the APICompanyID

Information on a company, such as determining if the account is on hold or pause, or if a is in good standing can be found using the APICompanyID.  To find that APICompanyID you will run the query you just learned:

• select *
  from Company
  where [Name] = ‘Company Name’

This query will populate a column called ‘APICompanyID’.  You will want to copy that ID and paste it in the following query:

• select *
  from Company
  where apicompanyid = ’00Di0000000Z3X6EAK-001f3000020yVN3AAM’