> ## 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_dimension table

> Defining target dimension

## target\_dimension Table (522)

Defining target dimension

## Fields

| Name                      | Description                                                                                                                     | Type                                                              | Nullable |
| ------------------------- | ------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------- | :------: |
| target\_dimension\_id     | Primary key                                                                                                                     | PK                                                                |    No    |
| entity\_type              | Entity type for this set of targets (Sale, Project, Selection, Appointment...)                                                  | Enum [TargetEntityType](./enums/targetentitytype.mdx)             |    Yes   |
| measurement\_unit         | What to measure (Amount, Count, Profit...                                                                                       | Enum [TargetMeasurementUnit](./enums/targetmeasurementunit.mdx)   |    Yes   |
| assignment\_level         | What level this dimension can be assigned to (Company, Group, Associate)                                                        | Enum [TargetAssignementLevel](./enums/targetassignementlevel.mdx) |    Yes   |
| dimension\_list\_field    | List that defines the dimensions for this target matrix (ex: Sale type, source, partner, business, udef or extrafield lists...) | String(255)                                                       |    Yes   |
| selected\_dimensions      | id's of the selected/wanted dimensions (what sale types or udef list lines that should be target dimensions)                    | FKArray                                                           |    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    |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/target_dimension.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=e7b3f8cf1589d8612027824fc9a1c1a5" alt="target_dimension table relationship diagram" width="763" height="686" data-path="media/loc/en/database/tables/target_dimension.png" />

## Indexes

| Fields               | Types   | Description |
| -------------------- | ------- | ----------- |
| entity\_type         | Enum    | Index       |
| selected\_dimensions | FKArray | Full text   |

## Relationships

| Table                           | Description                                                                |
| ------------------------------- | -------------------------------------------------------------------------- |
| [associate](./associate)        | Employees, resources and other users - except for External persons         |
| [SaleType](./saletype)          | Type of sale - large solution, incremental, whatever fits the organization |
| [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

- [Save Target Dimension](/en/api/reference/restful/agent/targets_agent/save-target-dimension.md)
- [Delete Target Dimension](/en/api/reference/restful/agent/targets_agent/delete-target-dimension.md)
- [target_group table](/en/database/tables/target-group.md)
- [Get Target Dimension](/en/api/reference/restful/agent/targets_agent/get-target-dimension.md)
- [SuperOffice.WebApi.Data.TargetDimension](/en/api/reference/webapi/SuperOffice.WebApi.Data.TargetDimension.md)
- [Get Target Group For Year And Dimension](/en/api/reference/restful/agent/targets_agent/get-target-group-for-year-and-dimension.md)