Skip to main content
Planview Customer Success Center

Where is the effective date of a workgroup transfer stored in the database?

The EffectiveDate field is stored in the WorkgroupHistoryMember table.

To determine the action that the EffectiveDate applies to, use the WorkGroupHistoryMemberType field in the same table:

  • act: activation, that is, the initial workgroup of the resource
  • trf: transferred resource from one workgroup to another
  • uns: unassigned resource
  • del: deleted resource