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

> A set of values linked to assignment info and a period in a target group.

## target\_assignment\_value Table (518)

A set of values linked to assignment info and a period in a target group.

## Fields

| Name                          | Description                           | Type                                                        | Nullable |
| ----------------------------- | ------------------------------------- | ----------------------------------------------------------- | :------: |
| target\_assignment\_value\_id | Primary key                           | PK                                                          |    No    |
| target\_assignment\_info\_id  | Who or what this value is assigned to | FK [target\_assignment\_info](./target-assignment-info.mdx) |    Yes   |
| target\_period\_id            | The group this target belongs to      | FK [target\_period](./target-period.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\_value                 | Target value                          | Double                                                      |    Yes   |

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

## Indexes

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

## Relationships

| Table                                                | Description                                                                                   |
| ---------------------------------------------------- | --------------------------------------------------------------------------------------------- |
| [associate](./associate)                             | Employees, resources and other users - except for External persons                            |
| [target\_assignment\_info](./target-assignment-info) | Linking associate, company or user group target and other information with target values      |
| [target\_period](./target-period)                    | A set of periods linked with target amounts for users/usergroups and the target groups/years. |

## Replication Flags

* None

## Security Flags

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


## Related topics

- [target_assignment_info table](/en/database/tables/target-assignment-info.md)
- [target_period table](/en/database/tables/target-period.md)
- [What's new in version 10.1.2.686](/release-notes/database/changes-10.1.2.md)
- [What's new in version 10.3.9.718](/release-notes/database/changes-10.3.9.md)
- [What's new in version 10.5.1.1092](/release-notes/database/changes-10.5.1.md)
- [What's new in version 10.5.2.435](/release-notes/database/changes-10.5.2.md)