Company: Link Technologies
Case No: L08260. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 16 Dec 2016 03:24PM
Priority: Low
Product: Payroll & HR
Group: Change Request
Time Taken: 75.00 (Weight: 75.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, AwaitingApproval, Development, Rashna, Sanjay, Vineet
Resolve By: Saturday, 17 December 2016 12:00 AM [2701 days since logged date]
Status: Closed
Subject: Enhancement - Include Time To and Time From under Time Control on menu 314.
Summary:    

Development Meeting: 09/05/2017:

Design:

  1. Add StartTime, Break Time and End Time to each day in the shift.
  2. Change hours work calculation to use shift time from the day if this is setup, otherwise use from default shift.

Hi Team. 

At  LTA, all staff have a default shift as DS (Day Shift). Start time as below

  • Monday to Thursday - 8am to 4.30pm
  • Friday - 8am to 4pm.

In the first segment of the shift, Monday to Friday has 7.5 hours and Friday has 7 hours.

When an employee applies for leave on a Friday from 8am to 4.30pm (default time on ESS), system calculates "hours taken" as 7 based on the shift.

However, when an employee changes the start time as 2pm. System calculates hours taken as "2.5" as end time is 4.30pm. This should be only 2 hours as Friday shift ends at 4pm.

In the current setup, there is no indication in the shift that the Friday shift should be 8am to 4pm.

Solution

As discussed in the morning meeting, Include "Time to" and "Time From" are everyday of the week under time control.



Audit Notes:Edited by alvis on 25/01/19 10:05. 
16 Dec 201603:25PM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Vineet (Link Business Solutions) Followup Date: 16-12-2016 03:25 PM Time Taken: 1.50

Hi Vineet, 

May you please discuss this case in the next development meeting.

Regards


07 Feb 201709:21AM Comment 2 by Vineet (Link Business Solutions) Assigned To: Vineet (Link Business Solutions) Followup Date: 07-02-2017 09:21 AM Time Taken: 1.50

Development Meeting 07/02/2017

This has been facilitated in ESS Shifts. Please kindly test this and advise if this is suitable for the need of the client.

Vineet to discuss this with Aarti,Vineshwar,Fariha and Rashna and test setup.

Regards
Vineet Ram


03 May 201709:26AM Comment 3 by Vineet (Link Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-05-2017 12:00 AM Time Taken: 2.00

Hi Rashna

Can QA this using ESS and see if this that is able to fulfil LTA's need. Let me know should you need my assistance.

Regards
Vineet 


04 May 201711:03AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: AwaitingApproval Followup Date: 09-05-2017 12:00 AM Time Taken: 3.50

Hi Team, 

I have tested the case in QA4 with version 811. Database - LINKSOFT.

Employee E001 works

  • Monday to Thursday - 8am to 4.30pm (7.5 hours)
  • Friday - 8am to 4pm. (7 hours)

In ESS, under Time Control we had declared 'Time From' to 'Time To' as 8am to 4pm for Friday.

Employee applied for leave on a Friday

Scenario 1.

Leave "Start Time" is 8am and "End Time" 4.30pm. User clicks on calculate button, the leave hours is calculated as 7. This is depicted from the Shift Configuration.

Scenario 2.

Leave "Start Time" is 2pm and "End Time" 4.30pm. User clicks on calculate button, the leave hours is calculated as 2.5. The hours calculated should be 2. 

Regards
Rashna



09 May 201710:47AM Comment 5 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 09-05-2017 10:47 AM Time Taken: 1.50

Development Meeting: 09/05/2017:

Design:

  1. Add StartTime, Break Time and End Time to each day in the shift. Add this to ESS Shift Configuration menu.
  2. Change hours work calculation to use shift time from the day if this is setup, otherwise use from default shift.

09 May 201710:48AM Comment 6 by Alvis (Link Technologies) Case 8260 added to project 8.13
06 Jun 201711:11AM Comment 7 by Alvis (Link Technologies) Case 8260 removed from project 8.13
06 Jun 201711:11AM Comment 8 by Alvis (Link Technologies) Case 8260 added to project 9.00
11 Jan 201809:57AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Development Followup Date: 11-01-2018 09:57 AM Time Taken: 2.50

Development meeting January 2018 Sanjay, Alvis, Sanjeet and Vineet.

Approved Design

  1. ESS Maintenance form has the required functionality.
  2. Move the time segment from the Shift Header to shift details.
  3. Change the calculations to use shift details times.
  4. Change the reports to use shift details times.

Test Plan

  1. Setup leave different days have different times for start and end.
  2. Test all areas where shift is used.
    1. Time Entry
    2. Leave Entry
    3. TNA


11 Jan 201809:57AM Comment 10 by Alvis (Link Technologies) Case 8260 added to project 900
26 Jul 201808:36AM Comment 11 by Rashna (Edge Business Solutions) Case 8260 removed from project 999
30 Aug 201809:02AM Comment 12 by Alvis (Link Technologies) Case 8260 added to project 999
25 Jan 201910:05AM Comment 13 by Alvis (Link Technologies) Case 8260 added to project 10.2
25 Jan 201910:10AM Comment 14 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 25-01-2019 10:10 AM Time Taken: 2.50

Discussion Notes: Sanjay, Alvis, Rashna.

  1. Remove Shift Maintenance from backoffice. This is maintained in Web.
  2. Move the time segment from the Shift Header to shift details.
  3. Change the calculations to use shift details times.
  4. Change the reports to use shift details times.

08 Feb 201904:54PM Comment 15 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 08-02-2019 04:54 PM Time Taken: 9.50

The following changes have been made:

  1. Move the time segment from the Shift Header to shift details.
  2. Change the calculations to use shift details times.
  3. Change the reports to use shift details times.

Changed the following database objects:

HR_SHIFT
LT_PAY_GetShiftStartDateTime_fx
LT_PAY_CalculateShiftBreakMinutesDayOffset_fx
LT_PAY_GetShiftFinishDateTime_fx
LT_PAY_GetShiftStartFinishTimeDescription_fx
LT_ESS_ShiftConfigurationTimeControl_UPDATE
LT_ESS_ShiftConfiguration_SELECT
LT_ESS_ShiftConfiguration_UPDATE
LT_SAA_Company_FrameworkBuild
LT_SAA_PostUpgradeCustomizations_GoodmanFielder :LT_PAY_Custom_GMF_GetMealTicketsForDay_fx
LT_ESS_CalculateLeaveHours_fx
LT_HRM_GetExpectedHoursWorked_fx
LT_HRM_GetShiftID_fx
LT_PAY_CALCULATE_WORK_HOURS_fx
LT_ESS_GetEmployeeProfile
LT_RPT_PAY_TimesheetReport
LT_HRM_GetLeaveTransactionByDay_fx
LT_PAY_EditRosterSchedule
LT_HRM_LEAVE_UPDATE_SplitLeaveIntoPayPeriod
LT_ESS_TimesheetImport_ComputeByEmployee
LT_ESS_RPT_TimesheetImportLog_fx
LT_ESS_RPT_EmployeeProfile
LT_PAY_RPT_MealClaims
LT_PAY_RPT_PaySettlement
LT_RPT_PAY_RosterSchedule
LT_ESS_CreateLeaveForInvalidTimeEntries
LBS_ReCalcContractExpiry_sp
LT_ESS_Timesheet_UPDATE
LT_ESS_TimesheetImport_ALERT_15MinuteVariance
LT_PAY_CreateFinalPayEntries
LT_ESS_CreatePublicHolidayTimeEntry
LT_SYS_AUDIT_HR_SHIFT_TRG
PR_TIME_CONTROL

Next Step:

  1. Find dependancies for PR_TIME_CONTROL and implement changes.
  2. Document all areas affected by this change.



11 Feb 201910:18AM Comment 16 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 11-02-2019 10:18 AM Time Taken: 5.50

Changed the following database objects: 

LT_ESS_ShiftConfigurationTimeControl_SELECT
LT_ESS_ShiftConfigurationTimeControl_UPDATE
LT_ESS_ShiftConfiguration_UPDATE
LT_PAY_GetMealTicketsForDay_fx
LT_SAA_Company_FrameworkBuild
LT_SAA_PostUpgradeCustomizations_GoodmanFielder:LT_PAY_Custom_GMF_GetMealTicketsForDay_fx
LT_ESS_CalculateLeaveHours_fx
LT_HRM_GetExpectedHoursWorked_fx
LT_ESS_ShiftConfiguration_GetHoursWorked_fx
LT_PAY_CALCULATE_WORK_HOURS_fx
LT_HRM_GetLeaveTransactionByDay_fx
LT_ESS_GetShiftHoursWorked_fx
LT_ESS_CreatePublicHolidayTimeEntry

11 Feb 201910:47AM Comment 17 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 11-02-2019 10:47 AM Time Taken: 3.50

The following areas are affected by this change:

  1. Timesheet Import
    1. Timesheet Import computations
    2. Timesheet import rule R006
    3. Timesheet Import computations for Union rates
    4. Timesheet Import Log Report
    5. TImesheet import rule R014
  2. Leave Entry
    1. Calculate Leave Hours
    2. Leave Split into Pay periods
  3. Time Entry
    1. Weekly View Save - Default start time for time entry
  4. Alerts
    1. Staff Hours Alert - Calculation for Expected hours worked
    2. Missing Time Alert - Calculation for expected hours
  5. Reports
    1. Employee Profile Report - description for the shift
    2. Roster Schedule Report
    3. Pay Settlement Report
    4. Meal Claims report
  6. Payroll Processing
    1. Contract Expiry hours calculations
    2. Create final pay entries
  7. Maintenance Forms
    1. Link Web ~> ESS Maintenance ~> Shift Configuration
    2. Link Web ~> Employee Profile ~> My Profile
    3. Backoffice ~> Organisation Maintenance ~> Create new company - Default values for DS shift and Time control
    4. Backoffice ~> Create roster schedule ~> verification checks to identify overlapping rosters.
  8. Processes
    1. ESS008 - Create leave transactions for invalid time entries
    2. ESS001 - Create "Public Holiday Entitled" time entries for employees marked as "Timesheet"
  9. Customizations
    1. Goodman Fielder customization - Calculation for Meal tickets
  10. Audit Data
    1. HR_SHIFT
    2. PR_TIME_CONTROL

11 Feb 201911:50AM Comment 18 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-02-2019 11:50 AM Time Taken: 2.50
Removed Shift Maintenance from backoffice

11 Feb 201902:17PM Comment 19 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-02-2019 02:17 PM Time Taken: 1.50

Next step: UAT


19 Mar 201904:03PM Comment 20 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-03-2019 12:00 AM Time Taken: 4.50
Excel Sheet updated with UAT Update. Will continue work tomorrow.

20 Mar 201904:09PM Comment 21 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 22-03-2019 12:00 AM Time Taken: 8.50
Excel Sheet updated with UAT Update. Will continue work Friday 22/03/2019

26 Mar 201903:24PM Comment 22 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 27-03-2019 12:00 AM Time Taken: 8.50

Hi Alvis, 

I have tested with 11.314 and 11.325 updates.

Test Results has been updated. Please review item 6 and 17 in the sheet.

Thanks
Rashna


27 Mar 201904:45PM Comment 23 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-03-2019 04:45 PM Time Taken: 2.50

Development work for this case has been completed.

The change will be available in version: 11.0.0327

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

  1. Corrected issue number 6 and 17 on the test result

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

4. Notes:


02 Apr 201910:08AM Comment 24 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 05-04-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
Create shift S85C with segment 1 as below
Monday to Thursday - 8 hours - Start 8am and Finish at 5pm. Break = 1 hr
Friday - 7.5 hours - Start 8am and Finish at 4.30pm. Break = 1 hr
Saturday - 5 hours - Start 10am and Finish at 3.30pm. Break = 0.5 hr
Pass
2
Assign Shift S85C to employee E004.
Apply leave from 27/03/2019 to 04/04/2019. Calculate leave hours should calculate 60.5 hours.
Set the pay date as 31/03/2019 and approve leave. Leave should split
27/03/2019 to 31/03/2019 - 28.5 Hours
01/04/2019 to 04/04/2019 - 32 Hours
Pass
3
Apply leave for the 05/04/2019. Leave Time = 8am to 5pm. Hours Calculated should be 7.5.
Apply leave for the 05/04/2019. Leave Time = 8am to 10.30am. Hours Calculated should be 2.5.
Apply leave for the 05/04/2019. Leave Time = 2pm to 5pm. Hours Calculated should be 2.5.
Apply leave for the 05/04/2019. Leave Time = 12pm to 3pm. Hours Calculated should be 2.
Apply leave for the 05/04/2019. Leave Time = 7am to 9am. Hours Calculated should be 1
Apply leave for the 08/04/2019. Leave Time = 8am to 5pm. Hours Calculated should be 8.
Apply leave for the 08/04/2019. Leave Time = 8am to 10.30am. Hours Calculated should be 2.5.
Apply leave for the 08/04/2019. Leave Time = 2pm to 5pm. Hours Calculated should be 3
Apply leave for the 08/04/2019. Leave Time = 12pm to 3pm. Hours Calculated should be 2.
Apply leave for the 08/04/2019. Leave Time = 7am to 9am. Hours Calculated should be 1
Pass
4Create the roster for employee E004 for 15/04/2019 with shift S85C. Edit the shift to DS from the "Roster Upload Template". This should be completed without errorsPass
5

Create the Roster for dates 

  • 18/04/2019 - Scheduled Hours should be 8 
  • 19/04/2019 - Scheduled Hours should be 7.5 
  • 20/04/2019 - Scheduled Hours should be  5 
Fails, the system picks hours as 8 for all days in the "Edit Schedule" screen.

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0329
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT_REPORTNOTES

Next Step: for review


    02 Apr 201903:05PM Comment 25 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-04-2019 03:05 PM Time Taken: 2.50

    Development work for this case has been completed.

    The change will be available in version: 11.0.0402

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

    1. The "Scheduled Hours" column in back-office was showing the "Hours per day". I have changed this to use the "Shift ~> Time ~> Segment 1"

    2. The issue was caused by:

    1. Improvement

    3. Next Step:

    1. UAT

    4. Notes:


    09 Apr 201912:52PM Comment 26 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-04-2019 12:00 AM Time Taken: 2.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

    Create the Roster for dates 

    • 18/04/2019 - Scheduled Hours should be 8 
    • 19/04/2019 - Scheduled Hours should be 7.5 
    • 20/04/2019 - Scheduled Hours should be  5

    Pass



    Environment Details

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

    Next Step: for documentation


      12 Apr 201902:41PM Comment 27 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-04-2019 12:00 AM Time Taken: 3.50

      Hi Sanjay, 

      Documentation for the case has been updated under

      • Link Web Applications->ESS Maintenance -> Shift Configuration 
        • Added documentation for "Shift", "Time Control", "Time Control Details" and allowances.

      Thank
      Rashna


      15 Apr 201909:33AM Comment 28 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 15-04-2019 09:33 AM Time Taken: 1.50
      Thanks Rashna 

      09 Oct 201908:14AM Comment 29 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08260 in the subject line of all emails regarding this issue.

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