Skip to content

Query: Qry Filled Position List

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

Tables Referenced

  • vwRubyPreFilledPositionList

Columns Selected

  • vwRubyPreFilledPositionList.[Application Status ID]
  • vwRubyPreFilledPositionList.[Position ID]
  • vwRubyPreFilledPositionList.[People ID]
  • vwRubyPreFilledPositionList.[Job ID]
  • vwRubyPreFilledPositionList.[Which Dashboard]
  • Job
  • vwRubyPreFilledPositionList.[Org Unit]
  • vwRubyPreFilledPositionList.[Pay Point]
  • vwRubyPreFilledPositionList.[Position Status ID]
  • vwRubyPreFilledPositionList.[Position Status]
  • Employee
  • Person
  • vwRubyPreFilledPositionList.[Start Date]
  • vwRubyPreFilledPositionList.[Termination Date]
  • vwRubyPreFilledPositionList.[Date Eliminated]
  • vwRubyPreFilledPositionList.[Date Suspended]
  • vwRubyPreFilledPositionList.[Company Name]

SQL

SELECT vwRubyPreFilledPositionList.[Application Status ID], vwRubyPreFilledPositionList.[Position ID], vwRubyPreFilledPositionList.[People ID], vwRubyPreFilledPositionList.[Job ID], vwRubyPreFilledPositionList.[Which Dashboard], vwRubyPreFilledPositionList.Job, vwRubyPreFilledPositionList.[Org Unit], vwRubyPreFilledPositionList.[Pay Point], vwRubyPreFilledPositionList.[Position Status ID], vwRubyPreFilledPositionList.[Position Status], vwRubyPreFilledPositionList.Employee, vwRubyPreFilledPositionList.Person, vwRubyPreFilledPositionList.[Start Date], vwRubyPreFilledPositionList.[Termination Date], vwRubyPreFilledPositionList.[Date Eliminated], vwRubyPreFilledPositionList.[Date Suspended], vwRubyPreFilledPositionList.[Company Name] FROM [vwRubyPreFilledPositionList]