TAM - Screening Question Query
The TAM Screening Question Query was created to provide a searchable way to view complete screening questions and their related answers from HRS. The query is 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. This public query allows those with the Recruiter security role the ability to query screening questions within HRS.
- Use of a percent sign (%) before and after the keyword is required.
- This query will be run on an Ad Hoc basis.
- Navigate to: Reporting Tools > Query > Query Viewer.
- In the "begins with" field, enter some or all of the query name UW_TA_SCR_QSTNS.
- Click Search.
- Click either HTML or Excel to select which format to run the query. A new browser tab will open.
- Enter a keyword 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.
- 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%
- To search for all screening questions in a category, enter the shorthand abbreviation surrounded by a % sign. i.e. %CR%.
- 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:
- ED = Education
- CR = Certificates
- TR = Training
- EX = Experience
- LS = Leadership
- BC = Broadcast
- TW = Team Work
- RS = Research
- OT = Others
- Click on the View Results button.
- 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 Job Opening(s) .