Table: Timer
Columns
Name | Type | Constraints | Description
timer_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
sheet_entry_KEY | int | NOT NULL | The key to the Sheet Entry row this timer is for.
timer_start | datetime | NOT NULL | The date and time this timer was started in local time.
elapsed_seconds | int | NOT NULL | The number of seconds this timer ran before it was stopped, or 0 if it is still running.
create_date | datetime | NOT NULL |
user_name | nvarchar (50) | NOT NULL | The name of the user that started the timer.
integration_application_name | nvarchar (30) | NOT NULL | Identifies the application integration application name that is using the timer (if any)
rounding_method_KEY | int | NOT NULL | The Rounding Method that was in place when the Timer was started.
rounding_increment | decimal (4, 2) | NOT NULL | The Rounding Increment that was in place when the Timer was started.
accumulate_time_before_rounding | bit | NOT NULL | The Accumulte Time setting that was in place when the Timer was started.
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |

Primary key
Name | Columns | Description
PK_Timer$timer_KEY | timer_KEY |
Indexes
Name | Columns | Description
IX_Timer$elapsed_seconds$sheet_entry_KEY$timer_KEY | elapsed_seconds, sheet_entry_KEY, timer_KEY | An index by elapsed_seconds, sheet_entry_KEY and timer_KEY. Used by dp_Sheet_Entry_get_by_staff_KEY_with_open_timers.
IX_Timer$elapsed_seconds$sheet_entry_KEY$timer_start | elapsed_seconds, sheet_entry_KEY, timer_start |
IX_Timer$rounding_method_KEY | rounding_method_KEY | Index supports foreign key FK_Timer__Rounding_Method__rounding_method_KEY
IX_Timer$sheet_entry_KEY | sheet_entry_KEY | CLUSTERED

Foreign keys
Name | Columns | Referenced table | Description
FK_Timer__Rounding_Method__rounding_method_KEY | rounding_method_KEY | Rounding_Method |
FK_Timer__Sheet_Entry__sheet_entry_KEY | sheet_entry_KEY | Sheet_Entry | on delete cascade;