Column: Timereg duplicate record



Column: Timereg duplicate record

Column	Timereg duplicate record
Source	This column will be set to true for the first instance of the same time registration record that is added for a resource cache. Should any duplicates be added, then these will be set to false. The reason that duplicates may exist is when a resource cache has both CATI contact log records AND time registration records included in columns. In this situation a time registration record will be copied multiple times for each cati contact log record.
Automatically given column name	TimeregDuplicateRecord
Column type	Boolean
Resource types that use it	Folder, Project, Product, Report, Questionnaire, User, Group, Task
How axis set information is built	Since this is a boolean column, then the possible values that can exist in this column are only 0 and 1, which corresponds to "False" and "True". It is therefore easy to create the axis since we have a limited well defined number of outcomes. The axis generated for this column will look like below: Axis text: "Time registration duplicate record"Math base: "TimeregDuplicateRecord"Pct base: "TimeregDuplicateRecord!=empty" Option 1: Name="False"; Value="!TimeregDuplicateRecord"Option 2: Name="True"; Value="TimeregDuplicateRecord"
Comment	As a time registration record can occur in more than one data row, this column helps you “SELECT DISTINCT” time registration records in a resource cache, so for example the following expression will return the actual time the user with Id 10 has spent on the resource with Id 12: = sum(TimeregTime) where (TimeregUser == 10 && Id == 12 && TimeregDuplicate == FALSE)