Time tracking (monthly header grouping the day lines of a resource for a term).

Show:

ID_PROFIL

Int(11)

Resource the time tracking belongs to.


Default: 0

ID_SOCIETE

Int(11)

Agency the time tracking belongs to.


Default: 0

ID_TIME_TRACKING

Int(11)

Unique identifier.

TIME_TRACKING_CREATED_AT

Datetime

Creation date.

TIME_TRACKING_HOUR_ACCOUNTS_SETTINGS

Text

Snapshot of the agency's hourly counts settings (décomptes horaires) applying to the time tracking, frozen when the resource validated their own time tracking. Only the settings targeting the contract type of a contract in force over the term are captured, so a later change of the agency's settings never alters a validated time tracking.

Serialized as JSON, in the very same format as TAB_GROUPECONFIG.GRPCONF_HOUR_ACCOUNTS_SETTINGS (Models\HourAccountsSetting::serializeCollection()), so a snapshot reads back exactly like the settings it was taken from.

An empty string means no snapshot : the resource's own validation step was never sealed or has been reopened, the time tracking is editable and the agency's current settings apply. Note that neither an unvalidation nor a rejection releases the snapshot on its own — both can leave the resource's step sealed. [] is a snapshot which captured no setting at all — the resource had no contract in force over the term, or no setting targeted its contract type — and is therefore frozen just like any other.


Default: ''

TIME_TRACKING_STATE

Tinyint(1)

Denormalized validation state of the time tracking (MAX(VAL_ETAT) of its TAB_VALIDATION seals, VAL_TYPE=3). 1 = validated, 2 = waiting for validation, 3 = rejected, 4 = saved and no validation.


Default: 2

TIME_TRACKING_TERM

Date

Term. The value follows this RegExp ([0-9]{4})-([0-9]{2})-01.

TIME_TRACKING_UPDATED_AT

Datetime

Last update date.