---
title: "SP Evaluations Table"
canonical: "https://help.agiloft.com/space/SD/44434551/SP+Evaluations+Table"
format: markdown
---
The SP Evaluations table stores the questionnaires that performance evaluators complete. Evaluators typically access SP Evaluation records from the End User Interface (EUI), and contract managers access them from the parent Contract or Company records.

# Creating Records

SP Evaluation records are typically created manually or automatically from Contract records. 

Once the evaluation is created, the assigned evaluator is notified and can access the record through the link in the email or by logging into the EUI and opening their assigned evaluations. After the evaluator answers all evaluation questions, they click Mark Complete and the Performance Manager gets notified of a completed evaluation. The score results are displayed in the Contract and Company records and are used for charts and reports.

SP Evaluation records are owned by the evaluator.

# Views

The out-of-the-box SP Evaluations table includes the [standard views](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43718574). The Default View shows the Edit icon, ID, Company Name, Evaluator, Question Set, Status, Date Evaluation Completed, and Overall Percent Score fields.

![Default View for the SP Evaluations table](media://2c28a1e2-e48f-47d3-906f-d777ebbbb424)

# Charts/Reports

In the out-of-the-box system, the SP Evaluations table includes the following charts and reports.

- **All Performance Scores (RT Supplier)**: Reports on all of the average overall performance scores for the selected company.
- **Average Performance Score by Supplier, all suppliers (RT Period)**: Reports on the average overall performance score per company in the selected timeframe.
- **Delivery Score by Quarter**: Reports on the total average delivery score by quarter. The chart is used on the [Supplier: Performance Overview](https://agiloft-public.atlassian.net/wiki/spaces/SD/pages/44434399/Power+User+Dashboards#Supplier%3A-Performance-Overview) dashboard where it’s typically filtered by supplier.
- **Overall Score by Quarter**: Reports on the total average overall score by quarter. This chart is also used on the Supplier: Performance Overview dashboard.
- **Overall Score by Quarter (RT Supplier)**: Reports on the average overall score for the selected company.
- **Price Score by Quarter**: Reports on the total average price score by quarter. Also used on the Supplier: Performance Overview dashboard.
- **Quality Score by Quarter**: Reports on the total average quality score by quarter. Also used on the Supplier: Performance Overview dashboard.
- **Service Score by Quarter**: Reports on the total average service score by quarter. Also used on the Supplier: Performance Overview dashboard.

# Related Tables

The diagram below shows the default incoming table relationships and linked fields in the SP Evaluations table.

![Default table relationships for the SP Evaluations table](media://ef41acd8-0834-4f8b-a0c7-5baac9b21226)

# Fields

In addition to the [standard fields](https://agiloft-public.atlassian.net/wiki/spaces/SD/pages/44434023/Table+Concepts#standard_fields), the out-of-the-box SP Evaluations table includes the following fields.

| **Field Label** | **Data Type** | **Description** |
| --- | --- | --- |
| Awarded Score | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Answer Score for all SP Evaluation Questions. |
| Awarded Score: Delivery | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Answer Score for all SP Evaluation Questions with a KPI Type of Delivery. |
| Awarded Score: Price | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Answer Score for all SP Evaluation Questions with a KPI Type of Price. |
| Awarded Score: Quality | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Answer Score for all SP Evaluation Questions with a KPI Type of Quality. |
| Awarded Score: Service | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Answer Score for all SP Evaluation Questions with a KPI Type of Service. |
| Button: Cancel Evaluation | Action button | If Status is blank, Created, or Assigned, this button can be used to cancel the evaluation. |
| Button: Mark Complete | Action button | If Status is blank, Created, Assigned, or Canceled, this button can be used to mark the evaluation complete. |
| Company Name  
Company ID | Link to selected fields from other table: Companies | The supplier’s company. |
| Contract Linked?  
Company ID from Contract  
Contract End Date  
Contract Start Date  
Contract Title  
Contract Type  
Contract Date of Last Evaluation  
Contract Evaluation Frequency  
Contract ID  
Contract Performance Manager  
Contract Performance Manager ID | Link to selected fields from other table: Contracts | Details about the linked contract if there is one. |
| Contract Type Default Question Set  
Contract Type ID | Link to selected fields from other table: Contract Types | The contract type information for the linked contract. |
| Date Evaluation Completed | Date | The date the evaluation was completed. |
| Date Evaluation Due | Date | The due date for the evaluation. |
| Delivery Score | Calculated Result | The delivery score as a percentage, calculated by multiplying Awarded Score: Delivery by 100 and dividing the result by Max Score: Delivery. |
| Evaluator  
Evaluator ID | Link to selected fields from other table: People | Identifies the evaluator. |
| Max Score | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Maximum Score for all SP Evaluation Questions. |
| Max Score: Delivery | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Maximum Score for all SP Evaluation Questions with a KPI Type of Delivery. |
| Max Score: Price | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Maximum Score for all SP Evaluation Questions with a KPI Type of Price. |
| Max Score: Quality | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Maximum Score for all SP Evaluation Questions with a KPI Type of Quality. |
| Max Score: Service | Calculation on Multiple Linked Records: SP Evaluation Questions | The sum of the Maximum Score for all SP Evaluation Questions with a KPI Type of Service. |
| Number of Questions Pending | Calculation on Multiple Linked Records: SP Evaluation Questions | The number of SP Evaluation Questions that are unanswered. |
| Overall Percent Score | Calculated Result | The overall score as a percentage, calculated by multiplying Awarded Score by 100 and dividing the result by Max Score. |
| Price Score | Calculated Result | The price score as a percentage, calculated by multiplying Awarded Score: Price by 100 and dividing the result by Max Score: Price. |
| Quality Score | Calculated Result | The quality score as a percentage, calculated by multiplying Awarded Score: Quality by 100 and dividing the result by Max Score: Quality. |
| Service Score | Calculated Result | The service score as a percentage, calculated by multiplying Awarded Score: Service by 100 and dividing the result by Max Score: Service. |
| SP Evaluation Questions | Related Table: SP Evaluation Questions | The list of questions included in the evaluation. |
| SP Question Set ID  
Question Set | Link to selected fields from other table: SP Question Sets | The SP Question Set for this evaluation. |
| Status | Choice: Created, Canceled, Assigned, Completed | The current state of the evaluation. |
| Supplier Contact Phone  
Supplier Contact Email  
Primary Supplier Contact  
Supplier Contact ID | Link to selected fields from other table: People | Lists supplier contact information. |

# Automation

This section describes the rules that are implemented for the out-of-the-box SP Evaluations table. For details about rule configuration options, see [Rules](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714473) in the CLM Help.

- **Create: All Create Actions (email, web, API)**: This rule runs when SP Evaluation records are created and performs the following actions:
  - If Company is blank and Contract ID is not, the Company is set to the company from the Contract.
  - If Date Due is blank, it’s set to 7 days in the future.
  - If a question set is selected, it creates the evaluation questions from the set, notifies the evaluator, and changes the status to Assigned.
  - If a question set isn’t selected, the Performance Manager is notified that additional actions are required.
  - If Supplier Main Contact is blank, it’s set to one from the Contract.
- **Edit: All Edit Actions (email, web)**: This rule runs when records are edited and performs the following actions:
  - If the Status changes to Canceled, the Evaluator and Performance Manager are notified.
  - If the Evaluator changes, the new one gets notified.
- **TB Demo Data Update: Update date fields by one month each month so reports have data**: This time-based rule runs the first day of every month at 4:00am. It updates date fields in demo data records so they stay current.