• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

target_change Table (503)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

A single field change.

Fields

Name Description Type Null
target_change_id Primary key PK
target_revision_id The revision history changeset this change belongs to FK target_revision ●
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) ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort
value_change_from Previous value Double ●
value_change_to New value Double ●

target_change table relationship diagram

Indexes

Fields Types Description
target_change_id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top