People Power Search Queries

 Top  Previous  Next

A. List of People Power Search Names

These are BASIC queries or low level building blocks designed and managed in the Deskflow Administrator utility.

These building blocks are for use within the People Power Search utility.

Most of the queries are parameter driven, with the User defining the WHERE clause information at run time.

Queries that have a partial WHERE clause require User-entered parameters.

Queries that have a fully formed WHERE clause are stand-alone SQL queries.

 

People Power Search Names

People Power Search Names

People Power Search Names

People Power Search Names

Activity History CompletedBy

Degree Name

People with Role in Primary Positions

Resume Document Name is Incorrect

Activity History CompletedOn

Email Address

People with RTF Email

Resume does Not Contain Word(s) or Phrase

Activity History Notes Containing Word(s) or Phrase(s)

File Search Candidates for Project Code

People with Skills

Resume Text Search

Activity History Type

First Name

People without Email

Temp Order Contacts with OrderDate

Activity History Subject

Former Employee of Company

People without Resumes

Test Bookkeeping Score

Age

Former Job Title

People without Skills

Test Dicta Typing Score

Bad Email Addresses

Formerly worked in City

Person Record Created By

Test Filing Score

Business Address ZIP or Postal Code

Home Address City

Person having Date Available

Test French Language Score

Business or Work Phone

Home Address State

Person has Current Contract Position

Test Grammar Score

Candidates Applying to JobOrder

Home Address ZIP or Postal Code

Person has Function

Test MS Access Score

Candidates Considered for JobOrder

Home Phone

Person has Skill Name

Test MS Excel Score

Candidates for Internal Interview

Inactive Clients

Person is a Project Source

Test PowerPoint Score

Candidates Placed by our Company

Last Name

Person is Ad Respondent to Job Order No

Test Word Score

Candidates Presented for a JobOrder

Long Lost Client Contacts

Person is Ad Respondent to Project No

Test Shorthand Score

Candidates Presented for All JobOrders

Main Language

Person is Bilingual

Test SpeedWriting Score

Candidates Registration Date

People from Companies in Area Code

Person is Source for Project No

Test Spelling Score

Candidates Recruiter Login Name

People from Public Companies

Person Record Last Updated By

Test Typing Errors

Candidates with no Email., Phone and Address

People from Public Companies in Industry Code

Person Notes Contain Words

Test Typing Score

Contact Register for Project Code

People from Companies with OpportunityCode

Person OpportunityType

Test Wonderlick Score

Client Contacts without Contract Orders since Date

People from Companies with Owner

Person Rating is

Test Word Processing Score

Current Job Title

People on List with Name

Person Record Owner1

Test WordPerfect Score

Current or former Department

People with Company Notes

Person Record Owner2

Current or former Job Title

People with Documents

Person Status Code

Current Primary Job Title

People with Duplicate Email Addresses

People with Email

Person Type Is

Current Salary

People Placing Orders for Company with Owner1

Person with CustomDate1

Current Total Compensation

People with Origin

Person with CistomDate2

Currently employed by Company

People with Origin2

Person with CistomText1

Currently Employed in IndustryCode

People with Resumes/CVs

Person with CistomText2

Currently working in City

People with Role in Any Positions

Projects AppliedTo

Currently working in State

People with Role in Current Positions

Resume Contains Word(s) or Phrase

 

B. People Power Search Queries

 

Activity History CompletedBy

 SELECT LinkObjectToActivityHistory.LeftID FROM LinkObjectToActivityHistory WITH (NOLOCK)

 JOIN ActivityHistory ON (RightID = ActivityHistoryID AND ObjectTableName = 'People')

 WHERE ActivityHistory.CompletedBy

Activity History CompletedOn

 SELECT LinkObjectToActivityHistory.LeftID FROM LinkObjectToActivityHistory WITH (NOLOCK)

 JOIN ActivityHistory ON (RightID = ActivityHistoryID  AND ObjectTableName = 'People')

 WHERE ActivityHistory.CompletedOn

Activity History Notes contains Word(s) or Phrase

 SELECT LinkObjectToActivityHistory.LeftID AS PeopleID FROM LinkObjectToActivityHistory WITH (NOLOCK)

 JOIN ActivityHistory ON (RightID = ActivityHistoryID AND ObjectTableName = 'People')

 WHERE CONTAINS

Activity History Record Type

 SELECT LinkObjectToActivityHistory.LeftID FROM LinkObjectToActivityHistory WITH (NOLOCK)

 JOIN ActivityHistory WITH (NOLOCK) ON (RightID = ActivityHistoryID AND ObjectTableName = 'People')

 WHERE Type

Activity History Subject

 SELECT LinkObjectToActivityHistory.LeftID FROM LinkObjectToActivityHistory  WITH (NOLOCK)

 JOIN ActivityHistory  WITH (NOLOCK) ON (RightID = ActivityHistoryID AND ObjectTableName = 'People')

 WHERE Description

Age

 SELECT People.PeopleID FROM People  WITH (NOLOCK)

 WHERE DATEDIFF(Year, People.Birthday, GetDate())

Bad Email Addresses

 SELECT EMailAddress.PeopleID FROM EMailAddress WITH (NOLOCK)

WHERE EmailAddress.PeopleID > 0

 AND ( (CharIndex('?', Address) > 0)   OR (CharIndex('  ',Address) > 0)  OR (CharIndex(' ', Address) > 0)

    OR (CharIndex('*', Address) > 0)   OR (CharIndex(',', Address) > 0)   OR (CharIndex('[', Address) > 0)

    OR (CharIndex(']', Address) > 0)    OR (CharIndex('@', Address) = 0)    OR (CharIndex('/', Address) > 0) )

Candidates Placed by Our Company

 SELECT PeopleID FROM People   WITH (NOLOCK) WHERE TCPPlacedStatus > 0

Business Address ZIP/Postal Code

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON (Positions.AddressesID = Addresses.AddressesID)

 WHERE ( Positions.EndDate IS NULL OR Positions.EndDate > GETDATE()) AND

 Addresses.PostalCode

Business or Work Phone

 SELECT PeopleID FROM People   WITH (NOLOCK)  WHERE People.Phone1

Candidate Recruiter LoginName

 SELECT People.PeopleID FROM People  WITH (NOLOCK) WHERE People.Owner1

 

Candidate Registration Date

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.CreatedOn

Candidates Applying to JobOrder

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 INNER JOIN  PeopleAppliedTo  WITH (NOLOCK)  ON People.PeopleID = PeopleAppliedTo.PeopleID

 INNER JOIN  JobOrders  WITH (NOLOCK)  ON PeopleAppliedTo.JobOrdersID = JobOrders.JobOrdersID

 WHERE JobOrders.JobOrderCode

Candidates Considered for JobOrder

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 INNER JOIN  JobOrderConsideredPeople WITH (NOLOCK)  ON People.PeopleID = JobOrderConsideredPeople.PeopleID

 INNER JOIN  JobOrders WITH (NOLOCK) ON JobOrderConsideredPeople.JobOrdersID = JobOrders.JobOrdersID

 WHERE  JobOrders.JobOrderCode

Candidates for Internal Intrvws

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 INNER JOIN InternalInterviews  WITH (NOLOCK)  ON  InternalInterviews.PeopleID = People.PeopleID

 WHERE (People.PeopleID = InternalInterviews.PeopleID)

Candidates Presented for ALL JobOrders

 SELECT People.PeopleID  FROM People WITH (NOLOCK)

 INNER JOIN  JobOrderPresentedPeople WITH (NOLOCK)  ON  People.PeopleID = JobOrderPresentedPeople.PeopleID

 INNER JOIN  JobOrders WITH (NOLOCK)  ON  JobOrderPresentedPeople.JobOrdersID = JobOrders.JobOrdersID

Candidates Presented for JobOrder

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 INNER JOIN  JobOrderPresentedPeople WITH (NOLOCK)  ON  People.PeopleID = JobOrderPresentedPeople.PeopleID

 INNER JOIN  JobOrders WITH (NOLOCK)  ON JobOrderPresentedPeople.JobOrdersID = JobOrders.JobOrdersID

 WHERE JobOrders.JobOrderCode

Candidates without Email, Phone or Address

 Select PeopleID  FROM People WITH (NOLOCK)

 WHERE People.Type LIKE 'Candidate%' AND ((Phone5 is null or Phone5='')

 OR (HomeAddressesID is null or HomeAddressesID=0)

 OR (Select count(*)as RR from EmailAddress where EmailAddress.PeopleID=People.PeopleID)=0)

Contact Register for Project Code

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 INNER JOIN ProjectsTargetLists WITH (NOLOCK)  ON  People.PeopleID = ProjectsTargetLists.PeopleID

 INNER JOIN  Projects WITH (NOLOCK)  ON        ProjectsTargetLists.ProjectsID = Projects.ProjectsID

 WHERE Projects.JobCode

Client Contacts without Contract Orders since Date

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 JOIN Positions c WITH (NOLOCK)  ON ( People.PeopleID = c.PeopleID

         AND (IsPrimaryPosition = 1 OR ( c.EndDate > GETDATE() OR c.EndDate IS NULL))

         AND c.CompaniesID IN (

                 SELECT DISTINCT a.CompaniesID

                 FROM Positions a WITH(NOLOCK)

                 JOIN JobOrders WITH(NOLOCK)

                 ON(a.JobOrdersID = JobOrders.JobOrdersID AND JobOrders.OrderType = 'Contract')

                 )

     )

 WHERE

 (SELECT MAX(d.StartDate)

 FROM Positions d WITH(NOLOCK)

 JOIN JobOrders WITH(NOLOCK)        ON (d.JobOrdersID = JobOrders.JobOrdersID AND JobOrders.OrderType = 'Contract')

 WHERE d.CompaniesID = JobOrders.CompaniesID AND d.CompaniesID = c.CompaniesID

 GROUP BY d.CompaniesID)

Current Job Title

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NULL OR EndDate > GETDATE()) AND JobTitle

Current or Former Department

 SELECT PeopleID FROM Positions  WITH (NOLOCK)  WHERE Department

Current or Former Job Title

 SELECT PeopleID FROM Positions  WITH (NOLOCK)  WHERE JobTitle

Current Primary Job Title

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NULL OR EndDate > GETDATE()) AND IsPrimaryPosition > 0 AND JobTitle

Current Salary

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NULL OR EndDate > GETDATE()) AND

 Salary

Current Total Compensation

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NULL OR EndDate > GETDATE()) AND

 TotalCompensation

Currently Employed by Company

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NULL OR EndDate > GETDATE()) AND CompanyName

Currently Employed in IndustryCode

 SELECT People.PeopleID FROM People  WITH (NOLOCK)

 INNER JOIN Positions  WITH (NOLOCK)  ON  People.PeopleID = Positions.PeopleID

 INNER JOIN Companies  WITH (NOLOCK)  ON Positions.CompaniesID = Companies.CompaniesID

 INNER JOIN CompaniesIndustry  WITH (NOLOCK)  ON Companies.CompaniesID = CompaniesIndustry.CompaniesID

 WHERE CompaniesIndustry.IndustryCode1

Currently Working in City

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON (Positions.AddressesID = Addresses.AddressesID)

 WHERE ( Positions.EndDate IS NULL OR Positions.EndDate > GETDATE()) AND Addresses.City

Currently Working in State

 SELECT Positions.PeopleID FROM Positions  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON (Positions.AddressesID = Addresses.AddressesID)

 WHERE ( Positions.EndDate IS NULL OR Positions.EndDate > GETDATE()) AND Addresses.Province

Degree Name

 SELECT PeopleID FROM Education  WITH (NOLOCK)  WHERE Degree

Email Address

 SELECT PeopleID FROM EMailAddress WITH (NOLOCK) WHERE Address

File Search Candidates for Project Code

 SELECT People.PeopleID FROM People

 INNER JOIN  ProjectsFileSearchCandidates

 ON  People.PeopleID = ProjectsFileSearchCandidates.PeopleID

 INNER JOIN Projects ON ProjectsFileSearchCandidates.ProjectsID = Projects.ProjectsID

 WHERE Projects.JobCode

First Name

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.FirstName

 

Former Employee of Company

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NOT NULL AND EndDate < GETDATE())

 AND CompanyName

Former Job Title

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (EndDate IS NOT NULL AND EndDate < GETDATE())

 AND JobTitle

Formerly worked in City

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON  (Positions.AddressesID = Addresses.AddressesID)

 WHERE ( Positions.EndDate IS NOT NULL AND Positions.EndDate < GETDATE()) AND

 Addresses.City

Home Address City

 SELECT PeopleID FROM People  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON (People.HomeAddressesID = Addresses.AddressesID)

 WHERE Addresses.City

Home Address State

 SELECT PeopleID FROM People  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON (People.HomeAddressesID = Addresses.AddressesID)

 WHERE Addresses.Province

Home Address ZIP/Postal Code

 SELECT PeopleID FROM People  WITH (NOLOCK)

 JOIN Addresses  WITH (NOLOCK)  ON (People.HomeAddressesID = Addresses.AddressesID)

 WHERE Addresses.PostalCode

Home Phone

 SELECT PeopleID FROM People  WITH (NOLOCK)  WHERE People.Phone5

Inactive Clients

 SELECT DISTINCT People.PeopleID

 FROM People WITH (NOLOCK)

 JOIN JobOrders WITH (NO LOCK) ON ( People.PeopleID = JobOrders.PlacedByPeopleID

 AND JobOrders.CompaniesID IN

 ( SELECT CompaniesID FROM JobOrders WITH (NOLOCK) GROUP BY CompaniesID

         HAVING ( DATEDIFF(month, MAX(JobOrders.JobOrderDate), GETDATE()) >= 12)))

Last Name

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.LastName

Long Lost Client Contacts

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 JOIN Positions c WITH (NOLOCK)

 ON ( People.PeopleID = c.PeopleID AND

         (IsPrimaryPosition = 1 OR ( c.EndDate > GETDATE() OR c.EndDate IS NULL))

         AND c.CompaniesID IN (

                 SELECT DISTINCT a.CompaniesID

                 FROM Positions a WITH(NOLOCK)

                 JOIN JobOrders WITH(NOLOCK)

                 ON(a.JobOrdersID = JobOrders.JobOrdersID AND JobOrders.OrderType = 'Contract')

                 )

     )

 WHERE

 (SELECT MAX(d.StartDate)

 FROM Positions d WITH(NOLOCK)

 JOIN JobOrders WITH(NOLOCK)        ON (d.JobOrdersID = JobOrders.JobOrdersID AND JobOrders.OrderType = 'Contract')

 WHERE d.CompaniesID = JobOrders.CompaniesID AND d.CompaniesID = c.CompaniesID

 GROUP BY d.CompaniesID)

Main Language

 SELECT PeopleID FROM People  WITH (NOLOCK)  WHERE MainLanguage

 

People from Companies in Area Code

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN Positions  WITH (NOLOCK) ON        People.PeopleID = Positions.PeopleID

 INNER JOIN Companies  WITH (NOLOCK) ON Positions.CompaniesID = Companies.CompaniesID

 WHERE Companies.switchboard

People from Public Companies

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN Positions  WITH (NOLOCK)  ON People.PeopleID = Positions.PeopleID

 INNER JOIN Companies  WITH (NOLOCK) ON Positions.CompaniesID = Companies.CompaniesID

 INNER JOIN CompaniesIndustry  WITH (NOLOCK) ON Companies.CompaniesID = CompaniesIndustry.CompaniesID

 WHERE ((Companies.Ownership = 'PUBLIC')

 OR (Companies.Ownership = 'NYSE')

 OR (Companies.Ownership = 'NASDAQ'))

People from Public Companies in IndustryCode

 SELECT People.PeopleID

 FROM People  WITH (NOLOCK)

 INNER JOIN Positions  WITH (NOLOCK)  ON People.PeopleID = Positions.PeopleID

 INNER JOIN Companies  WITH (NOLOCK)  ON  Positions.CompaniesID = Companies.CompaniesID

 INNER JOIN CompaniesIndustry  WITH (NOLOCK)  ON  Companies.CompaniesID = CompaniesIndustry.CompaniesID

 WHERE ((Companies.Ownership = 'PUBLIC') OR

     (Companies.Ownership = 'NYSE') OR

     (Companies.Ownership = 'NASDAQ')) AND (CompaniesIndustry.IndustryCode1)

People from Companies with OpportunityStatus

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN Positions WITH (NOLOCK) ON        People.PeopleID = Positions.PeopleID

 INNER JOIN Companies WITH (NOLOCK) ON Positions.CompaniesID = Companies.CompaniesID

 WHERE Positions.IsPrimaryPosition = 1 AND Companies.Owner1

People from Companies with Owner

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN Positions WITH (NOLOCK) ON        People.PeopleID = Positions.PeopleID

 INNER JOIN Companies WITH (NOLOCK) ON Positions.CompaniesID = Companies.CompaniesID

 WHERE Positions.IsPrimaryPosition = 1 AND Companies.Owner1

People on List with Name

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 JOIN  ListsDetails WITH (NOLOCK)  ON   People.PeopleID = ListsDetails.RecordID

 JOIN  Lists WITH (NOLOCK) ON ListsDetails.ListID = Lists.ListsID

 WHERE (Lists.SourceTable = 'People')  AND  Lists.Name

People with Company Notes

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN Positions WITH (NOLOCK) ON        People.PeopleID = Positions.PeopleID

 INNER JOIN Companies WITH (NOLOCK) ON Positions.CompaniesID = Companies.CompaniesID

 WHERE  Positions.IsPrimaryPosition = 1 AND Companies.Notes

People with Documents

 SELECT  PeopleID

 FROM  People WITH (NOLOCK)

 INNER JOIN LinkObjectToDocument WITH (NOLOCK)        ON People.PeopleID = LinkObjectToDocument.LeftID

 INNER JOIN  Document WITH (NOLOCK) ON LinkObjectToDocument.RightID = Document.DocumentID

 WHERE (LinkObjectToDocument.ObjectTableName = 'People')  AND Document.Name

 

People with Duplicate Email Addresses

SELECT  distinct PeopleID FROM  EmailAddress as a WITH (NOLOCK)

WHERE EXISTS (SELECT count(*)

FROM EmailAddress b WITH (NOLOCK)

WHERE b.Address = a.Address AND IsNull(b.PeopleID,0) <> IsNull(a.PeopleID,0)

AND  b.PeopleID > 0 and a.PeopleID >0

People with Email

 SELECT PeopleID FROM EMailAddress WITH (NOLOCK)

People Placing Orders for Company with Owner1

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN JobOrders WITH (NOLOCK)  ON People.PeopleID = JobOrders.PlacedByPeopleID

 INNER  JOIN  Companies WITH (NOLOCK)  ON JobOrders.CompaniesID = Companies.CompaniesID

 WHERE Companies.Owner1

People with Origin

  SELECT PeopleID FROM People  WITH (NOLOCK)  WHERE People.Origin

People with Origin2

  SELECT PeopleID FROM People  WITH (NOLOCK)  WHERE People.Origin2

People with Resumes

 SELECT PeopleID FROM Resumes  WITH (NOLOCK)

People with Role in all Positions

 SELECT PeopleID FROM Positions WITH (NOLOCK)

 JOIN RoleCodes WITH (NOLOCK)

 ON (Positions.RoleCode1 = RoleCodes.RoleCode1)

 WHERE RoleCodes.Description

People with Role in Current Positions

 SELECT PeopleID FROM Positions WITH (NOLOCK)

 JOIN RoleCodes WITH (NOLOCK) ON  (Positions.RoleCode1 = RoleCodes.RoleCode1

 AND ( Positions.EndDate IS NULL OR Positions.EndDate > GETDATE()))

 WHERE RoleCodes.Description

People with Role in Primary Positions

 SELECT PeopleID FROM Positions WITH (NOLOCK)

 JOIN RoleCodes WITH (NOLOCK)  ON (Positions.RoleCode1 = RoleCodes.RoleCode1 AND IsPrimaryPosition > 0)

 WHERE RoleCodes.Description

People with RTF Email

 SELECT PeopleID FROM EMailAddress WITH (NOLOCK) WHERE SendRTF = 1

People with Skills

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

People without Email

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 LEFT JOIN EmailAddress WITH (NOLOCK) ON People.PeopleID = EmailAddress.PeopleID

 WHERE EmailAddress.EmailAddressID IS NULL

People without Resumes

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 LEFT JOIN Resumes WITH (NOLOCK) ON

 People.PeopleID = Resumes.PeopleID

 WHERE Resumes.PeopleID IS NULL

People without Skills

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 LEFT JOIN LinkPeopleToSkills WITH (NOLOCK) ON People.PeopleID = LinkPeopleToSkills.PeopleID

 WHERE LinkPeopleToSkills.PeopleID IS NULL

 

Person Record Created By

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.CreatedBy

Person having Date Available

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.DateAvailable

Person has Current Contract Position

 SELECT PeopleID FROM Positions  WITH (NOLOCK)

 WHERE (IsPrimaryPosition = 0 AND StartDate <= GETDATE()

 AND EndDate >= GETDATE() AND PositionsID IS NOT NULL)

Person has Function

 SELECT PeopleID FROM Positions  WITH (NOLOCK)  WHERE JobFunction

Person has Skill Name

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 JOIN Skills  WITH (NOLOCK) ON ( LinkPeopleToSkills.SkillsID = Skills.SkillsID )

 WHERE Skills.Name

Person is a Project Source

 SELECT PeopleID FROM  ProjectsSources  WITH (NOLOCK)  WHERE ProjectsID > 0  

Person is Ad Respondent to Job Order No

 SELECT People.PeopleID FROM People WITH (NOLOCK)

 INNER JOIN  PeopleAppliedTo WITH (NOLOCK) ON  People.PeopleID =  PeopleAppliedTo.PeopleID

 INNER JOIN JobOrders WITH (NOLOCK) ON PeopleAppliedTo.JobOrdersID = JobOrders.JobOrdersID

 WHERE JobOrders.JobOrderCode

Person is Ad Respondent to Project No

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN  PeopleAppliedTo WITH (NOLOCK) ON  People.PeopleID =        PeopleAppliedTo.PeopleID

 INNER JOIN Projects WITH (NOLOCK) ON PeopleAppliedTo.ProjectsID = Projects.ProjectsID

 WHERE Projects.JobCode

Person is Bilingual

  SELECT PeopleID FROM People  WITH (NOLOCK)

 WHERE People.Bilingual IS NOT NULL

 AND People.Bilingual = 'Y'

Person is Source for Project No

 SELECT ProjectsSources.PeopleID

 FROM ProjectsSources  WITH (NOLOCK)

  INNER JOIN Projects  WITH (NOLOCK) ON ProjectsSources.ProjectsID = Projects.ProjectsID

 WHERE Projects.JobCode

Person Last Updated By

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.UpdatedBy

Person Notes contains Word(s)

 SELECT Notes.PeopleID FROM Notes WITH (NOLOCK) WHERE CONTAINS

Person OpportunityType

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.OpportunityType

Person Rating is

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.Rating

Person record Owner1

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.Owner1

Person record Owner2

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.Owner2

 

Person Status Code

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.PersonStatus

Person Type is

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.Type

Person with CustomDate1

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.CustomDate1

Person with CustomDate2

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.CustomDate2

Person with CustomText1

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.CustomText1

Person with CustomText2

 SELECT People.PeopleID FROM People  WITH (NOLOCK)  WHERE People.CustomText1

Projects AppliedTo

 SELECT PeopleID  FROM  People  WITH (NOLOCK)  WHERE ProjectsAppliedTo

Resume contains Word(s) or Phrase

 SELECT PeopleID FROM Resumes  WITH (NOLOCK)  WHERE CONTAINS

Resume Document Name is Incorrect

 SELECT People.PeopleID FROM People  WITH (NOLOCK)

 JOIN Resumes  WITH (NOLOCK)

 ON (People.PeopleID =        Resumes.PeopleID)

 WHERE (LEFT(People.LastName, 6) <> LEFT(Resumes.Documentname, 6))

Resume does NOT contain Word(s) or Phrase

  SELECT PeopleID FROM Resumes  WITH (NOLOCK)  WHERE NOT CONTAINS

Resume Text Search

 SELECT PeopleID FROM Resumes WITH (NOLOCK)  WHERE TEXTIMAGE

Temp Order Contacts with OrderDate

 SELECT People.PeopleID

 FROM People WITH (NOLOCK)

 INNER JOIN Positions WITH (NOLOCK) ON People.PeopleID = Positions.PeopleID        

 INNER JOIN Companies WITH (NOLOCK) ON Positions.CompaniesID = Companies.CompaniesID

 INNER  JOIN JobOrders WITH (NOLOCK)  ON Companies.CompaniesID = JobOrders.CompaniesID

 WHERE (Positions.IsPrimaryPosition = 1) AND

 (JobOrders.OrderType = 'Temp' OR JobOrders.OrderType = 'Contract')  AND JobOrders.JobOrderDate

Test Bookkeeping Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 324 AND LinkPeopleToSkills.IntValue

Test DictaTyping Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 326 AND LinkPeopleToSkills.IntValue

Test Filing Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 327 AND LinkPeopleToSkills.IntValue

Test French Language Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 163 AND LinkPeopleToSkills.IntValue

Test Grammar Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 267 AND LinkPeopleToSkills.IntValue

 

Test MS Access Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 2  AND LinkPeopleToSkills.IntValue

Test MS Excel Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 196 AND LinkPeopleToSkills.IntValue

Test MS Powerpoint Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 266 AND LinkPeopleToSkills.IntValue

Test MS Word Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 1 AND LinkPeopleToSkills.IntValue

Test Shorthand Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 331 AND LinkPeopleToSkills.IntValue

Test SpeedWriting Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 332 AND LinkPeopleToSkills.IntValue

Test Spelling Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 268 AND LinkPeopleToSkills.IntValue

Test Typing Errors

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 333 AND LinkPeopleToSkills.IntValue

Test Typing Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 9 AND LinkPeopleToSkills.IntValue

Test Wonderlick Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 335 AND LinkPeopleToSkills.IntValue

Test Word Processing Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 11 AND LinkPeopleToSkills.IntValue

Test WordPerfect Score

 SELECT PeopleID FROM LinkPeopleToSkills  WITH (NOLOCK)

 WHERE LinkPeopleToSkills.SkillsID = 77 AND LinkPeopleToSkills.IntValue