time_keeping table - SuperOffice

time_keeping Table (506)

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	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	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	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

Indexes

Fields	Types	Description
ownerRecord, state_id, time_keeping_type	RecordId, 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.