---
title: "Status Times Table"
canonical: "https://help.agiloft.com/space/SDA2512/218108411/Status+Times+Table"
format: markdown
---
The Status Times table tracks the time a record spends in each stage of its lifecycle. Time is measured as the number of days a record spends in a tracked Status. One Status Time record is generated for each tracked Status per record type. For example, there's one record for the time a contract spent in Draft status, another record for the time the same contract spent in Pending Review, another for With Counterparty, and so on. In the out-of-the-box system, Status Time tracking is enabled for Contracts, Approvals, and Sourcing Events.

# Record Creation

Users don't create records directly in the Status Times table. New records are created automatically every time a tracked record's status changes. Information from these records can be used in monthly reports, added to dashboards, and used for estimations and predictions. See [Charts/Reports](#charts_reports) below for details about the charts and reports that are included out-of-the-box.

Status Time records store the following types of information: 

- The related table, such as Contracts or Approvals
- The specific record in the related table
- The Status value being tracked
- Dates when the status changed to and from the tracked status value
- The amount of time between status start and end dates

# Views

The out-of-the-box Status Times table includes the [standard views](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43718574). The Default View shows the Edit icon, ID, Related To, Linked Source Record, Status, Next Status, Status Start Date, Status End Date, and Time in Days fields.

![Default View for the Status Times table](media://da150637-6ad1-4a61-b651-e161ee7d93fc)

# Saved Searches

The out-of-the-box Status Times tables includes a Related To Contracts saved search that returns all records related to contracts.

# > Macro (anchor)

Charts/Reports

In the out-of-the-box system, the Status Times table includes the following charts and reports. For information on working with charts and reports, see [Create and Edit Charts and Reports](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714395) in the Help Guide.

- **Average Review Time by Contract Owner then by Contract Type**: Reports on the average number of days contracts owned by each Contract Manager spend in the Status of Pending Contract Manager.
  - The bar chart shows the average number of days and has a drill-down by Contract Type.
  - The report lists each relevant contract, sorted by Contract Manager then by Contract Type.
- **Average Time by Status then by Contract Owner**: Reports on the average number of days contracts spend in each status.
  - The bar chart shows the average number of days per status and has a drill-down by Contract Manager.
  - The report lists the relevant contracts, sorted by Status then by Contract Manager.
- **Contract Status Times for Combined Report**: Excel report that shows details about all Status Time records related to Contracts.
- **Percent Average Cycle Time by Contract Type**: Reports on the average percentage of time contracts spend in each status until they're Signed.
  - The bar chart shows the overall percentage of time for each Contract Type, segmented by Status.
  - The report lists the relevant contracts, grouped by average time then by Contract Type.

# Fields

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

| **Field Label** | **Data Type** | **Description** |
| --- | --- | --- |
| Approval Team  
Approver  
Approval ID  
Approval Related To | Link to selected fields from other table: Approvals | For Approvals, these fields identify the approvers. |
| Contract Manager  
Contract Start Date  
Contract Title  
Contract Type  
Contract ID  
Contract Record Type  
Contract Status | Link to selected fields from other table: Contracts | For Contracts, these fields identify the contract and its owner. |
| Linked Source Record | Text | Links to the source record whose status was tracked. |
| Next Status | Choice:  
To view the options, go to Setup Status Times and click the Fields tab. Edit the Next Status field, and click Edit Choice List on the General tab. | The status the record was updated to. |
| Related To | Choice:<br>- Contract
- Approval
- Sourcing Event | The type of record that was tracked. |
| Sourcing Event ID  
Sourcing Event Manager  
Sourcing Event Title  
Sourcing Event Type  
Sourcing Event Status | Link to selected fields from other table: Sourcing Events | For Sourcing Events, these fields identify the sourcing event and its owner. |
| Status | Choice:  
To view the options, go to Setup Status Times and click the Fields tab. Edit the Status field, and click Edit Choice List on the General tab. | The status being tracked. |
| Status End Date | Date/Time | Timestamp when the record moved to a new status and the current status ended. |
| Status Start Date | Date/Time | Timestamp when the record moved to the tracked status. |
| Time in Days | Elapsed Time | The total number of days the record spent in the tracked status. |

# Ownership

Status Time records are owned by the user who creates them. Specifically, Creator Login is set to the Login of the user who creates the record. For more information on record ownership, see [Record Ownership](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43718158) in the Help Guide.