Changes to Query Tools > Technician

Version 8.2.4 Changes

• TECHNICIAN CERTIFICATIONS: Added the Contractor field from Staff table to the Technician Certification Query in DOH Vendor.

Version 6.1.1 Changes

• CLASS REGISTRATION/ENROLLMENT: Added the Office Location field to the query tool.

• TECHNICIAN CERTIFICATIONS: Added the Office Location field to the query tool.

Vendor 3.7 Changes

• CLASS INFORMATION: The double-click navigation feature that enables the Technician Class window to be opened from the Query Tool has been corrected.

• CLASS REGISTRATION/ENROLLMENT: The 'Producer/Supplier Name' and 'Other Company Name' fields are now available for selection.

Version 3.6 Changes

• COURSE INFORMATION: The query tool has been corrected to prevent the truncation of phone number information.

Version 3.5 Changes

• CLASS REGISTRATION/ENROLLMENT: This query has been updated to include all information contained in the registration and enrollment windows, including all test information (available only to those users with proper security).

• TECHNICIAN CERTIFICATIONS: This query tool has been updated to include all OJT/Apprenticeship information (previously available in a separate query tool).

• TECHNICIAN OJT/APPRENTICESHIP: This query tool has been removed, and all information has been merged into the Technician Certification query.

• TECHNICIAN TEST INFORMATION: This query tool has been removed, and all information has been moved to the Class Registration/Enrollment query tool.

• TECHNICIAN TEST RESULTS: This query tool has been removed, and all information has been moved to the Class Registration/Enrollment query tool.

Version 3.3 Changes

• GENERAL - The Technician query tool has been updated to add new queries (see below) and re-sort the menu items alphabetically. In addition, all technician queries have been updated to provide navigation from the query tool results (Snapshot Report) to the appropriate window by double-clicking the appropriate row in the Snapshot Report.

• GENERAL - The query criteria has been changed on all technician queries to replace the Technician/Inspector First Name, Middle Initial and Last Name fields with Technician [name] and Staff List icon to search for name. This will simplify the process for generating queries based on a technician's name.

• The Technician Query Tool has been updated to add two new queries:

  1. CLASS INFORMATION - Users with adequate permission can access information on the following:
     • City
     • Class ID
     • Course Number
     • Course Name
     • End Date
     • Instructor
     • Location
     • Passing Score
     • Room Seats
     • Start Date
     • State
     • Status
     • Test Name

  2. COURSE INFORMATION - Users with adequate permission can access information on the following:

     • Comment
     • Contact Name
     • Course Active
     • Course Description
     • Course ID

• CLASS REGISTRATION/ENROLLMENT - The Technician Query Tools have been updated to make changes to the Enrollment query. This query has been renamed to Class Registration/Enrollment. The available criteria for generating this query have also been updated with the following changes:

  • New Columns:
    • Class ID
    • Class Status - (Open/Closed/Canceled)
    • Certification
    • Payment Method
    • Priority
    • Fee Received Date
    • Registration Date
    • Job Title
    • Office Location

  • Updated Columns:
    • Course Number
    • Course Name
    • Class Start Date (Renamed from Start Date)
    • Class End Date (Renamed from End Date)
    • Class City
    • Class State
    • Technician ID
    • Staff ID
    • Enrollment Status (Renamed from Status)

• TECHNICIAN CERTIFICATIONS - Information about OJT/APPRENTICESHIP attributes has been added. Users with adequate permission can access information on the following:
  • Apprenticeship Program Name
  • Final Review Technician Name
  • Score
  • Technician Name
  • Technician ID
  • Staff ID

Version 2.5 Changes

• If a field has limited valid choices such as Yes or No, these are included in the list box to the right of the Value field in the Criteria Columns selection grid. The criteria is selected from the list instead of being typed into the field.

Page last updated 30 March 2012