> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/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/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/target_group.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=5527537ec03b55ab5b4f2d2b1c391fd0" 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.


## Related topics

- [target_period table](/en/database/tables/target-period.md)
- [target_dimension table](/en/database/tables/target-dimension.md)
- [target_revision_history table](/en/database/tables/target-revision-history.md)
- [Save Target Group](/en/api/reference/restful/agent/targets_agent/save-target-group.md)
- [SuperOffice.WebApi.Data.TargetGroup](/en/api/reference/webapi/SuperOffice.WebApi.Data.TargetGroup.md)
- [Delete Target Group](/en/api/reference/restful/agent/targets_agent/delete-target-group.md)