target_assignment_info table - SuperOffice

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	Yes
contact_id	Company who owns this target	FK contact	Yes
usergroup_id	User group who owns this target	FK UserGroup	Yes
currency_id	Currency for value	FK Currency	Yes
locked	Locked, should not be editable	Bool	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
target_dimension_item_id	Dimension item this target assignment is in	Int	Yes

target_assignment_info table relationship diagram

Indexes

Fields	Types	Description
associate_id	FK	Index
contact_id	FK	Index
usergroup_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
Currency	Currency list table
target_assignment_value	A set of values linked to assignment info and a period in a target group.
target_revision	One batch of changes made to targets
target_revision_history	Revision history info in case the original target group or assignment info was deleted
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 target_revision table target_revision_history table What's new in version 11.5.755.0 What's new in version 11.6.943.0 What's new in version 11.7.727.0

⌘I