Company: Link Technologies
Case No: L11683. Project: 11.40: LinkSOFT Version 11.4
Logged By: Alvis (Link Technologies) on 21 Aug 2019 02:07PM
Priority: Medium
Product: Payroll & HR
Group: Change Request
Time Taken: 16.00 (Weight: 16.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Saturday, 17 August 2019 12:00 AM [1701 days since logged date]
Status: Closed
Subject: Enhancement to auto Create "Public Holiday Entitled" time entries for employees marked as "Timesheet"
Summary:    

Currently, it looks at Shifts Segment 1 hour to assess the employee’s entitlement. It should look at the employee's Roster and verify if the employee was present on the rostered day before and rostered the day after to determine the public holiday eligibility

Audit Notes:Edited by alvis on 21/08/19 14:07. 
16 Aug 201911:54AM Comment 1 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 16-08-2019 11:54 AM Time Taken: 3.50

Hi Vineet,

The current design is as follows:

  1. Employee's default Shift is used to calculate the "previous working day" and "next working day"
  2. "Previous Working Day" is the previous date with "Segment 1" hours greater than zero and it is not a public holiday
  3. "Next Working Day" is the next date with "Segment 1" greater than zero and it is not a public holiday.
  4. The system then checks if the employee "Has Worked" or "Has Leave" on the "Previous Working Day" and "Next Working Day"
  5. "Has Worked" checks if there is:
    1. Time entry with a status "Submitted",'Approved","Processed","Approval In Progress"
    2. Timesheet with "Normal" + "Time Half" + "Double Time" + "Holiday" hours greater than zero
  6. "Has Leave" checks if there is:
    1. Leave transaction with "Hours taken" greater than zero
    2. Leave status is either "Approved" or "Taken"
    3. Leave is not a "Leave without Pay"
    4. Leave is not sold
Based on the current design, which process do you want to change?

regards
Alvis


20 Aug 201910:03AM Comment 2 by Vineet (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 20-08-2019 10:03 AM Time Taken: 3.00

Bula Alvis

Below is the business scenario:

For PAFCO, their Day 1 is Monday and Day 7 is Sunday. Employees are usually rostered for 5 days, however depending on workload some are rostered for 6 days. Employees are rostered to work from Monday to Friday, Tuesday to Saturday and Wednesday to Sunday. Employees are given 2 days day offs. This day off is either on Saturday and Sunday, Sunday and Monday or Monday and Tuesday depending on the Employees Roster. PAFCO has the below custom rules:

  1. Employees working  for consecutive 6 days will be paid 5 hours Time&Half and remaining double provided normal hours of 42.5 has been worked.
  2. Employees working for consecutive 7 days will be paid double time provided normal hours of 42.5 has been worked.

Below is the shift setup for PAFCO .

Now with the current setup as above, when there is a public holiday, system is expecting employees to be available at work for all 7 days, however employee will only work on the Rostered day. For this reason most employees are missed out on the Public Holiday entitlement. 

The change we are requesting for is to add a rule for process ESS001 as ESS001-03 Compare Rostered Days with Work Days to Determine consecutive hours worked. If this is set to Y, system will look for expected worked days in the Roster instead of the Seg 1 hours. 

I hope the above clarifies your query.

Regards
Vineet Ram


21 Aug 201902:07PM Comment 3 by Alvis (Link Technologies) Case 11683 added to project 11.0
21 Aug 201902:18PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-08-2019 02:18 PM Time Taken: 3.50

Development work for this case has been completed.

The change will be available in version:11.0.0821

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

  1. Extended the public holiday entitlement to check for an employees roster. If a roster for the day is not found, then default employee shift is used.

2. Affected Areas:

  1. Process ESS001 - Create "Public Holiday Entitled" time entries for employees marked as "Timesheet". 

3. The issue was caused by:

  1. Change request

4. Notes

Company XYZ has the following shifts:

DS: 8am-5pm Seg 1 hours = 8, Seg 2 hours = 2, seg 3 hours = 24 for all days (Mon-Sun)

OFF: 8am-5pm Seg 1 hours = 0, Seg 2 hours = 0, seg 3 hours = 24 for all days (Mon-Sun)

Public Holiday Date: 26/08/2019


An employee is rostered as follows:

19 Aug20 Aug21 Aug22 Aug23 Aug24 Aug25 Aug26 Aug27 Aug28 Aug
DSDSDsDsDSOFFOFFDSDSDS


The public holiday entitlement gets the previous and next working day as follows:

  • Previous Working Day: 23 Aug
  • Next Working Day: 27 Aug
The employee would be entitled to public holiday if they had worked on 23rd Aug and 27th Aug.


5. Next Step
: UAT


23 Aug 201903:27PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-08-2019 03:27 PM Time Taken: 1.50
For UAT

03 Sep 201902:57PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 13-09-2019 12:00 AM Time Taken: 3.50
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1
Week dates - 02/09/2019 to 06/09/2019.
Public Holiday - 05/09/2019.
Employee works on the 02/09/2019,03/09/2019 and 06/09/2019
Day off on the 04/09/2019
System should create the "Public Holiday" entry for 5/09/2019.
Pass
2
Week dates - 02/09/2019 to 06/09/2019.
Public Holiday - 05/09/2019.
Employee works on the 02/09/2019,03/09/2019 and
Day off on the 04/09/2019
Leave application on the 06/09/2019.
System should create the "Public Holiday" entry for 5/09/2019.
Pass
3
Week dates - 02/09/2019 to 08/09/2019.
Public Holiday - 05/09/2019.
Day off on the 06/09/2019
System should create the "Public Holiday" entry for 5/09/2019.
Pass
4
Week dates - 02/09/2019 to 08/09/2019.
Public Holiday - 09/09/2019.
Day off on the 07/09/2019 and 08/09/2019
System should create the "Public Holiday" entry for 9/09/2019.
Pass

Notes - Create a shift as "OFF - Day Off"with segment 1 hours as 0. Tag this shift to the roster when the employee is on a day off.

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.002.0830
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step: Documentation


    04 Dec 201901:29PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-12-2019 01:20 PM Time Taken: 1.00

    Hi Sanjay, 

    Documentation has been updated at Linkweb Application Portal - Company Administration - Processes - ESS Processes

    Thanks
    Rashna


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

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