Company: Link Technologies
Case No: L08627. Project: 08.20: LinkSOFT Version 8.2
Logged By: Vineshwar Prasad (Edge Business Solutions) on 21 Jun 2017 01:56PM
Priority: High
Product: Payroll & HR
Group: New Feature
Time Taken: 14.00 (Weight: 14.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Rashna, Vineshwar Prasad
Resolve By: Thursday, 22 June 2017 12:00 AM [2494 days since logged date]
Status: Closed
Subject: New Rule in Import Timesheet to deduct 1 hour break
Summary:    
Hi Team,

Recently we got a new client. They operate as a Supermarket and they are using our TNA. All staffs are allowed a break of 1 hour per day. However, this break can be taken at any time during the day. When staff leaves for break, they sign out using the biometric machine. When they resume, they sign in again. New World wants to know exactly when a staff had left for the break. In addition to this, they will also monitor staff who are taking more than 1-hour break. For this reason, breaks won't be defined in the system. The complexity comes in scenarios where employees have taken less than 1-hour break. In this situation New World wants the system to still deduct 1 hour. However, if they have taken a break more than an hour, than break time deducted will be the actual break time.  This rule is currently not available in the system. The break hour of 1 hour per day is applicable to all employees irrespective of their position and location.

Rule:

  1. If break is less than 1 hour, deduct 1 hour as break
  2. If break is more than 1 hour, deduct the actual break
  3. Break hour needs to be between the start time of the shift and end time of the shift. Any break taken after the end time of the shift should not be included in the mandatory one hour break (Scenario 4)



Scenario 1

Staffs works without taking any break during the day as the staff was busy. The system to only account 8 hours in normal (after auto deducting the 1-hour break between 8 am to 5 pm) and the rest in overtime according to the Hours defined in the Segments.

Below is the result that we should get from the above setup.

Start Time: 8.00 am
End Time : 10.00 pm

Expected Results 

Normal Hours - 8 (8.00 am - 5.00 pm)
Time & Half - 2 (5.00 pm - 7.00 pm)
Double Time - 3 (7.00 pm - 10.00 pm)

Scenario 2

Staffs do a shift and No breaks are defined in the system. They take multiple breaks however they are only allowed up to 1 hour of break. The system should only account 8 hours in normal and the rest in overtime according to the Hours defined in the Segments.

Below is the result that we should get from the above setup.

Start Time: 8.00 am
Break 1 Start: 10.00 am
Break 1 End: 10.15 am
Break 2 Start: 1.00 pm
Break 2 End: 1.15 pm
Break 3 Start: 3.00 pm
Break 3 End: 3.15 pm
End Time: 10.00 pm

Total breaks are taken: 45 mins. However, the system should deduct 1 hour as the break.

Expected Results 

Normal Hours - 8 (8.00 am - 5.00 pm)
Time & Half - 2 (5.00 pm - 7.00 pm)
Double Time - 3 (7.00 pm - 10.00 pm)

Scenario 3

Staffs do a shift and No breaks are defined in the system. They take multiple breaks however they are only allowed up to 1 hour of break. Any XXXXX break should be penalized. The system should only account 6.5 hours in normal and the rest in overtime according to the Hours defined in the Segments.

Below is the time from the TNA device

Start Time: 9.00 am
Break 1 Start: 10.00 am
Break 1 End: 10.30 am
Break 2 Start: 1.00 pm
Break 2 End: 1.30 pm
Break 3 Start: 3.00 pm
Break 3 End: 3.30 pm
End Time: 10.00 pm

Total breaks are taken: 1.5 hours. However, the system should penalize 1/2 hour for an XXXXX break and 1 hour for starting late.

Expected Results

Normal Hours - 6.5 (9.00 am - 5.00 pm)
Time & Half - 2 (5.00 pm - 7.00 pm)
Double Time - 3 (7.00 pm - 10.00 pm)

Scenario 4

An employee is part of Shift A. Shift A starts from 9 am to 6 pm, Below are the details of the employees TNA Time.

Time in :9.00am
Time out: 1.00pm
Time in: 1.30pm
Timeout: 6.00pm
Time in: 7.00pm
Timeout : 10.00pm

Expected Results:
Normal Hours: 8 hours
Time &Half: 2 hours
Double Time: 1 hour

Regards
Vinesh
Audit Notes:
27 Jun 201710:32AM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-06-2017 10:32 AM

Development meeting.

Design:

  1. Add a global configuration "Minimum break hours in a shift"
  2. Change break hours calculation to factor configuration in 1 above.

27 Jun 201710:32AM Comment 2 by Alvis (Link Technologies) Case 8627 added to project 9.00
27 Jun 201711:01AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-06-2017 11:01 AM

The estimated effort is 6 to 8 hrs.
Sanjeet stated that this case is for IGA and is holding up project signoff.


28 Jun 201702:46PM Comment 4 by Alvis (Link Technologies) Case 8627 removed from project 9.00
28 Jun 201702:46PM Comment 5 by Alvis (Link Technologies) Case 8627 added to project 8.13
28 Jun 201704:08PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-06-2017 04:08 PM Time Taken: 4.00
Development work for this case has been completed.
The change will be available in version: 8.13
Documentation update required(Yes/No. Add change details below)
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Created a timesheet rule "Deduct minimum 1-hour break within shift duration"
  2. This rule will deduct 1 hour from the duration of shift start time and end time.

Documentation details:
  

03 Jul 201701:23PM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 03-07-2017 01:23 PM Time Taken: 2.00
System test completed, please proceed with UAT. 

04 Jul 201707:02PM Comment 8 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-07-2017 12:00 AM Time Taken: 3.00
Hi Team,

The test was unsuccessful. Test done in QA3 V8130.000.BETA1

1. Was this test completed using Demo / New / Other database? Demo
2. Did the test pass or fail? Fail
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? Yes
5. Documentation update required? 
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

Active Rules

1. Change multiple IN (1) for a date to BREAK IN (2)
2. Deduct minimum 1 hour break within shift duration

Shift Configuration

DS : 8.00 am - 5.00 pm

 Sequence
 Time From
 Time To
 Rate
 1
 8.00 am
 5.00 pm
 1
 2
 5.00 pm
 7.00 pm
 1.5
 3
 7.00 pm
 11.59 pm
 2

MS : 9.00 am - 6.00 pm

 Sequence
 Time From
 Time To
 Rate
 1
 9.00 am
 6.00 pm
 1
 2
 6.00 pm
 8.00 pm
 1.5
 3
 8.00 pm
 11.59 pm
 2

Scenario 1 : Shift DS
Scenario 2 : Shift DS
Scenario 3 : Shift DS
Scenario 4 : Shift MS

Below is the result that we got;


Regards
Vinesh

05 Jul 201702:45PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-07-2017 02:45 PM Time Taken: 1.00

Hi Rashna

I have changed the rule to deduct break from Normal Hours, then Time 1/2 then Double then Holiday.

Update in beta2

Regards
Alvis


06 Jul 201704:18PM Comment 10 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 06-07-2017 04:18 PM Time Taken: 1.00

Hi Vineshwar,

Issue with hours calculation has been corrected in beta3.

regards
Alvis


07 Jul 201709:19AM Comment 11 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 07-07-2017 12:00 AM Time Taken: 3.00
Hi Team,

This case have been tested successfully.

1. Was this test completed using Demo / New / Other database? Demo V8130.000.BETA3
2. Did the test pass or fail? Pass
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? Yes
4. Data verified, saved, edit, delete/void? Yes
5. Documentation update required? 
Additional Details (Risks, issues, special conditions required for this test to pass etc): 

Active Rules
1. Change multiple IN (1) for a date to BREAK IN (2)
2. Deduct minimum 1 hour break within shift duration

Shift Configuration
DS : 8.00 am - 5.00 pm

 Sequence
 Time From
 Time To
 Rate
 1
 8.00 am
 5.00 pm
 1
 2
 5.00 pm
 7.00 pm
 1.5
 3
 7.00 pm
 8.00 am
 2

MS : 9.00 am - 6.00 pm

 Sequence
 Time From
 Time To
 Rate
 1
 9.00 am
 6.00 pm
 1
 2
 6.00 pm
 9.00 pm
 1.5
 3
 9.00 pm
9.00 am
 2

Scenario 1 : Shift DS
Scenario 2 : Shift DS
Scenario 3 : Shift DS
Scenario 4 : Shift MS

Below is the result that we got;


Regards

Vinesh


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08627 in the subject line of all emails regarding this issue.

Document size: 99.5 KB
For call complaints, please contact the Managing Director of the company using this form