I guess this is for Add Employee

Hi Amannda Johnson,

To achieve this,we need to create trigger to populate payroll file no automatically.
We are also checking from export side for any other way to populate values.

Also if we implement trigger then for employee login ,you need to set 'View Only' rights.So that employee could not change the payroll file no.

We will update you on this by tomorrow EOD.

CC:SatyaGaurav Sodani

Thanks,
Sheetal Bodhale

Hi Amannda Johnson,

We will plan this in coming sprint 35(14th August - 25th August) and will share ETA for the same during that sprint only.

CC:SatyaGaurav Sodani

Thanks,
Sheetal Bodhale

Hi [~meghana joshi],

Please find the attached analysis document. WT-10372_Analysis_Document.doc

Regards,
Jyotibala P.

CC: Satya, Sheetal Bodhale, Swapnil Pandhare

PFA Test Cases WT-10372 Test Cases.xls

We need to verify above enhancement through UI and Import

CC - Sachin Hingole Prasad Pise Jayshree Nagpure

Verified all the attached scenarios on LB through UI and Import.
Working Fine

CC - Sachin Hingole Jayshree Nagpure Prasad Pise

This is working as expected on Stage. Ready for Production

Hi Amannda Johnson,

This has been developed on Stage.
Please let us know latest number from the client so We will mark the start number on Production.

Thanks,
Hrishikesh.

Hrishikesh Deshpande the client has informed us that when an employee changes from Class 3 Company code to a different Class 3 Company code they are required to get a new File #. Since WORKTERRA now does the auto generation please add this into the auto generation structure that when an existing employee changes Class 3 values they get the next auto generated File #.

Hi Jyotibala Pardeshi,

Please take this in development.
In case of Employees Class3 change we have to generate new Payroll File no.

Amannda Johnson, We will take this into development and update you once it is moved on Stage.

Thanks,
Hrishikesh.

Hi Amannda Johnson,

Please consider following case and let us know your feedback on this.

For example,
If suppose we have added new employee with name Test, payroll number will generate as '035393'(just for example).
When an employee changes from Class 3 Company code to a different Class 3 Company code then what should be his new payroll file number,
1. '035393' + 1 or (If we did this then might be conflict will occurs as some other employee may have same payroll file no)
2. The latest payroll file no

This functionality will work for add employee and also for class changes as mentioned.
Let us know your feedback.

Thanks and Regards,
Jyotibala P.

CC: Satya Swapnil Pandhare Sheetal Bodhale Hrishikesh Deshpande

Jyotibala Pardeshi the latest payroll file no should get assigned for the existing employee who changes Class 3 values.

Let me know if there are additional questions.

Hello [~meghana joshi],

Impacted Areas: Employee Payroll and Employee Class3 Value Changes.

Affected files: trgInsEmployee_Payroll_PayrollFileNoGeneration_AfterInsert.sql
trgUpdEmployee_Payroll_PayrollFileNoGeneration_AfterUpdate.sql

Thanks,
Jyotibala P.

CC: Satya Swapnil Pandhare Sheetal Bodhale

PFA Test Cases WT-10372 Test Cases.xls

CC - Sachin Hingole

Verified attached scenarios on LB.

Found ISSUE :

Scenarios :

Pre condition : Payroll File No. is not exist for any employee within company

ISSUE 1 : Payroll File No is decremented on changing class 3 twice

1) Add new employee - Generated proper Payroll File No . 035393
2) Changed Class 3 for newly added employee - Incremented Payroll File No. with 1 - 035394
3) Changed Class 3 again for same employee

Actual Result : Payroll file No. is decremented with 1 . 035393
Expected Result : Payroll file No. is incremented with 1 from last Payroll File No . 035395

ISSUE 2 : If we added new employee after above scenarios , then wrong Payroll File No Generated ( 035393 ) . Ideally It should generated last Payroll File No incremented with 1

Rest are working Fine

CC - Sachin Hingole

Verified all the attached scenarios and reported issues on LB.

Working Fine

CC - Sachin Hingole

Hi Amannda Johnson,

As per our change request, Payroll File No. should be 035393 and after it is increase by 1 digit from 035393.
As of now on Stage - "Solomon Page" Company, Latest Payroll file no. is 99999998 . ( Verified from Back-end ) So, If we add any new employee or Change class 3 of employee then newly generated Payroll file no. is increase by 1 digit from 99999998.

Kindly, Let us know we should keep 99999998 as it is or we need to change Payroll file no to 035393 ?

CC - Sachin Hingole Sheetal Bodhale

Thanks,
[~meghana joshi]

Hi Amannda Johnson,

Please check above comment and provide your input.

Thanks,
[~meghana joshi]

Amannda Johnson Please update to avoid any delay.

Hi Sheetal Bodhale, [~meghana joshi] & Rakesh Roy,

As discussed with Amannda Johnson - please do not make any changes in payroll file no. This has to be kept on Hold till we hear next from them.

Regards,
Satya Prakash

Client no longer moving forward with WORKTERRA implementation