Skip to content

Query: Qry Open Position List

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

Tables Referenced

  • vwRubyPreOpenPositionList

Columns Selected

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

SQL

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