Skip to content

Query: Qry Onboarding Application List

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

Tables Referenced

  • vwRubyPreOnboardingApplicationList

Columns Selected

  • vwRubyPreOnboardingApplicationList.[Position Status ID]
  • vwRubyPreOnboardingApplicationList.[Application ID]
  • vwRubyPreOnboardingApplicationList.[Position ID]
  • vwRubyPreOnboardingApplicationList.[People ID]
  • vwRubyPreOnboardingApplicationList.[Job ID]
  • vwRubyPreOnboardingApplicationList.[Application Status ID]
  • Applicant
  • vwRubyPreOnboardingApplicationList.[Application Date]
  • Int(DateDiff(\
  • Job
  • vwRubyPreOnboardingApplicationList.[Reporting To]

Where Clause

(((vwRubyPreOnboardingApplicationList.[Position Status ID])=3))

Order By

vwRubyPreOnboardingApplicationList.Applicant

SQL

SELECT vwRubyPreOnboardingApplicationList.[Position Status ID], vwRubyPreOnboardingApplicationList.[Application ID], vwRubyPreOnboardingApplicationList.[Position ID], vwRubyPreOnboardingApplicationList.[People ID], vwRubyPreOnboardingApplicationList.[Job ID], vwRubyPreOnboardingApplicationList.[Application Status ID], vwRubyPreOnboardingApplicationList.Applicant, vwRubyPreOnboardingApplicationList.[Application Date], Int(DateDiff(\, vwRubyPreOnboardingApplicationList.Job, vwRubyPreOnboardingApplicationList.[Reporting To] FROM [vwRubyPreOnboardingApplicationList] WHERE (((vwRubyPreOnboardingApplicationList.[Position Status ID])=3))