Skip to content

Query: Qry Open Position Applicant List

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

Tables Referenced

  • vwRubyPreOpenPositionApplicantList

Columns Selected

  • vwRubyPreOpenPositionApplicantList.[Position ID]
  • vwRubyPreOpenPositionApplicantList.[Job ID]
  • vwRubyPreOpenPositionApplicantList.[Which Dashboard]
  • Job
  • vwRubyPreOpenPositionApplicantList.[Org Unit]
  • vwRubyPreOpenPositionApplicantList.[Pay Point]
  • vwRubyPreOpenPositionApplicantList.[Position Status ID]
  • vwRubyPreOpenPositionApplicantList.[Position Status]
  • vwRubyPreOpenPositionApplicantList.[Reporting To]
  • Applicant
  • vwRubyPreOpenPositionApplicantList.[Company Name]
  • vwRubyPreOpenPositionApplicantList.[Job Profile File Name]

SQL

SELECT vwRubyPreOpenPositionApplicantList.[Position ID], vwRubyPreOpenPositionApplicantList.[Job ID], vwRubyPreOpenPositionApplicantList.[Which Dashboard], vwRubyPreOpenPositionApplicantList.Job, vwRubyPreOpenPositionApplicantList.[Org Unit], vwRubyPreOpenPositionApplicantList.[Pay Point], vwRubyPreOpenPositionApplicantList.[Position Status ID], vwRubyPreOpenPositionApplicantList.[Position Status], vwRubyPreOpenPositionApplicantList.[Reporting To], vwRubyPreOpenPositionApplicantList.Applicant, vwRubyPreOpenPositionApplicantList.[Company Name], vwRubyPreOpenPositionApplicantList.[Job Profile File Name] FROM [vwRubyPreOpenPositionApplicantList]