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

> Linking associate, company or user group target and other information with target values

## target\_assignment\_info Table (517)

Linking associate, company or user group target and other information with target values

## Fields

| Name                         | Description                                 | Type                            | Nullable |
| ---------------------------- | ------------------------------------------- | ------------------------------- | :------: |
| target\_assignment\_info\_id | Primary key                                 | PK                              |    No    |
| associate\_id                | Associate who owns this target              | FK [associate](./associate.mdx) |    Yes   |
| contact\_id                  | Company who owns this target                | FK [contact](./contact.mdx)     |    Yes   |
| usergroup\_id                | User group who owns this target             | FK [UserGroup](./usergroup.mdx) |    Yes   |
| currency\_id                 | Currency for value                          | FK [Currency](./currency.mdx)   |    Yes   |
| locked                       | Locked, should not be editable              | Bool                            |    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\_item\_id  | Dimension item this target assignment is in | Int                             |    Yes   |

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

## Indexes

| Fields        | Types | Description |
| ------------- | ----- | ----------- |
| associate\_id | FK    | Index       |
| contact\_id   | FK    | Index       |
| usergroup\_id | FK    | Index       |

## Relationships

| Table                                                  | Description                                                                            |
| ------------------------------------------------------ | -------------------------------------------------------------------------------------- |
| [associate](./associate)                               | Employees, resources and other users - except for External persons                     |
| [contact](./contact)                                   | Companies and Organizations.                                                           |
| [Currency](./currency)                                 | Currency list table                                                                    |
| [target\_assignment\_value](./target-assignment-value) | A set of values linked to assignment info and a period in a target group.              |
| [target\_revision](./target-revision)                  | One batch of changes made to targets                                                   |
| [target\_revision\_history](./target-revision-history) | Revision history info in case the original target group or assignment info was deleted |
| [UserGroup](./usergroup)                               | Secondary user groups                                                                  |

## 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_value table](/en/database/tables/target-assignment-value.md)
- [target_revision table](/en/database/tables/target-revision.md)
- [target_revision_history table](/en/database/tables/target-revision-history.md)
- [What's new in version 11.7.727.0](/release-notes/database/changes-11.7.727.md)
- [What's new in version 11.8.788.0](/release-notes/database/changes-11.8.788.md)
- [What's new in version 11.9.1204.0](/release-notes/database/changes-11.9.1204.md)