TAM - Screening Question Query

This public query allows those with the Recruiter or TA Affirmative Action TAM security role the ability to query screening questions within HRS.

Procedure At-A-Glance
Category: Recruiting/Screening
Audience: Campus Recruiters or Affirmative Action employees
Overarching Process: Manage Job Openings & Applicants
Navigation: Reporting Tools > Query > Query Viewer > UW_TA_SCR_QSTNS

General Description

The TAM Screening Question Query was created to provide a searchable way to view complete screening questions and their related answers from HRS.

Primarily used by institutional Recruiters or designee to locate appropriate screening questions and correct answer combinations to assist when creating a new job Opening within TAM. 

Process Inputs

Use of a percent sign (%) before and after the keyword is required.

Process Outputs

Output Format: Excel or HTML within the web browser
Query Fields:
  • Question ID
  • Question Code
  • Descr (Description)
  • Short Desc (Short Description)
  • Long Descr (Long Description)
  • Answer
  • Correct Ans (Correct Answer)
  • Descr (Answer Description)
  • Short Desc (Answer Short Description)
  • Long Descr (Answer Long Description)

Process Considerations

This query will be run on an Ad Hoc basis.

Security Roles

    Users with the following security roles will have access to run this query.
    • Recruiter
    • TA Affirmative Action

    Procedure Steps

    1. Navigate to HRS: Reporting Tools > Query > Query Viewer.

    2. In the "begins with" field, enter the query name UW_TA_SCR_QSTNS.  Select the Search button

    3. Click either HTML or Excel to select which format to run the query.  A new browser tab will open.

    4. Enter a keyword by which to search the screening question library.  You must use percent signs (%) before and after the keyword.  The query will not work unless you place a % in front of and after the keyword. 

    5. Click on the View Results button.

    To return all questions in the TAM screening question library, type two % signs and click View Results. i.e. %%

    To search for an exact phrase, place a % before and after the phrase.  i.e %social work%.

    To search for multiple words, parse out each word by surrounding each one with a % sign.  i.e. %social%work%.

    The query is case sensitive.   Running the query using capital letters will return different search results.  i.e. %Social Work% vs. %social work%

    This query will search both the Long description field as well as the Question Code field for the keyword. Searching by Question Code can be used to return an entire category of questions.  Question Codes are identified in the following:

    1. ED = Education

    2. CR = Certificates

    3. TR = Training

    4. EX = Experience

    5. LS = Leadership

    6. BC = Broadcast

    7. TW = Team Work

    8. RS = Research

    9. OT = Others

    To search for all screening questions in a category, enter the shorthand abbreviation surrounded by a % sign. i.e. %CR%.

    6. Once the appropriate question is found, make note of the Question ID, Question Code, or Descr field.  This can then be entered into the Screening Criteria through the standard method on the Job Opening Screening tab by using the Question ID, Question Code, or Description fields from this query.  Reference TAM - Create a Job Opening - Screening.

    Related Policies, Job Aids and Forms

    Related Policies

    • N/A

    Related Job Aids

    • N/A

    Related Forms

      • N/A

      Keywords:Screening, TAM, Query, Screening Question, Screening Answer, Answer, criteria, library   Doc ID:51784
      Owner:Sheila W.Group:Human Resource System (HRS)
      Created:2015-05-29 14:41 CDTUpdated:2016-06-24 09:44 CDT
      Sites:Human Resource System (HRS)
      Feedback:  0   0