Skip to content

Query: Qry MeGRAPH

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

Tables Referenced

  • People MeGRAPH Scores
  • Positions
  • People
  • Applications
  • Organisational Codes
  • Organisational
  • Pay Points

Columns Selected

  • [Organisational Codes].[Organisational Unit]
  • [Pay Points].[Pay Point]
  • [First Name] & \
  • [People MeGRAPH Scores].[Date Captured]
  • Quarter
  • [People MeGRAPH Scores].[Quarter Year]
  • [People MeGRAPH Scores].[Me Score]
  • [People MeGRAPH Scores].[G Score]
  • [People MeGRAPH Scores].[R Score]
  • [People MeGRAPH Scores].[A Score]
  • [People MeGRAPH Scores].[P Score]
  • [People MeGRAPH Scores].[H Score]
  • [Pay Points].[Pay Point ID]

SQL

SELECT [Organisational Codes].[Organisational Unit], [Pay Points].[Pay Point], [First Name] & \, [People MeGRAPH Scores].[Date Captured], [People MeGRAPH Scores].Quarter, [People MeGRAPH Scores].[Quarter Year], [People MeGRAPH Scores].[Me Score], [People MeGRAPH Scores].[G Score], [People MeGRAPH Scores].[R Score], [People MeGRAPH Scores].[A Score], [People MeGRAPH Scores].[P Score], [People MeGRAPH Scores].[H Score], [Pay Points].[Pay Point ID] FROM [Organisational Codes], [Positions], [People MeGRAPH Scores], [People], [Applications], [Pay Points]