Skip to content

Query: Qry Report Application Onboarding Form

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

Tables Referenced

  • Qry Get Line Manager
  • Positions
  • People
  • Applications
  • DatabaseUsersRuby
  • Job Codes
  • Organisational Codes
  • Pay Points

Columns Selected

  • Applications.[Application ID]
  • Applications.[People ID]
  • [Pay Points].[Pay Point]
  • [Qry Get Line Manager].[Line Manager]
  • [Qry Get Line Manager].[Line Manager Email]
  • People.[Last Modified By]
  • Email
  • Title
  • [People].[First Name] & \
  • People.[Known As]
  • People.[ID Number]
  • People.[Birth Date]
  • People.[Cell Number]
  • People.[Internal Extension]
  • People.[Private Email]
  • Email
  • Job
  • Positions.[Start Date]
  • [Organisational Codes].[Organisational Unit]
  • People.[Office Location]
  • IIf([Access Control]=1,\
  • IIf([Desk]=1,\
  • IIf([Chair]=1,\
  • IIf([Filing Cabinet]=1,\
  • IIf([Bookshelf]=1,\
  • IIf([Access Control Tag]=1,\
  • IIf([Telephone - Designated Line]=1,\
  • IIf([Laptop Computer - Cable lock]=1,\
  • IIf([Desktop Computer]=1,\
  • IIf([Telephone - Printer - Scanner]=1,\
  • IIf([Remote Desktop REMS]=1,\
  • IIf([VPN Access]=1,\
  • IIf([Signature Loaded]=1,\
  • IIf([Email Address]=1,\
  • IIf([Microsoft 365 Package]=1,\

Where Clause

(((Applications.[People ID])=[Forms]![Frm Add and Edit Application Onboarding In

SQL

SELECT Applications.[Application ID], Applications.[People ID], [Pay Points].[Pay Point], [Qry Get Line Manager].[Line Manager], [Qry Get Line Manager].[Line Manager Email], People.[Last Modified By], DatabaseUsersRuby.Email, People.Title, [People].[First Name] & \, People.[Known As], People.[ID Number], People.[Birth Date], People.[Cell Number], People.[Internal Extension], People.[Private Email], People.Email, [Job Codes].Job, Positions.[Start Date], [Organisational Codes].[Organisational Unit], People.[Office Location], IIf([Access Control]=1,\, IIf([Desk]=1,\, IIf([Chair]=1,\, IIf([Filing Cabinet]=1,\, IIf([Bookshelf]=1,\, IIf([Access Control Tag]=1,\, IIf([Telephone - Designated Line]=1,\, IIf([Laptop Computer - Cable lock]=1,\, IIf([Desktop Computer]=1,\, IIf([Telephone - Printer - Scanner]=1,\, IIf([Remote Desktop REMS]=1,\, IIf([VPN Access]=1,\, IIf([Signature Loaded]=1,\, IIf([Email Address]=1,\, IIf([Microsoft 365 Package]=1,\ FROM [People], [Positions], [Applications], [Pay Points], [Organisational Codes], [DatabaseUsersRuby], [Job Codes], [Qry Get Line Manager] WHERE (((Applications.[People ID])=[Forms]![Frm Add and Edit Application Onboarding In