target_change table - SuperOffice

target_change Table (521)

A single field change.

Fields

Name	Description	Type	Nullable
target_change_id	Primary key	PK	No
target_revision_id	The revision history changeset this change belongs to	FK target_revision	Yes
field_identifier	What field was changed - target_group.period_type or target_assignment_value.month01.target_value or target_assignment_value.quarter01.target_value etc.	String(255)	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
value_change_from	Previous value	Double	Yes
value_change_to	New value	Double	Yes

Indexes

Fields	Types	Description
target_revision_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
target_revision	One batch of changes made to targets

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

target_revision table SuperOffice.WebApi.Data.TargetChange Released database changes in version 11.2.664.0 What's new in version 10.1.2.686 What's new in version 12.3.2570.0 What's new in version 11.1.447.0