Skip to content

Query: Qry People Disciplinary Hearing Process List

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

Tables Referenced

  • People
  • People Disciplinary Hearing Process

Columns Selected

  • [People Disciplinary Hearing Process].[People Disciplinary Hearing Process ID]
  • [People Disciplinary Hearing Process].[People ID]
  • [People Disciplinary Hearing Process].[Date Captured]
  • [People Disciplinary Hearing Process].[Captured By]
  • Charges
  • [People Disciplinary Hearing Process].[Hearing Date]
  • Chairperson
  • Outcome
  • Notes

SQL

SELECT [People Disciplinary Hearing Process].[People Disciplinary Hearing Process ID], [People Disciplinary Hearing Process].[People ID], [People Disciplinary Hearing Process].[Date Captured], [People Disciplinary Hearing Process].[Captured By], [People Disciplinary Hearing Process].Charges, [People Disciplinary Hearing Process].[Hearing Date], [People Disciplinary Hearing Process].Chairperson, [People Disciplinary Hearing Process].Outcome, [People Disciplinary Hearing Process].Notes FROM [People Disciplinary Hearing Process]