---
title: "Status Times Table"
canonical: "https://help.agiloft.com/space/SD/44434118/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://bdd16014-746b-421f-85d0-3d422abec5de)

# 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.

# Related Tables

The diagram below shows the default incoming table relationships and linked fields in the Status Times table.

![Diagram of the default table relationships for the Status Times table](media://483d7f63-68ce-4dae-8c5c-5d90d1102165)

# 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 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: Contracts, Approvals, Sourcing Events | 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. |