> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-worktree-351-fix-webapi-escaped-anchors.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# target_group table

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

## 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](./enums/targetentitytype.mdx) |    Yes   |
| period\_type              | Period type for editing this set of targets (Year, Quarter...)                 | Enum [TargetPeriodType](./enums/targetperiodtype.mdx) |    Yes   |
| registered                | Registered when                                                                | UtcDateTime                                           |    No    |
| registered\_associate\_id | Registered by whom                                                             | FK [associate](./associate.mdx)                       |    No    |
| updated                   | Last updated when                                                              | UtcDateTime                                           |    No    |
| updated\_associate\_id    | Last updated by whom                                                           | FK [associate](./associate.mdx)                       |    No    |
| updatedCount              | Number of updates made to this record                                          | UShort                                                |    No    |
| target\_dimension\_id     | Dimension this target is in                                                    | FK [target\_dimension](./target-dimension.mdx)        |    Yes   |

<img src="https://mintcdn.com/superofficeas-worktree-351-fix-webapi-escaped-anchors/KsvSyGQJCWf4OHdL/media/loc/en/database/tables/target_group.png?fit=max&auto=format&n=KsvSyGQJCWf4OHdL&q=85&s=faa8deec740f1c2a27bcc0df8e7e6ebb" alt="target_group table relationship diagram" width="1015" height="901" data-path="media/loc/en/database/tables/target_group.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                                                  | Description                                                                                   |
| ------------------------------------------------------ | --------------------------------------------------------------------------------------------- |
| [associate](./associate)                               | Employees, resources and other users - except for External persons                            |
| [target\_dimension](./target-dimension)                | Defining target dimension                                                                     |
| [target\_period](./target-period)                      | A set of periods linked with target amounts for users/usergroups and the target groups/years. |
| [target\_revision\_history](./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.