/
Database view containing recruitment status description in Pending Applicants

Database view containing recruitment status description in Pending Applicants

Owned by Knowledge Assistant
Jun 21, 2022
1 min read



Description of Issue

User needs TRS view containing recruitment status description in Pending Applicants program



Context

  • Munis all versions

  • Tyler Reporting Services views

  • Pending Applicants



Cause

The view database overlay shows only the status code.



Resolution

To view this description in Munis, follow the steps below:

  1. Navigate to Munis menu > Human Capital Management > Recruiting > Pending Applicants

  2. Search for a given requisition number, the field Recruitment Status under MAIN tab contains the description.

The description for this status code is available in TRS view pr_miscellaneous under the column ms_desc_long. In following SQL query, replace XXXX with the status code in Pending Applicants to get the description:

SELECT

a_misc_code,

ms_desc_short,

ms_desc_long

FROM pr_miscellaneous

WHERE a_code_type = 'RSTS'

and a_misc_code = 'XXXX'



Additional Information