Skip to content

Query: Qry Report Opal Calculate Tenure by Org Unit

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

Tables Referenced

  • Qry
  • Qry Report Opal Count Hired and Terminated Employees by Org Unit
  • Qry Report Opal Sum Length of Service by Org Unit

Columns Selected

  • [Qry Report Opal Sum Length of Service by Org Unit].[Organisational Unit]
  • [Org Unit Total Tenure]/[Org Unit Number]

SQL

SELECT [Qry Report Opal Sum Length of Service by Org Unit].[Organisational Unit], [Org Unit Total Tenure]/[Org Unit Number] FROM [Qry Report Opal Sum Length of Service by Org Unit], [Qry Report Opal Count Hired and Terminated Employees by Org Unit]