Employee Central (EC) relies on the field “To be Hired/Vacant”, set to either “Yes” or “No” , to identify if a position is vacant or not. EC does not offer a standard advanced report which can determine if a position is truly vacant, relying wholly on the “To be hired/Vacant” field. The weakness of this approach is that the position can be erroneously flagged as vacant, yet is occupied or left set to “Yes” when the position is truly vacant.
To produce a report on vacant positions that does not rely on the “To be Hired/Vacant” field, an advanced report can be created joining the following 2 table, and filtering on Last Name = Null.
1) Position table
2) Incumbent(s) Global Job Information
This will return a list of all positions, where the incumbents “Last Name” is null, under the assumption that all users in Employee Central are required to have a Last name.
To round this report out and make it useful to the end user, additional position related data should be added. (Position Name, Location, Business Unit Department, Cost Center, etc)
