1. Project Overview
The Job Application Tracking System is a company-level Salesforce application designed to streamline the end-toend recruitment process. This solution enables the company to manage job positions, candidate applications,
interview scheduling, and job offers efficiently. It combines standard Salesforce functionality with custom objects
and flows to provide a seamless experience for HR, recruiters, and hiring managers.
Key capabilities include:
– Creating and managing job positions with openings and salary details
– Allowing candidates to submit applications
– Scheduling interviews through guided flows
– Generating job offers
– Automatically tracking application statuses and reducing openings when offers are accepted
2. Standard & Custom Object
Standard Object:
We have customized the following standard objects in Salesforce:
• User
Custom Objects:
Below is the list of custom objects that we need to create in the system:
• Candidate
• Job Application1
• Job Position1
• Interview1
• Job Offer1
• Hiring Manager
1. Job_Position1__c
This object stores details about open roles within the organization, such as job title, department, location, hiring
manager and expected salary. It helps recruiters manage and publish available positions to which candidates can
apply.
| Field Label | Field Type | Picklist Value | Lookup To |
|---|---|---|---|
| Position Title | Name | N/A | N/A |
| Department | Picklist | HR Engineering Sales IT Analytics Marketing | N/A |
| Expected Salary | Currency | N/A | N/A |
| Hiring Manager | Lookup | N/A | Hiring Manager |
| Location | Picklist | Mumbai Bangalore Hyderabad Delhi Chennai Pune Remote | N/A |
| Opening | Number | N/A | N/A |
| Status | Picklist | Open Closed On Hold | N/A |
| Hiring Manager Name | Formula (HiringManager__r.Name__c) | N/A | N/A |
| Job Description | Long Text | N/A | N/A |
2. Job_Application1__c
This object captures candidate applications for job positions. It includes the applicant’s personal details, contact
information, uploaded resume, expected salary, and current application status. It links each application to a specific
job position and tracks its progress through the hiring process.
| Field Label | Field Type | Picklist Value | Lookup To |
|---|---|---|---|
| Job Application ID | Auto Number | N/A | N/A |
| Candidate Application | Lookup | N/A | Candidate |
| Candidate Name | Formula (CandidateApplication__r.Full_Name__c) | N/A | N/A |
| N/A | N/A | ||
| Phone | Phone | N/A | N/A |
| Job Position1 | Lookup | N/A | Job Position1 |
| Status | Picklist | Submitted In Review Interview Rejected Offered Shortlisted Closed | N/A |
| Expected Salary | Currency | N/A | N/A |
| Offered Salary | Formula (JobPosition1__r.Expected_Salary__c) | N/A | N/A |
| Submission Date | Date | N/A | N/A |
3. Interview1__c
This object stores information about scheduled interviews between candidates and interviewers. It includes the
interview date, interviewer’s name, and current interview status. It is linked to a specific job application to
maintain a complete interview history
| Field Label | Field Type | Picklist Value | Lookup To |
|---|---|---|---|
| Job Application | Lookup | N/A | Job Application |
| Interview Date | Date/Time | N/A | N/A |
| Candidate Name | Formula | N/A | N/A |
| Interview Type | Picklist | Phone Technical HR Final | N/A |
| Interviewer | Lookup | N/A | User |
| Interview Status | Picklist | Scheduled Completed Cancelled | N/A |
4. Job_Offer1__c
This object holds the job offers made to candidates. It includes the offer date, offered salary, joining date, and
current offer status (Made, Accepted, Rejected). Each offer is associated with a job application, and it helps
recruiters manage the offer process and track final outcomes.
| Field Label | Field Type | Picklist Value | Lookup To |
|---|---|---|---|
| Job Offer ID | Auto Number | N/A | N/A |
| Job Application | Lookup | N/A | Job Application |
| Candidate Name | Formula (Job_Application__r.Candidate_Name__c) | N/A | N/A |
| Offer Date | Date | N/A | N/A |
| Joining Date | Date | N/A | N/A |
| Offer Status | Picklist | Accepted Rejected Pending | N/A |
5. Candidate
This object stores information about individuals applying for jobs. It includes details such as the candidate’s name,
email, phone number, and resume. Each candidate may be associated with one or more job applications. This
object helps recruiters track applicant profiles, communicate with candidates, and manage their overall application
journey.
| Field Label | Field Type | Picklist Value | Lookup To |
|---|---|---|---|
| Candidate ID | Auto Number | N/A | N/A |
| Full Name | Text | N/A | N/A |
| N/A | N/A | ||
| Phone | Phone | N/A | N/A |
| Contact | Lookup | N/A | Contact |
