Initial requirements

PAFCO has requested for automated Meal Allowance insertion to their Pay Edit for all staff on timesheet based on the below rules. LPO for this task is attached.

1. Any employee working in access of 2 hours in addition to their normal rostered hours deserves one meal claim ticket. The meal claims is issued after every 4 hours thereafter. This Rules is applicable to Employees Day 1 to Day 5 worked hours.
2. Employees working for consecutive 6 days receive one meal ticket after every 4 consecutive hours hours. eg: if employee works for 8 hours, he will deserve 2 meal tickets.
3. Employees working for consecutive 7 days receive one meal ticket after every 4 consecutive hours hours. eg: if employee works for 8 hours, he will deserve 2 meal tickets.
4. Employees working on Saturdays and Sundays receive one meal ticket after every 4 consecutive hours hours. eg: if employee works for 8 hours, he will deserve 2 meal tickets.
5. Employees working on a Public Holiday will receive meal allowance in blocks of 4 hours
6. Employees working on a day without resting 10 hours will receive this allowance in blocks of 4 hours

Requirements reworded by Alvis/Sanjay on 22-10-2015

Requirment 1: Create 1 rule that will implement the 4 items listed below

1. This rule is applied to the first 5 days of the roster.
   1. When an employee works 2 hours more than the rostered time, they receive 1 meal claim ticket.
      
   2. An additional meal ticket is issued for every 4 hour block thereafter
2. This rule is applied on the 6th consecutive day of the roster
   1. An additional meal ticket is issued for every 4 hour block 
3. This rule is applied on the 7th consecutive day of the roster
   1. An additional meal ticket is issued for every 4 hour block 
4. This rule is applied on Saturday and Sunday
   
   1. An additional meal ticket is issued for every 4 hour block
5. This rule is applied for all employees working on Public Holidays
   1. An additional meal ticket is issued for every 4 hour block
6. This rule is applied for employees not having rested 10 hours and coming to work.
   1. An additional meal ticket is issued for every 4 hour block for the day they are working without resting
      

Requirement 2: Create a new report as shown in the screenshot

Further to the automated meal allowance, they need a report to verify this and have it endorse by the employees. Report filter and layout below.

Filters required: Date From, Date To, Employee From, Employee To, Territory,Branch, Cost Centre, Group by field to be easily able to group by cost centres, New Page per cost  centre. Report should only show details of employees who deserve meal allowance and not everyone.

Hi Vineet,

The requirements was not very clear. We have reworded the requirements and updated case header. Can you reivew and confirm these requirements are correct.

Requirements reworded by Alvis/Sanjay on 22-10-2015

Requirment 1: Create 1 rule that will implement the 4 items listed below

1. This rule is applied to the first 5 days of the roster.
   1. When an employee works 2 hours more than the rostered time, they receive 1 meal claim ticket.
      
   2. An additional meal ticket is issued for every 4 hour block thereafter
2. This rule is applied on the 6th consecutive day of the roster
   1. An additional meal ticket is issued for every 4 hour block 
3. This rule is applied on the 7th consecutive day of the roster
   1. An additional meal ticket is issued for every 4 hour block 
4. This rule is applied on Saturday and Sunday
   
   1. An additional meal ticket is issued for every 4 hour block

Bula Guys

I have reviewed the requirements reworded by Alvis and Sanjay. It surely fulfills client requirement. Please kindly go ahead with the development.

Vineet Ram

Hi Alvis

I have created the following scenarios and number of meal claims that each employee should receive. Attached is also the csv file for the corresponding time on which meal claims will be based on (PAFCO-Meals.csv). Please commence your development.

Best Regards

Vineet Ram

Development has been completed. Updates applied to QA machines.

After you have upgraded the database. Run the following script to apply PAFCO customizations.

Hi Team

I have successfully managed to test scanarios 1-5. Alvis and I will need to look at scenario 6 and report creation before this case can be released as an update.

Best Regards

Vineet Ram

Hi Vineet,

The following has been completed and applied to QA for UAT.

1. Added report to ESS (Meal Claims Report)
2. Added public holiday rule
3. Added 10 hours rest rule

Hi Alvis

After testing this thoroughly its has been noted that the allowances are not being paid out as per the requirement. Please review the summary of what is expected and what the system totals. I have also attached the excel sheet with comments on rules applied for each day for each employee.

Best Regards

Vineet Ram

Hi Vineet,

I have resolved issue with public holiday calculations.

With Employee 0060, how are you getting 3 meal tickets on 26/10/2015. Based on the calculations, I am only getting 2.

Applied updates to QA machines.

Hi Alvis

We have applied the SCR onsite and have been testing this with the PAFCO team. They have advised that the allowance should not be automatically inserted in PAY but rather created in ESS as a claim entry and require approval by supervisors once time is submitted at Timesheet Menu. Only after this has been approved then it should flow to payroll. The meal claims report should only display all approved meal claims entry.

This was an issue with uderstanding the requirements from our end and contingency has been included in the PO. Please let me know when we can discuss this.

Best Regards

Vineet Ram

Hi Alvis

Please ignore comment 12. The requirement is as per below:

1. Normal hours once submitted are directly approved for payroll processing
2. Time&Half and Double Time on the other hand are submitted as unapproved entries which are approved using the Standard Time Approval.
3. Public Holiday hours once submitted are also directly approved for payroll processing.

Now the meal claims should be based on the Total Approved hours in LT_ESS_Time as oppose to total hours from LT_ESS_TimesheetImport_Archive. These meal claims should be automatically inserted as it is being done now except the total hours should be total approved hours from LT_ESS_TIME.

Vineet

Hi Vineet,

Can you setup an environment that has the 3 conditions defined in comment number 13 so that we can test which of the 3 scenarios is not working.

Hi Alvis,

I have again tested the PAFCO meal claims and it is working fine, however 2 things needs to be fixed:

1. Do not show the meal claim hours in the meal claim report unless and until Time&Half and double time is approved.
As of now, as soon as we submit the entries for payroll, the meal claim hours are shown in the report.

2. If the Time&Half and DoubleTime is not approved, do not insert the EMEAL paycode in the pay created .

Currently, even if the Time*Half and DoubleTime is not approved, blank EMEAL paycodes are inserted when the pay is created.

Vinaka

Hi Shavindar,

This is a change request. The procedure is as follows:

1. Assign case to Vineet/Sanjeet for approval. Then assign to awaiting approval.
2. Vineet/Sanjeet to bring up the case for discussion in Company Meeting and determine which patch this will be released in.

Hi Alvis,

I have had a discussion with Vineet. (meeting minutes on 6th November)
According to him, this has already been discussed in company meeting.

Request if you can please take this further.

Thanks

Hi Shavindar,

I have made this change. Updates available in patch 8.

Thanks Alvis,

This will be tested once patch 8 will be released.

Thanks Alvis,'

I have tested this.
Thanks for fixing as per my request.