Skip to content

Query: Qry People Disciplinary Grievance Process List

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

Tables Referenced

  • People
  • People Disciplinary Grievance Process

Columns Selected

  • [People Disciplinary Grievance Process].[People Disciplinary Grievance Process I
  • [People Disciplinary Grievance Process].[People ID]
  • [People Disciplinary Grievance Process].[Date Captured]
  • [People Disciplinary Grievance Process].[Captured By]
  • [People Disciplinary Grievance Process].[Reason Provided]
  • [People Disciplinary Grievance Process].[Lodged Against]
  • [People Disciplinary Grievance Process].[Record of Steps Taken]
  • [People Disciplinary Grievance Process].[Record of Consultation Dates]
  • Outcome

SQL

SELECT [People Disciplinary Grievance Process].[People Disciplinary Grievance Process I, [People Disciplinary Grievance Process].[People ID], [People Disciplinary Grievance Process].[Date Captured], [People Disciplinary Grievance Process].[Captured By], [People Disciplinary Grievance Process].[Reason Provided], [People Disciplinary Grievance Process].[Lodged Against], [People Disciplinary Grievance Process].[Record of Steps Taken], [People Disciplinary Grievance Process].[Record of Consultation Dates], [People Disciplinary Grievance Process].Outcome FROM [People Disciplinary Grievance Process]