CRM Employee Summary Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

This report can contain two types of sections:

• Default sections — You select the default sections in Report Sections to Include on the General tab. Each default section contains a pre-defined set of columns. You do not select the columns for the default sections. The table below provides descriptions of the columns in the default sections.
• User-defined sections — If you set up user-defined sections for this report, use the Columns tab to select the columns for each of those sections and specify column attributes. The columns available for user-defined columns are the same as those available for the Employee List. Refer to the help topics for the Employee List for descriptions of the columns that you can select for user-defined columns.

You can include both default sections and user-defined sections on the same report.

Contents

Field	Description
Employee	This column displays the employee's full name: first, middle, and last name, with prefix and suffix.
Number	This column displays the employee identification number.
Title	This column displays the employee's job title or job function.
Preferred Name	This column displays the name by which the employee prefers to be addressed.
Organization	If your firm uses organizations in Ajera CRM, this column displays the organization to which the employee is assigned.
Supervisor	The name of the employee's supervisor. When you preview this report, you can click the supervisor's name to drill down. Ajera CRM displays a CRM Employee Summary report that shows information about the supervisor.
Hire Date	This column displays the date on which the employee was hired.
Address 1	This column displays the employee's street address (street name and number, apartment number, P.O. Box number, and so on).
City, State, Zip	This column displays the city, state, and zip code from the employee's address.
Consultant	This column contains Y or N (Yes or No) to indicate whether or not the employee is a consultant.
Years with Other Firms	This column displays the number of years the employee worked for other companies.
Email	This column displays the employee's email address.
Home Phone	This column displays the employee's home telephone number.
Work Phone, Ext	This column displays the employee's work telephone number and extension.
Memo	This column displays the text entered in Notes on the General tab of the Employee Info Center. The report only displays the notes text if you have the correct security access.
Activities - Completed	The activity can be Pending or Completed.
Activities - Type	This column displays the activity type (for example, Phone Call, Meeting, or Email).
Activities - Subject	This column displays a brief description of the activity (for example, Initial Consultation, Planning Meeting, Customer Lunch, or Follow-up Visit).
Activities - Start Date	This column displays the date and time that the activity is scheduled to begin.
Activities - Priority	This column displays the priority ranking that indicates the relative importance of individual activities: High, Medium, or Low.
Activities - Owner	This column displays the name of the employee who is responsible for the activity.
Activities - Client Contact	This column displays the name of the client contact associated with the activity.
Activities - Client Contact Bus. Phone	This column displays the client contact's work telephone number.
Activities - Vendor	This column displays the name of the vendor associated with the activity.
Activities - Vendor Contact	This column displays the name of the vendor contact associated with the activity.
Activities - Vendor Contact Bus. Phone	This column displays the vendor contact's work telephone number.
Activities - Opportunity	This column displays the name of the opportunity associated with the activity.
Activities - Project	This column displays the name of the project associated with the activity.
Activities - Marketing Campaign	This column displays the marketing campaign associated with the activity.
Activities - Lead	This column displays the lead associated with the activity.
Activities - Location	This column displays the location where the activity occurred or will occur.
Activities - Notes	This column displays additional text that describes the activity.
Projects - Name	This column displays the name of the project.
Projects - Number	This column displays the project identifier.
Projects - Role	This column displays the role of the employee in the project (for example, Transportation Engineer or Geologist).
Projects - Role Description	This column displays additional text describing the employee's role in the project.
Education - Degree	This column displays the degrees the employee earned (for example, BA Bachelor of Arts, BS Bachelor of Science, or MA Master of Arts).
Education - Institution	This column displays the educational institution where the employee earned the degree.
Education - Specialty	This column displays the specialty associated with the employee's degree.
Education - Year	This column displays the year the employee received the degree.
Education - Proposals	This column contains Y or N (Yes or No) to indicate whether or not this education information can be used in proposals.
Licenses - License	This column displays the names of the licenses the employee holds (for example, CPG Certified Professional Geologist or PE Professional Engineer).
Licenses - Earned	This column displays the year the year the employee became licensed.
Licenses - State	This column displays the state in which the employee is licensed.
Licenses - Number	This column displays the license number.
Licenses - Expires	This column displays the license expiration date.
Licenses - Last Renewal	This column displays the date the license was most recently renewed.
Licenses - Proposals	This column contains Y or N (Yes or No) to indicate whether or not the license information can be used in proposals.
Skills - Skill	This column displays descriptions of employee skills or disciplines.
Skills - Level	This column displays the skill level. For example, Ajera CRM could be set up to provide the following set of levels based on years of experience: Entry 1-2 Years 3-5 Years 6-10 Years Over 10 Years
Skills - Primary	This column contains Y or N (Yes or No) to indicate whether or not the skill is the employee's primary skill.
Resumes - Resumes	This column displays the employee's resume information.
Opportunities - Number	This column displays the identifier of the opportunity associated with the employee.
Opportunities - Name	This column displays the name of the opportunity.
Opportunities - Stage	This column displays the current stage of the opportunity (for example, Pending, Awarded, or Lost).
Clients - Name	This column displays the name of the client for which the employee has performed work.
Clients - Number	This column displays the client identifier.
Clients - Relationship	This column displays the employee's relationship to the client (for example, Client Manager or Principal Assigned).
Clients - Description	This column displays the description of the employee's association with the client.
Contacts - Name	This column displays the first name and last name of the contact with which the employee is associated.
Contacts - Title	This column displays the contact's title (for example, Vice President, Principal, or Project Manager).
Contacts - Relationship	This column displays the employee's relationship to the contact (for example, Client Manager or Former Employee).
Contacts - Client	This column displays the name of the client associated with the contact.
Contacts - Phone	This column displays the contact's phone number.