Skip to content

Query: Qry ISP Individual From Three Plus One Page

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

Tables Referenced

  • People Three Plus One ISP Contract
  • Positions
  • People
  • Applications
  • Job Codes
  • People Three Plus One
  • Organisational Codes

Columns Selected

  • [People].[First Name] & \
  • [People Three Plus One].[Reviewed By]
  • [People Three Plus One].[Date of Review]
  • [People Three Plus One ISP Contract].[Key Performance Area]
  • [People Three Plus One ISP Contract].[KPA Weighting]
  • [People Three Plus One ISP Contract].[Key Performance Indicator]
  • [People Three Plus One ISP Contract].[KPI Score]
  • [People Three Plus One].[Adjust Percentage]
  • [People Three Plus One].[Evidence to Adjust Score]
  • [Organisational Codes].[Organisational Unit]
  • Job
  • [People Three Plus One ISP Contract].[KPI Score]/100*[KPI Weighting]
  • [People_1].[First Name] & \
  • [People Three Plus One ISP Contract].[KPI Weighting]
  • People.[People ID]

Order By

[People Three Plus One ISP Contract].[Key Performance Area]

SQL

SELECT [People].[First Name] & \, [People Three Plus One].[Reviewed By], [People Three Plus One].[Date of Review], [People Three Plus One ISP Contract].[Key Performance Area], [People Three Plus One ISP Contract].[KPA Weighting], [People Three Plus One ISP Contract].[Key Performance Indicator], [People Three Plus One ISP Contract].[KPI Score], [People Three Plus One].[Adjust Percentage], [People Three Plus One].[Evidence to Adjust Score], [Organisational Codes].[Organisational Unit], [Job Codes].Job, [People Three Plus One ISP Contract].[KPI Score]/100*[KPI Weighting], [People_1].[First Name] & \, [People Three Plus One ISP Contract].[KPI Weighting], People.[People ID] FROM [People], [Positions], [People], [People Three Plus One], [People Three Plus One ISP Contract], [Applications], [Job Codes], [Organisational Codes]