Job Interviews

Interviews

This table links all job interview records to interviewees, interviewers, interview questions, and interview responses. If the interview rating is 5.0 or lower, a red bar appears at the left border of the row. The row is highlighted in green if the interview has already been marked as Passed, yellow if the interview is still being completed, and gray if the interview is for review.

Fields

ID. An autogenerated unique identifier for this job interview record or row.
Interviewee. This field is linked to the Interviewees table, indicating the interviewee responding to this interview.
Interview rating. This is a formula field that takes the average of all the interview response scores corresponding to this interview.
Role. This is a formula field that returns the corresponding role or title of the interviewee fetched from the Interviewees table.
Department. A lookup field that returns the interviewee’s assigned department based on the Interviewee field.
Interviewed by. This field is linked to the Employees table, indicating the employee who conducted the interview.
Type. This is a single select field for specifying the type of session for this interview. By default, an interview session could be any of the following: Phone; Group; One-on-one; Panel; Informal/casual; or, Technical test.
Status. This is a single select field for specifying the current status of this interview. By default, an interview could be any of the following: Scheduled; On hold; Cancelled; Interviewee declined; For review; Failed; or, Passed.
Date of interview . The scheduled date and time of this interview.
Notes. Any additional remarks or comments pertaining to this interview.
Date added. The date and time this interview record was added to the database.
Date updated. The most recent date and time this interview record was modified.
Department for sorting. A formula field that creates a plain text copy of the Department field. This field is used for sorting records. This field is hidden by default.
Interviewee for sorting. A formula field that creates a plain text copy of the Interviewee field. This field is used for sorting records. This field is hidden by default.
Related answers. This field is linked to the Answers table, specifying all interview responses associated with this interview. This field is hidden by default.

Views

All interviews. Displays all job interviews without filters, sorted alphabetically by the Department for sorting field from A to Z, then by the Role field, and then by the Interviewee for sorting field.
Best interviews. Displays job interviews with interview ratings equivalent to 8 or above, sorted by the Interview rating field from the highest rating to the lowest, and then by the Interviewee for sorting field.
Scheduled interviews. Displays job interviews with Scheduled or On hold status, sorted alphabetically by the Department for sorting field from A to Z, then by the Role field, and then by the Interviewee for sorting field.
Completed interviews. Displays job interviews with Passed, Failed, or For review status, sorted alphabetically by the Department for sorting field from A to Z, then by the Role field, and then by the Interviewee for sorting field.
Interviews for human resources. Displays job interviews associated with the Human resources department, sorted alphabetically by the Role field from A to Z, and then by the Interviewee for sorting field.
Interviews for research and development. Displays job interviews associated with the Research and development department, sorted alphabetically by the Role field from A to Z, and then by the Interviewee for sorting field.
Interviews for sales. Displays job interviews associated with the Sales department, sorted alphabetically by the Role field from A to Z, and then by the Interviewee for sorting field.
Add an interview. Displays a form view that facilitates adding new job interviews to this table.
By type. Displays a kanban view of all the job interviews stacked by Type.
By status. Displays a kanban view of all the job interviews stacked by Status.

Questions

This table contains all job interview questions. A question record or row may be linked to multiple answers or interview responses from the Answers table. If a question row was not used, a red bar appears on its left border side.

Fields

ID. An autogenerated unique identifier for this interview question record or row.
Department. This field is linked to the Departments table and shows which department this question is most relevant to.
Role. This field is linked to the Titles table and shows which title or role this question is most relevant to.
Question. This is a long text field that accommodates an entire interview question along with details and other explanations supporting this question.
Prepared by. This field is linked to the Employees table, indicating the employee who came up with this question.
Type. This is a single select field for specifying the type of interview question this record is. By default, an interview question could be any of the following: Behavioral; Situational; Communication; or, Skill-based.
Notes. Any additional remarks or comments pertaining to this question.
Date added. The date and time this interview question was added to the database.
Date updated. The most recent date and time this interview question was modified.
Use count. This is a formula that counts the number of times this question has been used and may be responded to.
Related answers. This field is linked to the Answers table and shows all of the answers that interviewees gave to this question. This field is hidden by default.
Department for sorting. A formula field that creates a plain text copy of the Department field. This field is used for sorting records. This field is hidden by default.
Role for sorting. A formula field that creates a plain text copy of the Role field. This field is used for sorting records. This field is hidden by default.

Views

All questions. Displays all job interview questions without filters, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
Questions for Assistant Recruiters. Displays job interview questions for the Assistant Recruiter role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
Questions for Associate Quality Assurance Engineers. Displays job interview questions for the Quality Assurance Engineer role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
Questions for Customer Service Officers. Displays job interview questions for the Customer Service Officer role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
Questions for Software Engineers. Displays job interview questions for the Software Engineer role, sorted alphabetically by the Department for sorting field from A to Z, and then by the Role for sorting field.
Add a question. Displays a form view that facilitates adding new job interview questions to this table.
By type. Displays a kanban view of all the job interview questions stacked by Type.

Answers

All of the answers from the interviewee are stored and organized in this table. Rows are grouped by interview. Background colors are used to make it easy to group interview answers. Feel free to make a separate view for every interviewee or responder.

Fields

ID. An autogenerated unique identifier for this interview answer record or row.
Interview ID. This field is linked to the Interviews table and shows which interview this interviewee’s response is for.
Interviewee. A lookup field that returns the interviewee’s full name based on the Interviewee ID field.
Index. A number field that can be set by the user to show where this response should go. This field is used to put questions in the right order in a list.
Question ID. This field is linked to the Questions table and shows which interview question this interviewee’s answer is for.
Question. A lookup field that returns the actual interview question based on the Question ID field.
Answer. A long text field where the interviewee can put their whole answer or response to a linked question, as well as details and other explanations to back up their answer.
Answer score. The score for the interviewee’s response on a scale from 1 to 10, with 10 being the best and 1 being the worst.
Is match. A formula field that checks to see if the question matches the role of the interviewee. If a match is not detected, a red bar shows up on the left side of the answer row.
Date added. The date and time this interview response was added to the database.
Date updated. The most recent date and time this interview response was modified.
Group bgcolor. This is a formula field that is used to automatically assign group colors to interview answers. These group colors are used as group background colors to make it easy to tell which response groups are which. This field is hidden by default.
Interview ID for sorting. A formula field that creates a plain text copy of the Interview ID field. This field is used for sorting records. This field is hidden by default.

Views

All answers. Displays all job interview answers without filters, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Bran O. Lopez. Displays all job interview answers by Bran O. Lopez, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Elizabeth C. Cunningham. Displays all job interview answers by Elizabeth C. Cunningham, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Latisha O. Mazon. Displays all job interview answers by Latisha O. Mazon, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Michael I. Robicheaux. Displays all job interview answers by Michael I. Robicheaux, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Nora S. Mott. Displays all job interview answers by Nora S. Mott, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Rodney G. Tran. Displays all job interview answers by Rodney G. Tran, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Answers by Sandra A. Love. Displays all job interview answers by Sandra A. Love, sorted by Interview ID for sorting field from the smallest to the highest number, and then by the No. field from the smallest to the highest number.
Add answer. Displays a form view that facilitates adding new interview question answers to this table.

Interviewees

All of the information about the people who responded to a job interview is stored in this table. You may want to add more people who you’ll be scheduling for interviews too. A red bar shows up on the left side of a row if that record hasn’t been given an interview yet.

Fields

Full name. A formula field that returns the interviewee’s full name.
Photo. The interviewee’s photograph.
Last name. The interviewee’s last name.
First name. The interviewee’s first (given) name.
Middle initial. The interviewee’s middle initial.
Title. This field is linked to the Titles table, indicating the interviewee’s assigned title or role in the organization.
Department. This field is linked to the Departments table, which indicates the department the interviewee belongs.
Interview count. This field is a formula that counts the total number of interviews this interviewee has responded to.
Phone number. The interviewee’s current phone or mobile number.
Email. The interviewee’s email address.
Address. The interviewee’s home address.
Zip code. The mailing zip code of the interviewee’s home address.
Remarks. This field is for recording any notes or remarks about the interviewee.
Status. The assigned employment status of the interviewee.
Date added. This is the date and time this interviewee was added to the database.
Related interviews. This field is linked to the Interviews table, indicating all interviews responded to by this interviewee. This field is hidden by default.

Views

All interviewee. Displays all interviewees without any filters, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Add new interviewee. Displays a form view for the purpose of simplifying the entry of basic contact information for interviewees.
Full-time. Displays a gallery of interviewees assigned as full-time, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Part-time. Displays a gallery of interviewees assigned as part-time, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Seasonal. Displays a gallery of interviewees assigned as seasonal, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Temporary. Displays a gallery of interviewees assigned as temporary, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Interviewee by status. Displays a kanban view of all interviewees stacked by Status.

Employees

In the Employees table, you can find contact information for each person in your organization. This table is connected to most of the other tables in this database. Feel free to add or remove fields from this table to fit or meet your organization’s security policy.

Fields

Full name. A formula field that returns the employee’s full name.
Photo. The employee’s photograph.
Last name. The employee’s last name.
First name. The employee’s first (given) name.
Middle initial. The employee’s middle initial.
Title. This field is linked to the Titles table, indicating the employee’s current title or position in the organization.
Department. This field is linked to the Departments table, which indicates the department the employee belongs.
Office location. This field is linked to the Office locations table, indicating the location of the employee’s office.
Local extension number. The employee’s local or extension number based on the organization’s trunk line.
Phone number. The employee’s current phone or mobile number.
Email. The employee’s email address.
Address. The employee’s home address.
Zip code. The mailing zip code of the employee’s home address.
Remarks. This field is for recording any notes or remarks about the employee.
Start date. The date the employee joined the organization.
End date. The date the employee left the organization. This is used when the employee is inactive or has left the organization.
Status. The employment status of the employee.
Is active. A checkbox that indicates whether the employee is still with the organization or not.
Related interviews. This field is linked to the Interviews table, indicating all interviews conducted by this employee. This field is hidden by default.

Views

All employees. Displays all employees without any filters, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Add new employee. Displays a form view for the purpose of simplifying the entry of basic contact information for employees.
Active employees. Displays a gallery of all active employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Full-time employees. Displays a gallery of all active, full-time employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Part-time employees. Displays a gallery of all active, part-time employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Seasonal employees. Displays a gallery of all active, seasonal employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Temporary employees. Displays a gallery of all active, temporary employees, sorted alphabetically by Last name from A to Z, then by First name from A to Z.
Employees by status. Displays a kanban view of active employees stacked by Status.

Titles

With this table, you can keep track of a list of job roles and their descriptions. As an example, this template comes with a list of titles for a software development business.

Fields

Name. The position name.
Level. A single select field specifying the position’s level in the hierarchy of roles.
Description. A description of the title, which may include position specifics and responsibilities.
Interviewee count. A formula field that counts the number of interviewees with this title.
Related employees. This field is linked to the Employees table, identifying all employees or staff members using this title. This field is hidden by default.
Related interviewees. This field is linked to the Interviewees table, identifying all interviewees with this title or role. This field is hidden by default.

Views

All titles. Displays all the titles or staff designations in an organization without any filters.
Business analysis. Displays all titles related to business analysis.
Quality assurance. Displays all titles related to quality assurance.
Software engineering. Displays all titles related to software engineering.
Human resources. Displays all titles related to human resources or recruitment.
Executive. Displays all titles related to the company’s executives.
By level. Displays a kanban view of all titles stacked by Level.

Departments

There are various kinds of departments, such as those that deal with finance, law, human resources, advertising, etc. In large and medium-sized companies, it’s common for these departments to work together to do business tasks. Use this table as needed to make it work for your company.

Fields

Name. The name of the department.
Description. A short description of the department.
Interviewee count. A formula field that counts the number of interviewees under this department.
Is active. A checkbox that indicates whether the department is active or not.
Related employees. This field is linked to the Employees table, indicating all employees assigned to the current department. This field is hidden by default.
Related interviewees. This field is linked to the Interviewees table, indicating all interviewees assigned to the current department. This field is hidden by default.

Views

All departments. Displays all departments sorted in alphabetical order by Name from A to Z.
Active departments. Displays a gallery of active departments arranged in alphabetical order by Name from A to Z.

Office locations

Your office will get bigger as your business grows. There is a good chance that you will grow into new places and spaces. You can keep track of where your offices are with this table.

Fields

Location. The name or identifier of the specific location.
Photo. A photograph of the building or office room identifying this location.
Floor. This specifies the building level or floor where the office room is located.
Street. This is the street where this office is located.
City. This is the city where this office is located.
State. This is the state where this office is located.
Zip code. The mailing zip code of this office location.
Phone number. The main or trunk line phone number of this location.
Employee count. A formula field that counts the number of active employees in this location.
Related employees. This field is linked to the Employees table, identifying all employees or staff members assigned to this location. This field is hidden by default.

Views

All locations. Displays all the locations of the organization’s offices without any filters sorted by Location in alphabetical order from A to Z.
Locations. Displays a gallery of the organization’s offices.