target_group table - SuperOffice

target_group Table (515)

Info about a set of (sales, project, selection…) targets

Fields

Name	Description	Type	Nullable
target_group_id	Primary key	PK	No
year	The year this set of targets are associated with (2020, 2021…)	Int	Yes
entity_type	Entity type for this set of targets (Sale, Project, Selection, Appointment…)	Enum TargetEntityType	Yes
period_type	Period type for editing this set of targets (Year, Quarter…)	Enum TargetPeriodType	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_dimension_id	Dimension this target is in	FK target_dimension	Yes

target_group table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
target_dimension	Defining target dimension
target_period	A set of periods linked with target amounts for users/usergroups and the target groups/years.
target_revision_history	Revision history info in case the original target group or assignment info was deleted

Replication Flags

None

Security Flags

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

Related topics

target_period table target_dimension table Save Target Group target_revision_history table Delete Target Group Get Target Group

⌘I