target_period table - SuperOffice

target_period Table (516)

A set of periods linked with target amounts for users/usergroups and the target groups/years.

Fields

Name	Description	Type	Nullable
target_period_id	Primary key	PK	No
target_group_id	The group this target belongs to	FK target_group	Yes
period_number	Month number, 1…12 (or maybe quarter number 1…4 or half year number…)	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

target_period table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
target_assignment_value	A set of values linked to assignment info and a period in a target group.
target_group	Info about a set of (sales, project, selection…) targets

Replication Flags

None

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix.

Related topics

Enum TargetPeriodType target_group table target_assignment_value table Enum values for TargetPeriodType What's new in version 10.1.2.686 What's new in version 10.3.11.910

⌘I