> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/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-bugfix-ty-screen-designer-paradox/G4reeQVP-LmhQATQ/media/loc/en/database/tables/target_assignment_value.png?fit=max&auto=format&n=G4reeQVP-LmhQATQ&q=85&s=9b0fb6ba976b272e48206ea27c803fba" 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.