# New: Times when in User Group now recorded

As part of of this Feature Wave, we are improving the recording of a user’s times spent in a given User Group. This ensures that reporting isn't just a reflection of which Group Users are in *now*, but a more accurate record of which Groups Users *were* in and when. This will help give operations managers & team leaders more accurate information in their reporting, particularly in environments where users move around between groups regularly. The additional data in the Data Warehouse will allow report builders access to historical user/group data to supply more accurate information into the operational reports they create.

Previously, when a User was moved from one group to another, the data of their time spent in the first group came across with them, creating inaccurate data for the new group occupancy, and losing the information about their time spent in the previous group. This resulted in user utilization and capacity reporting becoming historically inaccurate. Now, by introducing **Effective Dating**, this historic data is not lost if a user is moved between User Groups: that capacity is always attributed to the correct team for the correct period.

### What Data is recorded

Details are as follows (this information is for any report builders, to allow them to accurately interpret data in the Data Warehouse when building their reports:

The following information will be stored for each user in a User Group, stored in the **tblUserGroupUsers** table in the Data Warehouse:

| **Field**   | Description                                                                                         |
| ----------- | --------------------------------------------------------------------------------------------------- |
| Holds From  | The date the user joined the group.                                                                 |
| Holds Until | The date the user left the group (Set to 31 December 9999 while the user is still an active member) |

This datestamp information will be recorded every time a user is added to or removed from a User Group.

**Population of data for migration**

As part of migrating to this Feature Wave, date stamp values will be set for users that are already in, and have already left, a User Group. The logic for this is as follows:

* Users who are currently in a given User Group:
  * **‘Holds From’ date:** set as the last date of activity for that User/UserGroup Combination - *the assumption being that that this is the date the user was added to the Group.*
* Users who *were* previously in a given User Group:
  * **‘Holds from’ date:** set to ‘01/01/2000’.
  * **‘Holds Until’ date:** set as the last date of activity for that User/userGroup Combination - *the assumption being that that this is the date the user was removed from the Group.*


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.enate.net/whats-new/april-2026-feature-wave/april-2026-feature-wave/new-times-when-in-user-group-now-recorded.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.