Background
Proseware, Inc. is an industry leading software company with several thousand employees. The company has had some trouble recruiting talented employees. Top-level candidates interview with the company but go on to work for competitors.
Feedback from candidates show that some offers were not accepted because the interview scheduling process was unpleasant. The company does not have a system to keep track of the candidates that were not selected.
Current Environment
The recruiting process starts when an individual applies for a position on the company website. The individual may have found the position on their own, they may have been officially referred by an employee, or in some cases were contacted directly by a hiring manager and encouraged to apply.
Recruiters schedule an interview with a hiring manager and interviews with two senior team members.
Each interview results in feedback about the candidate and a recommendation whether to hire or not.
The recruiting team manages all information by using a model-driven application.
The company has the following Microsoft Dataverse tables and columns:
JobPosting
- Hiring Manager - lookup to SystemUser
- Recruiter Assigned - lookup to SystemUser
Contact (Job Applicant)
- Contact identifier
- First name
- Last name
- Time-Zone Offset
- Person of Interest - Yes/No (default)
Application proapplication
- Contact identifier, Contact - lookup to Contact
- Job Posting - lookup to JobPosting
- pro_recruiterassignedid
Interview
- Application - lookup to Application
- Job Posting - lookup to JobPosting
- Recommend - Choice (Yes (0), No (1), and null (default) are the available values)
- Person of Interest - Yes/No, No is the default value
Referral
- Contact - lookup to Contact
- Referrer - lookup to SystemUser
- Job Posting - lookup to JobPosting
SystemUser
- Manager - lookup to SystemUser
- Time-Zone Offset
Recruiter
- Recruiter identifier
- Recruiter name
Applications
There may be multiple applications associated with each job posting. Applications are linked to an employee record if an employee referred the applicant for a position. The same individual can be an applicant for multiple job postings.
Interviews
Each interview is performed by an employee and is related to a single application.
The interview scheduling process may force potential candidates to accept interviews at unusual times with the senior team members due to time-zone differences.
Requirements. Interview Scheduling
The system must provide recruiters with a list of team members and their time-zone information. You must create a Microsoft Power Apps Component Framework (PCF) control for the Job Application form to display a list of senior team members who report directly to a hiring manager.
1. The control must display the current time in each team member's local time.
2. The control must be bound so that it minimizes the amount of code that must be written.
3. You must display the list of team members and sort the list to show team members who reside in time zones closest to the applicant's time zone first.
You must develop a second PCF control that displays the time-zone name and current time on the Job Application form. You must display the data in the candidate's local time.
Requirements. Historical Information Tracking
You must create a process to identify individuals as a person of interest that the company should consider hiring. You must assign each individual a score based on their past interactions.
You must be able to determine the following information about a candidate:
- The number of interviews in the past two years and whether team members provided
recommendations
- The number of hiring manager referrals and employee referrals in the past two years
- Whether the individual has any of the 12 designations or certifications that the company considers
significant
Only a single referral can be made per job application. The system must be able to support multiple referrals for a candidate.
The system must track referrals even if an application is not completed.
Requirements. Historical Information Scoring
The automated process must run weekly to assess all candidates. The process must also run automatically when historical information is updated. You must be able to perform scoring by selecting a command button on the contact form.
This new command button must only be visible to employees who belong to a security role assigned named Recruiter. The command button must not be visible to anyone unless the contact form is in Update
mode.
A person of interest is defined as having a score of 15 or more based on the following historical information criteria:
- Each interview with a recommendation adds two to the score.
- Each interview without a recommendation subtracts two from the score.
- Each employee or manager referral adds one to the score.
- Each designation or certification adds one to the score.
All scoring elements must be recalculated when changes occur. You must assign the score to the Person of interest field.
Values representing totals or scores must be stored in their own numeric fields.
Plug-ins must be used to keep the Person of Interest field on active interview records associated with the Contact.
Plug-ins registered on the update of the Person of interest field must send an email notification when the candidate named in the email is a person of interest. Recruiters must receive the message when the field is updated on the Contact record.
Interviewers must get an email notification when the Person of Interest field on the interview record is successfully updated.
Requirements. Design Guidelines
The following design guidelines must be followed:
1. Schema changes must be made using the method requiring the least amount of storage to meet the requirement.
2. Out-of-the-box functionality must be used when possible.
3. Any code required to calculate scores must be able to be run from a single point.
4. Email notifications need to be kept to a minimum.
Issues
1. Recruiters report that the command button to score a candidate is not working. You debug the code and observe that the context input parameter is null.
2. The system does not support associating designations and certifications with candidates.
3. The value for the field used by the PCF control to display local time is saved to Microsoft Dataverse each time an active application record is opened.
4. Interviewers report that they do not receive email notifications when interview records are created for an existing person of interest.