> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # time_keeping table > Time keeping for how much time a sale or project or other entity has spent in a given stage or other state ## time\_keeping Table (505) Time keeping for how much time a sale or project or other entity has spent in a given stage or other state ## Fields | Name | Description | Type | Nullable | | ------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------- | :------: | | time\_keeping\_id | Primary key | PK | No | | time\_keeping\_type | What we are keeping time of | Enum [TimeKeepingType](./enums/timekeepingtype.mdx) | Yes | | state\_id | The id of the state we are keeping time of (a sale stage, or other thing - given by time\_keeping\_type) | Int | Yes | | start\_time | When the time keeping started for the last change, not yet finished/accumulated - The time since start\_time must be added to the accumulation of time. When accumulation is done start\_time will be set to the minimum value. start\_time > min implies this is the current state (stage). | DateTime | Yes | | accumulated\_minutes | The previously accumulated time in minutes for the given state | Int | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | | ownerTable | The table that is the owning entity | TableNumber | No | | ownerRecord | Optional owner record id, if layout is bound to an owner | RecordId | Yes | time_keeping table relationship diagram ## Indexes | Fields | Types | Description | | ------------------------------------------- | ------------------- | ----------- | | ownerRecord, state\_id, time\_keeping\_type | RecordId, Int, Enum | Index | ## Relationships | Table | Description | | ------------------------ | ------------------------------------------------------------------ | | [associate](./associate) | Employees, resources and other users - except for External persons | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [What's new in version 11.10.705.0](/release-notes/database/changes-11.10.705.md) - [What's new in version 11.7.727.0](/release-notes/database/changes-11.7.727.md) - [What's new in version 11.8.788.0](/release-notes/database/changes-11.8.788.md) - [What's new in version 11.9.1204.0](/release-notes/database/changes-11.9.1204.md) - [What's new in version 12.0.342.0](/release-notes/database/changes-12.0.342.md) - [What's new in version 12.1.1412.0](/release-notes/database/changes-12.1.1412.md)