time_keeping Table (497)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
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 | Null |
|---|---|---|---|
| time_keeping_id | Primary key | PK | |
| time_keeping_type | What we are keeping time of | Enum TimeKeepingType | ● |
| entity_id | The entity we are keeping time of (a sale, project - given by time_keeping_type) | Int | ● |
| state_id | The id of the state we are keeping time of (a sale stage, or other thing - given by time_keeping_type) | Int | ● |
| 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 | ● |
| accumulated_minutes | The previously accumulated time in minutes for the given state | Int | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| time_keeping_id | PK | Clustered, Unique |
| entity_id, state_id, time_keeping_type | Int, Int, Enum | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
Replication Flags
- None
Security Flags
- No access control via user's Role.