Skip to content

Query: Qry Export Employee Engage

Type: Select
Has Parameters: Yes
Has Joins: Yes
Has Subquery: No

Tables Referenced

  • Positions
  • People
  • Applications
  • Date
  • Job Codes
  • Organisational Codes
  • Pay Points

Columns Selected

  • Applications.[Application Status ID]
  • Positions.[Position Status ID]
  • People.[People ID]
  • People.[Employee Number]
  • Initials
  • People.[First Name]
  • People.[Last Name]
  • Email
  • People.[Cell Number]
  • People.[Birth Date]
  • Gender
  • Race
  • People.[ID Number]
  • People.[Group Join Date]
  • Positions.[Termination Date]
  • People.[ISP Q1]
  • People.[ISP Q2]
  • People.[ISP Q3]
  • People.[ISP Q4]
  • Positions.[Training Approver ID]
  • Positions.[Second Training Approver ID]
  • [Organisational Codes].[Organisational Code]
  • [Job Codes].[Job Code]
  • People.[Phys Line 1]
  • People.[Phys Line 2]
  • People.[Phys Line 3]
  • People.[Phys Postal Code]
  • People.[Phys Street Number]
  • People.[Phys Unit Number]
  • People.[Phys Complex]
  • People.[Phys Province]
  • People.[Phys Country]
  • People.[Send Post To]
  • People.[Postal Add 1]
  • People.[Postal Add 2]
  • People.[Postal Add 3]
  • People.[Postal Code]
  • People.[Postal Street Number]
  • People.[Postal Unit Number]
  • People.[Postal Complex]
  • People.[Postal Province]
  • People.[Postal Country]
  • [Organisational Codes].[Organisational Unit]
  • Job
  • Positions.[Position Effective Date]
  • [Pay Points].[Pay Point]
  • [People_1].[Employee Number] & \
  • Title
  • People.[Middle Name]
  • Positions.[Employment Status]
  • People.[Foreign National]
  • People.[Home Number]
  • Citizenship
  • People.[Emergency Contact Name]
  • People.[Emergency Contact Number]
  • People.[Emergency Contact Address]

Where Clause

(((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID

SQL

SELECT Applications.[Application Status ID], Positions.[Position Status ID], People.[People ID], People.[Employee Number], People.Initials, People.[First Name], People.[Last Name], People.Email, People.[Cell Number], People.[Birth Date], People.Gender, People.Race, People.[ID Number], People.[Group Join Date], Positions.[Termination Date], People.[ISP Q1], People.[ISP Q2], People.[ISP Q3], People.[ISP Q4], Positions.[Training Approver ID], Positions.[Second Training Approver ID], [Organisational Codes].[Organisational Code], [Job Codes].[Job Code], People.[Phys Line 1], People.[Phys Line 2], People.[Phys Line 3], People.[Phys Postal Code], People.[Phys Street Number], People.[Phys Unit Number], People.[Phys Complex], People.[Phys Province], People.[Phys Country], People.[Send Post To], People.[Postal Add 1], People.[Postal Add 2], People.[Postal Add 3], People.[Postal Code], People.[Postal Street Number], People.[Postal Unit Number], People.[Postal Complex], People.[Postal Province], People.[Postal Country], [Organisational Codes].[Organisational Unit], [Job Codes].Job, Positions.[Position Effective Date], [Pay Points].[Pay Point], [People_1].[Employee Number] & \, People.Title, People.[Middle Name], Positions.[Employment Status], People.[Foreign National], People.[Home Number], People.Citizenship, People.[Emergency Contact Name], People.[Emergency Contact Number], People.[Emergency Contact Address] FROM [People], [Applications], [Positions], [Organisational Codes], [Job Codes], [Pay Points], [People] WHERE (((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID